DBA Data[Home] [Help]

PACKAGE: APPS.PO_PDOI_HEADER_PROCESS_PVT

Source


1 PACKAGE PO_PDOI_HEADER_PROCESS_PVT AUTHID CURRENT_USER AS
2 /* $Header: PO_PDOI_HEADER_PROCESS_PVT.pls 120.2.12020000.3 2013/02/11 01:24:26 vegajula ship $ */
3 
4 PROCEDURE open_headers
5 (
6   p_max_intf_header_id   IN NUMBER,
7   x_headers_csr   OUT NOCOPY PO_PDOI_TYPES.intf_cursor_type
8 );
9 
10 -- CLM Partial Funding Changes
11 PROCEDURE open_specific_headers
12 (
13   p_intf_po_header_id   IN NUMBER,
14   x_headers_csr   OUT NOCOPY PO_PDOI_TYPES.intf_cursor_type
15 );
16 
17 PROCEDURE fetch_headers
18 (
19   x_headers_csr   IN OUT NOCOPY PO_PDOI_TYPES.intf_cursor_type,
20   x_headers       OUT NOCOPY PO_PDOI_TYPES.headers_rec_type
21 );
22 
23 PROCEDURE derive_headers
24 (
25   x_headers       IN OUT NOCOPY PO_PDOI_TYPES.headers_rec_type
26 );
27 
28 
29 PROCEDURE default_headers
30 (
31   x_headers       IN OUT NOCOPY PO_PDOI_TYPES.headers_rec_type
32 );
33 
34 PROCEDURE validate_headers
35 (
36   x_headers       IN OUT NOCOPY PO_PDOI_TYPES.headers_rec_type
37 );
38 
39 -- shared with line location derivation logic
40 PROCEDURE derive_location_id
41 (
42   p_key                IN po_session_gt.key%TYPE,
43   p_index_tbl          IN DBMS_SQL.NUMBER_TABLE,
44   p_location_type      IN VARCHAR2,
45   p_location_tbl       IN PO_TBL_VARCHAR100,
46   x_location_id_tbl    IN OUT NOCOPY PO_TBL_NUMBER
47 );
48 
49 -- shared with line location derivation logic
50 PROCEDURE derive_terms_id
51 (
52   p_key                IN po_session_gt.key%TYPE,
53   p_index_tbl          IN DBMS_SQL.NUMBER_TABLE,
54   p_payment_terms_tbl  IN PO_TBL_VARCHAR100,
55   x_terms_id_tbl       IN OUT NOCOPY PO_TBL_NUMBER
56 );
57 
58 -- shared with pre-processing
59 PROCEDURE derive_vendor_id
60 (
61   p_key              IN po_session_gt.key%TYPE,
62   p_index_tbl        IN DBMS_SQL.NUMBER_TABLE,
63   p_vendor_name_tbl  IN PO_TBL_VARCHAR2000,
64   p_vendor_num_tbl   IN PO_TBL_VARCHAR30,
65   x_vendor_id_tbl    IN OUT NOCOPY PO_TBL_NUMBER
66 );
67 
68 --CLM PDOI Integration Starts
69 PROCEDURE derive_clm_source_document_id
70 (
71   p_key                     IN po_session_gt.key%TYPE,
72   p_index_tbl               IN DBMS_SQL.NUMBER_TABLE,
73   p_clm_source_document_disp_tbl IN PO_TBL_VARCHAR240,
74   x_clm_source_document_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
75 );
76 
77 PROCEDURE derive_vendor_id_from_idv
78 (
79   p_key                        IN po_session_gt.key%TYPE,
80   p_index_tbl                  IN DBMS_SQL.NUMBER_TABLE,
81   p_clm_source_document_id_tbl IN PO_TBL_NUMBER,
82   p_doc_type_tbl               IN PO_TBL_VARCHAR30,
83   x_vendor_id_tbl              IN OUT NOCOPY PO_TBL_NUMBER
84 );
85 --CLM PDOI Integration Ends
86 
87 END PO_PDOI_HEADER_PROCESS_PVT;