APPS.PO_DOC_NUMBERING_PKG dependencies on EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 22: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;

18:
19: l_po_uda_usage_object_array PO_UDA_USAGE_OBJECT_ARRAY;
20: l_template_id NUMBER;
21: l_po_uda_usage_object PO_UDA_USAGE_OBJECT;
22: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;
23:
24: l_return_status VARCHAR2(2);
25: l_errorcode NUMBER;
26: l_msg_count NUMBER;

Line 38: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

34: l_attr_list VARCHAR2(2000);
35: l_attr_group_id NUMBER;
36: l_attr_group_name VARCHAR2(30);
37: l_attr_group_request_table EGO_ATTR_GROUP_REQUEST_TABLE;
38: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
39: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
40: l_external_attr_value_pairs EGO_COL_NAME_VALUE_PAIR_TABLE;
41: l_src_object_name VARCHAR2(200);
42: l_src_data_level VARCHAR2(100) := 'PO_HEADER';

Line 39: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

35: l_attr_group_id NUMBER;
36: l_attr_group_name VARCHAR2(30);
37: l_attr_group_request_table EGO_ATTR_GROUP_REQUEST_TABLE;
38: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
39: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
40: l_external_attr_value_pairs EGO_COL_NAME_VALUE_PAIR_TABLE;
41: l_src_object_name VARCHAR2(200);
42: l_src_data_level VARCHAR2(100) := 'PO_HEADER';
43: l_source_org_owned VARCHAR2(2) := p_source_org_owned;

Line 97: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY(

93: PO_LOG.proc_begin(d_module, 'Source IDV number ', l_idv_number);
94: END IF;
95:
96: IF p_caller = 'REQ' OR p_caller = 'SOL' OR p_caller = 'SOL_AMD' THEN
97: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY(
98: EGO_COL_NAME_VALUE_PAIR_OBJ('DOCUMENT_TYPE', p_context_usage),
99: EGO_COL_NAME_VALUE_PAIR_OBJ('ISSUING_ORG_OWNED', l_source_org_owned),
100: EGO_COL_NAME_VALUE_PAIR_OBJ('ORG_ID', To_Char(l_org_id))
101: /*Bug 13241358/12881115: instead of using fnd_global.org_id use

Line 105: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY(

101: /*Bug 13241358/12881115: instead of using fnd_global.org_id use
102: po_moac_utils_pvt.get_current_org_id*/
103: );
104: ELSIF p_caller = 'PO_MOD' OR p_caller = 'PO' THEN
105: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY(
106: EGO_COL_NAME_VALUE_PAIR_OBJ('DOCUMENT_TYPE', p_context_usage),
107: EGO_COL_NAME_VALUE_PAIR_OBJ('ISSUING_ORG_OWNED', l_source_org_owned),
108: EGO_COL_NAME_VALUE_PAIR_OBJ('ORG_ID', To_Char(l_org_id))
109: /*Bug 13241358/12881115: instead of using fnd_global.org_id use

Line 214: l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

210:
211: l_ag_type := 'PO_HEADER_EXT_ATTRS';
212: l_src_data_level := 'PO_HEADER';
213:
214: l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
215: EGO_COL_NAME_VALUE_PAIR_OBJ(
216: 'PO_HEADER_ID', p_doc_header_id
217: ),
218: EGO_COL_NAME_VALUE_PAIR_OBJ(

Line 228: l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

224:
225: l_ag_type := 'PON_AUC_HDRS_EXT_ATTRS';
226: l_src_data_level := 'PON_AUC_HEADER';
227:
228: l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
229: EGO_COL_NAME_VALUE_PAIR_OBJ(
230: 'AUCTION_HEADER_ID', p_doc_header_id
231: )
232: );

Line 306: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY

302: );
303: END IF;
304:
305:
306: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
307: (
308: EGO_COL_NAME_VALUE_PAIR_OBJ
309: (
310: 'UDA_TEMPLATE_ID',p_template_id || ''

Line 5011: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

5007: l_attr_list VARCHAR2(2000);
5008: l_attr_group_id NUMBER;
5009: l_attr_group_name VARCHAR2(30);
5010: l_attr_group_request_table EGO_ATTR_GROUP_REQUEST_TABLE;
5011: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
5012: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
5013: l_external_attr_value_pairs EGO_COL_NAME_VALUE_PAIR_TABLE;
5014: l_src_object_name VARCHAR2(200);
5015: l_src_data_level VARCHAR2(100) := 'PO_HEADER';

Line 5012: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

5008: l_attr_group_id NUMBER;
5009: l_attr_group_name VARCHAR2(30);
5010: l_attr_group_request_table EGO_ATTR_GROUP_REQUEST_TABLE;
5011: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
5012: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
5013: l_external_attr_value_pairs EGO_COL_NAME_VALUE_PAIR_TABLE;
5014: l_src_object_name VARCHAR2(200);
5015: l_src_data_level VARCHAR2(100) := 'PO_HEADER';
5016:

Line 5052: l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

5048: l_attr_list := l_attr_list || ',' || l_attr_list_rec.END_USER_COLUMN_NAME;
5049: END IF;
5050: END LOOP;
5051:
5052: l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
5053: EGO_COL_NAME_VALUE_PAIR_OBJ(
5054: 'PO_HEADER_ID', p_po_header_id
5055: ),
5056: EGO_COL_NAME_VALUE_PAIR_OBJ(

Line 5114: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY

5110: ,x_msg_data => x_msg_data
5111: );
5112: END IF;
5113:
5114: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
5115: (
5116: EGO_COL_NAME_VALUE_PAIR_OBJ
5117: (
5118: 'UDA_TEMPLATE_ID'

Line 5239: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

5235: l_attr_list VARCHAR2(2000);
5236: l_attrb_grp_id NUMBER;
5237:
5238: l_attr_group_request_table EGO_ATTR_GROUP_REQUEST_TABLE;
5239: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
5240: l_external_attr_value_pairs EGO_COL_NAME_VALUE_PAIR_TABLE;
5241: --bug 13054072
5242: l_org_id NUMBER;
5243:

Line 5313: l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

5309:
5310: END;
5311: -- bug 13054072 ends
5312:
5313: l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
5314: EGO_COL_NAME_VALUE_PAIR_OBJ(
5315: 'PO_HEADER_ID', p_po_header_id
5316: ),
5317: EGO_COL_NAME_VALUE_PAIR_OBJ(