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 1042: jai_cmn_rgm_recording_pkg.get_account(

1038: if nvl(ln_rgm_cnt,0) = 0 then
1039: lv_account_name := jai_constants.recovery;
1040: stmt_name:='Getting the interim recovery amount';
1041: ln_interim_recovery_account :=
1042: jai_cmn_rgm_recording_pkg.get_account(
1043: p_regime_id => ln_regime_id,
1044: p_organization_type => jai_constants.orgn_type_io,
1045: p_organization_id => p_organization_id,
1046: p_location_id => p_location_id,

Line 1056: jai_cmn_rgm_recording_pkg.get_account(

1052: RETURN;
1053: END IF;
1054: stmt_name:='Getting the code combination id';
1055: ln_code_combination_id :=
1056: jai_cmn_rgm_recording_pkg.get_account(
1057: p_regime_id => ln_regime_id,
1058: p_organization_type => jai_constants.orgn_type_io,
1059: p_organization_id => p_organization_id,
1060: p_location_id => p_location_id,

Line 1075: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry(

1071: ln_entered_dr := ln_entered_cr*-1;
1072: ln_entered_cr := NULL;
1073: END IF;
1074: stmt_name:='Calling insert vat repository entry';
1075: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry(
1076: pn_repository_id => ln_repository_id,
1077: pn_regime_id => ln_regime_id,
1078: pv_tax_type => rec_claims.tax_type,
1079: pv_organization_type => jai_constants.orgn_type_io,

Line 1144: jai_cmn_rgm_recording_pkg.do_vat_accounting(

1140: /*
1141: ln_entered_dr := NULL;
1142: ln_entered_cr := rec_claims.tax_amt;
1143: stmt_name:='calling do vat accounting procedure for credit';
1144: jai_cmn_rgm_recording_pkg.do_vat_accounting(
1145: pn_regime_id => ln_regime_id,
1146: pn_repository_id => ln_repository_id,
1147: pv_organization_type => jai_constants.orgn_type_io,
1148: pn_organization_id => p_organization_id,

Line 1170: jai_cmn_rgm_recording_pkg.do_vat_accounting(

1166: ---Dr Vat Recovery
1167: ln_entered_dr := rec_claims.tax_amt;
1168: ln_entered_cr:= NULL;
1169: stmt_name:='calling do vat accounting procedure for debit';
1170: jai_cmn_rgm_recording_pkg.do_vat_accounting(
1171: pn_regime_id => ln_regime_id,
1172: pn_repository_id => ln_repository_id,
1173: pv_organization_type => jai_constants.orgn_type_io,
1174: pn_organization_id => p_organization_id,

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

2392: ELSIF main_rec.tax_type_val = 4 and p_register_type IN ('SVAT','RVAT') THEN /* value added tax*/
2393:
2394: IF p_register_type='SVAT' and main_rec.tax_type <> 'VAT REVERSAL' then
2395: t_gl_entries(rec).amount := main_rec.tax_amount;
2396: stmt_name := 'Calling:4 jai_cmn_rgm_recording_pkg.get_account()';
2397: t_gl_entries(rec).debit_account := jai_cmn_rgm_recording_pkg.get_account(
2398: p_regime_id => l_regime_id,
2399: p_organization_type => jai_constants.orgn_type_io,
2400: p_organization_id => r_mtl_trx_info.from_organization,

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

2393:
2394: IF p_register_type='SVAT' and main_rec.tax_type <> 'VAT REVERSAL' then
2395: t_gl_entries(rec).amount := main_rec.tax_amount;
2396: stmt_name := 'Calling:4 jai_cmn_rgm_recording_pkg.get_account()';
2397: t_gl_entries(rec).debit_account := jai_cmn_rgm_recording_pkg.get_account(
2398: p_regime_id => l_regime_id,
2399: p_organization_type => jai_constants.orgn_type_io,
2400: p_organization_id => r_mtl_trx_info.from_organization,
2401: p_location_id => ln_from_loc_id,

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

2401: p_location_id => ln_from_loc_id,
2402: p_tax_type => main_rec.tax_type,
2403: p_account_name => jai_constants.liability_interim
2404: );
2405: stmt_name := 'Calling:3 jai_cmn_rgm_recording_pkg.get_account()';
2406: t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(
2407: p_regime_id => l_regime_id,
2408: p_organization_type => jai_constants.orgn_type_io,
2409: p_organization_id => r_mtl_trx_info.from_organization,

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

2402: p_tax_type => main_rec.tax_type,
2403: p_account_name => jai_constants.liability_interim
2404: );
2405: stmt_name := 'Calling:3 jai_cmn_rgm_recording_pkg.get_account()';
2406: t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(
2407: p_regime_id => l_regime_id,
2408: p_organization_type => jai_constants.orgn_type_io,
2409: p_organization_id => r_mtl_trx_info.from_organization,
2410: p_location_id => ln_from_loc_id,

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

2430: debit expense accnt
2431: credit VAT recovery Account
2432: */
2433: -- t_gl_entries(rec).amount := main_rec.tax_amount;
2434: -- t_gl_entries(rec).debit_account := jai_cmn_rgm_recording_pkg.get_account(
2435: -- p_regime_id => l_regime_id,
2436: -- p_organization_type => jai_constants.orgn_type_io,
2437: -- p_organization_id => r_mtl_trx_info.from_organization,
2438: -- p_location_id => ln_from_loc_id,

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

2439: -- p_tax_type => main_rec.tax_type,
2440: -- p_account_name => 'EXPENSE'
2441: -- );
2442:
2443: -- t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(
2444: -- p_regime_id => l_regime_id,
2445: -- p_organization_type => jai_constants.orgn_type_io,
2446: -- p_organization_id => r_mtl_trx_info.from_organization,
2447: -- p_location_id => ln_from_loc_id,

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

2468:
2469: IF r_get_interorg_params.fob_point = 1 THEN -- Shippment
2470: t_gl_entries(rec).amount := main_rec.tax_amount;
2471: t_gl_entries(rec).debit_account := r_get_interorg_params.interorg_receivables_account;
2472: stmt_name := 'Calling:2 jai_cmn_rgm_recording_pkg.get_account()';
2473: t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(
2474: p_regime_id => l_regime_id,
2475: p_organization_type => jai_constants.orgn_type_io,
2476: p_organization_id => r_mtl_trx_info.from_organization,

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

2469: IF r_get_interorg_params.fob_point = 1 THEN -- Shippment
2470: t_gl_entries(rec).amount := main_rec.tax_amount;
2471: t_gl_entries(rec).debit_account := r_get_interorg_params.interorg_receivables_account;
2472: stmt_name := 'Calling:2 jai_cmn_rgm_recording_pkg.get_account()';
2473: t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(
2474: p_regime_id => l_regime_id,
2475: p_organization_type => jai_constants.orgn_type_io,
2476: p_organization_id => r_mtl_trx_info.from_organization,
2477: p_location_id => ln_from_loc_id,

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

2509:
2510: ELSIF r_get_interorg_params.fob_point = 2 THEN --Receipt
2511: t_gl_entries(rec).amount := main_rec.tax_amount;
2512: t_gl_entries(rec).debit_account := r_get_interorg_params.intransit_inv_account;
2513: stmt_name := 'Calling:1 jai_cmn_rgm_recording_pkg.get_account()';
2514: t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(
2515: p_regime_id => l_regime_id,
2516: p_organization_type => jai_constants.orgn_type_io,
2517: p_organization_id => r_mtl_trx_info.from_organization,

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

2510: ELSIF r_get_interorg_params.fob_point = 2 THEN --Receipt
2511: t_gl_entries(rec).amount := main_rec.tax_amount;
2512: t_gl_entries(rec).debit_account := r_get_interorg_params.intransit_inv_account;
2513: stmt_name := 'Calling:1 jai_cmn_rgm_recording_pkg.get_account()';
2514: t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(
2515: p_regime_id => l_regime_id,
2516: p_organization_type => jai_constants.orgn_type_io,
2517: p_organization_id => r_mtl_trx_info.from_organization,
2518: p_location_id => ln_from_loc_id,

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

2537: ELSIF r_get_interorg_params.intransit_type = 1
2538: and p_register_type = 'RVAT' and main_rec.tax_type <> 'VAT RECOVERY' /* Direct */ THEN
2539: t_gl_entries(rec).amount := main_rec.tax_amount;
2540: t_gl_entries(rec).debit_account := r_get_interorg_params.interorg_receivables_account;
2541: stmt_name := 'Calling jai_cmn_rgm_recording_pkg.get_account()';
2542: t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(
2543: p_regime_id => l_regime_id,
2544: p_organization_type => jai_constants.orgn_type_io,
2545: p_organization_id => r_mtl_trx_info.from_organization,

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

2538: and p_register_type = 'RVAT' and main_rec.tax_type <> 'VAT RECOVERY' /* Direct */ THEN
2539: t_gl_entries(rec).amount := main_rec.tax_amount;
2540: t_gl_entries(rec).debit_account := r_get_interorg_params.interorg_receivables_account;
2541: stmt_name := 'Calling jai_cmn_rgm_recording_pkg.get_account()';
2542: t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(
2543: p_regime_id => l_regime_id,
2544: p_organization_type => jai_constants.orgn_type_io,
2545: p_organization_id => r_mtl_trx_info.from_organization,
2546: p_location_id => ln_from_loc_id,

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

2577: rec := rec + 1;
2578:
2579: -- starts here code for VAT
2580: t_gl_entries(rec).amount := main_rec.tax_amount;
2581: t_gl_entries(rec).debit_account := jai_cmn_rgm_recording_pkg.get_account(
2582: p_regime_id => l_regime_id,
2583: p_organization_type => jai_constants.orgn_type_io,
2584: p_organization_id => r_mtl_trx_info.to_organization,
2585: p_location_id => r_mtl_trx_info.location_id,

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

2602: rec := rec + 1;
2603:
2604:
2605: t_gl_entries(rec).amount := main_rec.tax_amount;
2606: t_gl_entries(rec).debit_account := jai_cmn_rgm_recording_pkg.get_account(
2607: p_regime_id => l_regime_id,
2608: p_organization_type => jai_constants.orgn_type_io,
2609: p_organization_id => r_mtl_trx_info.to_organization,
2610: p_location_id => r_mtl_trx_info.location_id,

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

2616: p_process_status := 'E';
2617: p_process_message := 'Recovery Account not defined for ' || main_rec.tax_type;
2618: RETURN;
2619: END IF;
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.to_organization,
2624: p_location_id => r_mtl_trx_info.location_id,

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

2698: debit expense accnt
2699: credit VAT recovery Account
2700: */
2701: t_gl_entries(rec).amount := main_rec.tax_amount;
2702: t_gl_entries(rec).debit_account := jai_cmn_rgm_recording_pkg.get_account(
2703: p_regime_id => l_regime_id,
2704: p_organization_type => jai_constants.orgn_type_io,
2705: p_organization_id => r_mtl_trx_info.from_organization,
2706: p_location_id => ln_from_loc_id,

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

2707: p_tax_type => main_rec.tax_type,
2708: p_account_name => 'EXPENSE'
2709: );
2710:
2711: t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(
2712: p_regime_id => l_regime_id,
2713: p_organization_type => jai_constants.orgn_type_io,
2714: p_organization_id => r_mtl_trx_info.from_organization,
2715: p_location_id => ln_from_loc_id,

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

2771: debit expense accnt
2772: credit VAT recovery Account
2773: */
2774: t_gl_entries(rec).amount := main_rec.tax_amount;
2775: t_gl_entries(rec).debit_account := jai_cmn_rgm_recording_pkg.get_account(
2776: p_regime_id => l_regime_id,
2777: p_organization_type => jai_constants.orgn_type_io,
2778: p_organization_id => r_mtl_trx_info.from_organization,
2779: p_location_id => ln_from_loc_id,

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

2780: p_tax_type => main_rec.tax_type,
2781: p_account_name => 'EXPENSE'
2782: );
2783:
2784: t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(
2785: p_regime_id => l_regime_id,
2786: p_organization_type => jai_constants.orgn_type_io,
2787: p_organization_id => r_mtl_trx_info.from_organization,
2788: p_location_id => ln_from_loc_id,

Line 4713: jai_cmn_rgm_recording_pkg.get_account(

4709: CLOSE c_regime_cur;
4710: lv_account_name := jai_constants.recovery;
4711: stmt_name:='Getting the interim recovery amount';
4712: ln_interim_recovery_account :=
4713: jai_cmn_rgm_recording_pkg.get_account(
4714: p_regime_id => ln_regime_id,
4715: p_organization_type => jai_constants.orgn_type_io,
4716: p_organization_id => p_organization_id,
4717: p_location_id => p_location_id,

Line 4727: jai_cmn_rgm_recording_pkg.get_account(

4723: RETURN;
4724: END IF;
4725: stmt_name:='Getting the code combination id';
4726: ln_code_combination_id :=
4727: jai_cmn_rgm_recording_pkg.get_account(
4728: p_regime_id => ln_regime_id,
4729: p_organization_type => jai_constants.orgn_type_io,
4730: p_organization_id => p_organization_id,
4731: p_location_id => p_location_id,

Line 4741: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry(

4737: RETURN;
4738: END IF;
4739: ln_entered_cr:=p_amount;
4740: stmt_name:='Calling insert vat repository entry';
4741: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry(
4742: pn_repository_id => ln_repository_id,
4743: pn_regime_id => ln_regime_id,
4744: pv_tax_type => p_tax_type,
4745: pv_organization_type => jai_constants.orgn_type_io,

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

5188: OPEN cur_regimes(rec_claims.regime_code);
5189: FETCH cur_regimes INTO ln_regime_id;
5190: CLOSE cur_regimes;
5191:
5192: sqlstmt := 'jai_cmn_rgm_recording_pkg.get_account for interim recovery account';
5193: ln_debit_ac := jai_cmn_rgm_recording_pkg.get_account(
5194: p_regime_id => ln_regime_id,
5195: p_organization_type => jai_constants.orgn_type_io,
5196: p_organization_id => rec_claims.organization_id,

Line 5193: ln_debit_ac := jai_cmn_rgm_recording_pkg.get_account(

5189: FETCH cur_regimes INTO ln_regime_id;
5190: CLOSE cur_regimes;
5191:
5192: sqlstmt := 'jai_cmn_rgm_recording_pkg.get_account for interim recovery account';
5193: ln_debit_ac := jai_cmn_rgm_recording_pkg.get_account(
5194: p_regime_id => ln_regime_id,
5195: p_organization_type => jai_constants.orgn_type_io,
5196: p_organization_id => rec_claims.organization_id,
5197: p_location_id => rec_claims.location_id,

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

5197: p_location_id => rec_claims.location_id,
5198: p_tax_type => rec_claims.tax_type,
5199: p_account_name => jai_constants.recovery_interim);
5200:
5201: sqlstmt := 'jai_cmn_rgm_recording_pkg.get_account for recovery account';
5202: ln_credit_ac := jai_cmn_rgm_recording_pkg.get_account(
5203: p_regime_id => ln_regime_id,
5204: p_organization_type => jai_constants.orgn_type_io,
5205: p_organization_id => rec_claims.organization_id,

Line 5202: ln_credit_ac := jai_cmn_rgm_recording_pkg.get_account(

5198: p_tax_type => rec_claims.tax_type,
5199: p_account_name => jai_constants.recovery_interim);
5200:
5201: sqlstmt := 'jai_cmn_rgm_recording_pkg.get_account for recovery account';
5202: ln_credit_ac := jai_cmn_rgm_recording_pkg.get_account(
5203: p_regime_id => ln_regime_id,
5204: p_organization_type => jai_constants.orgn_type_io,
5205: p_organization_id => rec_claims.organization_id,
5206: p_location_id => rec_claims.location_id,