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.POR_UDA_PKG dependencies on EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 19: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;

15: d_module CONSTANT VARCHAR2(100) := d_pkg_name || d_api_name;
16: d_progress NUMBER := 0;
17:
18: l_po_uda_usage_object po_uda_usage_object ;
19: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;
20: l_attr_grp_ids_list PO_TBL_NUMBER;
21: l_contract_type VARCHAR2(250);
22: l_x_attr_ids_count NUMBER;
23: l_attr_grp_ids PO_TBL_NUMBER;

Line 44: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY();

40: PO_LOG.proc_begin(d_module, 'p_req_line_id', p_req_line_id);
41: END IF;
42:
43: l_attr_grp_ids := PO_TBL_NUMBER();
44: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY();
45:
46: FOR c_get_usages_rec IN c_get_usages(p_template_id) LOOP
47:
48: IF (c_get_usages_rec.attribute_category = 'PRICING') then

Line 53: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTRACT_LINE_TYPE', l_contract_type),

49: OPEN c_get_usage_context(p_req_line_id);
50: FETCH c_get_usage_context INTO l_contract_type;
51: CLOSE c_get_usage_context;
52:
53: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTRACT_LINE_TYPE', l_contract_type),
54: EGO_COL_NAME_VALUE_PAIR_OBJ( 'IDC_TYPE', 'IDC_NA'));
55: END IF;
56:
57: IF(p_is_amd_mode = 'true' AND c_get_usages_rec.attribute_category = 'CHAIN') THEN

Line 103: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;

99:
100: l_po_uda_usage_object_array PO_UDA_USAGE_OBJECT_ARRAY;
101: l_template_id NUMBER;
102: l_contract_type VARCHAR2(500);
103: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;
104: l_preparer_id NUMBER;
105: l_org_id NUMBER;
106: l_line_type_id NUMBER;
107: l_contract_line_type VARCHAR2(100);

Line 289: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

285:
286:
287: is_valid_entity_ag BOOLEAN := FALSE;
288:
289: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
290: l_entity_code VARCHAR2(200);
291: l_ag_type VARCHAR2(200);
292: l_ag_name VARCHAR2(200);
293: l_attr_list VARCHAR2(2000);

Line 305: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

301: l_attr_group_request_table EGO_ATTR_GROUP_REQUEST_TABLE;
302:
303: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
304: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;
305: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
306:
307: l_ext_attr_value_pairs_ind NUMBER;
308: l_ext_name_val_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
309:

Line 316: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY();

312:
313: d_progress := 10;
314:
315: x_return_status := FND_API.G_RET_STS_SUCCESS;
316: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY();
317: l_attr_group_request_table := EGO_ATTR_GROUP_REQUEST_TABLE();
318:
319: d_progress := 20;
320:

Line 490: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY

486:
487: l_attributes_row_table := EGO_USER_ATTR_ROW_TABLE();
488: l_attr_name_value_pairs := EGO_USER_ATTR_DATA_TABLE();
489:
490: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
491: (
492: EGO_COL_NAME_VALUE_PAIR_OBJ
493: (
494: 'UDA_TEMPLATE_ID'

Line 591: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;

587:
588: l_po_uda_usage_object po_uda_usage_object ;
589: l_attr_grp_ids_list PO_TBL_NUMBER;
590: l_x_attr_ids_count NUMBER;
591: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;
592: l_attr_grp_ids PO_TBL_NUMBER;
593: t_count NUMBER;
594:
595: CURSOR c_get_usages(p_template_id NUMBER) IS

Line 606: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY();

602: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
603: END IF;
604:
605: l_attr_grp_ids := PO_TBL_NUMBER();
606: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY();
607:
608: FOR c_get_usages_rec IN c_get_usages(p_template_id) LOOP
609: IF(p_is_amd_mode = 'true' AND c_get_usages_rec.attribute_category = 'CHAIN') THEN
610: IF PO_LOG.d_stmt THEN

Line 653: l_from_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

649: d_module CONSTANT VARCHAR2(100) := d_pkg_name || d_api_name;
650: d_progress NUMBER := 0;
651:
652: l_template_id NUMBER;
653: l_from_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
654: l_to_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
655: l_copy_attribute_groups VARCHAR2(10);
656: l_attribute_group_table PO_TBL_VARCHAR30;
657: l_attr_group_name VARCHAR2(250);

Line 654: l_to_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

650: d_progress NUMBER := 0;
651:
652: l_template_id NUMBER;
653: l_from_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
654: l_to_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
655: l_copy_attribute_groups VARCHAR2(10);
656: l_attribute_group_table PO_TBL_VARCHAR30;
657: l_attr_group_name VARCHAR2(250);
658:

Line 686: l_from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

682: OPEN get_source_ids(p_confirmed_id, p_revision_num);
683: FETCH get_source_ids INTO l_req_source_hdr_id, l_template_id ;
684: CLOSE get_source_ids;
685:
686: l_from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
687: EGO_COL_NAME_VALUE_PAIR_OBJ(
688: 'REQUISITION_HEADER_ID', l_req_source_hdr_id ));
689:
690: l_to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

Line 690: l_to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

686: l_from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
687: EGO_COL_NAME_VALUE_PAIR_OBJ(
688: 'REQUISITION_HEADER_ID', l_req_source_hdr_id ));
689:
690: l_to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
691: EGO_COL_NAME_VALUE_PAIR_OBJ(
692: 'REQUISITION_HEADER_ID', p_confirmed_id ));
693:
694: l_attribute_group_table := PO_TBL_VARCHAR30();

Line 752: l_from_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

748: d_module CONSTANT VARCHAR2(100) := d_pkg_name || d_api_name;
749: d_progress NUMBER := 0;
750:
751: l_template_id NUMBER;
752: l_from_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
753: l_to_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
754: l_copy_attribute_groups VARCHAR2(10);
755:
756: l_return_status VARCHAR2(2);

Line 753: l_to_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

749: d_progress NUMBER := 0;
750:
751: l_template_id NUMBER;
752: l_from_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
753: l_to_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
754: l_copy_attribute_groups VARCHAR2(10);
755:
756: l_return_status VARCHAR2(2);
757: l_msg_count NUMBER;

Line 787: l_from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY();

783: WHERE requisition_header_id = l_req_source_hdr_id;
784: -- AND group_line_id IS NULL
785: -- AND clm_base_line_num IS NULL;
786:
787: l_from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY();
788: l_to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY();
789:
790: l_from_pk_col_value_pairs.extend(l_line_ids.Count);
791: l_to_pk_col_value_pairs.extend(l_line_ids.Count);

Line 788: l_to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY();

784: -- AND group_line_id IS NULL
785: -- AND clm_base_line_num IS NULL;
786:
787: l_from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY();
788: l_to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY();
789:
790: l_from_pk_col_value_pairs.extend(l_line_ids.Count);
791: l_to_pk_col_value_pairs.extend(l_line_ids.Count);
792:

Line 799: l_from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(

795:
796: SELECT uda_template_id INTO l_template_id
797: FROM po_requisition_lines_all WHERE REQUISITION_LINE_ID = l_line_ids(i);
798:
799: l_from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(
800: 'REQUISITION_LINE_ID', l_line_ids(i)));
801:
802: l_to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(
803: 'REQUISITION_LINE_ID', l_conformed_line_ids(i)));

Line 802: l_to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(

798:
799: l_from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(
800: 'REQUISITION_LINE_ID', l_line_ids(i)));
801:
802: l_to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(
803: 'REQUISITION_LINE_ID', l_conformed_line_ids(i)));
804: END IF;
805:
806: PO_UDA_DATA_UTIL.AutoCreate_User_Attrs

Line 846: l_from_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

842: d_module CONSTANT VARCHAR2(100) := d_pkg_name || d_api_name;
843: d_progress NUMBER := 0;
844:
845: l_template_id NUMBER;
846: l_from_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
847: l_to_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
848: l_copy_attribute_groups VARCHAR2(10);
849:
850: l_return_status VARCHAR2(2);

Line 847: l_to_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

843: d_progress NUMBER := 0;
844:
845: l_template_id NUMBER;
846: l_from_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
847: l_to_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
848: l_copy_attribute_groups VARCHAR2(10);
849:
850: l_return_status VARCHAR2(2);
851: l_msg_count NUMBER;

Line 870: l_from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

866: OPEN get_source_ids(p_from_req_header_id);
867: FETCH get_source_ids INTO l_template_id ;
868: CLOSE get_source_ids;
869:
870: l_from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
871: EGO_COL_NAME_VALUE_PAIR_OBJ(
872: 'REQUISITION_HEADER_ID', p_from_req_header_id ));
873:
874: l_to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

Line 874: l_to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

870: l_from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
871: EGO_COL_NAME_VALUE_PAIR_OBJ(
872: 'REQUISITION_HEADER_ID', p_from_req_header_id ));
873:
874: l_to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
875: EGO_COL_NAME_VALUE_PAIR_OBJ(
876: 'REQUISITION_HEADER_ID', p_to_req_header_id ));
877:
878: PO_UDA_DATA_UTIL.Copy_User_Attrs

Line 916: l_from_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

912: d_module CONSTANT VARCHAR2(100) := d_pkg_name || d_api_name;
913: d_progress NUMBER := 0;
914:
915: l_template_id NUMBER;
916: l_from_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
917: l_to_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
918: l_copy_attribute_groups VARCHAR2(10);
919:
920: l_return_status VARCHAR2(2);

Line 917: l_to_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

913: d_progress NUMBER := 0;
914:
915: l_template_id NUMBER;
916: l_from_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
917: l_to_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
918: l_copy_attribute_groups VARCHAR2(10);
919:
920: l_return_status VARCHAR2(2);
921: l_msg_count NUMBER;

Line 946: l_from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY();

942: BULK COLLECT INTO l_to_line_ids
943: FROM po_requisition_lines_all
944: WHERE requisition_header_id = p_to_req_header_id;
945:
946: l_from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY();
947: l_to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY();
948:
949: l_from_pk_col_value_pairs.extend(l_from_line_ids.Count);
950: l_to_pk_col_value_pairs.extend(l_to_line_ids.Count);

Line 947: l_to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY();

943: FROM po_requisition_lines_all
944: WHERE requisition_header_id = p_to_req_header_id;
945:
946: l_from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY();
947: l_to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY();
948:
949: l_from_pk_col_value_pairs.extend(l_from_line_ids.Count);
950: l_to_pk_col_value_pairs.extend(l_to_line_ids.Count);
951:

Line 958: l_from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(

954:
955: SELECT uda_template_id INTO l_template_id
956: FROM po_requisition_lines_all WHERE REQUISITION_LINE_ID = l_from_line_ids(i);
957:
958: l_from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(
959: 'REQUISITION_LINE_ID', l_from_line_ids(i)));
960:
961: l_to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(
962: 'REQUISITION_LINE_ID', l_to_line_ids(i)));

Line 961: l_to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(

957:
958: l_from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(
959: 'REQUISITION_LINE_ID', l_from_line_ids(i)));
960:
961: l_to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(
962: 'REQUISITION_LINE_ID', l_to_line_ids(i)));
963: END IF;
964:
965: PO_UDA_DATA_UTIL.Copy_User_Attrs

Line 1008: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;

1004: l_external_attr_value_pairs EGO_COL_NAME_VALUE_PAIR_TABLE;
1005: l_line_ext_attr_value_pairs EGO_COL_NAME_VALUE_PAIR_TABLE;
1006: l_po_uda_usage_object PO_UDA_USAGE_OBJECT;
1007: l_contract_type VARCHAR2(500);
1008: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;
1009: l_address_lookup_type VARCHAR2(200);
1010: l_preparer_id NUMBER;
1011: l_org_id NUMBER;
1012: l_line_type_id NUMBER;

Line 1053: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY();

1049: FROM po_requisition_headers_all WHERE requisition_header_id = p_req_header_id;
1050:
1051: l_po_uda_usage_object := PO_UDA_USAGE_OBJECT();
1052: l_po_uda_usage_object_array := PO_UDA_USAGE_OBJECT_ARRAY();
1053: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY();
1054:
1055: IF p_is_amend_flow = 'true' THEN
1056: l_address_lookup_type := 'PR_AMD_UDA_ADDRESS_TYPES';
1057: ELSE

Line 1112: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTRACT_LINE_TYPE', l_contract_type));

1108: OPEN c_get_usage_context(c_get_lines_rec.requisition_line_id);
1109: FETCH c_get_usage_context INTO l_contract_type;
1110: CLOSE c_get_usage_context;
1111:
1112: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTRACT_LINE_TYPE', l_contract_type));
1113: END IF;
1114:
1115: l_po_uda_usage_object := po_uda_usage_object.new_instance(l_template_id,c_get_line_usages_rec.attribute_category,l_context );
1116: l_attr_grp_ids_list := l_po_uda_usage_object.Attr_group_Id;