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: l_clm_document VARCHAR2(1);

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: l_clm_document VARCHAR2(1);
232:

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: l_clm_document VARCHAR2(1);
232:
233: BEGIN

Line 353: l_po_line_id_tbl PO_TBL_NUMBER;

349: d_position NUMBER;
350:
351: l_key NUMBER;
352:
353: l_po_line_id_tbl PO_TBL_NUMBER;
354: l_draft_id_tbl PO_TBL_NUMBER;
355: l_delete_flag_tbl PO_TBL_VARCHAR1;
356: l_record_exist_tbl PO_TBL_VARCHAR1;
357:

Line 354: l_draft_id_tbl PO_TBL_NUMBER;

350:
351: l_key NUMBER;
352:
353: l_po_line_id_tbl PO_TBL_NUMBER;
354: l_draft_id_tbl PO_TBL_NUMBER;
355: l_delete_flag_tbl PO_TBL_VARCHAR1;
356: l_record_exist_tbl PO_TBL_VARCHAR1;
357:
358: BEGIN

Line 497: , x_delete_list OUT NOCOPY PO_TBL_NUMBER

493: --End of Comments
494: ------------------------------------------------------------------------
495: PROCEDURE group_records_by_dml_type
496: ( p_draft_info IN PO_DRAFTS_PVT.DRAFT_INFO_REC_TYPE
497: , x_delete_list OUT NOCOPY PO_TBL_NUMBER
498: , x_insert_list OUT NOCOPY PO_TBL_NUMBER
499: , x_update_list OUT NOCOPY PO_TBL_NUMBER
500: ) IS
501:

Line 498: , x_insert_list OUT NOCOPY PO_TBL_NUMBER

494: ------------------------------------------------------------------------
495: PROCEDURE group_records_by_dml_type
496: ( p_draft_info IN PO_DRAFTS_PVT.DRAFT_INFO_REC_TYPE
497: , x_delete_list OUT NOCOPY PO_TBL_NUMBER
498: , x_insert_list OUT NOCOPY PO_TBL_NUMBER
499: , x_update_list OUT NOCOPY PO_TBL_NUMBER
500: ) IS
501:
502: d_api_name CONSTANT VARCHAR2(30) := 'group_records_by_dml_type';

Line 499: , x_update_list OUT NOCOPY PO_TBL_NUMBER

495: PROCEDURE group_records_by_dml_type
496: ( p_draft_info IN PO_DRAFTS_PVT.DRAFT_INFO_REC_TYPE
497: , x_delete_list OUT NOCOPY PO_TBL_NUMBER
498: , x_insert_list OUT NOCOPY PO_TBL_NUMBER
499: , x_update_list OUT NOCOPY PO_TBL_NUMBER
500: ) IS
501:
502: d_api_name CONSTANT VARCHAR2(30) := 'group_records_by_dml_type';
503: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';

Line 506: l_id_list PO_TBL_NUMBER;

502: d_api_name CONSTANT VARCHAR2(30) := 'group_records_by_dml_type';
503: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
504: d_position NUMBER;
505:
506: l_id_list PO_TBL_NUMBER;
507: l_del_flag_list PO_TBL_VARCHAR1;
508: l_txn_exists_list PO_TBL_VARCHAR1;
509:
510: BEGIN

Line 516: x_delete_list := PO_TBL_NUMBER();

512: IF (PO_LOG.d_proc) THEN
513: PO_LOG.proc_begin(d_module);
514: END IF;
515:
516: x_delete_list := PO_TBL_NUMBER();
517: x_insert_list := PO_TBL_NUMBER();
518: x_update_list := PO_TBL_NUMBER();
519:
520: d_position := 10;

Line 517: x_insert_list := PO_TBL_NUMBER();

513: PO_LOG.proc_begin(d_module);
514: END IF;
515:
516: x_delete_list := PO_TBL_NUMBER();
517: x_insert_list := PO_TBL_NUMBER();
518: x_update_list := PO_TBL_NUMBER();
519:
520: d_position := 10;
521: SELECT PLLD.line_location_id,

Line 518: x_update_list := PO_TBL_NUMBER();

514: END IF;
515:
516: x_delete_list := PO_TBL_NUMBER();
517: x_insert_list := PO_TBL_NUMBER();
518: x_update_list := PO_TBL_NUMBER();
519:
520: d_position := 10;
521: SELECT PLLD.line_location_id,
522: NVL(PLLD.delete_flag, 'N'),