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_LINE_LOCATIONS_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_line_location_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_line_location_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_line_location_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_line_location_id_tbl => PO_TBL_NUMBER(p_line_location_id)
181: );
182:
183: IF (PO_LOG.d_stmt) THEN

Line 180: p_line_location_id_tbl => PO_TBL_NUMBER(p_line_location_id)

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

Line 227: l_delete_list PO_TBL_NUMBER;

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

Line 228: l_insert_list PO_TBL_NUMBER;

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

Line 229: l_update_list PO_TBL_NUMBER;

225: d_position NUMBER;
226:
227: l_delete_list PO_TBL_NUMBER;
228: l_insert_list PO_TBL_NUMBER;
229: l_update_list PO_TBL_NUMBER;
230:
231: BEGIN
232: d_position := 0;
233: IF (PO_LOG.d_proc) THEN

Line 312: l_po_line_id_tbl PO_TBL_NUMBER;

308: d_position NUMBER;
309:
310: l_key NUMBER;
311:
312: l_po_line_id_tbl PO_TBL_NUMBER;
313: l_draft_id_tbl PO_TBL_NUMBER;
314: l_delete_flag_tbl PO_TBL_VARCHAR1;
315: l_record_exist_tbl PO_TBL_VARCHAR1;
316:

Line 313: l_draft_id_tbl PO_TBL_NUMBER;

309:
310: l_key NUMBER;
311:
312: l_po_line_id_tbl PO_TBL_NUMBER;
313: l_draft_id_tbl PO_TBL_NUMBER;
314: l_delete_flag_tbl PO_TBL_VARCHAR1;
315: l_record_exist_tbl PO_TBL_VARCHAR1;
316:
317: BEGIN

Line 456: , x_delete_list OUT NOCOPY PO_TBL_NUMBER

452: --End of Comments
453: ------------------------------------------------------------------------
454: PROCEDURE group_records_by_dml_type
455: ( p_draft_info IN PO_DRAFTS_PVT.DRAFT_INFO_REC_TYPE
456: , x_delete_list OUT NOCOPY PO_TBL_NUMBER
457: , x_insert_list OUT NOCOPY PO_TBL_NUMBER
458: , x_update_list OUT NOCOPY PO_TBL_NUMBER
459: ) IS
460:

Line 457: , x_insert_list OUT NOCOPY PO_TBL_NUMBER

453: ------------------------------------------------------------------------
454: PROCEDURE group_records_by_dml_type
455: ( p_draft_info IN PO_DRAFTS_PVT.DRAFT_INFO_REC_TYPE
456: , x_delete_list OUT NOCOPY PO_TBL_NUMBER
457: , x_insert_list OUT NOCOPY PO_TBL_NUMBER
458: , x_update_list OUT NOCOPY PO_TBL_NUMBER
459: ) IS
460:
461: d_api_name CONSTANT VARCHAR2(30) := 'group_records_by_dml_type';

Line 458: , x_update_list OUT NOCOPY PO_TBL_NUMBER

454: PROCEDURE group_records_by_dml_type
455: ( p_draft_info IN PO_DRAFTS_PVT.DRAFT_INFO_REC_TYPE
456: , x_delete_list OUT NOCOPY PO_TBL_NUMBER
457: , x_insert_list OUT NOCOPY PO_TBL_NUMBER
458: , x_update_list OUT NOCOPY PO_TBL_NUMBER
459: ) IS
460:
461: d_api_name CONSTANT VARCHAR2(30) := 'group_records_by_dml_type';
462: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';

Line 465: l_id_list PO_TBL_NUMBER;

461: d_api_name CONSTANT VARCHAR2(30) := 'group_records_by_dml_type';
462: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
463: d_position NUMBER;
464:
465: l_id_list PO_TBL_NUMBER;
466: l_del_flag_list PO_TBL_VARCHAR1;
467: l_txn_exists_list PO_TBL_VARCHAR1;
468:
469: BEGIN

Line 475: x_delete_list := PO_TBL_NUMBER();

471: IF (PO_LOG.d_proc) THEN
472: PO_LOG.proc_begin(d_module);
473: END IF;
474:
475: x_delete_list := PO_TBL_NUMBER();
476: x_insert_list := PO_TBL_NUMBER();
477: x_update_list := PO_TBL_NUMBER();
478:
479: d_position := 10;

Line 476: x_insert_list := PO_TBL_NUMBER();

472: PO_LOG.proc_begin(d_module);
473: END IF;
474:
475: x_delete_list := PO_TBL_NUMBER();
476: x_insert_list := PO_TBL_NUMBER();
477: x_update_list := PO_TBL_NUMBER();
478:
479: d_position := 10;
480: SELECT PLLD.line_location_id,

Line 477: x_update_list := PO_TBL_NUMBER();

473: END IF;
474:
475: x_delete_list := PO_TBL_NUMBER();
476: x_insert_list := PO_TBL_NUMBER();
477: x_update_list := PO_TBL_NUMBER();
478:
479: d_position := 10;
480: SELECT PLLD.line_location_id,
481: NVL(PLLD.delete_flag, 'N'),