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 || '.';
62: d_position NUMBER;
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
70: d_position := 0;
166: d_api_name CONSTANT VARCHAR2(30) := 'draft_changes_exist';
167: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
168: d_position NUMBER;
169:
170: l_exists_tbl PO_TBL_VARCHAR1;
171: BEGIN
172: d_position := 0;
173: IF (PO_LOG.d_proc) THEN
174: PO_LOG.proc_begin(d_module);
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
318: d_position := 0;
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
318: d_position := 0;
319: IF (PO_LOG.d_proc) THEN
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
470: d_position := 0;
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
470: d_position := 0;
471: IF (PO_LOG.d_proc) THEN