APPS.JAI_OM_RG_PKG dependencies on JAI_CMN_RG_BALANCES

Line 2434: FROM JAI_CMN_RG_BALANCES

2430: fin_year = p_fin_year;
2431:
2432: CURSOR rg23a_part_ii_balance_cur IS
2433: SELECT NVL(rg23a_balance,0)
2434: FROM JAI_CMN_RG_BALANCES
2435: WHERE organization_id = p_org_id AND
2436: location_id = p_location_id;
2437:
2438: CURSOR rg23c_part_ii_balance_cur IS

Line 2440: FROM JAI_CMN_RG_BALANCES

2436: location_id = p_location_id;
2437:
2438: CURSOR rg23c_part_ii_balance_cur IS
2439: SELECT NVL(rg23c_balance,0)
2440: FROM JAI_CMN_RG_BALANCES
2441: WHERE organization_id = p_org_id AND
2442: location_id = p_location_id;
2443:
2444: CURSOR serial_no_cur IS

Line 2759: UPDATE JAI_CMN_RG_BALANCES

2755: END IF;
2756:
2757: IF p_register_type = 'A' THEN
2758:
2759: UPDATE JAI_CMN_RG_BALANCES
2760: SET rg23a_balance = rg23a_balance - v_excise_amount
2761: WHERE organization_id = p_org_id AND
2762: location_id = p_location_id;
2763:

Line 2766: UPDATE JAI_CMN_RG_BALANCES

2762: location_id = p_location_id;
2763:
2764: ELSIF p_register_type = 'C' THEN
2765:
2766: UPDATE JAI_CMN_RG_BALANCES
2767: SET rg23c_balance = rg23c_balance - v_excise_amount
2768: WHERE organization_id = p_org_id AND
2769: location_id = p_location_id;
2770: END IF;

Line 2861: FROM JAI_CMN_RG_BALANCES

2857: --Changed by Nagaraj.s for Enh#2415656..........
2858: CURSOR pla_balance_cur IS
2859: SELECT NVL(pla_balance,0),NVL(basic_pla_balance,0),
2860: NVL(additional_pla_balance,0), NVL(other_pla_balance,0)
2861: FROM JAI_CMN_RG_BALANCES
2862: WHERE organization_id = p_org_id AND
2863: location_id = p_location_id;
2864:
2865: CURSOR range_division_cur IS

Line 3210: UPDATE JAI_CMN_RG_BALANCES

3206: fnd_file.put_line(fnd_file.log, '16 after insert into JAI_CMN_RG_PLA_TRXS');
3207:
3208: v_excise_amount := NVL(p_dr_basic_ed,0) + NVL(p_dr_additional_ed,0) + NVL(p_dr_other_ed,0);
3209:
3210: UPDATE JAI_CMN_RG_BALANCES
3211: SET pla_balance = pla_balance - v_excise_amount,
3212: basic_pla_balance = basic_pla_balance - p_dr_basic_ed,
3213: additional_pla_balance = NVL(additional_pla_balance,0) - NVL(p_dr_additional_ed,0),
3214: other_pla_balance = NVL(other_pla_balance,0) - NVL(p_dr_other_ed,0)

Line 3217: fnd_file.put_line(fnd_file.log, '17 after update into JAI_CMN_RG_BALANCES');

3213: additional_pla_balance = NVL(additional_pla_balance,0) - NVL(p_dr_additional_ed,0),
3214: other_pla_balance = NVL(other_pla_balance,0) - NVL(p_dr_other_ed,0)
3215: WHERE organization_id = p_org_id
3216: AND location_id = p_location_id;
3217: fnd_file.put_line(fnd_file.log, '17 after update into JAI_CMN_RG_BALANCES');
3218: ELSE
3219: fnd_file.put_line(fnd_file.log, '18 before insert into update into JAI_CMN_RG_PLA_TRXS , slno ' || v_serial_no
3220: ||' , register_id ->' || ln_register_id
3221: ||' , organization_id ->' || p_org_id

Line 3315: UPDATE JAI_CMN_RG_BALANCES

3311: fnd_file.put_line(fnd_file.log, '19 after insert into JAI_CMN_RG_PLA_TRXS');
3312:
3313: v_excise_amount := NVL(p_dr_basic_ed,0) + NVL(p_dr_additional_ed,0) + NVL(p_dr_other_ed,0);
3314:
3315: UPDATE JAI_CMN_RG_BALANCES
3316: SET pla_balance = pla_balance - v_excise_amount
3317: WHERE organization_id = p_org_id
3318: AND location_id = p_location_id;
3319:

Line 3320: fnd_file.put_line(fnd_file.log, '20 after update of JAI_CMN_RG_BALANCES');

3316: SET pla_balance = pla_balance - v_excise_amount
3317: WHERE organization_id = p_org_id
3318: AND location_id = p_location_id;
3319:
3320: fnd_file.put_line(fnd_file.log, '20 after update of JAI_CMN_RG_BALANCES');
3321:
3322: END IF;
3323:
3324: