APPS.PO_PDOI_MAINPROC_PVT dependencies on PO_LINES_INTERFACE

Line 371: -- process the records in po_lines_interface table;

367: --Modifies:
368: --Locks:
369: -- None
370: --Function:
371: -- process the records in po_lines_interface table;
372: -- the records in the interface table will be divided into four sets
373: -- according to their header and line level actions:
374: -- First set: all the lines with header action equal to 'ORIGINAL'or
375: -- 'REPLACE'; If header action is 'UPDATE', the document

Line 688: -- update po_lines_interface with po_line_id and line level action

684: );
685:
686: d_position := 90;
687:
688: -- update po_lines_interface with po_line_id and line level action
689: PO_PDOI_LINE_PROCESS_PVT.update_line_intf_tbl
690: (
691: x_lines => l_lines
692: );

Line 771: FROM po_lines_interface intf_line1

767:
768: -- reject lines that are price breaks if main po line failed
769: SELECT interface_line_id
770: BULK COLLECT INTO l_rej_intf_line_id_tbl
771: FROM po_lines_interface intf_line1
772: WHERE price_break_flag = 'Y'
773: AND processing_id = PO_PDOI_PARAMS.g_processing_id
774: AND EXISTS(
775: SELECT 'Y'

Line 776: FROM po_lines_interface intf_line2

772: WHERE price_break_flag = 'Y'
773: AND processing_id = PO_PDOI_PARAMS.g_processing_id
774: AND EXISTS(
775: SELECT 'Y'
776: FROM po_lines_interface intf_line2
777: WHERE intf_line1.interface_header_id = intf_line2.interface_header_id
778: AND intf_line1.po_line_id = intf_line2.po_line_id
779: AND NVL(intf_line2.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
780: = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED

Line 793: UPDATE po_lines_interface intf_line1

789:
790: d_position := 160;
791:
792: -- set status to NOTIFIED for price break lines if main po line is NOTIFIED
793: UPDATE po_lines_interface intf_line1
794: SET intf_line1.process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED
795: WHERE intf_line1.processing_id = PO_PDOI_PARAMS.g_processing_id
796: AND intf_line1.price_break_flag = 'Y'
797: AND EXISTS(

Line 799: FROM po_lines_interface intf_line2

795: WHERE intf_line1.processing_id = PO_PDOI_PARAMS.g_processing_id
796: AND intf_line1.price_break_flag = 'Y'
797: AND EXISTS(
798: SELECT 'Y'
799: FROM po_lines_interface intf_line2
800: WHERE intf_line2.interface_header_id = intf_line1.interface_header_id
801: AND intf_line2.po_line_id = intf_line1.po_line_id
802: AND NVL(intf_line2.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
803: = PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED

Line 1111: FROM po_lines_interface intf_line1,

1107:
1108: -- reject lines that are price breaks if main po line failed
1109: SELECT v.interface_line_id
1110: BULK COLLECT INTO l_rej_intf_line_id_tbl
1111: FROM po_lines_interface intf_line1,
1112: (SELECT intf_line2.interface_line_id, max(intf_line3.interface_line_id) AS match_intf_line_id
1113: FROM po_lines_interface intf_line2, po_lines_interface intf_line3,
1114: po_headers_interface intf_headers
1115: WHERE intf_line2.interface_header_id = intf_headers.interface_header_id

Line 1113: FROM po_lines_interface intf_line2, po_lines_interface intf_line3,

1109: SELECT v.interface_line_id
1110: BULK COLLECT INTO l_rej_intf_line_id_tbl
1111: FROM po_lines_interface intf_line1,
1112: (SELECT intf_line2.interface_line_id, max(intf_line3.interface_line_id) AS match_intf_line_id
1113: FROM po_lines_interface intf_line2, po_lines_interface intf_line3,
1114: po_headers_interface intf_headers
1115: WHERE intf_line2.interface_header_id = intf_headers.interface_header_id
1116: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
1117: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num

Line 1143: FROM po_lines_interface intf_line1,

1139:
1140: -- set status to NOTIFIED for price break lines if main po line is NOTIFIED
1141: SELECT v.interface_line_id
1142: BULK COLLECT INTO l_notified_intf_line_id_tbl
1143: FROM po_lines_interface intf_line1,
1144: (SELECT intf_line2.interface_line_id, max(intf_line3.interface_line_id) AS match_intf_line_id
1145: FROM po_lines_interface intf_line2, po_lines_interface intf_line3,
1146: po_headers_interface intf_headers
1147: WHERE intf_line2.interface_header_id = intf_headers.interface_header_id

Line 1145: FROM po_lines_interface intf_line2, po_lines_interface intf_line3,

1141: SELECT v.interface_line_id
1142: BULK COLLECT INTO l_notified_intf_line_id_tbl
1143: FROM po_lines_interface intf_line1,
1144: (SELECT intf_line2.interface_line_id, max(intf_line3.interface_line_id) AS match_intf_line_id
1145: FROM po_lines_interface intf_line2, po_lines_interface intf_line3,
1146: po_headers_interface intf_headers
1147: WHERE intf_line2.interface_header_id = intf_headers.interface_header_id
1148: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
1149: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num

Line 1164: UPDATE po_lines_interface

1160:
1161: d_position := 150;
1162:
1163: FORALL i IN 1..l_notified_intf_line_id_tbl.COUNT
1164: UPDATE po_lines_interface
1165: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED
1166: WHERE interface_line_id = l_notified_intf_line_id_tbl(i);
1167:
1168: d_position := 160;

Line 1292: -- update po_lines_interface with po_line_id and line level action

1288: );
1289:
1290: d_position := 60;
1291:
1292: -- update po_lines_interface with po_line_id and line level action
1293: PO_PDOI_LINE_PROCESS_PVT.update_line_intf_tbl
1294: (
1295: x_lines => x_lines
1296: );

Line 1437: -- update po_lines_interface with po_line_id and line level action

1433: );
1434:
1435: d_position := 30;
1436:
1437: -- update po_lines_interface with po_line_id and line level action
1438: PO_PDOI_LINE_PROCESS_PVT.update_line_intf_tbl
1439: (
1440: x_lines => x_lines
1441: );