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
102: po_moac_utils_pvt.get_current_org_id*/
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
102: po_moac_utils_pvt.get_current_org_id*/
103: );
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
102: po_moac_utils_pvt.get_current_org_id*/
103: );
104: ELSIF p_caller = 'PO_MOD' OR p_caller = 'PO' THEN
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
110: 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
110: po_moac_utils_pvt.get_current_org_id*/
111: );
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
110: po_moac_utils_pvt.get_current_org_id*/
111: );
112: END IF;
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(
219: 'DRAFT_ID', p_draft_id
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(
219: 'DRAFT_ID', p_draft_id
220: )
221: );
222:
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: );
233: 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 || ''
311: )
312: );
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(
5057: 'DRAFT_ID', p_po_draft_id
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(
5057: 'DRAFT_ID', p_po_draft_id
5058: )
5059: );
5060:
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'
5119: ,p_uda_template_id || ''
5120: )
5246: FROM FND_DESCR_FLEX_COLUMN_USAGES
5247: WHERE DESCRIPTIVE_FLEXFIELD_NAME = p_ag_type
5248: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_ag_name;
5249:
5250: l_ext_name_val_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
5251: l_delimiter VARCHAR2(2);
5252:
5253: BEGIN
5254:
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(
5318: 'DRAFT_ID', Nvl(p_draft_id,-1)
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(
5318: 'DRAFT_ID', Nvl(p_draft_id,-1)
5319: )
5320: );
5321: