eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_MTL_TRXS_PKG dependencies on JAI_CMN_RGM_RECORDING_PKG

Line 919: jai_cmn_rgm_recording_pkg.get_account(

915: if nvl(ln_rgm_cnt,0) = 0 then
916: lv_account_name := jai_constants.recovery;
917: stmt_name:='Getting the interim recovery amount';
918: ln_interim_recovery_account :=
919: jai_cmn_rgm_recording_pkg.get_account(
920: p_regime_id => ln_regime_id,
921: p_organization_type => jai_constants.orgn_type_io,
922: p_organization_id => p_organization_id,
923: p_location_id => p_location_id,

Line 933: jai_cmn_rgm_recording_pkg.get_account(

929: RETURN;
930: END IF;
931: stmt_name:='Getting the code combination id';
932: ln_code_combination_id :=
933: jai_cmn_rgm_recording_pkg.get_account(
934: p_regime_id => ln_regime_id,
935: p_organization_type => jai_constants.orgn_type_io,
936: p_organization_id => p_organization_id,
937: p_location_id => p_location_id,

Line 952: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry(

948: ln_entered_dr := ln_entered_cr*-1;
949: ln_entered_cr := NULL;
950: END IF;
951: stmt_name:='Calling insert vat repository entry';
952: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry(
953: pn_repository_id => ln_repository_id,
954: pn_regime_id => ln_regime_id,
955: pv_tax_type => rec_claims.tax_type,
956: pv_organization_type => jai_constants.orgn_type_io,

Line 1016: jai_cmn_rgm_recording_pkg.do_vat_accounting(

1012: /*
1013: ln_entered_dr := NULL;
1014: ln_entered_cr := rec_claims.tax_amt;
1015: stmt_name:='calling do vat accounting procedure for credit';
1016: jai_cmn_rgm_recording_pkg.do_vat_accounting(
1017: pn_regime_id => ln_regime_id,
1018: pn_repository_id => ln_repository_id,
1019: pv_organization_type => jai_constants.orgn_type_io,
1020: pn_organization_id => p_organization_id,

Line 1042: jai_cmn_rgm_recording_pkg.do_vat_accounting(

1038: ---Dr Vat Recovery
1039: ln_entered_dr := rec_claims.tax_amt;
1040: ln_entered_cr:= NULL;
1041: stmt_name:='calling do vat accounting procedure for debit';
1042: jai_cmn_rgm_recording_pkg.do_vat_accounting(
1043: pn_regime_id => ln_regime_id,
1044: pn_repository_id => ln_repository_id,
1045: pv_organization_type => jai_constants.orgn_type_io,
1046: pn_organization_id => p_organization_id,

Line 2232: stmt_name := 'Calling:4 jai_cmn_rgm_recording_pkg.get_account()';

2228: ELSIF main_rec.tax_type_val = 4 and p_register_type IN ('SVAT','RVAT') THEN /* value added tax*/
2229:
2230: IF p_register_type='SVAT' and main_rec.tax_type <> 'VAT REVERSAL' then
2231: t_gl_entries(rec).amount := main_rec.tax_amount;
2232: stmt_name := 'Calling:4 jai_cmn_rgm_recording_pkg.get_account()';
2233: t_gl_entries(rec).debit_account := jai_cmn_rgm_recording_pkg.get_account(
2234: p_regime_id => l_regime_id,
2235: p_organization_type => jai_constants.orgn_type_io,
2236: p_organization_id => r_mtl_trx_info.from_organization,

Line 2233: t_gl_entries(rec).debit_account := jai_cmn_rgm_recording_pkg.get_account(

2229:
2230: IF p_register_type='SVAT' and main_rec.tax_type <> 'VAT REVERSAL' then
2231: t_gl_entries(rec).amount := main_rec.tax_amount;
2232: stmt_name := 'Calling:4 jai_cmn_rgm_recording_pkg.get_account()';
2233: t_gl_entries(rec).debit_account := jai_cmn_rgm_recording_pkg.get_account(
2234: p_regime_id => l_regime_id,
2235: p_organization_type => jai_constants.orgn_type_io,
2236: p_organization_id => r_mtl_trx_info.from_organization,
2237: p_location_id => ln_from_loc_id,

Line 2241: stmt_name := 'Calling:3 jai_cmn_rgm_recording_pkg.get_account()';

2237: p_location_id => ln_from_loc_id,
2238: p_tax_type => main_rec.tax_type,
2239: p_account_name => jai_constants.liability_interim
2240: );
2241: stmt_name := 'Calling:3 jai_cmn_rgm_recording_pkg.get_account()';
2242: t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(
2243: p_regime_id => l_regime_id,
2244: p_organization_type => jai_constants.orgn_type_io,
2245: p_organization_id => r_mtl_trx_info.from_organization,

Line 2242: t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(

2238: p_tax_type => main_rec.tax_type,
2239: p_account_name => jai_constants.liability_interim
2240: );
2241: stmt_name := 'Calling:3 jai_cmn_rgm_recording_pkg.get_account()';
2242: t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(
2243: p_regime_id => l_regime_id,
2244: p_organization_type => jai_constants.orgn_type_io,
2245: p_organization_id => r_mtl_trx_info.from_organization,
2246: p_location_id => ln_from_loc_id,

Line 2270: -- t_gl_entries(rec).debit_account := jai_cmn_rgm_recording_pkg.get_account(

2266: debit expense accnt
2267: credit VAT recovery Account
2268: */
2269: -- t_gl_entries(rec).amount := main_rec.tax_amount;
2270: -- t_gl_entries(rec).debit_account := jai_cmn_rgm_recording_pkg.get_account(
2271: -- p_regime_id => l_regime_id,
2272: -- p_organization_type => jai_constants.orgn_type_io,
2273: -- p_organization_id => r_mtl_trx_info.from_organization,
2274: -- p_location_id => ln_from_loc_id,

Line 2279: -- t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(

2275: -- p_tax_type => main_rec.tax_type,
2276: -- p_account_name => 'EXPENSE'
2277: -- );
2278:
2279: -- t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(
2280: -- p_regime_id => l_regime_id,
2281: -- p_organization_type => jai_constants.orgn_type_io,
2282: -- p_organization_id => r_mtl_trx_info.from_organization,
2283: -- p_location_id => ln_from_loc_id,

Line 2308: stmt_name := 'Calling:2 jai_cmn_rgm_recording_pkg.get_account()';

2304:
2305: IF r_get_interorg_params.fob_point = 1 THEN -- Shippment
2306: t_gl_entries(rec).amount := main_rec.tax_amount;
2307: t_gl_entries(rec).debit_account := r_get_interorg_params.interorg_receivables_account;
2308: stmt_name := 'Calling:2 jai_cmn_rgm_recording_pkg.get_account()';
2309: t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(
2310: p_regime_id => l_regime_id,
2311: p_organization_type => jai_constants.orgn_type_io,
2312: p_organization_id => r_mtl_trx_info.from_organization,

Line 2309: t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(

2305: IF r_get_interorg_params.fob_point = 1 THEN -- Shippment
2306: t_gl_entries(rec).amount := main_rec.tax_amount;
2307: t_gl_entries(rec).debit_account := r_get_interorg_params.interorg_receivables_account;
2308: stmt_name := 'Calling:2 jai_cmn_rgm_recording_pkg.get_account()';
2309: t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(
2310: p_regime_id => l_regime_id,
2311: p_organization_type => jai_constants.orgn_type_io,
2312: p_organization_id => r_mtl_trx_info.from_organization,
2313: p_location_id => ln_from_loc_id,

Line 2349: stmt_name := 'Calling:1 jai_cmn_rgm_recording_pkg.get_account()';

2345:
2346: ELSIF r_get_interorg_params.fob_point = 2 THEN --Receipt
2347: t_gl_entries(rec).amount := main_rec.tax_amount;
2348: t_gl_entries(rec).debit_account := r_get_interorg_params.intransit_inv_account;
2349: stmt_name := 'Calling:1 jai_cmn_rgm_recording_pkg.get_account()';
2350: t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(
2351: p_regime_id => l_regime_id,
2352: p_organization_type => jai_constants.orgn_type_io,
2353: p_organization_id => r_mtl_trx_info.from_organization,

Line 2350: t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(

2346: ELSIF r_get_interorg_params.fob_point = 2 THEN --Receipt
2347: t_gl_entries(rec).amount := main_rec.tax_amount;
2348: t_gl_entries(rec).debit_account := r_get_interorg_params.intransit_inv_account;
2349: stmt_name := 'Calling:1 jai_cmn_rgm_recording_pkg.get_account()';
2350: t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(
2351: p_regime_id => l_regime_id,
2352: p_organization_type => jai_constants.orgn_type_io,
2353: p_organization_id => r_mtl_trx_info.from_organization,
2354: p_location_id => ln_from_loc_id,

Line 2377: stmt_name := 'Calling jai_cmn_rgm_recording_pkg.get_account()';

2373: ELSIF r_get_interorg_params.intransit_type = 1
2374: and p_register_type = 'RVAT' and main_rec.tax_type <> 'VAT RECOVERY' /* Direct */ THEN
2375: t_gl_entries(rec).amount := main_rec.tax_amount;
2376: t_gl_entries(rec).debit_account := r_get_interorg_params.interorg_receivables_account;
2377: stmt_name := 'Calling jai_cmn_rgm_recording_pkg.get_account()';
2378: t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(
2379: p_regime_id => l_regime_id,
2380: p_organization_type => jai_constants.orgn_type_io,
2381: p_organization_id => r_mtl_trx_info.from_organization,

Line 2378: t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(

2374: and p_register_type = 'RVAT' and main_rec.tax_type <> 'VAT RECOVERY' /* Direct */ THEN
2375: t_gl_entries(rec).amount := main_rec.tax_amount;
2376: t_gl_entries(rec).debit_account := r_get_interorg_params.interorg_receivables_account;
2377: stmt_name := 'Calling jai_cmn_rgm_recording_pkg.get_account()';
2378: t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(
2379: p_regime_id => l_regime_id,
2380: p_organization_type => jai_constants.orgn_type_io,
2381: p_organization_id => r_mtl_trx_info.from_organization,
2382: p_location_id => ln_from_loc_id,

Line 2417: t_gl_entries(rec).debit_account := jai_cmn_rgm_recording_pkg.get_account(

2413: rec := rec + 1;
2414:
2415: -- starts here code for VAT
2416: t_gl_entries(rec).amount := main_rec.tax_amount;
2417: t_gl_entries(rec).debit_account := jai_cmn_rgm_recording_pkg.get_account(
2418: p_regime_id => l_regime_id,
2419: p_organization_type => jai_constants.orgn_type_io,
2420: p_organization_id => r_mtl_trx_info.to_organization,
2421: p_location_id => r_mtl_trx_info.location_id,

Line 2442: t_gl_entries(rec).debit_account := jai_cmn_rgm_recording_pkg.get_account(

2438: rec := rec + 1;
2439:
2440:
2441: t_gl_entries(rec).amount := main_rec.tax_amount;
2442: t_gl_entries(rec).debit_account := jai_cmn_rgm_recording_pkg.get_account(
2443: p_regime_id => l_regime_id,
2444: p_organization_type => jai_constants.orgn_type_io,
2445: p_organization_id => r_mtl_trx_info.to_organization,
2446: p_location_id => r_mtl_trx_info.location_id,

Line 2456: t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(

2452: p_process_status := 'E';
2453: p_process_message := 'Recovery Account not defined for ' || main_rec.tax_type;
2454: RETURN;
2455: END IF;
2456: t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(
2457: p_regime_id => l_regime_id,
2458: p_organization_type => jai_constants.orgn_type_io,
2459: p_organization_id => r_mtl_trx_info.to_organization,
2460: p_location_id => r_mtl_trx_info.location_id,

Line 2538: t_gl_entries(rec).debit_account := jai_cmn_rgm_recording_pkg.get_account(

2534: debit expense accnt
2535: credit VAT recovery Account
2536: */
2537: t_gl_entries(rec).amount := main_rec.tax_amount;
2538: t_gl_entries(rec).debit_account := jai_cmn_rgm_recording_pkg.get_account(
2539: p_regime_id => l_regime_id,
2540: p_organization_type => jai_constants.orgn_type_io,
2541: p_organization_id => r_mtl_trx_info.from_organization,
2542: p_location_id => ln_from_loc_id,

Line 2547: t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(

2543: p_tax_type => main_rec.tax_type,
2544: p_account_name => 'EXPENSE'
2545: );
2546:
2547: t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(
2548: p_regime_id => l_regime_id,
2549: p_organization_type => jai_constants.orgn_type_io,
2550: p_organization_id => r_mtl_trx_info.from_organization,
2551: p_location_id => ln_from_loc_id,

Line 2611: t_gl_entries(rec).debit_account := jai_cmn_rgm_recording_pkg.get_account(

2607: debit expense accnt
2608: credit VAT recovery Account
2609: */
2610: t_gl_entries(rec).amount := main_rec.tax_amount;
2611: t_gl_entries(rec).debit_account := jai_cmn_rgm_recording_pkg.get_account(
2612: p_regime_id => l_regime_id,
2613: p_organization_type => jai_constants.orgn_type_io,
2614: p_organization_id => r_mtl_trx_info.from_organization,
2615: p_location_id => ln_from_loc_id,

Line 2620: t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(

2616: p_tax_type => main_rec.tax_type,
2617: p_account_name => 'EXPENSE'
2618: );
2619:
2620: t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(
2621: p_regime_id => l_regime_id,
2622: p_organization_type => jai_constants.orgn_type_io,
2623: p_organization_id => r_mtl_trx_info.from_organization,
2624: p_location_id => ln_from_loc_id,

Line 4273: jai_cmn_rgm_recording_pkg.get_account(

4269: CLOSE c_regime_cur;
4270: lv_account_name := jai_constants.recovery;
4271: stmt_name:='Getting the interim recovery amount';
4272: ln_interim_recovery_account :=
4273: jai_cmn_rgm_recording_pkg.get_account(
4274: p_regime_id => ln_regime_id,
4275: p_organization_type => jai_constants.orgn_type_io,
4276: p_organization_id => p_organization_id,
4277: p_location_id => p_location_id,

Line 4287: jai_cmn_rgm_recording_pkg.get_account(

4283: RETURN;
4284: END IF;
4285: stmt_name:='Getting the code combination id';
4286: ln_code_combination_id :=
4287: jai_cmn_rgm_recording_pkg.get_account(
4288: p_regime_id => ln_regime_id,
4289: p_organization_type => jai_constants.orgn_type_io,
4290: p_organization_id => p_organization_id,
4291: p_location_id => p_location_id,

Line 4301: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry(

4297: RETURN;
4298: END IF;
4299: ln_entered_cr:=p_amount;
4300: stmt_name:='Calling insert vat repository entry';
4301: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry(
4302: pn_repository_id => ln_repository_id,
4303: pn_regime_id => ln_regime_id,
4304: pv_tax_type => p_tax_type,
4305: pv_organization_type => jai_constants.orgn_type_io,

Line 4749: sqlstmt := 'jai_cmn_rgm_recording_pkg.get_account for interim recovery account';

4745: OPEN cur_regimes(rec_claims.regime_code);
4746: FETCH cur_regimes INTO ln_regime_id;
4747: CLOSE cur_regimes;
4748:
4749: sqlstmt := 'jai_cmn_rgm_recording_pkg.get_account for interim recovery account';
4750: ln_debit_ac := jai_cmn_rgm_recording_pkg.get_account(
4751: p_regime_id => ln_regime_id,
4752: p_organization_type => jai_constants.orgn_type_io,
4753: p_organization_id => rec_claims.organization_id,

Line 4750: ln_debit_ac := jai_cmn_rgm_recording_pkg.get_account(

4746: FETCH cur_regimes INTO ln_regime_id;
4747: CLOSE cur_regimes;
4748:
4749: sqlstmt := 'jai_cmn_rgm_recording_pkg.get_account for interim recovery account';
4750: ln_debit_ac := jai_cmn_rgm_recording_pkg.get_account(
4751: p_regime_id => ln_regime_id,
4752: p_organization_type => jai_constants.orgn_type_io,
4753: p_organization_id => rec_claims.organization_id,
4754: p_location_id => rec_claims.location_id,

Line 4758: sqlstmt := 'jai_cmn_rgm_recording_pkg.get_account for recovery account';

4754: p_location_id => rec_claims.location_id,
4755: p_tax_type => rec_claims.tax_type,
4756: p_account_name => jai_constants.recovery_interim);
4757:
4758: sqlstmt := 'jai_cmn_rgm_recording_pkg.get_account for recovery account';
4759: ln_credit_ac := jai_cmn_rgm_recording_pkg.get_account(
4760: p_regime_id => ln_regime_id,
4761: p_organization_type => jai_constants.orgn_type_io,
4762: p_organization_id => rec_claims.organization_id,

Line 4759: ln_credit_ac := jai_cmn_rgm_recording_pkg.get_account(

4755: p_tax_type => rec_claims.tax_type,
4756: p_account_name => jai_constants.recovery_interim);
4757:
4758: sqlstmt := 'jai_cmn_rgm_recording_pkg.get_account for recovery account';
4759: ln_credit_ac := jai_cmn_rgm_recording_pkg.get_account(
4760: p_regime_id => ln_regime_id,
4761: p_organization_type => jai_constants.orgn_type_io,
4762: p_organization_id => rec_claims.organization_id,
4763: p_location_id => rec_claims.location_id,