APPS.JAI_OM_RG_PKG dependencies on JAI_CMN_RG_BALANCES

Line 2599: FROM JAI_CMN_RG_BALANCES

2595: fin_year = p_fin_year;
2596:
2597: CURSOR rg23a_part_ii_balance_cur IS
2598: SELECT NVL(rg23a_balance,0)
2599: FROM JAI_CMN_RG_BALANCES
2600: WHERE organization_id = p_org_id AND
2601: location_id = p_location_id;
2602:
2603: CURSOR rg23c_part_ii_balance_cur IS

Line 2605: FROM JAI_CMN_RG_BALANCES

2601: location_id = p_location_id;
2602:
2603: CURSOR rg23c_part_ii_balance_cur IS
2604: SELECT NVL(rg23c_balance,0)
2605: FROM JAI_CMN_RG_BALANCES
2606: WHERE organization_id = p_org_id AND
2607: location_id = p_location_id;
2608:
2609: CURSOR serial_no_cur IS

Line 2991: UPDATE JAI_CMN_RG_BALANCES

2987: END IF;
2988:
2989: IF p_register_type = 'A' THEN
2990:
2991: UPDATE JAI_CMN_RG_BALANCES
2992: SET rg23a_balance = rg23a_balance - v_excise_amount
2993: WHERE organization_id = p_org_id AND
2994: location_id = p_location_id;
2995:

Line 2998: UPDATE JAI_CMN_RG_BALANCES

2994: location_id = p_location_id;
2995:
2996: ELSIF p_register_type = 'C' THEN
2997:
2998: UPDATE JAI_CMN_RG_BALANCES
2999: SET rg23c_balance = rg23c_balance - v_excise_amount
3000: WHERE organization_id = p_org_id AND
3001: location_id = p_location_id;
3002: END IF;

Line 3093: FROM JAI_CMN_RG_BALANCES

3089: --Changed by Nagaraj.s for Enh#2415656..........
3090: CURSOR pla_balance_cur IS
3091: SELECT NVL(pla_balance,0),NVL(basic_pla_balance,0),
3092: NVL(additional_pla_balance,0), NVL(other_pla_balance,0)
3093: FROM JAI_CMN_RG_BALANCES
3094: WHERE organization_id = p_org_id AND
3095: location_id = p_location_id;
3096:
3097: CURSOR range_division_cur IS

Line 3506: UPDATE JAI_CMN_RG_BALANCES

3502: fnd_file.put_line(fnd_file.log, '16 after insert into JAI_CMN_RG_PLA_TRXS');
3503:
3504: v_excise_amount := NVL(p_dr_basic_ed,0) + NVL(p_dr_additional_ed,0) + NVL(p_dr_other_ed,0);
3505:
3506: UPDATE JAI_CMN_RG_BALANCES
3507: SET pla_balance = pla_balance - v_excise_amount,
3508: basic_pla_balance = basic_pla_balance - p_dr_basic_ed,
3509: additional_pla_balance = NVL(additional_pla_balance,0) - NVL(p_dr_additional_ed,0),
3510: other_pla_balance = NVL(other_pla_balance,0) - NVL(p_dr_other_ed,0)

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

3509: additional_pla_balance = NVL(additional_pla_balance,0) - NVL(p_dr_additional_ed,0),
3510: other_pla_balance = NVL(other_pla_balance,0) - NVL(p_dr_other_ed,0)
3511: WHERE organization_id = p_org_id
3512: AND location_id = p_location_id;
3513: fnd_file.put_line(fnd_file.log, '17 after update into JAI_CMN_RG_BALANCES');
3514: ELSE
3515: fnd_file.put_line(fnd_file.log, '18 before insert into update into JAI_CMN_RG_PLA_TRXS , slno ' || v_serial_no
3516: ||' , register_id ->' || ln_register_id
3517: ||' , organization_id ->' || p_org_id

Line 3611: UPDATE JAI_CMN_RG_BALANCES

3607: fnd_file.put_line(fnd_file.log, '19 after insert into JAI_CMN_RG_PLA_TRXS');
3608:
3609: v_excise_amount := NVL(p_dr_basic_ed,0) + NVL(p_dr_additional_ed,0) + NVL(p_dr_other_ed,0);
3610:
3611: UPDATE JAI_CMN_RG_BALANCES
3612: SET pla_balance = pla_balance - v_excise_amount
3613: WHERE organization_id = p_org_id
3614: AND location_id = p_location_id;
3615:

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

3612: SET pla_balance = pla_balance - v_excise_amount
3613: WHERE organization_id = p_org_id
3614: AND location_id = p_location_id;
3615:
3616: fnd_file.put_line(fnd_file.log, '20 after update of JAI_CMN_RG_BALANCES');
3617:
3618: END IF;
3619:
3620: