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_LINES_DRAFT_PVT dependencies on PO_TBL_NUMBER

Line 13: , x_delete_list OUT NOCOPY PO_TBL_NUMBER

9: -------------------------------------------------------
10:
11: PROCEDURE group_records_by_dml_type
12: ( p_draft_info IN PO_DRAFTS_PVT.DRAFT_INFO_REC_TYPE
13: , x_delete_list OUT NOCOPY PO_TBL_NUMBER
14: , x_insert_list OUT NOCOPY PO_TBL_NUMBER
15: , x_update_list OUT NOCOPY PO_TBL_NUMBER
16: );
17:

Line 14: , x_insert_list OUT NOCOPY PO_TBL_NUMBER

10:
11: PROCEDURE group_records_by_dml_type
12: ( p_draft_info IN PO_DRAFTS_PVT.DRAFT_INFO_REC_TYPE
13: , x_delete_list OUT NOCOPY PO_TBL_NUMBER
14: , x_insert_list OUT NOCOPY PO_TBL_NUMBER
15: , x_update_list OUT NOCOPY PO_TBL_NUMBER
16: );
17:
18:

Line 15: , x_update_list OUT NOCOPY PO_TBL_NUMBER

11: PROCEDURE group_records_by_dml_type
12: ( p_draft_info IN PO_DRAFTS_PVT.DRAFT_INFO_REC_TYPE
13: , x_delete_list OUT NOCOPY PO_TBL_NUMBER
14: , x_insert_list OUT NOCOPY PO_TBL_NUMBER
15: , x_update_list OUT NOCOPY PO_TBL_NUMBER
16: );
17:
18:
19: -------------------------------------------------------

Line 56: ( p_draft_id_tbl IN PO_TBL_NUMBER,

52: --Testing:
53: --End of Comments
54: ------------------------------------------------------------------------
55: FUNCTION draft_changes_exist
56: ( p_draft_id_tbl IN PO_TBL_NUMBER,
57: p_po_line_id_tbl IN PO_TBL_NUMBER
58: ) RETURN PO_TBL_VARCHAR1
59: IS
60: d_api_name CONSTANT VARCHAR2(30) := 'draft_changes_exist';

Line 57: p_po_line_id_tbl IN PO_TBL_NUMBER

53: --End of Comments
54: ------------------------------------------------------------------------
55: FUNCTION draft_changes_exist
56: ( p_draft_id_tbl IN PO_TBL_NUMBER,
57: p_po_line_id_tbl IN PO_TBL_NUMBER
58: ) RETURN PO_TBL_VARCHAR1
59: IS
60: d_api_name CONSTANT VARCHAR2(30) := 'draft_changes_exist';
61: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';

Line 65: l_index_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

61: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
62: d_position NUMBER;
63:
64: l_key NUMBER;
65: l_index_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
66: l_dft_exists_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
67: l_dft_exists_index_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
68:
69: BEGIN

Line 67: l_dft_exists_index_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

63:
64: l_key NUMBER;
65: l_index_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
66: l_dft_exists_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
67: l_dft_exists_index_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
68:
69: BEGIN
70: d_position := 0;
71: IF (PO_LOG.d_proc) THEN

Line 179: ( p_draft_id_tbl => PO_TBL_NUMBER(p_draft_id),

175: END IF;
176:
177: l_exists_tbl :=
178: draft_changes_exist
179: ( p_draft_id_tbl => PO_TBL_NUMBER(p_draft_id),
180: p_po_line_id_tbl => PO_TBL_NUMBER(p_po_line_id)
181: );
182:
183: IF (PO_LOG.d_stmt) THEN

Line 180: p_po_line_id_tbl => PO_TBL_NUMBER(p_po_line_id)

176:
177: l_exists_tbl :=
178: draft_changes_exist
179: ( p_draft_id_tbl => PO_TBL_NUMBER(p_draft_id),
180: p_po_line_id_tbl => PO_TBL_NUMBER(p_po_line_id)
181: );
182:
183: IF (PO_LOG.d_stmt) THEN
184: PO_LOG.stmt(d_module, d_position, 'exists', l_exists_tbl(1));

Line 228: l_delete_list PO_TBL_NUMBER;

224: d_api_name CONSTANT VARCHAR2(30) := 'apply_changes';
225: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
226: d_position NUMBER;
227:
228: l_delete_list PO_TBL_NUMBER;
229: l_insert_list PO_TBL_NUMBER;
230: l_update_list PO_TBL_NUMBER;
231:
232: l_return_status varchar2(1);

Line 229: l_insert_list PO_TBL_NUMBER;

225: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
226: d_position NUMBER;
227:
228: l_delete_list PO_TBL_NUMBER;
229: l_insert_list PO_TBL_NUMBER;
230: l_update_list PO_TBL_NUMBER;
231:
232: l_return_status varchar2(1);
233: l_msg_count number;

Line 230: l_update_list PO_TBL_NUMBER;

226: d_position NUMBER;
227:
228: l_delete_list PO_TBL_NUMBER;
229: l_insert_list PO_TBL_NUMBER;
230: l_update_list PO_TBL_NUMBER;
231:
232: l_return_status varchar2(1);
233: l_msg_count number;
234: l_msg_data varchar2(200);

Line 418: l_po_line_id_tbl PO_TBL_NUMBER;

414: d_api_name CONSTANT VARCHAR2(30) := 'maintain_retroactive_change';
415: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
416: d_position NUMBER;
417:
418: l_po_line_id_tbl PO_TBL_NUMBER;
419: l_price_break_lookup_code_tbl PO_TBL_VARCHAR30;
420:
421: l_update_retro_date_flag_tbl PO_TBL_VARCHAR1;
422:

Line 518: , x_delete_list OUT NOCOPY PO_TBL_NUMBER

514: --End of Comments
515: ------------------------------------------------------------------------
516: PROCEDURE group_records_by_dml_type
517: ( p_draft_info IN PO_DRAFTS_PVT.DRAFT_INFO_REC_TYPE
518: , x_delete_list OUT NOCOPY PO_TBL_NUMBER
519: , x_insert_list OUT NOCOPY PO_TBL_NUMBER
520: , x_update_list OUT NOCOPY PO_TBL_NUMBER
521: ) IS
522: d_api_name CONSTANT VARCHAR2(30) := 'group_records_by_dml_type';

Line 519: , x_insert_list OUT NOCOPY PO_TBL_NUMBER

515: ------------------------------------------------------------------------
516: PROCEDURE group_records_by_dml_type
517: ( p_draft_info IN PO_DRAFTS_PVT.DRAFT_INFO_REC_TYPE
518: , x_delete_list OUT NOCOPY PO_TBL_NUMBER
519: , x_insert_list OUT NOCOPY PO_TBL_NUMBER
520: , x_update_list OUT NOCOPY PO_TBL_NUMBER
521: ) IS
522: d_api_name CONSTANT VARCHAR2(30) := 'group_records_by_dml_type';
523: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';

Line 520: , x_update_list OUT NOCOPY PO_TBL_NUMBER

516: PROCEDURE group_records_by_dml_type
517: ( p_draft_info IN PO_DRAFTS_PVT.DRAFT_INFO_REC_TYPE
518: , x_delete_list OUT NOCOPY PO_TBL_NUMBER
519: , x_insert_list OUT NOCOPY PO_TBL_NUMBER
520: , x_update_list OUT NOCOPY PO_TBL_NUMBER
521: ) IS
522: d_api_name CONSTANT VARCHAR2(30) := 'group_records_by_dml_type';
523: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
524: d_position NUMBER;

Line 526: l_id_list PO_TBL_NUMBER;

522: d_api_name CONSTANT VARCHAR2(30) := 'group_records_by_dml_type';
523: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
524: d_position NUMBER;
525:
526: l_id_list PO_TBL_NUMBER;
527: l_del_flag_list PO_TBL_VARCHAR1;
528: l_txn_exists_list PO_TBL_VARCHAR1;
529:
530: BEGIN

Line 536: x_delete_list := PO_TBL_NUMBER();

532: IF (PO_LOG.d_proc) THEN
533: PO_LOG.proc_begin(d_module);
534: END IF;
535:
536: x_delete_list := PO_TBL_NUMBER();
537: x_insert_list := PO_TBL_NUMBER();
538: x_update_list := PO_TBL_NUMBER();
539:
540: d_position := 10;

Line 537: x_insert_list := PO_TBL_NUMBER();

533: PO_LOG.proc_begin(d_module);
534: END IF;
535:
536: x_delete_list := PO_TBL_NUMBER();
537: x_insert_list := PO_TBL_NUMBER();
538: x_update_list := PO_TBL_NUMBER();
539:
540: d_position := 10;
541: SELECT PLD.po_line_id,

Line 538: x_update_list := PO_TBL_NUMBER();

534: END IF;
535:
536: x_delete_list := PO_TBL_NUMBER();
537: x_insert_list := PO_TBL_NUMBER();
538: x_update_list := PO_TBL_NUMBER();
539:
540: d_position := 10;
541: SELECT PLD.po_line_id,
542: NVL(PLD.delete_flag, 'N'),