DBA Data[Home] [Help]

APPS.JAI_CMN_RGM_SETTLEMENT_PKG dependencies on JAI_CMN_RGM_RECORDING_PKG

Line 233: ln_charge_accounting_id := jai_cmn_rgm_recording_pkg.get_account(

229: ln_credit_amount:= NULL; --- these amounts are with respect to repository not w.r.t accounting
230: ln_debit_amount := p_to_trx_amount; --- its is reverse w.r.t accounting
231:
232:
233: ln_charge_accounting_id := jai_cmn_rgm_recording_pkg.get_account(
234: p_regime_id => p_regime_id,
235: p_organization_type => p_from_party_type,
236: p_organization_id => p_from_party_id,
237: p_location_id => p_from_locn_id,

Line 242: ln_balance_accounting_id := jai_cmn_rgm_recording_pkg.get_account(

238: p_tax_type => p_from_tax_type,
239: p_account_name => jai_constants.recovery
240: );
241:
242: ln_balance_accounting_id := jai_cmn_rgm_recording_pkg.get_account(
243: p_regime_id => p_regime_id,
244: p_organization_type => p_to_party_type,
245: p_organization_id => p_to_party_id,
246: p_location_id => p_to_locn_id,

Line 252: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry(

248: p_account_name => jai_constants.recovery
249: );
250:
251:
252: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry(
253: pn_repository_id => ln_repository_id,
254: pn_regime_id => p_regime_id,
255: pv_tax_type => p_from_tax_type ,
256: pv_organization_type => p_from_party_type,

Line 291: jai_cmn_rgm_recording_pkg.do_vat_accounting(

287: END IF;
288: p_repository_id := ln_repository_id;
289:
290:
291: jai_cmn_rgm_recording_pkg.do_vat_accounting(
292: pn_regime_id => p_regime_id,
293: pn_repository_id => ln_repository_id,
294: pv_organization_type => p_from_party_type,
295: pn_organization_id => p_from_party_id,

Line 327: ln_charge_accounting_id := jai_cmn_rgm_recording_pkg.get_account(

323: lv_source := jai_constants.source_settle_in ;
324: ln_credit_amount := p_from_trx_amount; --- these amounts are with respect to repository not w.r.t accounting
325: ln_debit_amount := NULL; --- its is reverse w.r.t accounting
326:
327: ln_charge_accounting_id := jai_cmn_rgm_recording_pkg.get_account(
328: p_regime_id => p_regime_id,
329: p_organization_type => p_to_party_type,
330: p_organization_id => p_to_party_id,
331: p_location_id => p_to_locn_id,

Line 336: ln_balance_accounting_id := jai_cmn_rgm_recording_pkg.get_account(

332: p_tax_type => p_to_tax_type,
333: p_account_name => jai_constants.recovery
334: );
335:
336: ln_balance_accounting_id := jai_cmn_rgm_recording_pkg.get_account(
337: p_regime_id => p_regime_id,
338: p_organization_type => p_from_party_type,
339: p_organization_id => p_from_party_id,
340: p_location_id => p_from_locn_id,

Line 346: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry(

342: p_account_name => jai_constants.recovery
343: );
344:
345:
346: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry(
347: pn_repository_id => ln_repository_id,
348: pn_regime_id => p_regime_id,
349: pv_tax_type => p_to_tax_type ,
350: pv_organization_type => p_to_party_type,

Line 385: jai_cmn_rgm_recording_pkg.do_vat_accounting(

381: END IF;
382: p_repository_id := ln_repository_id;
383:
384:
385: jai_cmn_rgm_recording_pkg.do_vat_accounting(
386: pn_regime_id => p_regime_id,
387: pn_repository_id => ln_repository_id,
388: pv_organization_type => p_to_party_type,
389: pn_organization_id => p_to_party_id,

Line 433: ln_charge_accounting_id := jai_cmn_rgm_recording_pkg.get_account(

429: */
430: lv_source := jai_constants.source_settle_in;
431: ln_credit_amount := p_to_trx_amount;
432: ln_debit_amount := NULL;
433: ln_charge_accounting_id := jai_cmn_rgm_recording_pkg.get_account(
434: p_regime_id => p_regime_id,
435: p_organization_type => p_to_party_type,
436: p_organization_id => p_to_party_id,
437: p_location_id => p_to_locn_id,

Line 441: ln_balance_accounting_id := jai_cmn_rgm_recording_pkg.get_account(

437: p_location_id => p_to_locn_id,
438: p_tax_type => p_to_tax_type,
439: p_account_name => jai_constants.liability );
440:
441: ln_balance_accounting_id := jai_cmn_rgm_recording_pkg.get_account(
442: p_regime_id => p_regime_id,
443: p_organization_type => p_to_party_type,
444: p_organization_id => p_to_party_id,
445: p_location_id => p_to_locn_id,

Line 449: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry(

445: p_location_id => p_to_locn_id,
446: p_tax_type => p_to_tax_type,
447: p_account_name => jai_constants.liability );
448:
449: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry(
450: pn_repository_id => ln_repository_id,
451: pn_regime_id => p_regime_id,
452: pv_tax_type => p_to_tax_type,
453: pv_organization_type => p_to_party_type,

Line 485: jai_cmn_rgm_recording_pkg.do_vat_accounting(

481: RETURN;
482: END IF;
483:
484: p_repository_id := ln_repository_id;
485: jai_cmn_rgm_recording_pkg.do_vat_accounting(
486: pn_regime_id => p_regime_id,
487: pn_repository_id => ln_repository_id,
488: pv_organization_type => p_to_party_type,
489: pn_organization_id => p_to_party_id,

Line 517: ln_charge_accounting_id := jai_cmn_rgm_recording_pkg.get_account(

513: lv_source := jai_constants.source_settle_out ;
514: ln_credit_amount := NULL;
515: ln_debit_amount := p_to_trx_amount;
516:
517: ln_charge_accounting_id := jai_cmn_rgm_recording_pkg.get_account(
518: p_regime_id => p_regime_id,
519: p_organization_type => p_to_party_type,
520: p_organization_id => p_to_party_id,
521: p_location_id => p_to_locn_id,

Line 525: ln_balance_accounting_id := jai_cmn_rgm_recording_pkg.get_account(

521: p_location_id => p_to_locn_id,
522: p_tax_type => p_to_tax_type,
523: p_account_name => jai_constants.recovery );
524:
525: ln_balance_accounting_id := jai_cmn_rgm_recording_pkg.get_account(
526: p_regime_id => p_regime_id,
527: p_organization_type => p_to_party_type,
528: p_organization_id => p_to_party_id,
529: p_location_id => p_to_locn_id,

Line 533: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry(

529: p_location_id => p_to_locn_id,
530: p_tax_type => p_to_tax_type,
531: p_account_name => jai_constants.recovery );
532:
533: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry(
534: pn_repository_id => ln_repository_id,
535: pn_regime_id => p_regime_id,
536: pv_tax_type => p_to_tax_type,
537: pv_organization_type => p_to_party_type,

Line 569: jai_cmn_rgm_recording_pkg.do_vat_accounting(

565: RETURN;
566: END IF;
567:
568: p_repository_id := ln_repository_id;
569: jai_cmn_rgm_recording_pkg.do_vat_accounting(
570: pn_regime_id => p_regime_id,
571: pn_repository_id => ln_repository_id,
572: pv_organization_type => p_to_party_type,
573: pn_organization_id => p_to_party_id,

Line 1001: jai_cmn_rgm_recording_pkg.get_account(p_regime_id => lv_regime_id,

997: END IF;
998:
999: IF ln_acct_amount <> 0 THEN /* added by ssawant for bug 6020629 */
1000: ln_charge_accounting_id :=
1001: jai_cmn_rgm_recording_pkg.get_account(p_regime_id => lv_regime_id,
1002: p_organization_type => lv_organization_type,
1003: p_organization_id => r_acct_balances.party_id,
1004: p_location_id => r_acct_balances.location_id,
1005: p_tax_type => r_acct_balances.tax_type,

Line 1008: /*Modifed call for jai_cmn_rgm_recording_pkg.post_accounting for post accounting*/

1004: p_location_id => r_acct_balances.location_id,
1005: p_tax_type => r_acct_balances.tax_type,
1006: p_account_name => jai_constants.liability);
1007:
1008: /*Modifed call for jai_cmn_rgm_recording_pkg.post_accounting for post accounting*/
1009:
1010: if (lv_regime_code <> 'TCS') then
1011: jai_cmn_rgm_recording_pkg.post_accounting(
1012: p_regime_code => lv_regime_code,

Line 1011: jai_cmn_rgm_recording_pkg.post_accounting(

1007:
1008: /*Modifed call for jai_cmn_rgm_recording_pkg.post_accounting for post accounting*/
1009:
1010: if (lv_regime_code <> 'TCS') then
1011: jai_cmn_rgm_recording_pkg.post_accounting(
1012: p_regime_code => lv_regime_code,
1013: p_tax_type => r_acct_balances.tax_type,
1014: p_organization_type => lv_organization_type,
1015: p_organization_id => r_acct_balances.party_id,

Line 1035: jai_cmn_rgm_recording_pkg.post_accounting(

1031: p_reference_name => NULL,
1032: p_reference_id => NULL,
1033: p_currency_code => jai_constants.func_curr);
1034: else
1035: jai_cmn_rgm_recording_pkg.post_accounting(
1036: p_regime_code => lv_regime_code,
1037: p_tax_type => r_acct_balances.tax_type,
1038: p_organization_type => lv_organization_type,
1039: p_organization_id => r_acct_balances.party_id,

Line 1071: jai_cmn_rgm_recording_pkg.get_account(p_regime_id => lv_regime_id,

1067:
1068: IF ln_acct_amount <> 0 THEN
1069:
1070: ln_charge_accounting_id :=
1071: jai_cmn_rgm_recording_pkg.get_account(p_regime_id => lv_regime_id,
1072: p_organization_type => lv_organization_type,
1073: p_organization_id => r_acct_balances.party_id,
1074: p_location_id => r_acct_balances.location_id,
1075: p_tax_type => r_acct_balances.tax_type,

Line 1078: /*Modifed call for jai_cmn_rgm_recording_pkg.post_accounting for post accounting*/

1074: p_location_id => r_acct_balances.location_id,
1075: p_tax_type => r_acct_balances.tax_type,
1076: p_account_name => jai_constants.recovery);
1077:
1078: /*Modifed call for jai_cmn_rgm_recording_pkg.post_accounting for post accounting*/
1079:
1080: if (lv_regime_code <> 'TCS') then
1081:
1082: jai_cmn_rgm_recording_pkg.post_accounting(

Line 1082: jai_cmn_rgm_recording_pkg.post_accounting(

1078: /*Modifed call for jai_cmn_rgm_recording_pkg.post_accounting for post accounting*/
1079:
1080: if (lv_regime_code <> 'TCS') then
1081:
1082: jai_cmn_rgm_recording_pkg.post_accounting(
1083: p_regime_code => lv_regime_code,
1084: p_tax_type => r_acct_balances.tax_type,
1085: p_organization_type => lv_organization_type,
1086: p_organization_id => r_acct_balances.party_id,

Line 1107: jai_cmn_rgm_recording_pkg.post_accounting(

1103: p_reference_id => NULL,
1104: p_currency_code => jai_constants.func_curr);
1105:
1106: else
1107: jai_cmn_rgm_recording_pkg.post_accounting(
1108: p_regime_code => lv_regime_code,
1109: p_tax_type => r_acct_balances.tax_type,
1110: p_organization_type => lv_organization_type,
1111: p_organization_id => r_acct_balances.party_id,

Line 1802: ln_dist_code_combination_id := jai_cmn_rgm_recording_pkg.get_account(

1798:
1799: FOR i IN cur_distributions_SERVICE LOOP /* added by ssawant for bug 5879769 */
1800:
1801:
1802: ln_dist_code_combination_id := jai_cmn_rgm_recording_pkg.get_account(
1803: p_regime_id => pn_regime_id,
1804: p_organization_type => jai_constants.orgn_type_io,/* added by ssawant for bug 5879769 */
1805: p_organization_id => i.party_id,/* added by ssawant for bug 5879769 */
1806: p_location_id => i.location_id,/* added by ssawant for bug 5879769 */

Line 1862: ln_dist_code_combination_id := jai_cmn_rgm_recording_pkg.get_account(

1858: END IF;
1859: /* end for bug 8657720 */
1860:
1861:
1862: ln_dist_code_combination_id := jai_cmn_rgm_recording_pkg.get_account(
1863: p_regime_id => pn_regime_id,
1864: p_organization_type => jai_constants.orgn_type_io,
1865: p_organization_id => i.party_id,
1866: p_location_id => i.location_id,

Line 1920: ln_dist_code_combination_id := jai_cmn_rgm_recording_pkg.get_account(

1916: ln_line_amount := nvl(i.balance_amount, 0) -nvl(ln_recovery_tcs, 0);
1917:
1918: /*End Additions by mmurtuza for bug12641455*/
1919:
1920: ln_dist_code_combination_id := jai_cmn_rgm_recording_pkg.get_account(
1921: p_regime_id => pn_regime_id,
1922: p_organization_type => jai_constants.orgn_type_io,
1923: p_organization_id => i.party_id,
1924: p_location_id => i.location_id,

Line 1986: ln_dist_code_combination_id := jai_cmn_rgm_recording_pkg.get_account(

1982:
1983: IF ln_amount1 <> 0 THEN
1984:
1985:
1986: ln_dist_code_combination_id := jai_cmn_rgm_recording_pkg.get_account(
1987: p_regime_id => pn_regime_id,
1988: p_organization_type => jai_constants.orgn_type_ou,
1989: p_organization_id => pn_org_id,
1990: p_location_id => NULL,

Line 2021: ln_dist_code_combination_id := jai_cmn_rgm_recording_pkg.get_account(

2017:
2018: END IF;
2019:
2020: IF ln_amount2 <> 0 THEN
2021: ln_dist_code_combination_id := jai_cmn_rgm_recording_pkg.get_account(
2022: p_regime_id => pn_regime_id,
2023: p_organization_type => jai_constants.orgn_type_ou,
2024: p_organization_id => pn_org_id,
2025: p_location_id => NULL,

Line 2068: ln_dist_code_combination_id := jai_cmn_rgm_recording_pkg.get_account(

2064: END IF;
2065:
2066:
2067: IF nvl(ln_amount,0) <> 0 THEN
2068: ln_dist_code_combination_id := jai_cmn_rgm_recording_pkg.get_account(
2069: p_regime_id => pn_regime_id,
2070: p_organization_type => jai_constants.orgn_type_io,
2071: p_organization_id => org_io_rec.party_id,
2072: p_location_id => org_io_rec.location_id,

Line 2420: jai_cmn_rgm_recording_pkg.insert_repository_entry(

2416: FOR i in cur_distributions LOOP
2417:
2418: IF lv_regime.regime_code = 'SERVICE' THEN
2419:
2420: jai_cmn_rgm_recording_pkg.insert_repository_entry(
2421: p_repository_id => ln_repository_id,
2422: p_regime_id => pn_regime_id,
2423: p_tax_type => i.tax_type,
2424: p_organization_type => jai_constants.orgn_type_io, /* added by ssawant for bug 5879769 */

Line 2466: jai_cmn_rgm_recording_pkg.get_account(p_regime_id => pn_regime_id,

2462: ln_debit_amount := NULL;
2463:
2464:
2465: ln_charge_accounting_id :=
2466: jai_cmn_rgm_recording_pkg.get_account(p_regime_id => pn_regime_id,
2467: p_organization_type => jai_constants.orgn_type_io,
2468: p_organization_id => i.party_id,
2469: p_location_id => i.location_id,
2470: p_tax_type => i.tax_type,

Line 2473: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry(

2469: p_location_id => i.location_id,
2470: p_tax_type => i.tax_type,
2471: p_account_name => jai_constants.recovery);
2472:
2473: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry(
2474: pn_repository_id => ln_repository_id,
2475: pn_regime_id => pn_regime_id,
2476: pv_tax_type => i.tax_type,
2477: pv_organization_type => jai_constants.orgn_type_io,

Line 2541: jai_cmn_rgm_recording_pkg.insert_repository_entry(

2537: FETCH cur_vendor_org_id INTO ln_org_id;
2538: CLOSE cur_vendor_org_id;
2539:
2540: IF NVL(ln_amount1,0) <> 0 THEN
2541: jai_cmn_rgm_recording_pkg.insert_repository_entry(
2542: p_repository_id => ln_repository_id,
2543: p_regime_id => pn_regime_id,
2544: p_tax_type => lv_tax_type1,
2545: p_organization_type => jai_constants.orgn_type_ou,

Line 2575: jai_cmn_rgm_recording_pkg.insert_repository_entry(

2571: END IF;
2572:
2573: ELSIF NVL(ln_amount2,0) <> 0 THEN
2574:
2575: jai_cmn_rgm_recording_pkg.insert_repository_entry(
2576: p_repository_id => ln_repository_id,
2577: p_regime_id => pn_regime_id,
2578: p_tax_type => lv_tax_type2,
2579: p_organization_type => jai_constants.orgn_type_ou,

Line 2629: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry(

2625: IF nvl(ln_amount,0) <> 0 THEN
2626:
2627: ln_credit_amount := ln_amount;
2628: ln_debit_amount := NULL;
2629: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry(
2630: pn_repository_id => ln_repository_id,
2631: pn_regime_id => pn_regime_id,
2632: pv_tax_type => lv_tax_type,
2633: pv_organization_type => jai_constants.orgn_type_io,