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_DATA_TABLE

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 42: -- This variable would contain a table of type EGO_USER_ATTR_DATA_TABLE with the attribute and its value pairs

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

Line 67: ,x_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

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
71: ,x_errorcode 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 408: -- and not present in variable x_attr_name_value_pairs of type EGO_USER_ATTR_DATA_TABLE already

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:
412: -- 1. x_attr_name_value_pairs

Line 413: -- This variable would contain a table of type EGO_USER_ATTR_DATA_TABLE with the attribute and its value pairs

409: -- with NULL values
410: --Parameters:
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

Line 426: x_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

422: --End of Comments
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

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 616: -- This variable would contain a table of type EGO_USER_ATTR_DATA_TABLE with the attribute and its value pairs

612: --IN/OUT:
613: -- 1. x_po_uda_usage_object_array
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

Line 634: ,x_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

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

Line 1088: p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

1084: -- Private
1085: -- To Check whether all the attributes in the AG are null or not
1086: --
1087: FUNCTION All_Attr_Values_Are_Null (
1088: p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
1089: )
1090: RETURN BOOLEAN
1091: IS
1092:

Line 1145: -- This variable would contain an array of type EGO_USER_ATTR_DATA_TABLE with the template details

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
1148: --OUT:
1149: -- 1. x_return_status - Generic Out parameter having return status

Line 1162: ,x_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

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

Line 1177: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;

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;
1178: l_attr_id_index NUMBER;
1179: l_attr_id_index1 NUMBER;
1180: l_attr_obj EGO_USER_ATTR_DATA_OBJ;
1181: l_attr_obj1 EGO_USER_ATTR_DATA_OBJ;

Line 1259: l_attr_name_value_pairs := EGO_USER_ATTR_DATA_TABLE();

1255: PO_UDA_DEFAULTING_PKG.DEBUG('Exception while trying to fetch l_data_level_name, l_data_level_id', d_progress);
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:

Line 1529: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;

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

Line 1571: l_attr_name_value_pairs := EGO_USER_ATTR_DATA_TABLE();

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:
1575: d_progress := 50;