DBA Data[Home] [Help]

APPS.PO_LINES_DRAFT_PKG dependencies on PO_TBL_NUMBER

Line 41: po_line_ids_tbl PO_TBL_NUMBER;

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

Line 127: ( p_po_line_id_tbl IN PO_TBL_NUMBER,

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

Line 128: p_draft_id_tbl IN PO_TBL_NUMBER,

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

Line 681: ( p_po_line_id_tbl => PO_TBL_NUMBER(p_po_line_id),

677: PO_LOG.proc_begin(d_module, 'p_po_line_id', p_po_line_id);
678: END IF;
679:
680: sync_draft_from_txn
681: ( p_po_line_id_tbl => PO_TBL_NUMBER(p_po_line_id),
682: p_draft_id_tbl => PO_TBL_NUMBER(p_draft_id),
683: p_delete_flag_tbl => PO_TBL_VARCHAR1(p_delete_flag),
684: x_record_already_exist_tbl => l_record_already_exist_tbl
685: );

Line 682: p_draft_id_tbl => PO_TBL_NUMBER(p_draft_id),

678: END IF;
679:
680: sync_draft_from_txn
681: ( p_po_line_id_tbl => PO_TBL_NUMBER(p_po_line_id),
682: p_draft_id_tbl => PO_TBL_NUMBER(p_draft_id),
683: p_delete_flag_tbl => PO_TBL_VARCHAR1(p_delete_flag),
684: x_record_already_exist_tbl => l_record_already_exist_tbl
685: );
686:

Line 733: l_line_id_tbl PO_TBL_NUMBER;

729: ( p_draft_id IN NUMBER,
730: p_draft_type PO_DRAFTS.draft_type%TYPE DEFAULT NULL
731: ) IS
732:
733: l_line_id_tbl PO_TBL_NUMBER;
734: d_api_name CONSTANT VARCHAR2(30) := 'merge_changes';
735: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
736: d_position NUMBER;
737: