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_MOD_CONTROL_PVT dependencies on PO_LINES_DRAFT_ALL

Line 180: FROM po_lines_draft_all

176:
177: -- Collect all withdrawn lines
178: SELECT po_line_id
179: BULK COLLECT INTO l_withdrawn_line_list
180: FROM po_lines_draft_all
181: WHERE draft_id = p_draft_id;
182:
183: -- Collect all withdrawn distributions
184: SELECT po_distribution_id

Line 214: FROM po_lines_draft_all pld

210: -- : Return the header and line dummy reqs if any to DWB
211: -- Collect all PAR withdrawn lines
212: SELECT po_line_id
213: BULK COLLECT INTO l_withdrawn_par_line_list
214: FROM po_lines_draft_all pld
215: WHERE draft_id = p_draft_id
216: AND EXISTS (SELECT 'PAR Line' FROM po_lines_draft_all
217: WHERE mod_line_id = pld.po_line_id
218: );

Line 216: AND EXISTS (SELECT 'PAR Line' FROM po_lines_draft_all

212: SELECT po_line_id
213: BULK COLLECT INTO l_withdrawn_par_line_list
214: FROM po_lines_draft_all pld
215: WHERE draft_id = p_draft_id
216: AND EXISTS (SELECT 'PAR Line' FROM po_lines_draft_all
217: WHERE mod_line_id = pld.po_line_id
218: );
219:
220: -- Collect all PAR withdrawn distributions

Line 451: FROM po_lines_draft_all

447:
448: -- Collect all deleted lines
449: SELECT po_line_id
450: BULK COLLECT INTO l_deleted_line_list
451: FROM po_lines_draft_all
452: WHERE draft_id = p_draft_id;
453:
454: -- Collect all deleted distributions
455: SELECT po_distribution_id

Line 562: FROM po_lines_draft_all

558:
559: DELETE FROM po_lines_all_ext_b
560: WHERE (draft_id = p_draft_id --main record for Mod
561: AND po_line_id IN (SELECT po_line_id
562: FROM po_lines_draft_all
563: WHERE po_header_id = p_entity_id
564: AND draft_id = p_draft_id))
565: OR (draft_id = -p_draft_id -- delta record for Mod complex pricing attribute
566: AND po_line_id IN (SELECT -po_line_id

Line 567: FROM po_lines_draft_all

563: WHERE po_header_id = p_entity_id
564: AND draft_id = p_draft_id))
565: OR (draft_id = -p_draft_id -- delta record for Mod complex pricing attribute
566: AND po_line_id IN (SELECT -po_line_id
567: FROM po_lines_draft_all
568: WHERE po_header_id = p_entity_id
569: AND draft_id = p_draft_id)
570: AND pk1_value = -p_draft_id)
571: OR (draft_id = -1 -- old record for Mod Complex pricing.

Line 574: FROM po_lines_draft_all

570: AND pk1_value = -p_draft_id)
571: OR (draft_id = -1 -- old record for Mod Complex pricing.
572: AND pk1_value = p_draft_id --: pk1_value is the p_draft_id not -1
573: AND po_line_id IN (SELECT po_Line_id
574: FROM po_lines_draft_all
575: WHERE po_header_id = p_entity_id
576: AND draft_id = p_draft_id));
577:
578: DELETE FROM po_lines_all_ext_tl

Line 581: FROM po_lines_draft_all

577:
578: DELETE FROM po_lines_all_ext_tl
579: WHERE (draft_id = p_draft_id --main record for Mod
580: AND po_line_id IN (SELECT po_line_id
581: FROM po_lines_draft_all
582: WHERE po_header_id = p_entity_id
583: AND draft_id = p_draft_id))
584: OR (draft_id = -p_draft_id -- delta record for Mod complex pricing attribute
585: AND po_line_id IN (SELECT -po_line_id

Line 586: FROM po_lines_draft_all

582: WHERE po_header_id = p_entity_id
583: AND draft_id = p_draft_id))
584: OR (draft_id = -p_draft_id -- delta record for Mod complex pricing attribute
585: AND po_line_id IN (SELECT -po_line_id
586: FROM po_lines_draft_all
587: WHERE po_header_id = p_entity_id
588: AND draft_id = p_draft_id)
589: AND pk1_value = -p_draft_id)
590: OR (draft_id = -1 -- old record for Mod Complex pricing.

Line 593: FROM po_lines_draft_all

589: AND pk1_value = -p_draft_id)
590: OR (draft_id = -1 -- old record for Mod Complex pricing.
591: AND pk1_value = p_draft_id --: pk1_value is the p_draft_id not -1
592: AND po_line_id IN (SELECT po_Line_id
593: FROM po_lines_draft_all
594: WHERE po_header_id = p_entity_id
595: AND draft_id = p_draft_id));
596:
597: DELETE FROM po_line_locations_all_ext_b

Line 759: update po_lines_draft_all

755:
756: d_position := 50;
757: -- If return status success, then go ahead
758:
759: update po_lines_draft_all
760: set control_action = p_action
761: where draft_id = p_draft_id;
762:
763: d_position := 60;

Line 1128: line_status_code po_lines_draft_all.draft_line_status%TYPE;

1124: l_req_enc_on BOOLEAN;
1125: l_enc_ret_code VARCHAR2(10);
1126: l_enc_report_id NUMBER;
1127: l_org_id NUMBER;
1128: line_status_code po_lines_draft_all.draft_line_status%TYPE;
1129: l_sequence_num NUMBER;
1130: l_object_rev_num NUMBER;
1131: l_approval_path_id NUMBER;
1132:

Line 1293: UPDATE po_lines_draft_all

1289: d_position := 120;
1290:
1291: -- Update lines with status Withdrawn
1292:
1293: UPDATE po_lines_draft_all
1294: SET draft_line_status = 'WITHDRAWN'
1295: WHERE draft_id = p_draft_id
1296: AND draft_line_status NOT IN( 'MOD_CREATED', 'PO_CREATED' );
1297:

Line 1314: FROM po_lines_draft_all

1310: 'PO_CREATED', 3,
1311: 'RETURNED', 4,
1312: 'WITHDRAWN', 5,
1313: 'COMPLETED', 6) ASC) priority
1314: FROM po_lines_draft_all
1315: WHERE draft_id = p_draft_id)
1316: WHERE priority = 1;
1317: d_position := 130;
1318: EXCEPTION