[Home] [Help]
PACKAGE: APPS.OZF_GL_INTERFACE_PVT
Source
1 PACKAGE OZF_GL_INTERFACE_PVT AUTHID CURRENT_USER AS
2 /* $Header: ozfvglis.pls 120.3.12020000.2 2012/07/17 10:04:51 bkunjan ship $ */
3
4 TYPE gl_interface_rec_type IS RECORD (
5 EVENT_TYPE_CODE VARCHAR2(30)
6 , EVENT_STATUS_CODE VARCHAR2(30)
7 , SOURCE_ID NUMBER
8 , SOURCE_TABLE VARCHAR2(30)
9 , DR_CODE_COMBINATION_ID NUMBER := NULL
10 , CR_CODE_COMBINATION_ID NUMBER := NULL
11 , SKIP_ACCOUNT_GEN_FLAG VARCHAR2(1) := 'F' --//BKUNJAN -Removed for TM SLA Uptake
12 );
13
14 TYPE gl_interface_tbl_type is TABLE OF gl_interface_rec_type;
15
16
17 ---------------------------------------------------------------------
18 TYPE CC_ID_REC is RECORD (
19 amount number,
20 code_combination_id number,
21 line_util_id number
22 );
23
24 TYPE CC_ID_TBL is TABLE of CC_ID_REC;
25 ---------------------------------------------------------------------
26 -- PROCEDURE
27 -- Get_GL_Account
28 --
29 -- PURPOSE
30 -- gets the GL Account codes for a account type
31 -- currently supported account types in OMO
32 -- 1. EXPENSE_ACCOUNT
33 -- 2. ACCRUAL_LIABILITY
34 -- 3. VEN_CLEARING
35 -- 4. REC_CLEARING
36 -- transaction tables
37 -- 1. OZF_CLAIMS_ALL
38 -- 2. OZF_FUNDS_UTILIZED_ALL_B
39 --
40 -- PARAMETERS
41 -- p_source_id : transaction record pk
42 -- p_source_table: transaction table
43 -- p_account_type: GL account type code
44 -- x_cc_id_tbl : table of code combination ids
45 --
46 -- NOTES
47 ---------------------------------------------------------------------
48 PROCEDURE Get_GL_Account(
49 p_api_version IN NUMBER
50 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
51 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
52 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
53
54 ,x_return_status OUT NOCOPY VARCHAR2
55 ,x_msg_data OUT NOCOPY VARCHAR2
56 ,x_msg_count OUT NOCOPY NUMBER
57
58 ,p_source_id IN NUMBER
59 ,p_source_table IN VARCHAR2
60 ,p_account_type IN VARCHAR2
61 ,p_event_type IN VARCHAR2 DEFAULT NULL
62 ,x_cc_id_tbl OUT NOCOPY CC_ID_TBL);
63 ---------------------------------------------------------------------
64 -- PROCEDURE
65 -- Create_Gl_Entry
66 --
67 -- PURPOSE
68 -- Create a gl entry.
69 --
70 -- PARAMETERS
71 -- p_gl_rec : the new record to be inserted
72 -- x_event_id : return the claim_id of the new reason code
73 --
74 -- NOTES
75 -- 1. object_version_number will be set to 1.
76 -- HISTORY
77 -- 05/03/2010 kpatro Updated for ER#9382547 ChRM-SLA Uptake
78
79 ---------------------------------------------------------------------
80 PROCEDURE Create_Gl_Entry (
81 p_api_version IN NUMBER
82 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
83 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
84 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
85
86 ,x_return_status OUT NOCOPY VARCHAR2
87 ,x_msg_data OUT NOCOPY VARCHAR2
88 ,x_msg_count OUT NOCOPY NUMBER
89
90 ,p_gl_rec IN gl_interface_rec_type
91 );
92 ---------------------------------------------------------------------
93
94 ---------------------------------------------------------------------
95 -- PROCEDURE
96 -- Post_Accrual_To_GL
97 --
98 -- PURPOSE
99 -- For budget adjustment/utilization, the API will be called.
100 --
101 -- PARAMETERS
102 -- p_utilization_id Funds utilization_id
103 -- p_event_type_code SLA Event type code
104 -- p_dr_code_combination_id Debit code combination id
105 -- p_cr_code_combination_id Credit code combination id
106 -- p_skip_acct_gen_flag 'F' to call OZF Account Generator worflow or
107 -- not on top of above two gl accounts passed.
108 -- 'T' to bypass OZF Account Generator worflow
109 -- to derive account.
110 --
111 -- NOTES
112 -- 8-Mar-10 BKUNJAN ER#9382547 ChRM-SLA Uptake - Removed the OUT parameter
113 -- x_event_id and IN Parameter p_adjustment_type.
114 -- renamed p_utilization_type to p_event_type_code.
115 -- removed p_skip_acct_gen_flag.
116 ---------------------------------------------------------------------
117 PROCEDURE Post_Accrual_To_GL (
118 p_api_version IN NUMBER
119 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
120 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
121 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
122
123 ,x_return_status OUT NOCOPY VARCHAR2
124 ,x_msg_data OUT NOCOPY VARCHAR2
125 ,x_msg_count OUT NOCOPY NUMBER
126
127 ,p_utilization_id IN NUMBER
128 ,p_event_type_code IN VARCHAR2
129 ,p_dr_code_combination_id IN NUMBER := NULL
130 ,p_cr_code_combination_id IN NUMBER := NULL
131 );
132
133 ---------------------------------------------------------------------
134 -- PROCEDURE
135 -- Post_Claim_To_GL
136
137 --
138 -- PURPOSE
139 -- For Claim settlement to be posted to GL, use this API.
140 --
141 -- PARAMETERS
142 -- p_claim_id Claim_id
143 -- p_claim_class 'CLAIM''CHARGE''DEDUCTION''OVERPAYMENT'
144 -- p_settlement_method 'CREDIT_MEMO''DEBIT_MEMO''CHECK''AP_DEBIT'
145 -- x_clear_code_combination_id Code combination id of AR or AP clearing account
146 --
147 -- NOTES
148 -- HISTORY
149 -- 09-Mar-2010 KPATRO ER#9382547 ChRM-SLA Uptake -Removed the
150 -- OUT parameter x_event_id,
151 -- x_clear_code_combination_id
152 -- IN p_claim_class
153 ---------------------------------------------------------------------
154 PROCEDURE Post_Claim_To_GL (
155 p_api_version IN NUMBER
156 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
157 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
158 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
159
160 ,x_return_status OUT NOCOPY VARCHAR2
161 ,x_msg_data OUT NOCOPY VARCHAR2
162 ,x_msg_count OUT NOCOPY NUMBER
163
164 ,p_claim_id IN NUMBER
165 ,p_settlement_method IN VARCHAR2
166 );
167
168 ---------------------------------------------------------------------
169 -- PROCEDURE
170 -- Create_SLA_Claim_Extract
171 --
172 -- PURPOSE
173 -- To trigger the SLA events and create Extract entries
174 -- for promotional claim settlement
175 -- PARAMETERS
176 -- p_claim_id : claim_id for which the event is raised.
177 -- p_event_type_code : event_type_code for the claim.
178 -- p_reversal_flag : Reversal flag will be used for account
179 -- reversal.
180 -- x_xla_event_id : SLA event id
181 -- NOTES
182 --
183 -- HISTORY
184 -- 09/19/2011 BKUNJAN Created for ER 12985686
185 ---------------------------------------------------------------------
186 PROCEDURE Create_SLA_Claim_Extract (
187 p_api_version IN NUMBER
188 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
189 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
190 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
191
192 ,x_return_status OUT NOCOPY VARCHAR2
193 ,x_msg_data OUT NOCOPY VARCHAR2
194 ,x_msg_count OUT NOCOPY NUMBER
195
196 ,p_claim_id IN NUMBER
197 ,p_event_type_code IN VARCHAR2
198 ,p_gl_rec IN gl_interface_rec_type
199
200 ,x_xla_event_id OUT NOCOPY NUMBER
201 );
202
203 END OZF_GL_INTERFACE_PVT;
204