Create Company Addresses - Intergraph Smart Materials - Version 2016 R4 (8.4.0) - Customization & Programming - Hexagon PPM

Intergraph Smart Materials Classic API Configuration (2016 R4)

PPMProduct
Intergraph Smart Materials
PPMCategory_custom
Customization & Programming
Version_SPMat_custom
2016 R4 (8.4)

To create a new company address, enter all mandatory values.

The arguments of the INS_COMPANY_ADDRS procedure 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_CA_ID

NUMBER, m_company_addrs.ca_id

OUT

P_COMPANY_ID

NUMBER, m_companies.company_id

IN

P_ADDRESS_TYPE_ID

NUMBER, m_company_addrs.address_type_id

IN

P_CY_ID

NUMBER, m_company_addrs.cy_id

IN

P_STPR_ID

NUMBER, m_company_addrs.stpr_id

IN

P_COMMIT_IND

VARCHAR2, default ‘Y’

IN

The procedure inserts a record into m_company_addrs.

The following table shows the values that can be transferred with P_COL_ARR in the INS_COMPANY_ADDRS procedure.

Column Name

Mandatory

Description

COMPANY_CODE

Yes

Company ID (NUMBER(12), m_company_addrs.company_id)

ADDRESS_TYPE_CODE

No

Address Type ID (NUMBER(12), m_company_addrs.address_type_id)

CY_CODE

Yes

Country ID (NUMBER(12), m_company_addrs.cy_id

CITY

Yes

City (VARCHAR2(80), m_company_addrs.city)

STPR_CODE

No

State or Province (NUMBER(12), m_company_addrs.stpr_id)

ADDR1

No

Address1 (VARCHAR2(80), m_company_addrs.addr1)

ADDR2

No

Address2 (VARCHAR2(80), m_company_addrs.addr2)

POSTAL_CODE

No

Zip or Postal Code (VARCHAR2(12), m_company_addrs.postal_code)