DBA Data[Home] [Help]

APPS.JAI_RGM_GST_ACCOUNTING_PKG dependencies on JAI_GENERAL_PKG

Line 134: lv_codepath := jai_general_pkg.plot_codepath(1, lv_codepath, 'Insert_Repository_Entry', 'START');

130:
131: BEGIN
132:
133: lv_statement := '0';
134: lv_codepath := jai_general_pkg.plot_codepath(1, lv_codepath, 'Insert_Repository_Entry', 'START');
135:
136: lv_regime_code := JAI_GST_GENERAL_PKG.get_regime_code(pn_regime_id);
137:
138: OPEN cur_fetch_ou(pn_organization_id);

Line 159: lv_codepath := jai_general_pkg.plot_codepath(2.1, lv_codepath);

155: END IF;
156:
157: lv_statement := '2';
158:
159: lv_codepath := jai_general_pkg.plot_codepath(2.1, lv_codepath);
160:
161: lv_statement := '2.1';
162:
163: IF pv_source = jai_constants.source_ap THEN

Line 165: lv_codepath := jai_general_pkg.plot_codepath(3, lv_codepath);

161: lv_statement := '2.1';
162:
163: IF pv_source = jai_constants.source_ap THEN
164: lv_statement := '3';
165: lv_codepath := jai_general_pkg.plot_codepath(3, lv_codepath);
166: lv_register_entry_type := jai_constants.credit;
167: lv_account_name := jai_constants.recovery;
168: lv_balancing_accnt_name := jai_constants.recovery_interim;
169:

Line 173: lv_codepath := jai_general_pkg.plot_codepath(4, lv_codepath);

169:
170:
171: ELSIF pv_source = jai_constants.source_ar THEN
172: lv_statement := '4';
173: lv_codepath := jai_general_pkg.plot_codepath(4, lv_codepath);
174: lv_register_entry_type := jai_constants.debit;
175: lv_account_name := jai_constants.liability;
176: lv_balancing_accnt_name := jai_constants.liability_interim;
177:

Line 181: lv_codepath := jai_general_pkg.plot_codepath(5, lv_codepath);

177:
178:
179: ELSIF pv_source = jai_constants.source_manual_entry THEN
180: lv_statement := '5';
181: lv_codepath := jai_general_pkg.plot_codepath(5, lv_codepath);
182: lv_account_name := pv_account_name;
183: IF lv_account_name IN (jai_constants.recovery, jai_constants.recovery_interim) THEN
184: lv_codepath := jai_general_pkg.plot_codepath(6, lv_codepath);
185: lv_register_entry_type := jai_constants.credit;

Line 184: lv_codepath := jai_general_pkg.plot_codepath(6, lv_codepath);

180: lv_statement := '5';
181: lv_codepath := jai_general_pkg.plot_codepath(5, lv_codepath);
182: lv_account_name := pv_account_name;
183: IF lv_account_name IN (jai_constants.recovery, jai_constants.recovery_interim) THEN
184: lv_codepath := jai_general_pkg.plot_codepath(6, lv_codepath);
185: lv_register_entry_type := jai_constants.credit;
186: ELSIF lv_account_name IN (jai_constants.liability, jai_constants.liability_interim) THEN
187: lv_codepath := jai_general_pkg.plot_codepath(7, lv_codepath);
188: lv_register_entry_type := jai_constants.debit;

Line 187: lv_codepath := jai_general_pkg.plot_codepath(7, lv_codepath);

183: IF lv_account_name IN (jai_constants.recovery, jai_constants.recovery_interim) THEN
184: lv_codepath := jai_general_pkg.plot_codepath(6, lv_codepath);
185: lv_register_entry_type := jai_constants.credit;
186: ELSIF lv_account_name IN (jai_constants.liability, jai_constants.liability_interim) THEN
187: lv_codepath := jai_general_pkg.plot_codepath(7, lv_codepath);
188: lv_register_entry_type := jai_constants.debit;
189: END IF;
190:
191: /* Incase of Distributions and settlements, we hit only recovery account and decrease/increase

Line 198: lv_codepath := jai_general_pkg.plot_codepath(8, lv_codepath);

194: AND nvl(ln_org_id,0)=nvl(ln_bal_org_id,0)) or (pv_source in( jai_constants.source_settle_out,jai_constants.service_src_distribute_out)
195: AND nvl(pv_distribution_type,'X')='X' )
196: THEN
197: lv_statement := '6';
198: lv_codepath := jai_general_pkg.plot_codepath(8, lv_codepath);
199: lv_register_entry_type := jai_constants.debit;
200: lv_account_name := jai_constants.recovery;
201: lv_balancing_accnt_name := jai_constants.recovery;
202:

Line 213: lv_codepath := jai_general_pkg.plot_codepath(9, lv_codepath);

209: AND nvl(ln_org_id,0)=nvl(ln_bal_org_id,0)) OR (pv_source in( jai_constants.source_settle_in,jai_constants.service_src_distribute_in)
210: AND nvl(pv_distribution_type,'X')='X')
211: THEN
212: lv_statement := '7';
213: lv_codepath := jai_general_pkg.plot_codepath(9, lv_codepath);
214: lv_register_entry_type := jai_constants.credit;
215: lv_account_name := jai_constants.recovery;
216: lv_balancing_accnt_name := jai_constants.recovery;
217: IF (pv_source = jai_constants.source_settle_in) THEN

Line 231: lv_codepath := jai_general_pkg.plot_codepath(10, lv_codepath);

227: FETCH cur_interorg_accts into r_interorg_accts;
228: CLOSE cur_interorg_accts;
229:
230: lv_statement := '8';
231: lv_codepath := jai_general_pkg.plot_codepath(10, lv_codepath);
232: lv_register_entry_type := jai_constants.debit;
233: lv_account_name := jai_constants.recovery;
234: lv_balancing_accnt_name :='InterOrg Receivable Account';
235: ln_balancing_account_id :=r_interorg_accts.interorg_receivables_account;

Line 245: lv_codepath := jai_general_pkg.plot_codepath(11, lv_codepath);

241: open cur_interorg_accts(pn_organization_id);
242: fetch cur_interorg_accts into r_interorg_accts;
243: close cur_interorg_accts;
244: lv_statement := '9';
245: lv_codepath := jai_general_pkg.plot_codepath(11, lv_codepath);
246: lv_register_entry_type := jai_constants.credit;
247: lv_account_name := jai_constants.recovery;
248:
249: lv_balancing_accnt_name := 'Interorg Payable Account';

Line 255: lv_codepath := jai_general_pkg.plot_codepath(10, lv_codepath);

251: END IF;
252:
253: IF lv_register_entry_type = jai_constants.debit THEN
254: lv_statement := '10';
255: lv_codepath := jai_general_pkg.plot_codepath(10, lv_codepath);
256: ln_debit := ln_amount;
257: ln_credit := NULL;
258: ln_trx_debit := nvl(ln_trx_amount, ln_amount);
259: ln_trx_credit := null;

Line 262: lv_codepath := jai_general_pkg.plot_codepath(11, lv_codepath);

258: ln_trx_debit := nvl(ln_trx_amount, ln_amount);
259: ln_trx_credit := null;
260: ELSE
261: lv_statement := '11';
262: lv_codepath := jai_general_pkg.plot_codepath(11, lv_codepath);
263: ln_debit := NULL;
264: ln_credit := ln_amount;
265: ln_trx_debit := null;
266: ln_trx_credit := nvl(ln_trx_amount, ln_amount);

Line 271: lv_codepath := jai_general_pkg.plot_codepath(12, lv_codepath);

267: END IF;
268:
269: lv_statement := '12';
270: IF pn_charge_account_id IS NULL THEN
271: lv_codepath := jai_general_pkg.plot_codepath(12, lv_codepath);
272:
273: ln_charge_account_id := JAI_GST_GENERAL_PKG.get_account(
274: p_regime_id => pn_regime_id,
275: p_organization_type => pv_organization_type,

Line 296: lv_codepath := jai_general_pkg.plot_codepath(13, lv_codepath);

292: lv_balancing_accnt_name := nvl(pv_balancing_accnt_name, lv_balancing_accnt_name);
293:
294: lv_statement := '15';
295: IF ln_balancing_orgn_id IS NULL THEN
296: lv_codepath := jai_general_pkg.plot_codepath(13, lv_codepath);
297: lv_balancing_orgn_type := pv_organization_type;
298: ln_balancing_orgn_id := pn_organization_id;
299: ln_balancing_location_id := pn_location_id;
300: lv_balancing_tax_type := pv_tax_type;

Line 306: lv_codepath := jai_general_pkg.plot_codepath(14, lv_codepath);

302:
303: lv_statement := '16';
304: IF pn_balancing_account_id IS NULL then
305: IF ln_balancing_account_id IS NULL THEN
306: lv_codepath := jai_general_pkg.plot_codepath(14, lv_codepath);
307:
308: ln_balancing_account_id := JAI_GST_GENERAL_PKG.get_account(
309: p_regime_id => pn_regime_id,
310: p_organization_type => lv_balancing_orgn_type,

Line 328: lv_codepath := jai_general_pkg.plot_codepath(15, lv_codepath);

324: OPEN cur_primary_regno;
325: FETCH cur_primary_regno into lv_primary_regime_regno;
326: CLOSE cur_primary_regno;
327:
328: lv_codepath := jai_general_pkg.plot_codepath(15, lv_codepath);
329: INSERT INTO jai_rgm_trx_records (
330: repository_id,
331: regime_code,
332: tax_type,

Line 427: lv_codepath := jai_general_pkg.plot_codepath(-999, lv_codepath);

423: EXCEPTION
424: WHEN OTHERS THEN
425: pv_process_flag := jai_constants.unexpected_error;
426: pv_process_message := 'Repository Error(Stmt:'||lv_statement||') Occured:'||SQLERRM;
427: lv_codepath := jai_general_pkg.plot_codepath(-999, lv_codepath);
428:
429: END create_repository_entry;
430:
431: PROCEDURE create_gl_entry