APPS.JAI_OM_RG_PKG dependencies on JAI_CMN_RG_23D_TRXS

Line 3437: FROM JAI_CMN_RG_23D_TRXS

3433: ln_sh_cess_debit_account_id number;/*Bug 5989740 bduvarag*/
3434:
3435: CURSOR balance_cur(p_previous_serial_no IN NUMBER) IS
3436: SELECT NVL(ROUND(opening_balance_qty,0),0),NVL(ROUND(closing_balance_qty,0),0)
3437: FROM JAI_CMN_RG_23D_TRXS
3438: WHERE organization_id = p_org_id AND
3439: location_id = p_location_id AND
3440: slno = p_previous_serial_no AND
3441: fin_year = p_fin_year

Line 3446: FROM JAI_CMN_RG_23D_TRXS

3442: AND inventory_item_id = p_inventory_item_id;
3443:
3444: CURSOR serial_no_cur IS
3445: SELECT NVL(MAX(slno),0) , NVL(MAX(slno),0) + 1
3446: FROM JAI_CMN_RG_23D_TRXS
3447: WHERE organization_id = p_org_id AND
3448: location_id = p_location_id AND
3449: fin_year = p_fin_year
3450: AND inventory_item_id = p_inventory_item_id;

Line 3457: FROM JAI_CMN_RG_23D_TRXS

3453: v_max_register_id NUMBER;
3454: CURSOR c_max_register_id( p_orgn_id IN NUMBER, p_loc_id IN NUMBER,
3455: p_inv_item_id IN NUMBER) IS
3456: SELECT max(register_id)
3457: FROM JAI_CMN_RG_23D_TRXS
3458: WHERE organization_id = p_orgn_id
3459: AND location_id = p_loc_id
3460: AND inventory_item_id = p_inv_item_id;
3461:

Line 3464: FROM JAI_CMN_RG_23D_TRXS

3460: AND inventory_item_id = p_inv_item_id;
3461:
3462: CURSOR c_rg23d_rec( p_register_id IN NUMBER) IS
3463: SELECT fin_year, slno, opening_balance_qty, closing_balance_qty
3464: FROM JAI_CMN_RG_23D_TRXS
3465: WHERE register_id = p_register_id;
3466: v_rg23d_rec c_rg23d_rec%ROWTYPE;
3467: -- End, Vijay Shankar for Bug# 3657742
3468: /*

Line 3636: INSERT INTO JAI_CMN_RG_23D_TRXS (

3632: FETCH balance_cur INTO v_opening_balance, v_closing_balance;
3633: CLOSE balance_cur;
3634: */
3635:
3636: INSERT INTO JAI_CMN_RG_23D_TRXS (
3637: register_id, organization_id, location_id, slno, fin_year,
3638: transaction_type, inventory_item_id, reference_line_id, primary_uom_code,
3639: transaction_uom_code, customer_id, bill_to_site_id, ship_to_site_id,
3640: quantity_issued, register_code, charge_account_id, rate_per_unit, excise_duty_rate,duty_amount, TRANSACTION_SOURCE_NUM,

Line 3742: update JAI_CMN_RG_23D_TRXS

3738: P_REFERENCE_24 => P_REF_24 ,
3739: P_REFERENCE_25 => P_REF_25 ,
3740: P_REFERENCE_26 => P_REF_26
3741: );
3742: update JAI_CMN_RG_23D_TRXS
3743: set other_tax_debit = ln_cess_amount + ln_sh_cess_amount/*Bug 5989740 bduvarag*/
3744: where register_id = p_register_id;
3745:
3746: