[Home] [Help]
145: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulting Buyer Name from source document ');
146: END IF;
147: BEGIN
148: IF p_source_doc_type = 'SOLICITATION' THEN
149: SELECT PO_UDA_PUB.get_address_attr_value(uda_template_id, NULL, auction_header_id, NULL, NULL, NULL, NULL, NULL, 'addresses', NULL, 'contact', 'ISSUING_OFFICE', 'DISPLAY_VALUE')
150: INTO x_buyer_name
151: FROM pon_auction_headers_all
152: WHERE auction_header_id = p_source_doc_id;
153: ELSE --for doc types PO_STANDARD_MOD, PA_BLANKET_MOD, PA_CONTRACT_MOD
150: INTO x_buyer_name
151: FROM pon_auction_headers_all
152: WHERE auction_header_id = p_source_doc_id;
153: ELSE --for doc types PO_STANDARD_MOD, PA_BLANKET_MOD, PA_CONTRACT_MOD
154: SELECT PO_UDA_PUB.get_address_attr_value(uda_template_id, NULL, po_header_id, draft_id, NULL, NULL, NULL, NULL, 'addresses', NULL, 'contact', 'ISSUING_OFFICE', 'DISPLAY_VALUE')
155: INTO x_buyer_name
156: FROM po_headers_draft_all
157: WHERE draft_id = p_source_doc_id;
158: END IF;
183: END IF;
184:
185: BEGIN
186: IF p_source_doc_type = 'SOLICITATION' THEN
187: SELECT PO_UDA_PUB.get_address_attr_value(uda_template_id, NULL, auction_header_id, NULL, NULL, NULL, NULL, NULL, 'addresses', NULL, 'addresscode', 'ISSUING_OFFICE', 'DISPLAY_VALUE')
188: INTO x_issuing_off_symbol
189: FROM pon_auction_headers_all
190: WHERE auction_header_id = p_source_doc_id;
191: ELSE --for doc types PO_STANDARD_MOD, PA_BLANKET_MOD, PA_CONTRACT_MOD
188: INTO x_issuing_off_symbol
189: FROM pon_auction_headers_all
190: WHERE auction_header_id = p_source_doc_id;
191: ELSE --for doc types PO_STANDARD_MOD, PA_BLANKET_MOD, PA_CONTRACT_MOD
192: SELECT PO_UDA_PUB.get_address_attr_value(uda_template_id, NULL, po_header_id, draft_id, NULL, NULL, NULL, NULL, 'addresses', NULL, 'addresscode', 'ISSUING_OFFICE', 'DISPLAY_VALUE')
193: INTO x_issuing_off_symbol
194: FROM po_headers_draft_all
195: WHERE draft_id = p_source_doc_id;
196: END IF;
293: END IF;
294:
295: BEGIN
296: IF p_source_doc_type = 'SOLICITATION' THEN
297: x_naics_code := PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PON_AUC_PRICES_EXT_ATTRS',
298: pk1_value => p_source_doc_id,
299: pk2_value => l_auc_line_num,
300: p_attr_grp_int_name => 'FED_CUST_DESG',
301: p_attr_int_name => 'NAICS');
301: p_attr_int_name => 'NAICS');
302:
303: ELSIF p_source_doc_type = 'PA_CONTRACT_MOD' THEN
304: --for IDV without lines document, there will nto be lines, getting the value from header
305: SELECT PO_UDA_PUB.get_single_attr_value(uda_template_id, NULL, po_header_id, draft_id, NULL, NULL, NULL, NULL, 'SET_ASIDE_INFO', NULL, 'NAICS', 'INTERNAL_VALUE' )
306: INTO x_naics_code
307: FROM po_headers_draft_all
308: WHERE draft_id = p_source_doc_id;
309:
307: FROM po_headers_draft_all
308: WHERE draft_id = p_source_doc_id;
309:
310: ELSE -- for doc types PO_STANDARD_MOD, PA_BLANKET_MOD
311: x_naics_code := PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_LINE_EXT_ATTRS',
312: pk1_value => l_po_line_id,
313: pk2_value => p_source_doc_id,
314: p_attr_grp_int_name => 'FED_CUST_DESG',
315: p_attr_int_name => 'NAICS');
341: END IF;
342:
343: BEGIN
344: IF p_source_doc_type = 'SOLICITATION' THEN
345: SELECT PO_UDA_PUB.get_single_attr_value(uda_template_id, NULL, auction_header_id, NULL, NULL, NULL, NULL, NULL, 'SET_ASIDE_INFO', NULL, 'SIZE_STANDARD', 'INTERNAL_VALUE')
346: INTO x_size_standard
347: FROM pon_auction_headers_all
348: WHERE auction_header_id = p_source_doc_id;
349: ELSE --for doc types PO_STANDARD_MOD, PA_BLANKET_MOD, PA_CONTRACT_MOD
346: INTO x_size_standard
347: FROM pon_auction_headers_all
348: WHERE auction_header_id = p_source_doc_id;
349: ELSE --for doc types PO_STANDARD_MOD, PA_BLANKET_MOD, PA_CONTRACT_MOD
350: SELECT PO_UDA_PUB.get_single_attr_value(uda_template_id, NULL, po_header_id, draft_id, NULL, NULL, NULL, NULL, 'SET_ASIDE_INFO', NULL, 'SIZE_STANDARD', 'INTERNAL_VALUE')
351: INTO x_size_standard
352: FROM po_headers_draft_all
353: WHERE draft_id = p_source_doc_id;
354: END IF;
379: END IF;
380:
381: BEGIN
382: IF p_source_doc_type = 'SOLICITATION' THEN
383: x_fsc_svc_code := PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PON_AUC_PRICES_EXT_ATTRS',
384: pk1_value => p_source_doc_id,
385: pk2_value => l_auc_line_num,
386: p_attr_grp_int_name => 'FED_CUST_DESG',
387: p_attr_int_name => 'FSC_PSC');
387: p_attr_int_name => 'FSC_PSC');
388:
389: ELSIF p_source_doc_type = 'PA_CONTRACT_MOD' THEN
390: --for IDV without lines document, there will nto be lines, getting the value from header
391: SELECT PO_UDA_PUB.get_multi_attr_value(uda_template_id, NULL, po_header_id, draft_id, NULL, NULL, NULL, NULL, 'FSC_PSC', NULL, 'FSC_PSC', NULL, 'INTERNAL_VALUE')
392: INTO l_fsc_svc_codes
393: FROM po_headers_draft_all
394: WHERE draft_id = p_source_doc_id;
395:
397: x_fsc_svc_code := l_fsc_svc_codes(1);
398: END IF;
399:
400: ELSE -- for doc types PO_STANDARD_MOD, PA_BLANKET_MOD
401: x_fsc_svc_code := PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_LINE_EXT_ATTRS',
402: pk1_value => l_po_line_id,
403: pk2_value => p_source_doc_id,
404: p_attr_grp_int_name => 'FED_CUST_DESG',
405: p_attr_int_name => 'FSC_PSC');
431: END IF;
432:
433: BEGIN
434: IF p_source_doc_type = 'SOLICITATION' THEN
435: x_item_long_desc := PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PON_AUC_PRICES_EXT_ATTRS',
436: pk1_value => p_source_doc_id,
437: pk2_value => l_auc_line_num,
438: p_attr_grp_int_name => 'ADD_ITEM_INFO',
439: p_attr_int_name => 'EXTND_DESC');
439: p_attr_int_name => 'EXTND_DESC');
440:
441: ELSIF p_source_doc_type = 'PO_STANDARD_MOD' OR p_source_doc_type = 'PA_BLANKET_MOD' THEN
442: --for doc types PO_STANDARD_MOD, PA_BLANKET_MOD (PA_CONTRACT_MOD doesn't have lines)
443: x_item_long_desc := PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_LINE_EXT_ATTRS',
444: pk1_value => l_po_line_id,
445: pk2_value => p_source_doc_id,
446: p_attr_grp_int_name => 'ADD_ITEM_INFO',
447: p_attr_int_name => 'EXTND_DESC');