eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_UDA_IMPORT_PKG dependencies on EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 26: -- This procedure populates the structures EGO_COL_NAME_VALUE_PAIR_ARRAY, EGO_USER_ATTR_DATA_TABLE,

22: --------------------------------------------------------------------------------------------------------------------
23: --Start of Comments
24: --Name: POPULATE_STRUCTURES
25: --Procedure:
26: -- This procedure populates the structures EGO_COL_NAME_VALUE_PAIR_ARRAY, EGO_USER_ATTR_DATA_TABLE,
27: -- EGO_USER_ATTR_ROW_TABLE, EGO_COL_NAME_VALUE_PAIR_ARRAY from the data in the interface table PO_UDA_INTERFACE
28: --Parameters:
29: --IN:
30: -- 1.p_transaction_id

Line 27: -- EGO_USER_ATTR_ROW_TABLE, EGO_COL_NAME_VALUE_PAIR_ARRAY from the data in the interface table PO_UDA_INTERFACE

23: --Start of Comments
24: --Name: POPULATE_STRUCTURES
25: --Procedure:
26: -- This procedure populates the structures EGO_COL_NAME_VALUE_PAIR_ARRAY, EGO_USER_ATTR_DATA_TABLE,
27: -- EGO_USER_ATTR_ROW_TABLE, EGO_COL_NAME_VALUE_PAIR_ARRAY from the data in the interface table PO_UDA_INTERFACE
28: --Parameters:
29: --IN:
30: -- 1.p_transaction_id
31: -- Unique id of the transaction

Line 40: -- This variable would contain an array of type EGO_COL_NAME_VALUE_PAIR_ARRAY with the PK values

36: --IN/OUT:
37: -- 1. x_base_object_name
38: -- This variable would contain the base object name
39: -- 2. x_pk_column_name_value_pairs
40: -- This variable would contain an array of type EGO_COL_NAME_VALUE_PAIR_ARRAY with the PK values
41: -- 3. x_attr_name_value_pairs
42: -- This variable would contain a table of type EGO_USER_ATTR_DATA_TABLE with the attribute and its value pairs
43: -- 4. x_attributes_row_table
44: -- This variable would contain a table of type EGO_USER_ATTR_ROW_TABLE with the attribute group details

Line 46: -- This variable would contain an array of type EGO_COL_NAME_VALUE_PAIR_ARRAY with the template details

42: -- This variable would contain a table of type EGO_USER_ATTR_DATA_TABLE with the attribute and its value pairs
43: -- 4. x_attributes_row_table
44: -- This variable would contain a table of type EGO_USER_ATTR_ROW_TABLE with the attribute group details
45: -- 5. x_class_code_name_value_pairs
46: -- This variable would contain an array of type EGO_COL_NAME_VALUE_PAIR_ARRAY with the template details
47: --OUT:
48: -- 1. x_return_status - Generic Out parameter having return status
49: -- 2. x_errorcode - Generic Out parameter having error code
50: -- 3. x_msg_count - Generic Out parameter having return msg Count

Line 66: ,x_pk_column_name_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY

62: ,p_pk3_value IN NUMBER
63: ,p_pk4_value IN NUMBER
64: ,p_pk5_value IN NUMBER
65: ,x_base_object_name IN OUT NOCOPY VARCHAR2
66: ,x_pk_column_name_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY
67: ,x_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
68: ,x_attributes_row_table IN OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
69: ,x_class_code_name_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY
70: ,x_return_status OUT NOCOPY VARCHAR2

Line 69: ,x_class_code_name_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY

65: ,x_base_object_name IN OUT NOCOPY VARCHAR2
66: ,x_pk_column_name_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY
67: ,x_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
68: ,x_attributes_row_table IN OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
69: ,x_class_code_name_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY
70: ,x_return_status OUT NOCOPY VARCHAR2
71: ,x_errorcode OUT NOCOPY NUMBER
72: ,x_msg_count OUT NOCOPY NUMBER
73: ,x_msg_data OUT NOCOPY VARCHAR2

Line 377: x_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY

373: CLOSE cur_uda_interface_recs;
374: d_progress := 190;
375:
376: PO_UDA_DEFAULTING_PKG.DEBUG('Before constructing Class codes Array', d_progress);
377: x_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
378: (
379: EGO_COL_NAME_VALUE_PAIR_OBJ
380: (
381: 'UDA_TEMPLATE_ID'

Line 609: -- This variable would contain an array of type EGO_COL_NAME_VALUE_PAIR_ARRAY with the PK values

605: -- x_po_uda_usage_object_array.
606: --Parameters:
607: --IN:
608: -- 1. p_pk_column_name_value_pairs
609: -- This variable would contain an array of type EGO_COL_NAME_VALUE_PAIR_ARRAY with the PK values
610: -- 2. p_external_attr_value_pairs
611: -- This variable wsould contain an array of attribute value pairs (EGO_COL_NAME_VALUE_PAIR_TABLE)
612: --IN/OUT:
613: -- 1. x_po_uda_usage_object_array

Line 630: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

626: --------------------------------------------------------------------------------------------------------------------
627: PROCEDURE POPULATE_EMPTY_AGS
628: (
629: p_template_id IN NUMBER
630: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
631: ,p_external_attr_value_pairs IN EGO_COL_NAME_VALUE_PAIR_TABLE
632: ,p_address_lookup_type IN VARCHAR2 DEFAULT NULL
633: ,x_po_uda_usage_object_array IN OUT NOCOPY PO_UDA_USAGE_OBJECT_ARRAY
634: ,x_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

Line 1143: -- This variable would contain an array of type EGO_COL_NAME_VALUE_PAIR_ARRAY with the PK values

1139: --IN/OUT:
1140: -- 1. x_external_attr_value_pairs
1141: -- This variable wsould contain an array of attribute value pairs (EGO_COL_NAME_VALUE_PAIR_TABLE)
1142: -- 2. x_pk_column_name_value_pairs
1143: -- This variable would contain an array of type EGO_COL_NAME_VALUE_PAIR_ARRAY with the PK values
1144: -- 3. x_attr_name_value_pairs
1145: -- This variable would contain an array of type EGO_USER_ATTR_DATA_TABLE with the template details
1146: -- 4. x_attributes_row_table
1147: -- This variable would contain a table of type EGO_USER_ATTR_ROW_TABLE with the attribute group details

Line 1161: ,x_pk_column_name_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY

1157: (
1158: p_template_id IN NUMBER
1159: ,p_event IN VARCHAR2
1160: ,x_external_attr_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE
1161: ,x_pk_column_name_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY
1162: ,x_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
1163: ,x_attributes_row_table IN OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
1164: ,x_return_status OUT NOCOPY VARCHAR2
1165: ,x_errorcode OUT NOCOPY NUMBER

Line 1317: ,p_dtlevel_col_value_pairs => EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(l_data_level_name, l_data_level_id))

1313: EGO_EXT_FWK_PUB.EXECUTE_FUNCTION
1314: (
1315: p_Action_Id => l_action_id
1316: ,p_pk_col_value_pairs => x_pk_column_name_value_pairs
1317: ,p_dtlevel_col_value_pairs => EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(l_data_level_name, l_data_level_id))
1318: ,x_attributes_row_table => l_attributes_row_table
1319: ,x_attributes_data_table => l_attr_name_value_pairs
1320: ,x_external_attrs_value_pairs => x_external_attr_value_pairs
1321: ,x_return_status => x_return_status

Line 1528: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

1524: ,p_transaction_id IN NUMBER DEFAULT NULL
1525: )
1526: IS
1527: l_base_object_name VARCHAR2(200);
1528: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1529: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;
1530: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
1531: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1532: d_progress NUMBER := 0;

Line 1531: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

1527: l_base_object_name VARCHAR2(200);
1528: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1529: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;
1530: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
1531: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1532: d_progress NUMBER := 0;
1533: l_failed_row_id_list VARCHAR2(2000);
1534:
1535: l_err_txt VARCHAR2(2000);