[Home] [Help]
183: --Locks:
184: -- None
185: --Function:
186: -- handle the logic to derive, default, validate and insert records
187: -- from po_headers_interface table
188: --Parameters:
189: --IN: None
190: --IN OUT: None
191: --OUT: None
365: END IF;
366:
367:
368: -- Bug:16730873
369: -- From Catalog Upload process the action in po_headers_interface
370: -- table is stamped as 'UPDATE', and in the sql used in open_headers proc
371: -- we look for the data in po_headers_interface with
372: -- actions in ('ORIGINAL',REPLACE'). So No data is returned and hence
373: -- No data is dumped in PO_headers_draft_all [This is the beahvior since begining]
367:
368: -- Bug:16730873
369: -- From Catalog Upload process the action in po_headers_interface
370: -- table is stamped as 'UPDATE', and in the sql used in open_headers proc
371: -- we look for the data in po_headers_interface with
372: -- actions in ('ORIGINAL',REPLACE'). So No data is returned and hence
373: -- No data is dumped in PO_headers_draft_all [This is the beahvior since begining]
374: -- When there is Some change made by Cat. Admin/Supplier which is not yet sent to Buyer
375: -- Would lie in Drafts Table and the data state would be like this
385: -- Draft_Id =-1 would come if there is No Data in Po_Drafts Or it should be 'COMPLETED'
386: -- or 'WITHDRAWN' status
387: -- So, Agreement coluld not be opened for Cat. admin any more.
388: -- So ,in order to support that case, inserting data in po_headers_draft_all
389: -- when the process in initiated from CATALOG_UPLOAD and action in po_headers_interface ='UPDATE'
390:
391: d_position := 100;
392:
393: IF (PO_PDOI_PARAMS.g_request.calling_module =
406: l_headers.draft_id_tbl,
407: l_headers.po_header_id_tbl,
408: l_delete_tbl
409:
410: FROM po_headers_interface
411: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
412: AND processing_round_num = PO_PDOI_PARAMS.g_current_round_num
413: AND interface_header_id > l_max_intf_header_id
414: AND action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE
672: /*
673: -- code added for debugging purpose
674: select interface_header_id
675: into PO_PDOI_PARAMS.g_request.interface_header_id
676: from po_headers_interface
677: where processing_id = PO_PDOI_PARAMS.g_processing_id
678: and processing_round_num = 1;
679: */
680:
1273: BULK COLLECT INTO l_rej_intf_line_id_tbl
1274: FROM po_lines_interface intf_line1,
1275: (SELECT intf_line2.interface_line_id, max(intf_line3.interface_line_id) AS match_intf_line_id
1276: FROM po_lines_interface intf_line2, po_lines_interface intf_line3,
1277: po_headers_interface intf_headers
1278: WHERE intf_line2.interface_header_id = intf_headers.interface_header_id
1279: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
1280: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
1281: AND intf_line2.price_break_flag = 'Y'
1305: BULK COLLECT INTO l_notified_intf_line_id_tbl
1306: FROM po_lines_interface intf_line1,
1307: (SELECT intf_line2.interface_line_id, max(intf_line3.interface_line_id) AS match_intf_line_id
1308: FROM po_lines_interface intf_line2, po_lines_interface intf_line3,
1309: po_headers_interface intf_headers
1310: WHERE intf_line2.interface_header_id = intf_headers.interface_header_id
1311: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
1312: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
1313: AND intf_line2.price_break_flag = 'Y'
3171: IS
3172: SELECT intf_lines.group_line_id, draft_lines.po_line_id,
3173: draft_lines.draft_id, draft_lines.po_header_id
3174: FROM po_lines_draft_all draft_lines, po_lines_interface intf_lines,
3175: po_headers_interface intf_headers
3176: WHERE intf_lines.group_line_id IS NOT NULL
3177: AND intf_lines.interface_header_id =
3178: intf_headers.interface_header_id
3179: AND intf_lines.line_num = draft_lines.line_num