APPS.OKC_REP_UDA_FUNCTIONS dependencies on PON_AUCTION_HEADERS_ALL

Line 151: FROM pon_auction_headers_all

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
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

Line 189: FROM pon_auction_headers_all

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
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

Line 262: FROM pon_auction_headers_all

258:
259: BEGIN
260: IF p_source_doc_type = 'SOLICITATION' THEN
261: SELECT currency_code INTO x_currency
262: FROM pon_auction_headers_all
263: WHERE auction_header_id = p_source_doc_id;
264: ELSE --for doc types PO_STANDARD_MOD, PA_BLANKET_MOD, PA_CONTRACT_MOD
265: SELECT currency_code INTO x_currency
266: FROM po_headers_draft_all

Line 347: FROM pon_auction_headers_all

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
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