DBA Data[Home] [Help]

APPS.PO_LINE_LOCATIONS_DRAFT_PKG dependencies on PO_TBL_NUMBER

Line 40: po_line_location_id_tbl PO_TBL_NUMBER;

36: ) IS
37: d_api_name CONSTANT VARCHAR2(30) := 'delete_rows';
38: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
39: d_position NUMBER;
40: po_line_location_id_tbl PO_TBL_NUMBER;
41:
42: BEGIN
43: d_position := 0;
44: IF (PO_LOG.d_proc) THEN

Line 126: ( p_line_location_id_tbl IN PO_TBL_NUMBER,

122: --Testing:
123: --End of Comments
124: ------------------------------------------------------------------------
125: PROCEDURE sync_draft_from_txn
126: ( p_line_location_id_tbl IN PO_TBL_NUMBER,
127: p_draft_id_tbl IN PO_TBL_NUMBER,
128: p_delete_flag_tbl IN PO_TBL_VARCHAR1,
129: x_record_already_exist_tbl OUT NOCOPY PO_TBL_VARCHAR1
130: ) IS

Line 127: p_draft_id_tbl IN PO_TBL_NUMBER,

123: --End of Comments
124: ------------------------------------------------------------------------
125: PROCEDURE sync_draft_from_txn
126: ( p_line_location_id_tbl IN PO_TBL_NUMBER,
127: p_draft_id_tbl IN PO_TBL_NUMBER,
128: p_delete_flag_tbl IN PO_TBL_VARCHAR1,
129: x_record_already_exist_tbl OUT NOCOPY PO_TBL_VARCHAR1
130: ) IS
131:

Line 637: ( p_line_location_id_tbl => PO_TBL_NUMBER(p_line_location_id),

633: PO_LOG.proc_begin(d_module, 'p_line_location_id', p_line_location_id);
634: END IF;
635:
636: sync_draft_from_txn
637: ( p_line_location_id_tbl => PO_TBL_NUMBER(p_line_location_id),
638: p_draft_id_tbl => PO_TBL_NUMBER(p_draft_id),
639: p_delete_flag_tbl => PO_TBL_VARCHAR1(p_delete_flag),
640: x_record_already_exist_tbl => l_record_already_exist_tbl
641: );

Line 638: p_draft_id_tbl => PO_TBL_NUMBER(p_draft_id),

634: END IF;
635:
636: sync_draft_from_txn
637: ( p_line_location_id_tbl => PO_TBL_NUMBER(p_line_location_id),
638: p_draft_id_tbl => PO_TBL_NUMBER(p_draft_id),
639: p_delete_flag_tbl => PO_TBL_VARCHAR1(p_delete_flag),
640: x_record_already_exist_tbl => l_record_already_exist_tbl
641: );
642:

Line 688: l_line_loc_id_tbl PO_TBL_NUMBER;

684: PROCEDURE merge_changes
685: ( p_draft_id IN NUMBER
686: ) IS
687:
688: l_line_loc_id_tbl PO_TBL_NUMBER;
689: d_api_name CONSTANT VARCHAR2(30) := 'merge_changes';
690: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
691: d_position NUMBER;
692: