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_TBL_NUMBER

Line 15: l_po_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

11: d_api_name CONSTANT VARCHAR2(30) := 'process_mod_control_action';
12: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
13: d_position NUMBER;
14:
15: l_po_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
16: l_po_draft_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
17: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
18: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
19:

Line 16: l_po_draft_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

12: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
13: d_position NUMBER;
14:
15: l_po_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
16: l_po_draft_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
17: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
18: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
19:
20: begin

Line 98: --l_withdrawn_par_dist_list PO_TBL_NUMBER;

94: l_mod_number po_drafts.modification_number%TYPE;
95: l_item_status varchar2(10);
96: l_result VARCHAR2(10);
97: --bug 15905347 start
98: --l_withdrawn_par_dist_list PO_TBL_NUMBER;
99: --l_withdrawn_par_line_list PO_TBL_NUMBER;
100: l_withdrawn_line_list PO_TBL_NUMBER;
101: l_withdrawn_dist_list PO_TBL_NUMBER;
102: --bug 15905347 end

Line 99: --l_withdrawn_par_line_list PO_TBL_NUMBER;

95: l_item_status varchar2(10);
96: l_result VARCHAR2(10);
97: --bug 15905347 start
98: --l_withdrawn_par_dist_list PO_TBL_NUMBER;
99: --l_withdrawn_par_line_list PO_TBL_NUMBER;
100: l_withdrawn_line_list PO_TBL_NUMBER;
101: l_withdrawn_dist_list PO_TBL_NUMBER;
102: --bug 15905347 end
103:

Line 100: l_withdrawn_line_list PO_TBL_NUMBER;

96: l_result VARCHAR2(10);
97: --bug 15905347 start
98: --l_withdrawn_par_dist_list PO_TBL_NUMBER;
99: --l_withdrawn_par_line_list PO_TBL_NUMBER;
100: l_withdrawn_line_list PO_TBL_NUMBER;
101: l_withdrawn_dist_list PO_TBL_NUMBER;
102: --bug 15905347 end
103:
104: BEGIN

Line 101: l_withdrawn_dist_list PO_TBL_NUMBER;

97: --bug 15905347 start
98: --l_withdrawn_par_dist_list PO_TBL_NUMBER;
99: --l_withdrawn_par_line_list PO_TBL_NUMBER;
100: l_withdrawn_line_list PO_TBL_NUMBER;
101: l_withdrawn_dist_list PO_TBL_NUMBER;
102: --bug 15905347 end
103:
104: BEGIN
105:

Line 174: l_withdrawn_line_list := PO_TBL_NUMBER();

170: --When a mod is withdrawn, the associated req lines should be sent bact to the pool.Using the same logic for sending the reqs to pool as during the deletion of mod, in 'process_mod_delete_action'
171: -- commented the code specific to the PAR lines and added a common logic that will process the associated reqs for all mod lines regardless of PAR or non-PAR.
172: --Made call to update_header_dummy_req(p_draft_id => p_draft_id) to remove the dummy req in case of PAR. for non-PAR lines there will be no impact.
173:
174: l_withdrawn_line_list := PO_TBL_NUMBER();
175: l_withdrawn_dist_list := PO_TBL_NUMBER();
176:
177: -- Collect all withdrawn lines
178: SELECT po_line_id

Line 175: l_withdrawn_dist_list := PO_TBL_NUMBER();

171: -- commented the code specific to the PAR lines and added a common logic that will process the associated reqs for all mod lines regardless of PAR or non-PAR.
172: --Made call to update_header_dummy_req(p_draft_id => p_draft_id) to remove the dummy req in case of PAR. for non-PAR lines there will be no impact.
173:
174: l_withdrawn_line_list := PO_TBL_NUMBER();
175: l_withdrawn_dist_list := PO_TBL_NUMBER();
176:
177: -- Collect all withdrawn lines
178: SELECT po_line_id
179: BULK COLLECT INTO l_withdrawn_line_list

Line 333: l_deleted_line_list PO_TBL_NUMBER;

329: l_mod_number po_drafts.modification_number%TYPE;
330: l_item_status varchar2(10);
331: l_result varchar2(10);
332:
333: l_deleted_line_list PO_TBL_NUMBER;
334: l_deleted_dist_list PO_TBL_NUMBER;
335: -- PAR project
336: l_release_locks_yn VARCHAR2(1);
337:

Line 334: l_deleted_dist_list PO_TBL_NUMBER;

330: l_item_status varchar2(10);
331: l_result varchar2(10);
332:
333: l_deleted_line_list PO_TBL_NUMBER;
334: l_deleted_dist_list PO_TBL_NUMBER;
335: -- PAR project
336: l_release_locks_yn VARCHAR2(1);
337:
338: --SBCR Integration Begin.

Line 445: l_deleted_line_list := PO_TBL_NUMBER();

441: l_po_header_id,
442: p_draft_id, '', '', '', 'Y');
443:
444: -- Bug: 13948625 - Start
445: l_deleted_line_list := PO_TBL_NUMBER();
446: l_deleted_dist_list := PO_TBL_NUMBER();
447:
448: -- Collect all deleted lines
449: SELECT po_line_id

Line 446: l_deleted_dist_list := PO_TBL_NUMBER();

442: p_draft_id, '', '', '', 'Y');
443:
444: -- Bug: 13948625 - Start
445: l_deleted_line_list := PO_TBL_NUMBER();
446: l_deleted_dist_list := PO_TBL_NUMBER();
447:
448: -- Collect all deleted lines
449: SELECT po_line_id
450: BULK COLLECT INTO l_deleted_line_list

Line 681: l_po_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

677: d_api_name CONSTANT VARCHAR2(30) := 'do_mod_line_control_action';
678: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
679: d_position NUMBER;
680:
681: l_po_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
682: l_po_draft_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
683: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
684: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
685:

Line 682: l_po_draft_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

678: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
679: d_position NUMBER;
680:
681: l_po_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
682: l_po_draft_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
683: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
684: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
685:
686: begin

Line 794: l_po_line_loc_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

790: d_api_name CONSTANT VARCHAR2(30) := 'do_mod_line_loc_control_action';
791: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
792: d_position NUMBER;
793:
794: l_po_line_loc_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
795: l_po_draft_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
796: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
797: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
798:

Line 795: l_po_draft_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

791: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
792: d_position NUMBER;
793:
794: l_po_line_loc_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
795: l_po_draft_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
796: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
797: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
798:
799: begin