Update Company Contacts - Intergraph Smart Materials - Version 2020 (10.0) - Customization & Programming - Hexagon

Intergraph Smart Materials Classic API Configuration (2020)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Customization & Programming
Smart Materials/Smart Reference Data Version
2020 (10.0)

To update company contacts, use the UPD_COMPANY_CONTACT procedure.

The arguments of UPD_COMPANY_CONTACT are listed below.

Argument Name

Type

In/Out

P_US_ID

NUMBER, m_user_securities.us_id

IN

P_COL_ARR

RECORD

IN

P_RESULT

VARCHAR2

OUT

P_CCP_ID

NUMBER, m_company_contact_people.ccp_id

OUT

P_COMPANY_ID

NUMBER, m_companies.company_id

IN

P_COMMIT_IND

VARCHAR2, default ‘Y’

IN

The procedure calls check routines for all columns to be updated prior to performing the actual update of table m_company_contact_people. When all checks succeed, the procedure updates a record in m_company_company_contact_people.

The following table shows the values that can be updated with the UPD_COMPANY_CONTACT procedure.

Column Name

Mandatory

Description

CCP_CODE

Yes

Employee (VARCHAR2(10), m_company_contact_people.ccp_code)

FIRST_NAME

Yes

First Name (VARCHAR2(30), m_company_contact_people.first_name)

LAST_NAME

Yes

Last Name (VARCHAR2(30), m_company_contact_people.last_name)

COMMENTS

No

Last Name (VARCHAR2(60), m_company_contact_people.comments)

DEPARTMENT

No

Last Name (VARCHAR2(30), m_company_contact_people.department)

TELEPHONE

No

Last Name (VARCHAR2(30), m_company_contact_people.telephone)

POSITION

No

Last Name (VARCHAR2(35), m_company_contact_people.position)

DEFAULT_SUP_IND

Yes

Default Indicator (VARCHAR2(1), m_company_contact_people.default_sup_ind)