1 PACKAGE FUN_BAL_UTILS_GRP AUTHID CURRENT_USER AS
2 /* $Header: fungbalutils.pls 120.2.12020000.1 2012/06/27 14:20:03 appldev ship $ */
3 /* ----------------------------------------------------------------------------
4 -- API name : FUN_BAL_UTILS_GRP.get_inter_intra_account
5 -- Type : Group
6 -- Pre-reqs : None.
7 -- Function : Given a transacting and trading Balancing segment value, the
8 -- the procedure determines what type of account is required
9 -- ie inter or intra company accounts and returns the same
10 -- Parameters :
11 -- IN :
12 -- p_api_version IN NUMBER Required
13 -- p_init_msg_list IN VARCHAR2 Optional
14 -- p_ledger_id IN NUMBER Required
15 -- p_to_ledger_id IN NUMBER Required
16 -- p_from_bsv IN VARCHAR2 Required
17 -- p_to_bsv IN VARCHAR2 Required
18 -- p_source IN VARCHAR2 Optional
19 -- p_category IN VARCHAR2 Optional
20 -- p_gl_date IN DATE Required
21 -- p_acct_type IN VARCHAR2 Required
22 -- Account type would be 'D'ebit(Receivables)
23 -- Or 'C'redit' (Payables)
24 --
25 -- OUT :
26 -- x_status VARCHAR2
27 -- x_msg_count NUMBER
28 -- x_msg_data VARCHAR2
29 -- x_ccid VARCHAR2 CCID requested
30 -- x_reciprocal_ccid VARCHAR2 Reciprocal CCID
31 -- Eg. If receivable account ccid is requested for BSV1 => BSV2
32 -- x_reciprocal_ccid will contain the payable account for
33 -- BSV2 => BSV1
34 --
35 -- Version : Current version 1.0
36 -- Previous version 1.0
37 -- Initial version 1.0
38 ------------------------------------------------------------------------------*/
39 PROCEDURE get_inter_intra_account (p_api_version IN NUMBER,
40 p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
41 p_ledger_id IN NUMBER,
42 p_to_ledger_id IN NUMBER,
43 p_from_bsv IN VARCHAR2,
44 p_to_bsv IN VARCHAR2,
45 p_source IN VARCHAR2,
46 p_category IN VARCHAR2,
47 p_gl_date IN DATE,
48 p_acct_type IN VARCHAR2,
49 x_status IN OUT NOCOPY VARCHAR2,
50 x_msg_count IN OUT NOCOPY NUMBER,
51 x_msg_data IN OUT NOCOPY VARCHAR2,
52 x_ccid IN OUT NOCOPY NUMBER ,
53 x_reciprocal_ccid IN OUT NOCOPY NUMBER);
54
55 /* ----------------------------------------------------------------------------
56 -- API name : FUN_BAL_UTILS_GRP.get_intercompany_account
57 -- Type : Group
58 -- Pre-reqs : None.
59 -- Function : Given a transacting and trading Balancing segment value, the
60 -- the procedure returns the intercompany receivables and
61 -- payables account
62 -- Parameters :
63 -- IN :
64 -- p_api_version IN NUMBER Required
65 -- p_init_msg_list IN VARCHAR2 Optional
66 -- p_ledger_id IN NUMBER Required
67 -- p_from_le IN NUMBER Required
68 -- p_source IN VARCHAR2 Required
69 -- p_category IN VARCHAR2 Required
70 -- p_from_bsv IN VARCHAR2 Required
71 -- p_to_le IN NUMBER Required
72 -- p_to_bsv IN VARCHAR2 Required
73 -- p_gl_date IN DATE Required
74 -- p_acct_type IN VARCHAR2 Required
75 -- Account type would be 'R'eceivables or 'P'ayables
76 --
77 -- OUT :
78 -- x_status VARCHAR2
79 -- x_msg_count NUMBER
80 -- x_msg_data VARCHAR2
81 -- x_ccid VARCHAR2 CCID requested
82 -- x_reciprocal_ccid VARCHAR2 Reciprocal CCID
83 -- Eg. If receivable account ccid is requested for BSV1 => BSV2
84 -- x_reciprocal_ccid will contain the payable account for
85 -- BSV2 => BSV1
86 --
87 -- Version : Current version 1.0
88 -- Previous version 1.0
89 -- Initial version 1.0
90 ------------------------------------------------------------------------------*/
91 PROCEDURE get_intercompany_account (p_api_version IN NUMBER,
92 p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
93 p_ledger_id IN NUMBER,
94 p_from_le IN NUMBER,
95 p_source IN VARCHAR2,
96 p_category IN VARCHAR2,
97 p_from_bsv IN VARCHAR2,
98 p_to_ledger_id IN NUMBER,
99 p_to_le IN NUMBER,
100 p_to_bsv IN VARCHAR2,
101 p_gl_date IN DATE,
102 p_acct_type IN VARCHAR2,
103 x_status IN OUT NOCOPY VARCHAR2,
104 x_msg_count IN OUT NOCOPY NUMBER,
105 x_msg_data IN OUT NOCOPY VARCHAR2,
106 x_ccid IN OUT NOCOPY NUMBER ,
107 x_reciprocal_ccid IN OUT NOCOPY NUMBER);
108
109 /* ----------------------------------------------------------------------------
110 -- API name : FUN_BAL_UTILS_GRP.get_intracompany_account
111 -- Type : Group
112 -- Pre-reqs : None.
113 -- Function : Given a transacting and trading Balancing segment value, the
114 -- the procedure returns the intracompany credit and debit
115 -- account
116 -- Parameters :
117 -- IN :
118 -- p_api_version IN NUMBER Required
119 -- p_init_msg_list IN VARCHAR2 Optional
120 -- p_ledger_id IN NUMBER Required
121 -- p_from_le IN NUMBER Optional
122 -- p_source IN VARCHAR2 Optional
123 -- If not provided, source of 'Other' will be used to derive
124 -- the account
125 -- p_category IN VARCHAR2 Optional
126 -- If not provided, category of 'Other' will be used to derive
127 -- the account
128 -- p_dr_bsv IN VARCHAR2 Required
129 -- p_cr_bsv IN VARCHAR2 Required
130 -- p_gl_date IN DATE Required
131 -- p_acct_type IN VARCHAR2 Required
132 -- Account type would be 'D'ebit or 'C'redit
133 --
134 -- OUT :
135 -- x_status VARCHAR2
136 -- x_msg_count NUMBER
137 -- x_msg_data VARCHAR2
138 -- x_ccid VARCHAR2 CCID requested
139 -- x_reciprocal_ccid VARCHAR2 Reciprocal CCID
140 -- Eg. If debit account ccid is requested for BSV1 => BSV2
141 -- x_reciprocal_ccid will contain the credit account for
142 -- BSV2 => BSV1
143 --
144 -- Version : Current version 1.0
145 -- Previous version 1.0
146 -- Initial version 1.0
147 ------------------------------------------------------------------------------*/
148 PROCEDURE get_intracompany_account (p_api_version IN NUMBER,
149 p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
150 p_ledger_id IN NUMBER,
151 p_from_le IN NUMBER,
152 p_source IN VARCHAR2,
153 p_category IN VARCHAR2,
154 p_dr_bsv IN VARCHAR2,
155 p_cr_bsv IN VARCHAR2,
156 p_gl_date IN DATE,
157 p_acct_type IN VARCHAR2,
158 x_status IN OUT NOCOPY VARCHAR2,
159 x_msg_count IN OUT NOCOPY NUMBER,
160 x_msg_data IN OUT NOCOPY VARCHAR2,
161 x_ccid IN OUT NOCOPY NUMBER ,
162 x_reciprocal_ccid IN OUT NOCOPY NUMBER);
163
164
165 END FUN_BAL_UTILS_GRP;