APPS.PO_LINES_DRAFT_PVT dependencies on PO_TBL_VARCHAR1

Line 58: ) RETURN PO_TBL_VARCHAR1

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 || '.';
62: d_position NUMBER;

Line 66: l_dft_exists_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

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;

Line 170: l_exists_tbl PO_TBL_VARCHAR1;

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);

Line 421: l_update_retro_date_flag_tbl PO_TBL_VARCHAR1;

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

Line 527: l_del_flag_list PO_TBL_VARCHAR1;

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

Line 528: l_txn_exists_list PO_TBL_VARCHAR1;

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

Line 604: p_line_num_arr IN PO_TBL_VARCHAR100,

600: --End of Comments
601: ------------------------------------------------------------------------
602: FUNCTION get_next_clin_num
603: ( p_po_header_id IN NUMBER,
604: p_line_num_arr IN PO_TBL_VARCHAR100,
605: p_par_draft_id IN NUMBER DEFAULT NULL -- Bug 16584685
606: ) RETURN VARCHAR2
607: IS
608: l_oth_line_num_arr PO_TBL_VARCHAR100 := PO_TBL_VARCHAR100();

Line 608: l_oth_line_num_arr PO_TBL_VARCHAR100 := PO_TBL_VARCHAR100();

604: p_line_num_arr IN PO_TBL_VARCHAR100,
605: p_par_draft_id IN NUMBER DEFAULT NULL -- Bug 16584685
606: ) RETURN VARCHAR2
607: IS
608: l_oth_line_num_arr PO_TBL_VARCHAR100 := PO_TBL_VARCHAR100();
609: l_merged_line_num_arr PO_TBL_VARCHAR100 := PO_TBL_VARCHAR100();
610: d_api_name CONSTANT VARCHAR2(30) := 'get_next_clin_num';
611: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
612: d_position NUMBER;

Line 609: l_merged_line_num_arr PO_TBL_VARCHAR100 := PO_TBL_VARCHAR100();

605: p_par_draft_id IN NUMBER DEFAULT NULL -- Bug 16584685
606: ) RETURN VARCHAR2
607: IS
608: l_oth_line_num_arr PO_TBL_VARCHAR100 := PO_TBL_VARCHAR100();
609: l_merged_line_num_arr PO_TBL_VARCHAR100 := PO_TBL_VARCHAR100();
610: d_api_name CONSTANT VARCHAR2(30) := 'get_next_clin_num';
611: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
612: d_position NUMBER;
613: BEGIN