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_USER_ATTR_ROW_TABLE

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 44: -- This variable would contain a table of type EGO_USER_ATTR_ROW_TABLE with the attribute group details

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
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

Line 68: ,x_attributes_row_table IN OUT NOCOPY EGO_USER_ATTR_ROW_TABLE

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
71: ,x_errorcode OUT NOCOPY NUMBER
72: ,x_msg_count OUT NOCOPY NUMBER

Line 405: -- This procedure populates the structures EGO_USER_ATTR_DATA_TABLE, EGO_USER_ATTR_ROW_TABLE

401: --------------------------------------------------------------------------------------------------------------------
402: --Start of Comments
403: --Name: POPULATE_REMAINING_ATTRIBUTES
404: --Procedure:
405: -- This procedure populates the structures EGO_USER_ATTR_DATA_TABLE, EGO_USER_ATTR_ROW_TABLE
406: -- from the table FND_DESCR_FLEX_COLUMN_USAGES. It would add elements for all the attributes present in
407: -- the attribute groups present in the variable x_attributes_row_table of type EGO_USER_ATTR_ROW_TABLE
408: -- and not present in variable x_attr_name_value_pairs of type EGO_USER_ATTR_DATA_TABLE already
409: -- with NULL values

Line 407: -- the attribute groups present in the variable x_attributes_row_table of type EGO_USER_ATTR_ROW_TABLE

403: --Name: POPULATE_REMAINING_ATTRIBUTES
404: --Procedure:
405: -- This procedure populates the structures EGO_USER_ATTR_DATA_TABLE, EGO_USER_ATTR_ROW_TABLE
406: -- from the table FND_DESCR_FLEX_COLUMN_USAGES. It would add elements for all the attributes present in
407: -- the attribute groups present in the variable x_attributes_row_table of type EGO_USER_ATTR_ROW_TABLE
408: -- and not present in variable x_attr_name_value_pairs of type EGO_USER_ATTR_DATA_TABLE already
409: -- with NULL values
410: --Parameters:
411: --IN/OUT:

Line 415: -- This variable would contain a table of type EGO_USER_ATTR_ROW_TABLE with the attribute group details

411: --IN/OUT:
412: -- 1. x_attr_name_value_pairs
413: -- This variable would contain a table of type EGO_USER_ATTR_DATA_TABLE with the attribute and its value pairs
414: -- 2. x_attributes_row_table
415: -- This variable would contain a table of type EGO_USER_ATTR_ROW_TABLE with the attribute group details
416: --OUT:
417: -- 1. x_return_status - Generic Out parameter having return status
418: -- 2. x_errorcode - Generic Out parameter having error code
419: -- 3. x_msg_count - Generic Out parameter having return msg Count

Line 427: ,x_attributes_row_table IN OUT NOCOPY EGO_USER_ATTR_ROW_TABLE

423: --------------------------------------------------------------------------------------------------------------------
424: PROCEDURE POPULATE_REMAINING_ATTRIBUTES
425: (
426: x_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
427: ,x_attributes_row_table IN OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
428: ,x_return_status OUT NOCOPY VARCHAR2
429: ,x_errorcode OUT NOCOPY NUMBER
430: ,x_msg_count OUT NOCOPY NUMBER
431: ,x_msg_data OUT NOCOPY VARCHAR2

Line 602: -- This procedure populates the structures EGO_USER_ATTR_DATA_TABLE, EGO_USER_ATTR_ROW_TABLE

598: --------------------------------------------------------------------------------------------------------------------
599: --Start of Comments
600: --Name: POPULATE_EMPTY_AGS
601: --Procedure:
602: -- This procedure populates the structures EGO_USER_ATTR_DATA_TABLE, EGO_USER_ATTR_ROW_TABLE
603: -- with the details of the attribute groups in x_attributes_row_table and attributes in
604: -- x_attr_name_value_pairs which are not present in x_attributes_row_table and present in
605: -- x_po_uda_usage_object_array.
606: --Parameters:

Line 618: -- This variable would contain a table of type EGO_USER_ATTR_ROW_TABLE with the attribute group details

614: -- This variable of type PO_UDA_USAGE_OBJECT_ARRAY contains data of hhe usages.
615: -- 2. x_attr_name_value_pairs
616: -- This variable would contain a table of type EGO_USER_ATTR_DATA_TABLE with the attribute and its value pairs
617: -- 3. x_attributes_row_table
618: -- This variable would contain a table of type EGO_USER_ATTR_ROW_TABLE with the attribute group details
619: --OUT:
620: -- 1. x_return_status - Generic Out parameter having return status
621: -- 2. x_errorcode - Generic Out parameter having error code
622: -- 3. x_msg_count - Generic Out parameter having return msg Count

Line 635: ,x_attributes_row_table IN OUT NOCOPY EGO_USER_ATTR_ROW_TABLE

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
635: ,x_attributes_row_table IN OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
636: ,x_return_status OUT NOCOPY VARCHAR2
637: ,x_errorcode OUT NOCOPY NUMBER
638: ,x_msg_count OUT NOCOPY NUMBER
639: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1147: -- This variable would contain a table of type EGO_USER_ATTR_ROW_TABLE with the attribute group details

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
1148: --OUT:
1149: -- 1. x_return_status - Generic Out parameter having return status
1150: -- 2. x_errorcode - Generic Out parameter having error code
1151: -- 3. x_msg_count - Generic Out parameter having return msg Count

Line 1163: ,x_attributes_row_table IN OUT NOCOPY EGO_USER_ATTR_ROW_TABLE

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
1166: ,x_msg_count OUT NOCOPY NUMBER
1167: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1173: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;

1169: IS
1170: d_progress NUMBER := 0;
1171: l_attr_group_id_index NUMBER;
1172: l_attr_row_obj EGO_USER_ATTR_ROW_OBJ;
1173: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
1174: l_action_id NUMBER;
1175: l_data_level_name VARCHAR2(200);
1176: l_data_level_id NUMBER;
1177: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;

Line 1260: l_attributes_row_table := EGO_USER_ATTR_ROW_TABLE();

1256: END;
1257:
1258: d_progress := 100;
1259: l_attr_name_value_pairs := EGO_USER_ATTR_DATA_TABLE();
1260: l_attributes_row_table := EGO_USER_ATTR_ROW_TABLE();
1261: l_attributes_row_table := EGO_USER_ATTR_ROW_TABLE(l_attr_row_obj);
1262: PO_UDA_DEFAULTING_PKG.DEBUG('Initialized l_attr_name_value_pairs, l_attributes_row_table', d_progress);
1263:
1264: d_progress := 110;

Line 1261: l_attributes_row_table := EGO_USER_ATTR_ROW_TABLE(l_attr_row_obj);

1257:
1258: d_progress := 100;
1259: l_attr_name_value_pairs := EGO_USER_ATTR_DATA_TABLE();
1260: l_attributes_row_table := EGO_USER_ATTR_ROW_TABLE();
1261: l_attributes_row_table := EGO_USER_ATTR_ROW_TABLE(l_attr_row_obj);
1262: PO_UDA_DEFAULTING_PKG.DEBUG('Initialized l_attr_name_value_pairs, l_attributes_row_table', d_progress);
1263:
1264: d_progress := 110;
1265: PO_UDA_DEFAULTING_PKG.DEBUG('Putting all attributes with the ROW_IDENTIFIER (' || l_attr_obj.ROW_IDENTIFIER || ') into another object array', d_progress);

Line 1530: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;

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;
1533: l_failed_row_id_list VARCHAR2(2000);
1534:

Line 1570: l_attributes_row_table := EGO_USER_ATTR_ROW_TABLE();

1566: PO_UDA_DEFAULTING_PKG.DEBUG('After PO_UDA_IMPORT_PKG.UPDATE_STATUS to change to PENDING from IN_PROGRESS', d_progress);
1567:
1568: d_progress := 30;
1569: g_attr_grp_type := p_attr_grp_type;
1570: l_attributes_row_table := EGO_USER_ATTR_ROW_TABLE();
1571: l_attr_name_value_pairs := EGO_USER_ATTR_DATA_TABLE();
1572: d_progress := 40;
1573: PO_UDA_DEFAULTING_PKG.DEBUG('Initialized teh objects l_attributes_row_table, l_attr_name_value_pairs', d_progress);
1574: