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.PON_UDA_IMPORT_PKG dependencies on EGO_COL_NAME_VALUE_PAIR_ARRAY

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

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

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

21: --Start of Comments
22: --Name: POPULATE_STRUCTURES
23: --Procedure:
24: -- This procedure populates the structures EGO_COL_NAME_VALUE_PAIR_ARRAY, EGO_USER_ATTR_DATA_TABLE,
25: -- EGO_USER_ATTR_ROW_TABLE, EGO_COL_NAME_VALUE_PAIR_ARRAY from the data in the interface table PO_UDA_INTERFACE
26: --Parameters:
27: --IN:
28: -- 1. p_attr_grp_type
29: -- The attribute Group Type (Entity Type)

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

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

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

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

Line 61: ,x_pk_column_name_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY

57: ,p_pk3_value IN NUMBER
58: ,p_pk4_value IN NUMBER
59: ,p_pk5_value IN NUMBER
60: ,x_base_object_name IN OUT NOCOPY VARCHAR2
61: ,x_pk_column_name_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY
62: ,x_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
63: ,x_attributes_row_table IN OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
64: ,x_class_code_name_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY
65: ,x_return_status OUT NOCOPY VARCHAR2

Line 64: ,x_class_code_name_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY

60: ,x_base_object_name IN OUT NOCOPY VARCHAR2
61: ,x_pk_column_name_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY
62: ,x_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
63: ,x_attributes_row_table IN OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
64: ,x_class_code_name_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY
65: ,x_return_status OUT NOCOPY VARCHAR2
66: ,x_errorcode OUT NOCOPY NUMBER
67: ,x_msg_count OUT NOCOPY NUMBER
68: ,x_msg_data OUT NOCOPY VARCHAR2

Line 420: x_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY

416: CLOSE cur_uda_interface_recs;
417: d_progress := 190;
418:
419: PON_UDA_IMPORT_PKG.DEBUG('Before constructing Class codes Array', d_progress);
420: x_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
421: (
422: EGO_COL_NAME_VALUE_PAIR_OBJ
423: (
424: 'UDA_TEMPLATE_ID'

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

699: -- x_po_uda_usage_object_array.
700: --Parameters:
701: --IN:
702: -- 1. p_pk_column_name_value_pairs
703: -- This variable would contain an array of type EGO_COL_NAME_VALUE_PAIR_ARRAY with the PK values
704: -- 2. p_external_attr_value_pairs
705: -- This variable wsould contain an array of attribute value pairs (EGO_COL_NAME_VALUE_PAIR_TABLE)
706: --IN/OUT:
707: -- 1. x_po_uda_usage_object_array

Line 724: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

720: --------------------------------------------------------------------------------------------------------------------
721: PROCEDURE POPULATE_EMPTY_AGS
722: (
723: p_template_id IN NUMBER
724: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
725: ,p_external_attr_value_pairs IN EGO_COL_NAME_VALUE_PAIR_TABLE
726: ,p_address_lookup_type IN VARCHAR2 DEFAULT NULL
727: ,x_po_uda_usage_object_array IN OUT NOCOPY PO_UDA_USAGE_OBJECT_ARRAY
728: ,x_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

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

1208: --IN/OUT:
1209: -- 1. x_external_attr_value_pairs
1210: -- This variable wsould contain an array of attribute value pairs (EGO_COL_NAME_VALUE_PAIR_TABLE)
1211: -- 2. x_pk_column_name_value_pairs
1212: -- This variable would contain an array of type EGO_COL_NAME_VALUE_PAIR_ARRAY with the PK values
1213: -- 3. x_attr_name_value_pairs
1214: -- This variable would contain an array of type EGO_USER_ATTR_DATA_TABLE with the template details
1215: -- 4. x_attributes_row_table
1216: -- This variable would contain a table of type EGO_USER_ATTR_ROW_TABLE with the attribute group details

Line 1230: ,x_pk_column_name_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY

1226: (
1227: p_template_id IN NUMBER
1228: ,p_event IN VARCHAR2
1229: ,x_external_attr_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE
1230: ,x_pk_column_name_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY
1231: ,x_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
1232: ,x_attributes_row_table IN OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
1233: ,x_return_status OUT NOCOPY VARCHAR2
1234: ,x_errorcode OUT NOCOPY NUMBER

Line 1385: ,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))

1381: EGO_EXT_FWK_PUB.EXECUTE_FUNCTION
1382: (
1383: p_Action_Id => l_action_id
1384: ,p_pk_col_value_pairs => x_pk_column_name_value_pairs
1385: ,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))
1386: ,x_attributes_row_table => l_attributes_row_table
1387: ,x_attributes_data_table => l_attr_name_value_pairs
1388: ,x_external_attrs_value_pairs => x_external_attr_value_pairs
1389: ,x_return_status => x_return_status

Line 1594: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

1590:
1591: )
1592: IS
1593: l_base_object_name VARCHAR2(200);
1594: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1595: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;
1596: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
1597: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1598: d_progress NUMBER := 0;

Line 1597: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

1593: l_base_object_name VARCHAR2(200);
1594: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1595: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;
1596: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
1597: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1598: d_progress NUMBER := 0;
1599: l_failed_row_id_list VARCHAR2(2000);
1600:
1601: l_err_txt VARCHAR2(2000);

Line 2281: ,x_pk_column_name_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY

2277: ,p_pk2_value IN NUMBER DEFAULT NULL
2278: ,p_pk3_value IN NUMBER DEFAULT NULL
2279: ,p_pk4_value IN NUMBER DEFAULT NULL
2280: ,p_pk5_value IN NUMBER DEFAULT NULL
2281: ,x_pk_column_name_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY
2282: )
2283: IS
2284: l_pk1_column_name VARCHAR2(200);
2285: l_pk2_column_name VARCHAR2(200);

Line 2291: x_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY();

2287: l_pk4_column_name VARCHAR2(200);
2288: l_pk5_column_name VARCHAR2(200);
2289: BEGIN
2290:
2291: x_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY();
2292: BEGIN
2293: select o.pk1_column_name,
2294: o.pk2_column_name,
2295: o.pk3_column_name,

Line 2614: p_structure_array IN EGO_COL_NAME_VALUE_PAIR_ARRAY

2610: END;
2611:
2612: PROCEDURE DEBUG
2613: (
2614: p_structure_array IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2615: ,p_progress IN NUMBER
2616: )
2617: IS
2618: l_structure_ind NUMBER;