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 PO_UDA_USAGE_OBJECT

Line 605: -- x_po_uda_usage_object_array.

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:
607: --IN:
608: -- 1. p_pk_column_name_value_pairs
609: -- This variable would contain an array of type EGO_COL_NAME_VALUE_PAIR_ARRAY with the PK values

Line 613: -- 1. x_po_uda_usage_object_array

609: -- This variable would contain an array of type EGO_COL_NAME_VALUE_PAIR_ARRAY with the PK values
610: -- 2. p_external_attr_value_pairs
611: -- This variable wsould contain an array of attribute value pairs (EGO_COL_NAME_VALUE_PAIR_TABLE)
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

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

610: -- 2. p_external_attr_value_pairs
611: -- This variable wsould contain an array of attribute value pairs (EGO_COL_NAME_VALUE_PAIR_TABLE)
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

Line 633: ,x_po_uda_usage_object_array IN OUT NOCOPY PO_UDA_USAGE_OBJECT_ARRAY

629: p_template_id IN NUMBER
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

Line 643: l_po_uda_usage_object PO_UDA_USAGE_OBJECT;

639: ,x_msg_data OUT NOCOPY VARCHAR2
640: )
641: IS
642: d_progress NUMBER := 0;
643: l_po_uda_usage_object PO_UDA_USAGE_OBJECT;
644: l_attr_group_table PO_TBL_NUMBER;
645: l_context_object_index NUMBER;
646: l_attr_group_id_index NUMBER;
647: l_pk_col_index NUMBER;

Line 707: PO_UDA_DEFAULTING_PKG.DEBUG('x_po_uda_usage_object_array is as follows', d_progress);

703: PO_UDA_DEFAULTING_PKG.DEBUG(p_pk_column_name_value_pairs, d_progress);
704: PO_UDA_DEFAULTING_PKG.DEBUG('p_external_attr_value_pairs is as follows', d_progress);
705: PO_UDA_DEFAULTING_PKG.DEBUG(p_external_attr_value_pairs, d_progress);
706: PO_UDA_DEFAULTING_PKG.DEBUG('p_address_lookup_type : ' || p_address_lookup_type, d_progress);
707: PO_UDA_DEFAULTING_PKG.DEBUG('x_po_uda_usage_object_array is as follows', d_progress);
708: PO_UDA_DEFAULTING_PKG.DEBUG(x_po_uda_usage_object_array, d_progress);
709: PO_UDA_DEFAULTING_PKG.DEBUG('x_attr_name_value_pairs is as follows', d_progress);
710: PO_UDA_DEFAULTING_PKG.DEBUG(x_attr_name_value_pairs, d_progress);
711: PO_UDA_DEFAULTING_PKG.DEBUG('x_attributes_row_table is as follows', d_progress);

Line 708: PO_UDA_DEFAULTING_PKG.DEBUG(x_po_uda_usage_object_array, d_progress);

704: PO_UDA_DEFAULTING_PKG.DEBUG('p_external_attr_value_pairs is as follows', d_progress);
705: PO_UDA_DEFAULTING_PKG.DEBUG(p_external_attr_value_pairs, d_progress);
706: PO_UDA_DEFAULTING_PKG.DEBUG('p_address_lookup_type : ' || p_address_lookup_type, d_progress);
707: PO_UDA_DEFAULTING_PKG.DEBUG('x_po_uda_usage_object_array is as follows', d_progress);
708: PO_UDA_DEFAULTING_PKG.DEBUG(x_po_uda_usage_object_array, d_progress);
709: PO_UDA_DEFAULTING_PKG.DEBUG('x_attr_name_value_pairs is as follows', d_progress);
710: PO_UDA_DEFAULTING_PKG.DEBUG(x_attr_name_value_pairs, d_progress);
711: PO_UDA_DEFAULTING_PKG.DEBUG('x_attributes_row_table is as follows', d_progress);
712: PO_UDA_DEFAULTING_PKG.DEBUG(x_attributes_row_table, d_progress);

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

713: d_progress := 20;
714:
715: l_attr_group_table := PO_TBL_NUMBER();
716: d_progress := 30;
717: IF (x_po_uda_usage_object_array IS NOT NULL AND x_po_uda_usage_object_array.COUNT > 0) THEN
718: d_progress := 40;
719: PO_UDA_DEFAULTING_PKG.DEBUG('x_po_uda_usage_object_array.COUNT :' || x_po_uda_usage_object_array.COUNT, d_progress);
720: l_context_object_index := x_po_uda_usage_object_array.FIRST;
721: d_progress := 50;

Line 719: PO_UDA_DEFAULTING_PKG.DEBUG('x_po_uda_usage_object_array.COUNT :' || x_po_uda_usage_object_array.COUNT, d_progress);

715: l_attr_group_table := PO_TBL_NUMBER();
716: d_progress := 30;
717: IF (x_po_uda_usage_object_array IS NOT NULL AND x_po_uda_usage_object_array.COUNT > 0) THEN
718: d_progress := 40;
719: PO_UDA_DEFAULTING_PKG.DEBUG('x_po_uda_usage_object_array.COUNT :' || x_po_uda_usage_object_array.COUNT, d_progress);
720: l_context_object_index := x_po_uda_usage_object_array.FIRST;
721: d_progress := 50;
722:
723: WHILE (l_context_object_index IS NOT NULL AND l_context_object_index <= x_po_uda_usage_object_array.LAST)

Line 720: l_context_object_index := x_po_uda_usage_object_array.FIRST;

716: d_progress := 30;
717: IF (x_po_uda_usage_object_array IS NOT NULL AND x_po_uda_usage_object_array.COUNT > 0) THEN
718: d_progress := 40;
719: PO_UDA_DEFAULTING_PKG.DEBUG('x_po_uda_usage_object_array.COUNT :' || x_po_uda_usage_object_array.COUNT, d_progress);
720: l_context_object_index := x_po_uda_usage_object_array.FIRST;
721: d_progress := 50;
722:
723: WHILE (l_context_object_index IS NOT NULL AND l_context_object_index <= x_po_uda_usage_object_array.LAST)
724: LOOP

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

719: PO_UDA_DEFAULTING_PKG.DEBUG('x_po_uda_usage_object_array.COUNT :' || x_po_uda_usage_object_array.COUNT, d_progress);
720: l_context_object_index := x_po_uda_usage_object_array.FIRST;
721: d_progress := 50;
722:
723: WHILE (l_context_object_index IS NOT NULL AND l_context_object_index <= x_po_uda_usage_object_array.LAST)
724: LOOP
725: d_progress := 60;
726: IF x_po_uda_usage_object_array(l_context_object_index) IS NOT NULL THEN
727: d_progress := 70;

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

722:
723: WHILE (l_context_object_index IS NOT NULL AND l_context_object_index <= x_po_uda_usage_object_array.LAST)
724: LOOP
725: d_progress := 60;
726: IF x_po_uda_usage_object_array(l_context_object_index) IS NOT NULL THEN
727: d_progress := 70;
728: l_po_uda_usage_object := x_po_uda_usage_object_array(l_context_object_index);
729: l_attr_group_table := l_po_uda_usage_object.Attr_group_Id;
730: d_progress := 80;

Line 728: l_po_uda_usage_object := x_po_uda_usage_object_array(l_context_object_index);

724: LOOP
725: d_progress := 60;
726: IF x_po_uda_usage_object_array(l_context_object_index) IS NOT NULL THEN
727: d_progress := 70;
728: l_po_uda_usage_object := x_po_uda_usage_object_array(l_context_object_index);
729: l_attr_group_table := l_po_uda_usage_object.Attr_group_Id;
730: d_progress := 80;
731:
732: IF (l_attr_group_table IS NOT NULL AND l_attr_group_table.COUNT > 0) THEN

Line 729: l_attr_group_table := l_po_uda_usage_object.Attr_group_Id;

725: d_progress := 60;
726: IF x_po_uda_usage_object_array(l_context_object_index) IS NOT NULL THEN
727: d_progress := 70;
728: l_po_uda_usage_object := x_po_uda_usage_object_array(l_context_object_index);
729: l_attr_group_table := l_po_uda_usage_object.Attr_group_Id;
730: d_progress := 80;
731:
732: IF (l_attr_group_table IS NOT NULL AND l_attr_group_table.COUNT > 0) THEN
733: d_progress := 100;

Line 786: IF l_po_uda_usage_object.USAGE_TYPE = 'ADDRESS' AND p_address_lookup_type = 'PO_MOD_UDA_ADDRESS_TYPES' THEN

782: d_progress := 230;
783: END LOOP;
784:
785: --bug11872637 Start : Add Condition for Mod Specific Lookup Codes of Type 'PO_MOD_UDA_ADDRESS_TYPES'
786: IF l_po_uda_usage_object.USAGE_TYPE = 'ADDRESS' AND p_address_lookup_type = 'PO_MOD_UDA_ADDRESS_TYPES' THEN
787: l_use_mod_addr_type := 'Y';
788: l_mod_add_query := ' AND C_EXT_ATTR40 = '|| '''PO_MOD_UDA_ADDRESS_TYPES''' ||
789: ' AND C_EXT_ATTR39 IN (' || '''MOD_ADMIN_OFFICE''' ||',' || '''MOD_ISSUING_OFFICE'''
790: || ')';

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

862: -- XD Function is not present and the ag need not be added
863: d_progress := 380;
864: PO_UDA_DEFAULTING_PKG.DEBUG('XD function is not found so skipping the AG', d_progress);
865: NULL;
866: ELSIF l_po_uda_usage_object.USAGE_TYPE = 'ADDRESS' THEN -- FOR ADDRESS AGS
867: d_progress := 390;
868: PO_UDA_DEFAULTING_PKG.DEBUG('Usage type is ADDRESS', d_progress);
869: FOR cur_address_rec IN cur_address(p_address_lookup_type, l_use_mod_addr_type) LOOP
870: BEGIN

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

1054: END IF;
1055:
1056: END IF;
1057: d_progress := 750;
1058: l_context_object_index := x_po_uda_usage_object_array.NEXT(l_context_object_index);
1059: END LOOP;
1060: ELSE
1061: d_progress := 760;
1062: PO_UDA_DEFAULTING_PKG.DEBUG('USAGE object array does not have any objects', d_progress);

Line 1497: -- 1. x_po_uda_usage_object_array

1493: -- The attribute Group Type (Entity Type)
1494: -- 3. p_pk1_value, p_pk2_value, p_pk3_value, p_pk4_value, p_pk5_value
1495: -- The Primary Key values for the UDA Attributes
1496: --IN/OUT:
1497: -- 1. x_po_uda_usage_object_array
1498: -- This variable of type PO_UDA_USAGE_OBJECT_ARRAY contains data of hhe usages.
1499: -- 2. x_external_attr_value_pairs
1500: -- This variable would contain an array of attribute value pairs (EGO_COL_NAME_VALUE_PAIR_TABLE)
1501: --OUT:

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

1494: -- 3. p_pk1_value, p_pk2_value, p_pk3_value, p_pk4_value, p_pk5_value
1495: -- The Primary Key values for the UDA Attributes
1496: --IN/OUT:
1497: -- 1. x_po_uda_usage_object_array
1498: -- This variable of type PO_UDA_USAGE_OBJECT_ARRAY contains data of hhe usages.
1499: -- 2. x_external_attr_value_pairs
1500: -- This variable would contain an array of attribute value pairs (EGO_COL_NAME_VALUE_PAIR_TABLE)
1501: --OUT:
1502: -- 1. x_return_status - Generic Out parameter having return status

Line 1517: ,x_po_uda_usage_object_array IN OUT NOCOPY PO_UDA_USAGE_OBJECT_ARRAY

1513: ,p_pk2_value IN NUMBER DEFAULT NULL
1514: ,p_pk3_value IN NUMBER DEFAULT NULL
1515: ,p_pk4_value IN NUMBER DEFAULT NULL
1516: ,p_pk5_value IN NUMBER DEFAULT NULL
1517: ,x_po_uda_usage_object_array IN OUT NOCOPY PO_UDA_USAGE_OBJECT_ARRAY
1518: ,x_external_attr_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE
1519: ,x_return_status OUT NOCOPY VARCHAR2
1520: ,x_errorcode OUT NOCOPY NUMBER
1521: ,x_msg_count OUT NOCOPY NUMBER

Line 1547: PO_UDA_DEFAULTING_PKG.DEBUG('x_po_uda_usage_object_array is as follows : ', d_progress);

1543: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk2_value : ' || p_pk2_value, d_progress);
1544: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk3_value : ' || p_pk3_value, d_progress);
1545: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk4_value : ' || p_pk4_value, d_progress);
1546: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk5_value : ' || p_pk5_value, d_progress);
1547: PO_UDA_DEFAULTING_PKG.DEBUG('x_po_uda_usage_object_array is as follows : ', d_progress);
1548: PO_UDA_DEFAULTING_PKG.DEBUG(x_po_uda_usage_object_array, d_progress);
1549: PO_UDA_DEFAULTING_PKG.DEBUG('x_external_attr_value_pairs is as follows : ', d_progress);
1550: PO_UDA_DEFAULTING_PKG.DEBUG(x_external_attr_value_pairs, d_progress);
1551: PO_UDA_DEFAULTING_PKG.DEBUG('p_commit_flag : ' || p_commit_flag, d_progress);

Line 1548: PO_UDA_DEFAULTING_PKG.DEBUG(x_po_uda_usage_object_array, d_progress);

1544: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk3_value : ' || p_pk3_value, d_progress);
1545: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk4_value : ' || p_pk4_value, d_progress);
1546: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk5_value : ' || p_pk5_value, d_progress);
1547: PO_UDA_DEFAULTING_PKG.DEBUG('x_po_uda_usage_object_array is as follows : ', d_progress);
1548: PO_UDA_DEFAULTING_PKG.DEBUG(x_po_uda_usage_object_array, d_progress);
1549: PO_UDA_DEFAULTING_PKG.DEBUG('x_external_attr_value_pairs is as follows : ', d_progress);
1550: PO_UDA_DEFAULTING_PKG.DEBUG(x_external_attr_value_pairs, d_progress);
1551: PO_UDA_DEFAULTING_PKG.DEBUG('p_commit_flag : ' || p_commit_flag, d_progress);
1552: d_progress := 20;

Line 1652: ,x_po_uda_usage_object_array => x_po_uda_usage_object_array

1648: (
1649: p_template_id => l_class_code_name_value_pairs(l_class_code_name_value_pairs.FIRST).VALUE
1650: ,p_pk_column_name_value_pairs => l_pk_column_name_value_pairs
1651: ,p_external_attr_value_pairs => x_external_attr_value_pairs
1652: ,x_po_uda_usage_object_array => x_po_uda_usage_object_array
1653: ,x_attr_name_value_pairs => l_attr_name_value_pairs
1654: ,x_attributes_row_table => l_attributes_row_table
1655: ,x_return_status => x_return_status
1656: ,x_errorcode => x_errorcode

Line 2217: x_po_uda_usage_object_array PO_UDA_USAGE_OBJECT_ARRAY;

2213: l_attr_group_id_tbl po_tbl_number;
2214: l_po_lines_tbl po_tbl_number;
2215: l_template_id_tbl po_tbl_number;
2216: l_draft_id_tbl po_tbl_number;
2217: x_po_uda_usage_object_array PO_UDA_USAGE_OBJECT_ARRAY;
2218: x_external_attr_value_pairs EGO_COL_NAME_VALUE_PAIR_TABLE;-- := new EGO_COL_NAME_VALUE_PAIR_TABLE();
2219: x_return_status VARCHAR2(100) := null;
2220: x_msg_data VARCHAR2(100) := null;
2221: x_errorcode NUMBER := null;

Line 2286: x_po_uda_usage_object_array => x_po_uda_usage_object_array,

2282: --Call import function to import data into po_uda_interface table
2283: IMPORT_UDA_ATTRS( p_attr_grp_type => l_attr_group_type_tbl(i), --ATTR_GROUP_TYPE
2284: p_pk1_value => l_uda_pk1_tbl(i), -- po_header_id in case of header level attr, po_line_id in case of line level attr,
2285: p_pk2_value => l_uda_pk2_tbl(i), -- draft_id
2286: x_po_uda_usage_object_array => x_po_uda_usage_object_array,
2287: x_external_attr_value_pairs => x_external_attr_value_pairs,
2288: x_return_status => x_return_status,
2289: x_errorcode => x_errorcode,
2290: x_msg_count => x_msg_count,