APPS.JAI_MTL_TRXS_PKG dependencies on JAI_CMN_RG_23AC_I_TRXS

Line 513: stmt_name := 'Calling jai_cmn_rg_23ac_i_trxs_pkg.insert_row';

509: );
510: processed_flag :='RG1';
511: ELSIF main_rec.excise_flag = 'Y' AND main_rec.bonded = 'Y' AND
512: main_rec.item_class IN ('RMIN', 'RMEX', 'CGIN', 'CGEX') THEN
513: stmt_name := 'Calling jai_cmn_rg_23ac_i_trxs_pkg.insert_row';
514: jai_cmn_rg_23ac_i_trxs_pkg.insert_row(
515: P_REGISTER_ID => l_register_id,
516: P_INVENTORY_ITEM_ID => main_rec.inventory_item_id,
517: P_ORGANIZATION_ID => main_rec.to_organization,

Line 514: jai_cmn_rg_23ac_i_trxs_pkg.insert_row(

510: processed_flag :='RG1';
511: ELSIF main_rec.excise_flag = 'Y' AND main_rec.bonded = 'Y' AND
512: main_rec.item_class IN ('RMIN', 'RMEX', 'CGIN', 'CGEX') THEN
513: stmt_name := 'Calling jai_cmn_rg_23ac_i_trxs_pkg.insert_row';
514: jai_cmn_rg_23ac_i_trxs_pkg.insert_row(
515: P_REGISTER_ID => l_register_id,
516: P_INVENTORY_ITEM_ID => main_rec.inventory_item_id,
517: P_ORGANIZATION_ID => main_rec.to_organization,
518: P_QUANTITY_RECEIVED => main_rec.quantity,

Line 740: UPDATE JAI_CMN_RG_23AC_I_TRXS SET register_id_part_ii = l_register_id_ii WHERE register_id = l_register_id;

736: UPDATE JAI_CMN_RG_I_TRXS
737: SET register_id_part_ii = l_register_id_ii,cess_amt = ln_Cess_amount
738: WHERE register_id = l_register_id;
739: ELSE
740: UPDATE JAI_CMN_RG_23AC_I_TRXS SET register_id_part_ii = l_register_id_ii WHERE register_id = l_register_id;
741: END IF;
742: IF SQL%NOTFOUND THEN
743: stmt_name := 'UPDATE register_id = '||l_register_id||': processed_flag = '||processed_flag;
744: RAISE no_data_found;

Line 749: SELECT JAI_CMN_RG_23AC_I_TRXSI_S.CURRVAL INTO v_register_id FROM dual;

745: END IF;
746: IF nvl(ln_cess_amount,0)<>0 THEN
747: /*
748: BEGIN
749: SELECT JAI_CMN_RG_23AC_I_TRXSI_S.CURRVAL INTO v_register_id FROM dual;
750: EXCEPTION when others THEN
751: SELECT JAI_CMN_RG_23AC_I_TRXSI_S.CURRVAL INTO v_register_id FROM dual;
752: END;
753: *//*commented the above by vkaranam for bug #5907436*/

Line 751: SELECT JAI_CMN_RG_23AC_I_TRXSI_S.CURRVAL INTO v_register_id FROM dual;

747: /*
748: BEGIN
749: SELECT JAI_CMN_RG_23AC_I_TRXSI_S.CURRVAL INTO v_register_id FROM dual;
750: EXCEPTION when others THEN
751: SELECT JAI_CMN_RG_23AC_I_TRXSI_S.CURRVAL INTO v_register_id FROM dual;
752: END;
753: *//*commented the above by vkaranam for bug #5907436*/
754: BEGIN
755: stmt_name := 'Calling jai_cmn_rg_others_pkg.insert_row';