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_USER_ATTR_ROW_TABLE

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

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

Line 63: ,x_attributes_row_table IN OUT NOCOPY EGO_USER_ATTR_ROW_TABLE

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
66: ,x_errorcode OUT NOCOPY NUMBER
67: ,x_msg_count OUT NOCOPY NUMBER

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

444: --------------------------------------------------------------------------------------------------------------------
445: --Start of Comments
446: --Name: POPULATE_REMAINING_ATTRIBUTES
447: --Procedure:
448: -- This procedure populates the structures EGO_USER_ATTR_DATA_TABLE, EGO_USER_ATTR_ROW_TABLE
449: -- from the table FND_DESCR_FLEX_COLUMN_USAGES. It would add elements for all the attributes present in
450: -- the attribute groups present in the variable x_attributes_row_table of type EGO_USER_ATTR_ROW_TABLE
451: -- and not present in variable x_attr_name_value_pairs of type EGO_USER_ATTR_DATA_TABLE already
452: -- with NULL values

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

446: --Name: POPULATE_REMAINING_ATTRIBUTES
447: --Procedure:
448: -- This procedure populates the structures EGO_USER_ATTR_DATA_TABLE, EGO_USER_ATTR_ROW_TABLE
449: -- from the table FND_DESCR_FLEX_COLUMN_USAGES. It would add elements for all the attributes present in
450: -- the attribute groups present in the variable x_attributes_row_table of type EGO_USER_ATTR_ROW_TABLE
451: -- and not present in variable x_attr_name_value_pairs of type EGO_USER_ATTR_DATA_TABLE already
452: -- with NULL values
453: --Parameters:
454: --IN/OUT:

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

454: --IN/OUT:
455: -- 1. x_attr_name_value_pairs
456: -- This variable would contain a table of type EGO_USER_ATTR_DATA_TABLE with the attribute and its value pairs
457: -- 2. x_attributes_row_table
458: -- This variable would contain a table of type EGO_USER_ATTR_ROW_TABLE with the attribute group details
459: --OUT:
460: -- 1. x_return_status - Generic Out parameter having return status
461: -- 2. x_errorcode - Generic Out parameter having error code
462: -- 3. x_msg_count - Generic Out parameter having return msg Count

Line 470: ,x_attributes_row_table IN OUT NOCOPY EGO_USER_ATTR_ROW_TABLE

466: --------------------------------------------------------------------------------------------------------------------
467: PROCEDURE POPULATE_REMAINING_ATTRIBUTES
468: (
469: x_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
470: ,x_attributes_row_table IN OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
471: ,x_return_status OUT NOCOPY VARCHAR2
472: ,x_errorcode OUT NOCOPY NUMBER
473: ,x_msg_count OUT NOCOPY NUMBER
474: ,x_msg_data OUT NOCOPY VARCHAR2

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

692: --------------------------------------------------------------------------------------------------------------------
693: --Start of Comments
694: --Name: POPULATE_EMPTY_AGS
695: --Procedure:
696: -- This procedure populates the structures EGO_USER_ATTR_DATA_TABLE, EGO_USER_ATTR_ROW_TABLE
697: -- with the details of the attribute groups in x_attributes_row_table and attributes in
698: -- x_attr_name_value_pairs which are not present in x_attributes_row_table and present in
699: -- x_po_uda_usage_object_array.
700: --Parameters:

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

708: -- This variable of type PO_UDA_USAGE_OBJECT_ARRAY contains data of hhe usages.
709: -- 2. x_attr_name_value_pairs
710: -- This variable would contain a table of type EGO_USER_ATTR_DATA_TABLE with the attribute and its value pairs
711: -- 3. x_attributes_row_table
712: -- This variable would contain a table of type EGO_USER_ATTR_ROW_TABLE with the attribute group details
713: --OUT:
714: -- 1. x_return_status - Generic Out parameter having return status
715: -- 2. x_errorcode - Generic Out parameter having error code
716: -- 3. x_msg_count - Generic Out parameter having return msg Count

Line 729: ,x_attributes_row_table IN OUT NOCOPY EGO_USER_ATTR_ROW_TABLE

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
729: ,x_attributes_row_table IN OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
730: ,x_return_status OUT NOCOPY VARCHAR2
731: ,x_errorcode OUT NOCOPY NUMBER
732: ,x_msg_count OUT NOCOPY NUMBER
733: ,x_msg_data OUT NOCOPY VARCHAR2

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

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
1217: --OUT:
1218: -- 1. x_return_status - Generic Out parameter having return status
1219: -- 2. x_errorcode - Generic Out parameter having error code
1220: -- 3. x_msg_count - Generic Out parameter having return msg Count

Line 1232: ,x_attributes_row_table IN OUT NOCOPY EGO_USER_ATTR_ROW_TABLE

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

Line 1242: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;

1238: IS
1239: d_progress NUMBER := 0;
1240: l_attr_group_id_index NUMBER;
1241: l_attr_row_obj EGO_USER_ATTR_ROW_OBJ;
1242: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
1243: l_action_id NUMBER;
1244: l_data_level_name VARCHAR2(200);
1245: l_data_level_id NUMBER;
1246: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;

Line 1329: l_attributes_row_table := EGO_USER_ATTR_ROW_TABLE();

1325: END;
1326:
1327: d_progress := 100;
1328: l_attr_name_value_pairs := EGO_USER_ATTR_DATA_TABLE();
1329: l_attributes_row_table := EGO_USER_ATTR_ROW_TABLE();
1330: l_attributes_row_table := EGO_USER_ATTR_ROW_TABLE(l_attr_row_obj);
1331: PON_UDA_IMPORT_PKG.DEBUG('Initialized l_attr_name_value_pairs, l_attributes_row_table', d_progress);
1332:
1333: d_progress := 110;

Line 1330: l_attributes_row_table := EGO_USER_ATTR_ROW_TABLE(l_attr_row_obj);

1326:
1327: d_progress := 100;
1328: l_attr_name_value_pairs := EGO_USER_ATTR_DATA_TABLE();
1329: l_attributes_row_table := EGO_USER_ATTR_ROW_TABLE();
1330: l_attributes_row_table := EGO_USER_ATTR_ROW_TABLE(l_attr_row_obj);
1331: PON_UDA_IMPORT_PKG.DEBUG('Initialized l_attr_name_value_pairs, l_attributes_row_table', d_progress);
1332:
1333: d_progress := 110;
1334: PON_UDA_IMPORT_PKG.DEBUG('Putting all attributes with the ROW_IDENTIFIER (' || l_attr_obj.ROW_IDENTIFIER || ') into another object array', d_progress);

Line 1596: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;

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

Line 1634: l_attributes_row_table := EGO_USER_ATTR_ROW_TABLE();

1630: PON_UDA_IMPORT_PKG.DEBUG('After PON_UDA_IMPORT_PKG.UPDATE_STATUS to change to PENDING from IN_PROGRESS', d_progress);
1631:
1632: d_progress := 30;
1633: g_attr_grp_type := p_attr_grp_type;
1634: l_attributes_row_table := EGO_USER_ATTR_ROW_TABLE();
1635: l_attr_name_value_pairs := EGO_USER_ATTR_DATA_TABLE();
1636: d_progress := 40;
1637: PON_UDA_IMPORT_PKG.DEBUG('Initialized teh objects l_attributes_row_table, l_attr_name_value_pairs', d_progress);
1638:

Line 2702: p_structure_array IN EGO_USER_ATTR_ROW_TABLE

2698: END DEBUG;
2699:
2700: PROCEDURE DEBUG
2701: (
2702: p_structure_array IN EGO_USER_ATTR_ROW_TABLE
2703: ,p_progress IN NUMBER
2704: )
2705: IS
2706: l_structure_ind NUMBER;