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 PO_UDA_USAGE_OBJECT

Line 699: -- x_po_uda_usage_object_array.

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

Line 707: -- 1. x_po_uda_usage_object_array

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

Line 708: -- This variable of type PO_UDA_USAGE_OBJECT_ARRAY contains data of hhe usages.

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

Line 727: ,x_po_uda_usage_object_array IN OUT NOCOPY PO_UDA_USAGE_OBJECT_ARRAY

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

Line 737: l_po_uda_usage_object PO_UDA_USAGE_OBJECT;

733: ,x_msg_data OUT NOCOPY VARCHAR2
734: )
735: IS
736: d_progress NUMBER := 0;
737: l_po_uda_usage_object PO_UDA_USAGE_OBJECT;
738: l_attr_group_table PO_TBL_NUMBER;
739: l_context_object_index NUMBER;
740: l_attr_group_id_index NUMBER;
741: l_pk_col_index NUMBER;

Line 795: PON_UDA_IMPORT_PKG.DEBUG('x_po_uda_usage_object_array is as follows', d_progress);

791: PON_UDA_IMPORT_PKG.DEBUG(p_pk_column_name_value_pairs, d_progress);
792: PON_UDA_IMPORT_PKG.DEBUG('p_external_attr_value_pairs is as follows', d_progress);
793: PON_UDA_IMPORT_PKG.DEBUG(p_external_attr_value_pairs, d_progress);
794: PON_UDA_IMPORT_PKG.DEBUG('p_address_lookup_type : ' || p_address_lookup_type, d_progress);
795: PON_UDA_IMPORT_PKG.DEBUG('x_po_uda_usage_object_array is as follows', d_progress);
796: PON_UDA_IMPORT_PKG.DEBUG(x_po_uda_usage_object_array, d_progress);
797: PON_UDA_IMPORT_PKG.DEBUG('x_attr_name_value_pairs is as follows', d_progress);
798: PON_UDA_IMPORT_PKG.DEBUG(x_attr_name_value_pairs, d_progress);
799: PON_UDA_IMPORT_PKG.DEBUG('x_attributes_row_table is as follows', d_progress);

Line 796: PON_UDA_IMPORT_PKG.DEBUG(x_po_uda_usage_object_array, d_progress);

792: PON_UDA_IMPORT_PKG.DEBUG('p_external_attr_value_pairs is as follows', d_progress);
793: PON_UDA_IMPORT_PKG.DEBUG(p_external_attr_value_pairs, d_progress);
794: PON_UDA_IMPORT_PKG.DEBUG('p_address_lookup_type : ' || p_address_lookup_type, d_progress);
795: PON_UDA_IMPORT_PKG.DEBUG('x_po_uda_usage_object_array is as follows', d_progress);
796: PON_UDA_IMPORT_PKG.DEBUG(x_po_uda_usage_object_array, d_progress);
797: PON_UDA_IMPORT_PKG.DEBUG('x_attr_name_value_pairs is as follows', d_progress);
798: PON_UDA_IMPORT_PKG.DEBUG(x_attr_name_value_pairs, d_progress);
799: PON_UDA_IMPORT_PKG.DEBUG('x_attributes_row_table is as follows', d_progress);
800: PON_UDA_IMPORT_PKG.DEBUG(x_attributes_row_table, d_progress);

Line 805: IF (x_po_uda_usage_object_array IS NOT NULL AND x_po_uda_usage_object_array.COUNT > 0) THEN

801: d_progress := 20;
802:
803: l_attr_group_table := PO_TBL_NUMBER();
804: d_progress := 30;
805: IF (x_po_uda_usage_object_array IS NOT NULL AND x_po_uda_usage_object_array.COUNT > 0) THEN
806: d_progress := 40;
807: PON_UDA_IMPORT_PKG.DEBUG('x_po_uda_usage_object_array.COUNT :' || x_po_uda_usage_object_array.COUNT, d_progress);
808: l_context_object_index := x_po_uda_usage_object_array.FIRST;
809: d_progress := 50;

Line 807: PON_UDA_IMPORT_PKG.DEBUG('x_po_uda_usage_object_array.COUNT :' || x_po_uda_usage_object_array.COUNT, d_progress);

803: l_attr_group_table := PO_TBL_NUMBER();
804: d_progress := 30;
805: IF (x_po_uda_usage_object_array IS NOT NULL AND x_po_uda_usage_object_array.COUNT > 0) THEN
806: d_progress := 40;
807: PON_UDA_IMPORT_PKG.DEBUG('x_po_uda_usage_object_array.COUNT :' || x_po_uda_usage_object_array.COUNT, d_progress);
808: l_context_object_index := x_po_uda_usage_object_array.FIRST;
809: d_progress := 50;
810:
811: WHILE (l_context_object_index IS NOT NULL AND l_context_object_index <= x_po_uda_usage_object_array.LAST)

Line 808: l_context_object_index := x_po_uda_usage_object_array.FIRST;

804: d_progress := 30;
805: IF (x_po_uda_usage_object_array IS NOT NULL AND x_po_uda_usage_object_array.COUNT > 0) THEN
806: d_progress := 40;
807: PON_UDA_IMPORT_PKG.DEBUG('x_po_uda_usage_object_array.COUNT :' || x_po_uda_usage_object_array.COUNT, d_progress);
808: l_context_object_index := x_po_uda_usage_object_array.FIRST;
809: d_progress := 50;
810:
811: WHILE (l_context_object_index IS NOT NULL AND l_context_object_index <= x_po_uda_usage_object_array.LAST)
812: LOOP

Line 811: WHILE (l_context_object_index IS NOT NULL AND l_context_object_index <= x_po_uda_usage_object_array.LAST)

807: PON_UDA_IMPORT_PKG.DEBUG('x_po_uda_usage_object_array.COUNT :' || x_po_uda_usage_object_array.COUNT, d_progress);
808: l_context_object_index := x_po_uda_usage_object_array.FIRST;
809: d_progress := 50;
810:
811: WHILE (l_context_object_index IS NOT NULL AND l_context_object_index <= x_po_uda_usage_object_array.LAST)
812: LOOP
813: d_progress := 60;
814: IF x_po_uda_usage_object_array(l_context_object_index) IS NOT NULL THEN
815: d_progress := 70;

Line 814: IF x_po_uda_usage_object_array(l_context_object_index) IS NOT NULL THEN

810:
811: WHILE (l_context_object_index IS NOT NULL AND l_context_object_index <= x_po_uda_usage_object_array.LAST)
812: LOOP
813: d_progress := 60;
814: IF x_po_uda_usage_object_array(l_context_object_index) IS NOT NULL THEN
815: d_progress := 70;
816: l_po_uda_usage_object := x_po_uda_usage_object_array(l_context_object_index);
817: l_attr_group_table := l_po_uda_usage_object.Attr_group_Id;
818: d_progress := 80;

Line 816: l_po_uda_usage_object := x_po_uda_usage_object_array(l_context_object_index);

812: LOOP
813: d_progress := 60;
814: IF x_po_uda_usage_object_array(l_context_object_index) IS NOT NULL THEN
815: d_progress := 70;
816: l_po_uda_usage_object := x_po_uda_usage_object_array(l_context_object_index);
817: l_attr_group_table := l_po_uda_usage_object.Attr_group_Id;
818: d_progress := 80;
819:
820: IF (l_attr_group_table IS NOT NULL AND l_attr_group_table.COUNT > 0) THEN

Line 817: l_attr_group_table := l_po_uda_usage_object.Attr_group_Id;

813: d_progress := 60;
814: IF x_po_uda_usage_object_array(l_context_object_index) IS NOT NULL THEN
815: d_progress := 70;
816: l_po_uda_usage_object := x_po_uda_usage_object_array(l_context_object_index);
817: l_attr_group_table := l_po_uda_usage_object.Attr_group_Id;
818: d_progress := 80;
819:
820: IF (l_attr_group_table IS NOT NULL AND l_attr_group_table.COUNT > 0) THEN
821: d_progress := 100;

Line 944: ELSIF l_po_uda_usage_object.USAGE_TYPE = 'ADDRESS' THEN -- FOR ADDRESS AGS

940: -- XD Function is not present and the ag need not be added
941: d_progress := 380;
942: PON_UDA_IMPORT_PKG.DEBUG('XD function is not found so skipping the AG', d_progress);
943: NULL;
944: ELSIF l_po_uda_usage_object.USAGE_TYPE = 'ADDRESS' THEN -- FOR ADDRESS AGS
945: d_progress := 390;
946: PON_UDA_IMPORT_PKG.DEBUG('Usage type is ADDRESS', d_progress);
947: FOR cur_address_rec IN cur_address(p_address_lookup_type) LOOP
948: BEGIN

Line 1132: l_context_object_index := x_po_uda_usage_object_array.NEXT(l_context_object_index);

1128: END IF;
1129:
1130: END IF;
1131: d_progress := 750;
1132: l_context_object_index := x_po_uda_usage_object_array.NEXT(l_context_object_index);
1133: END LOOP;
1134: ELSE
1135: d_progress := 760;
1136: PON_UDA_IMPORT_PKG.DEBUG('USAGE object array does not have any objects', d_progress);

Line 1564: -- 1. x_po_uda_usage_object_array

1560: -- The attribute Group Type (Entity Type)
1561: -- 2. p_pk1_value, p_pk2_value, p_pk3_value, p_pk4_value, p_pk5_value
1562: -- The Primary Key values for the UDA Attributes
1563: --IN/OUT:
1564: -- 1. x_po_uda_usage_object_array
1565: -- This variable of type PO_UDA_USAGE_OBJECT_ARRAY contains data of hhe usages.
1566: -- 2. x_external_attr_value_pairs
1567: -- This variable would contain an array of attribute value pairs (EGO_COL_NAME_VALUE_PAIR_TABLE)
1568: --OUT:

Line 1565: -- This variable of type PO_UDA_USAGE_OBJECT_ARRAY contains data of hhe usages.

1561: -- 2. p_pk1_value, p_pk2_value, p_pk3_value, p_pk4_value, p_pk5_value
1562: -- The Primary Key values for the UDA Attributes
1563: --IN/OUT:
1564: -- 1. x_po_uda_usage_object_array
1565: -- This variable of type PO_UDA_USAGE_OBJECT_ARRAY contains data of hhe usages.
1566: -- 2. x_external_attr_value_pairs
1567: -- This variable would contain an array of attribute value pairs (EGO_COL_NAME_VALUE_PAIR_TABLE)
1568: --OUT:
1569: -- 1. x_return_status - Generic Out parameter having return status

Line 1584: ,x_po_uda_usage_object_array IN OUT NOCOPY PO_UDA_USAGE_OBJECT_ARRAY

1580: ,p_pk2_value IN NUMBER DEFAULT NULL
1581: ,p_pk3_value IN NUMBER DEFAULT NULL
1582: ,p_pk4_value IN NUMBER DEFAULT NULL
1583: ,p_pk5_value IN NUMBER DEFAULT NULL
1584: ,x_po_uda_usage_object_array IN OUT NOCOPY PO_UDA_USAGE_OBJECT_ARRAY
1585: ,x_external_attr_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE
1586: ,x_return_status OUT NOCOPY VARCHAR2
1587: ,x_errorcode OUT NOCOPY NUMBER
1588: ,x_msg_count OUT NOCOPY NUMBER

Line 1612: PON_UDA_IMPORT_PKG.DEBUG('x_po_uda_usage_object_array is as follows : ', d_progress);

1608: PON_UDA_IMPORT_PKG.DEBUG('p_pk2_value : ' || p_pk2_value, d_progress);
1609: PON_UDA_IMPORT_PKG.DEBUG('p_pk3_value : ' || p_pk3_value, d_progress);
1610: PON_UDA_IMPORT_PKG.DEBUG('p_pk4_value : ' || p_pk4_value, d_progress);
1611: PON_UDA_IMPORT_PKG.DEBUG('p_pk5_value : ' || p_pk5_value, d_progress);
1612: PON_UDA_IMPORT_PKG.DEBUG('x_po_uda_usage_object_array is as follows : ', d_progress);
1613: PON_UDA_IMPORT_PKG.DEBUG(x_po_uda_usage_object_array, d_progress);
1614: PON_UDA_IMPORT_PKG.DEBUG('x_external_attr_value_pairs is as follows : ', d_progress);
1615: PON_UDA_IMPORT_PKG.DEBUG(x_external_attr_value_pairs, d_progress);
1616: d_progress := 20;

Line 1613: PON_UDA_IMPORT_PKG.DEBUG(x_po_uda_usage_object_array, d_progress);

1609: PON_UDA_IMPORT_PKG.DEBUG('p_pk3_value : ' || p_pk3_value, d_progress);
1610: PON_UDA_IMPORT_PKG.DEBUG('p_pk4_value : ' || p_pk4_value, d_progress);
1611: PON_UDA_IMPORT_PKG.DEBUG('p_pk5_value : ' || p_pk5_value, d_progress);
1612: PON_UDA_IMPORT_PKG.DEBUG('x_po_uda_usage_object_array is as follows : ', d_progress);
1613: PON_UDA_IMPORT_PKG.DEBUG(x_po_uda_usage_object_array, d_progress);
1614: PON_UDA_IMPORT_PKG.DEBUG('x_external_attr_value_pairs is as follows : ', d_progress);
1615: PON_UDA_IMPORT_PKG.DEBUG(x_external_attr_value_pairs, d_progress);
1616: d_progress := 20;
1617:

Line 1720: ,x_po_uda_usage_object_array => x_po_uda_usage_object_array

1716: (
1717: p_template_id => l_class_code_name_value_pairs(l_class_code_name_value_pairs.FIRST).VALUE
1718: ,p_pk_column_name_value_pairs => l_pk_column_name_value_pairs
1719: ,p_external_attr_value_pairs => x_external_attr_value_pairs
1720: ,x_po_uda_usage_object_array => x_po_uda_usage_object_array
1721: ,x_attr_name_value_pairs => l_attr_name_value_pairs
1722: ,x_attributes_row_table => l_attributes_row_table
1723: ,x_return_status => x_return_status
1724: ,x_errorcode => x_errorcode

Line 2739: p_structure_array IN PO_UDA_USAGE_OBJECT_ARRAY

2735: END DEBUG;
2736:
2737: PROCEDURE DEBUG
2738: (
2739: p_structure_array IN PO_UDA_USAGE_OBJECT_ARRAY
2740: ,p_progress IN NUMBER
2741: )
2742: IS
2743: l_structure_ind NUMBER;

Line 2744: l_structure PO_UDA_USAGE_OBJECT;

2740: ,p_progress IN NUMBER
2741: )
2742: IS
2743: l_structure_ind NUMBER;
2744: l_structure PO_UDA_USAGE_OBJECT;
2745: BEGIN
2746: IF p_structure_array IS NOT NULL THEN
2747: l_structure_ind := p_structure_array.FIRST;
2748: WHILE (l_structure_ind IS NOT NULL AND l_structure_ind <= p_structure_array.LAST)