APPS.PO_HEADERS_DRAFT_PVT dependencies on PO_TBL_NUMBER

Line 40: ( p_draft_id_tbl IN PO_TBL_NUMBER,

36: --Testing:
37: --End of Comments
38: ------------------------------------------------------------------------
39: FUNCTION draft_changes_exist
40: ( p_draft_id_tbl IN PO_TBL_NUMBER,
41: p_po_header_id_tbl IN PO_TBL_NUMBER
42: ) RETURN PO_TBL_VARCHAR1
43: IS
44: d_api_name CONSTANT VARCHAR2(30) := 'draft_changes_exist';

Line 41: p_po_header_id_tbl IN PO_TBL_NUMBER

37: --End of Comments
38: ------------------------------------------------------------------------
39: FUNCTION draft_changes_exist
40: ( p_draft_id_tbl IN PO_TBL_NUMBER,
41: p_po_header_id_tbl IN PO_TBL_NUMBER
42: ) RETURN PO_TBL_VARCHAR1
43: IS
44: d_api_name CONSTANT VARCHAR2(30) := 'draft_changes_exist';
45: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';

Line 49: l_index_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

45: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
46: d_position NUMBER;
47:
48: l_key NUMBER;
49: l_index_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
50: l_dft_exists_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
51: l_dft_exists_index_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
52:
53: BEGIN

Line 51: l_dft_exists_index_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

47:
48: l_key NUMBER;
49: l_index_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
50: l_dft_exists_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
51: l_dft_exists_index_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
52:
53: BEGIN
54: d_position := 0;
55: IF (PO_LOG.d_proc) THEN

Line 164: ( p_draft_id_tbl => PO_TBL_NUMBER(p_draft_id),

160: END IF;
161:
162: l_exists_tbl :=
163: draft_changes_exist
164: ( p_draft_id_tbl => PO_TBL_NUMBER(p_draft_id),
165: p_po_header_id_tbl => PO_TBL_NUMBER(p_po_header_id)
166: );
167:
168: IF (PO_LOG.d_stmt) THEN

Line 165: p_po_header_id_tbl => PO_TBL_NUMBER(p_po_header_id)

161:
162: l_exists_tbl :=
163: draft_changes_exist
164: ( p_draft_id_tbl => PO_TBL_NUMBER(p_draft_id),
165: p_po_header_id_tbl => PO_TBL_NUMBER(p_po_header_id)
166: );
167:
168: IF (PO_LOG.d_stmt) THEN
169: PO_LOG.stmt(d_module, d_position, 'exists', l_exists_tbl(1));