eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_PDOI_MAINPROC_PVT dependencies on PO_LINES_INTERFACE

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

487: --Modifies:
488: --Locks:
489: -- None
490: --Function:
491: -- process the records in po_lines_interface table;
492: -- the records in the interface table will be divided into four sets
493: -- according to their header and line level actions:
494: -- First set: all the lines with header action equal to 'ORIGINAL'or
495: -- 'REPLACE'; If header action is 'UPDATE', the document

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

830: );
831:
832: d_position := 90;
833:
834: -- update po_lines_interface with po_line_id and line level action
835: PO_PDOI_LINE_PROCESS_PVT.update_line_intf_tbl
836: (
837: x_lines => l_lines
838: );

Line 934: FROM po_lines_interface intf_line1

930:
931: -- reject lines that are price breaks if main po line failed
932: SELECT interface_line_id
933: BULK COLLECT INTO l_rej_intf_line_id_tbl
934: FROM po_lines_interface intf_line1
935: WHERE price_break_flag = 'Y'
936: AND processing_id = PO_PDOI_PARAMS.g_processing_id
937: AND EXISTS(
938: SELECT 'Y'

Line 939: FROM po_lines_interface intf_line2

935: WHERE price_break_flag = 'Y'
936: AND processing_id = PO_PDOI_PARAMS.g_processing_id
937: AND EXISTS(
938: SELECT 'Y'
939: FROM po_lines_interface intf_line2
940: WHERE intf_line1.interface_header_id = intf_line2.interface_header_id
941: AND intf_line1.po_line_id = intf_line2.po_line_id
942: AND NVL(intf_line2.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
943: = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED

Line 956: UPDATE po_lines_interface intf_line1

952:
953: d_position := 160;
954:
955: -- set status to NOTIFIED for price break lines if main po line is NOTIFIED
956: UPDATE po_lines_interface intf_line1
957: SET intf_line1.process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED
958: WHERE intf_line1.processing_id = PO_PDOI_PARAMS.g_processing_id
959: AND intf_line1.price_break_flag = 'Y'
960: AND EXISTS(

Line 962: FROM po_lines_interface intf_line2

958: WHERE intf_line1.processing_id = PO_PDOI_PARAMS.g_processing_id
959: AND intf_line1.price_break_flag = 'Y'
960: AND EXISTS(
961: SELECT 'Y'
962: FROM po_lines_interface intf_line2
963: WHERE intf_line2.interface_header_id = intf_line1.interface_header_id
964: AND intf_line2.po_line_id = intf_line1.po_line_id
965: AND NVL(intf_line2.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
966: = PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED

Line 1274: FROM po_lines_interface intf_line1,

1270:
1271: -- reject lines that are price breaks if main po line failed
1272: SELECT v.interface_line_id
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

Line 1276: FROM po_lines_interface intf_line2, po_lines_interface intf_line3,

1272: SELECT v.interface_line_id
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

Line 1306: FROM po_lines_interface intf_line1,

1302:
1303: -- set status to NOTIFIED for price break lines if main po line is NOTIFIED
1304: SELECT v.interface_line_id
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

Line 1308: FROM po_lines_interface intf_line2, po_lines_interface intf_line3,

1304: SELECT v.interface_line_id
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

Line 1327: UPDATE po_lines_interface

1323:
1324: d_position := 150;
1325:
1326: FORALL i IN 1..l_notified_intf_line_id_tbl.COUNT
1327: UPDATE po_lines_interface
1328: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED
1329: WHERE interface_line_id = l_notified_intf_line_id_tbl(i);
1330:
1331: d_position := 160;

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

1451: );
1452:
1453: d_position := 60;
1454:
1455: -- update po_lines_interface with po_line_id and line level action
1456: PO_PDOI_LINE_PROCESS_PVT.update_line_intf_tbl
1457: (
1458: x_lines => x_lines
1459: );

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

1596: );
1597:
1598: d_position := 30;
1599:
1600: -- update po_lines_interface with po_line_id and line level action
1601: PO_PDOI_LINE_PROCESS_PVT.update_line_intf_tbl
1602: (
1603: x_lines => x_lines
1604: );

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

3057: );
3058:
3059: d_position := 90;
3060:
3061: -- update po_lines_interface with po_line_id and line level action
3062: PO_PDOI_LINE_PROCESS_PVT.update_line_intf_tbl
3063: (
3064: x_lines => l_lines
3065: );

Line 3174: FROM po_lines_draft_all draft_lines, po_lines_interface intf_lines,

3170: CURSOR c_slins
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

Line 3196: FROM po_lines_interface pli, po_lines_draft_all pld

3192: LOOP
3193: UPDATE po_lines_draft_all
3194: SET group_line_id =
3195: (SELECT pld.po_line_id
3196: FROM po_lines_interface pli, po_lines_draft_all pld
3197: WHERE 1 = 1
3198: AND pld.po_header_id = l_rec.po_header_id
3199: AND pld.group_line_id IS NULL
3200: AND pld.line_num = pli.line_num

Line 3241: FROM po_lines_interface

3237: --collect po_line_id and corressponding clm_base_line_num for all base lines
3238: SELECT clm_base_line_num,
3239: po_line_id
3240: BULK COLLECT INTO l_clm_base_line_num_tbl, l_po_line_id_tbl
3241: FROM po_lines_interface
3242: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
3243: AND Nvl(clm_option_indicator,'*') = 'O';
3244:
3245: d_position := 10;

Line 3252: SET clm_base_line_num = ( SELECT po_line_id FROM po_lines_interface

3248: END IF;
3249:
3250: FORALL i IN 1..l_clm_base_line_num_tbl.Count
3251: UPDATE po_lines_draft_all
3252: SET clm_base_line_num = ( SELECT po_line_id FROM po_lines_interface
3253: WHERE interface_line_id = l_clm_base_line_num_tbl(i)
3254: )
3255: WHERE l_clm_base_line_num_tbl(i) IS NOT NULL
3256: AND po_line_id = l_po_line_id_tbl(i);