A.7 Table: m_used_other_costs, Package: m_api_uoc - 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)

A.7.1 Procedure: upd_uoc

Argument Name

Type

In/Out

P_US_ID

NUMBER(12)

IN

P_UOC_ID

NUMBER(12)

IN

P_COL_ARR

RECORD

IN

COL_NAME

TABLE OF VARCHAR2(255)

IN

COL_VALUE

TABLE OF VARCHAR2(255)

IN

P_RESULT

VARCHAR2

OUT

P_COMMIT_IND

VARCHAR2

IN; DEFAULT ‘Y’

Column Name

Prompt on D.50.12

Allowable values

COST_VALUE

Cost Value

0 – 99999999999.99

CURRENCY_CODE

Currency

All units in the ‘currency’ unit group

EVAL_COST_IND

Eval Cost

‘Y’, ‘N’

JOB_NUMBER

Account Code

All account codes defined on A.10.30

OC_CODE

Other Cost

All other costs defined on P.10.33

UNIT_PRICE_TYPE

Unit Price Type

NULL, ‘I’, ‘E’, ‘Q’, ‘R’

A.7.2 Procedure: upd_uocn

Argument Name

Type

In/Out

P_US_ID

NUMBER(12)

IN

P_UOC_ID

NUMBER(12)

IN

P_NLS_ID

NUMBER(2)

IN

P_COL_ARR

RECORD

IN

COL_NAME

TABLE OF VARCHAR2(255)

IN

COL_VALUE

TABLE OF VARCHAR2(255)

IN

P_RESULT

VARCHAR2

OUT

P_COMMIT_IND

VARCHAR2

IN; DEFAULT ‘Y’

Column Name

Prompt on D.50.12

Allowable values

DESCRIPTION

Description

SHORT_DESC

Short Desc

A.7.3 Procedure: ins_uoc

Argument Name

Type

In/Out

P_US_ID

NUMBER(12)

IN

P_TERM_TYPE

VARCHAR2(3)

IN

P_PK_ID

NUMBER(12)

IN

P_COL_ARR

RECORD

IN

COL_NAME

TABLE OF VARCHAR2(255)

IN

COL_VALUE

TABLE OF VARCHAR2(255)

IN

P_RESULT

VARCHAR2

OUT

P_UOC_ID

NUMBER(12)

OUT

P_COMMIT_IND

VARCHAR2

IN; DEFAULT ‘Y’

Column Name

Prompt on D.50.12

Allowable values

COST_VALUE

Cost Value

0 – 99999999999.99

CURRENCY_CODE

Currency

All units in the ‘currency’ unit group

JOB_NUMBER

Account Code

All account codes defined on A.10.30

OC_CODE

Other Cost

All other costs defined on P.10.33

UNIT_PRICE_TYPE

Unit Price Type

NULL, ‘I’, ‘E’, ‘Q’, ‘R’

A.7.4 Procedure: ins_uocn

Argument Name

Type

In/Out

P_US_ID

NUMBER(12)

IN

P_UOC_ID

NUMBER(12)

IN

P_NLS_ID

NUMBER(2)

IN

P_COL_ARR

RECORD

IN

COL_NAME

TABLE OF VARCHAR2(255)

IN

COL_VALUE

TABLE OF VARCHAR2(255)

IN

P_RESULT

VARCHAR2

OUT

P_COMMIT_IND

VARCHAR2

IN; DEFAULT ‘Y’

Column Name

Prompt on D.50.12

Allowable values

DESCRIPTION

Description

SHORT_DESC

Short Desc