DBA Data[Home] [Help]

APPS.PO_DOCS_INTERFACE_PURGE dependencies on PO_TBL_NUMBER

Line 8: ( x_intf_header_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,

4: d_pkg_name CONSTANT varchar2(50) :=
5: PO_LOG.get_package_base('PO_DOCS_INTERFACE_PURGE');
6:
7: PROCEDURE exclude_undeletable_records
8: ( x_intf_header_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
9: p_process_code_tbl IN PO_TBL_VARCHAR30,
10: p_po_header_id IN NUMBER
11: );
12:

Line 37: l_intf_header_id_tbl PO_TBL_NUMBER;

33: d_position NUMBER;
34:
35: l_org_id NUMBER;
36:
37: l_intf_header_id_tbl PO_TBL_NUMBER;
38: l_process_code_tbl PO_TBL_VARCHAR30;
39: BEGIN
40:
41: --

Line 190: ( x_intf_header_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,

186: RAISE;
187: END process_po_interface_tables;
188:
189: PROCEDURE exclude_undeletable_records
190: ( x_intf_header_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
191: p_process_code_tbl IN PO_TBL_VARCHAR30,
192: p_po_header_id IN NUMBER
193: ) IS
194:

Line 199: l_new_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

195: d_api_name CONSTANT VARCHAR2(30) := 'exclude_undeletable_records';
196: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
197: d_position NUMBER;
198:
199: l_new_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
200:
201: l_draft_id PO_DRAFTS.draft_id%TYPE;
202: l_request_id PO_DRAFTS.request_id%TYPE;
203: l_old_request_complete VARCHAR2(1);