[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;