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: BEGIN
232: d_position := 0;

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: BEGIN
232: d_position := 0;
233: IF (PO_LOG.d_proc) THEN

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: BEGIN
232: d_position := 0;
233: IF (PO_LOG.d_proc) THEN
234: PO_LOG.proc_begin(d_module);

Line 310: l_po_line_id_tbl PO_TBL_NUMBER;

306: d_api_name CONSTANT VARCHAR2(30) := 'maintain_retroactive_change';
307: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
308: d_position NUMBER;
309:
310: l_po_line_id_tbl PO_TBL_NUMBER;
311: l_price_break_lookup_code_tbl PO_TBL_VARCHAR30;
312:
313: l_update_retro_date_flag_tbl PO_TBL_VARCHAR1;
314:

Line 410: , x_delete_list OUT NOCOPY PO_TBL_NUMBER

406: --End of Comments
407: ------------------------------------------------------------------------
408: PROCEDURE group_records_by_dml_type
409: ( p_draft_info IN PO_DRAFTS_PVT.DRAFT_INFO_REC_TYPE
410: , x_delete_list OUT NOCOPY PO_TBL_NUMBER
411: , x_insert_list OUT NOCOPY PO_TBL_NUMBER
412: , x_update_list OUT NOCOPY PO_TBL_NUMBER
413: ) IS
414: d_api_name CONSTANT VARCHAR2(30) := 'group_records_by_dml_type';

Line 411: , x_insert_list OUT NOCOPY PO_TBL_NUMBER

407: ------------------------------------------------------------------------
408: PROCEDURE group_records_by_dml_type
409: ( p_draft_info IN PO_DRAFTS_PVT.DRAFT_INFO_REC_TYPE
410: , x_delete_list OUT NOCOPY PO_TBL_NUMBER
411: , x_insert_list OUT NOCOPY PO_TBL_NUMBER
412: , x_update_list OUT NOCOPY PO_TBL_NUMBER
413: ) IS
414: d_api_name CONSTANT VARCHAR2(30) := 'group_records_by_dml_type';
415: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';

Line 412: , x_update_list OUT NOCOPY PO_TBL_NUMBER

408: PROCEDURE group_records_by_dml_type
409: ( p_draft_info IN PO_DRAFTS_PVT.DRAFT_INFO_REC_TYPE
410: , x_delete_list OUT NOCOPY PO_TBL_NUMBER
411: , x_insert_list OUT NOCOPY PO_TBL_NUMBER
412: , x_update_list OUT NOCOPY PO_TBL_NUMBER
413: ) IS
414: d_api_name CONSTANT VARCHAR2(30) := 'group_records_by_dml_type';
415: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
416: d_position NUMBER;

Line 418: l_id_list PO_TBL_NUMBER;

414: d_api_name CONSTANT VARCHAR2(30) := 'group_records_by_dml_type';
415: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
416: d_position NUMBER;
417:
418: l_id_list PO_TBL_NUMBER;
419: l_del_flag_list PO_TBL_VARCHAR1;
420: l_txn_exists_list PO_TBL_VARCHAR1;
421:
422: BEGIN

Line 428: x_delete_list := PO_TBL_NUMBER();

424: IF (PO_LOG.d_proc) THEN
425: PO_LOG.proc_begin(d_module);
426: END IF;
427:
428: x_delete_list := PO_TBL_NUMBER();
429: x_insert_list := PO_TBL_NUMBER();
430: x_update_list := PO_TBL_NUMBER();
431:
432: d_position := 10;

Line 429: x_insert_list := PO_TBL_NUMBER();

425: PO_LOG.proc_begin(d_module);
426: END IF;
427:
428: x_delete_list := PO_TBL_NUMBER();
429: x_insert_list := PO_TBL_NUMBER();
430: x_update_list := PO_TBL_NUMBER();
431:
432: d_position := 10;
433: SELECT PLD.po_line_id,

Line 430: x_update_list := PO_TBL_NUMBER();

426: END IF;
427:
428: x_delete_list := PO_TBL_NUMBER();
429: x_insert_list := PO_TBL_NUMBER();
430: x_update_list := PO_TBL_NUMBER();
431:
432: d_position := 10;
433: SELECT PLD.po_line_id,
434: NVL(PLD.delete_flag, 'N'),