1 PACKAGE INV_FA_INTERFACE_PVT AS
2 /* $Header: INVFAAPS.pls 120.1 2005/05/25 17:14:04 appldev $ */
3
4
5
6 -- Name
7 -- FUNCTION Get_IC_CCID
8 --
9 -- Purpose
10 -- This procedure gets the Code_Combination_Id from the po_req_distributions_all
11 -- table to support the Intercompany AP Invoices created thru Internal Sales Orders to
12 -- Interface into FA
13 -- Input parameters
14 -- p_inv_dist_id IN NUMBER corresponds to ap_invoice_distributions_all.invoice_distribution_id
15 -- p_inv_cc_id IN NUMBER corresponds to ap_invoice_distributions_all.DIST_CODE_COMBINATION_ID
16 -- p_line_type IN VARCHAR2 corresponds to ap_invoice_distributions_all.LINE_TYPE_LOOKUP_CODE
17 -- Output Parameters
18 -- p_cc_id - Code combination Id from po_req_distributions_all if
19 -- Single/Multiple distributions exist for the requisition with same charge Account's.
20 -- Else returns p_inv_cc_id
21
22 FUNCTION Get_IC_CCID(p_inv_dist_id IN NUMBER,
23 p_inv_cc_id IN NUMBER,
24 p_line_type IN VARCHAR2 )
25 RETURN NUMBER;
26
27
28
29 -- Name
30 -- FUNCTION Get_REF_CCID
31 --
32 -- Purpose
33 -- This procedure gets the Code_Combination_Id from the po_req_distributions_all
34 -- table to support the Intercompany AP Invoices created thru Internal Sales Orders to
35 -- Interface into FA
36 -- Input parameters
37 -- p_inv_ref_id IN VARCHAR2 corresponds to ap_expense_report_lines_all.reference_1
38 -- p_inv_cc_id IN NUMBER corresponds to ap_expense_report_lines_all.CODE_COMBINATION_ID
39 -- p_line_type IN VARCHAR2 corresponds to ap_expense_report_lines_all.LINE_TYPE_LOOKUP_CODE
40 -- Output Parameters
41 -- p_cc_id - Code combination Id from po_req_distributions_all if
42 -- Single/Multiple distributions exist for the requisition with same charge Account's.
43 -- Else returns p_inv_cc_id
44
45 FUNCTION Get_REF_CCID(p_inv_ref_id IN VARCHAR2,
46 p_inv_cc_id IN NUMBER,
47 p_line_type IN VARCHAR2 )
48 RETURN NUMBER;
49
50
51
52 END INV_FA_INTERFACE_PVT;