APPS.JAI_OM_RG_PKG dependencies on JAI_CMN_RG_23D_TRXS

Line 3735: FROM JAI_CMN_RG_23D_TRXS

3731: ln_sh_cess_debit_account_id number;/*Bug 5989740 bduvarag*/
3732:
3733: CURSOR balance_cur(p_previous_serial_no IN NUMBER) IS
3734: SELECT NVL(ROUND(opening_balance_qty,0),0),NVL(ROUND(closing_balance_qty,0),0)
3735: FROM JAI_CMN_RG_23D_TRXS
3736: WHERE organization_id = p_org_id AND
3737: location_id = p_location_id AND
3738: slno = p_previous_serial_no AND
3739: fin_year = p_fin_year

Line 3744: FROM JAI_CMN_RG_23D_TRXS

3740: AND inventory_item_id = p_inventory_item_id;
3741:
3742: CURSOR serial_no_cur IS
3743: SELECT NVL(MAX(slno),0) , NVL(MAX(slno),0) + 1
3744: FROM JAI_CMN_RG_23D_TRXS
3745: WHERE organization_id = p_org_id AND
3746: location_id = p_location_id AND
3747: fin_year = p_fin_year
3748: AND inventory_item_id = p_inventory_item_id;

Line 3755: FROM JAI_CMN_RG_23D_TRXS

3751: v_max_register_id NUMBER;
3752: CURSOR c_max_register_id( p_orgn_id IN NUMBER, p_loc_id IN NUMBER,
3753: p_inv_item_id IN NUMBER) IS
3754: SELECT max(register_id)
3755: FROM JAI_CMN_RG_23D_TRXS
3756: WHERE organization_id = p_orgn_id
3757: AND location_id = p_loc_id
3758: AND inventory_item_id = p_inv_item_id;
3759:

Line 3762: FROM JAI_CMN_RG_23D_TRXS

3758: AND inventory_item_id = p_inv_item_id;
3759:
3760: CURSOR c_rg23d_rec( p_register_id IN NUMBER) IS
3761: SELECT fin_year, slno, opening_balance_qty, closing_balance_qty
3762: FROM JAI_CMN_RG_23D_TRXS
3763: WHERE register_id = p_register_id;
3764: v_rg23d_rec c_rg23d_rec%ROWTYPE;
3765: -- End, Vijay Shankar for Bug# 3657742
3766: /*

Line 3942: INSERT INTO JAI_CMN_RG_23D_TRXS (

3938: FETCH balance_cur INTO v_opening_balance, v_closing_balance;
3939: CLOSE balance_cur;
3940: */
3941:
3942: INSERT INTO JAI_CMN_RG_23D_TRXS (
3943: register_id, organization_id, location_id, slno, fin_year,
3944: transaction_type, inventory_item_id, reference_line_id, primary_uom_code,
3945: transaction_uom_code, customer_id, bill_to_site_id, ship_to_site_id,
3946: quantity_issued, register_code, charge_account_id, rate_per_unit, excise_duty_rate,duty_amount, TRANSACTION_SOURCE_NUM,

Line 4049: update JAI_CMN_RG_23D_TRXS

4045: P_REFERENCE_24 => P_REF_24 ,
4046: P_REFERENCE_25 => P_REF_25 ,
4047: P_REFERENCE_26 => P_REF_26
4048: );
4049: update JAI_CMN_RG_23D_TRXS
4050: set other_tax_debit = ln_cess_amount + ln_sh_cess_amount/*Bug 5989740 bduvarag*/
4051: where register_id = p_register_id;
4052:
4053: