APPS.JAI_MTL_TRXS_PKG dependencies on JAI_CMN_RG_23AC_I_TRXS

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

632: );
633: processed_flag :='RG1';
634: ELSIF main_rec.excise_flag = 'Y' AND main_rec.bonded = 'Y' AND
635: main_rec.item_class IN ('RMIN', 'RMEX', 'CGIN', 'CGEX') THEN
636: stmt_name := 'Calling jai_cmn_rg_23ac_i_trxs_pkg.insert_row';
637: jai_cmn_rg_23ac_i_trxs_pkg.insert_row(
638: P_REGISTER_ID => l_register_id,
639: P_INVENTORY_ITEM_ID => main_rec.inventory_item_id,
640: P_ORGANIZATION_ID => main_rec.to_organization,

Line 637: jai_cmn_rg_23ac_i_trxs_pkg.insert_row(

633: processed_flag :='RG1';
634: ELSIF main_rec.excise_flag = 'Y' AND main_rec.bonded = 'Y' AND
635: main_rec.item_class IN ('RMIN', 'RMEX', 'CGIN', 'CGEX') THEN
636: stmt_name := 'Calling jai_cmn_rg_23ac_i_trxs_pkg.insert_row';
637: jai_cmn_rg_23ac_i_trxs_pkg.insert_row(
638: P_REGISTER_ID => l_register_id,
639: P_INVENTORY_ITEM_ID => main_rec.inventory_item_id,
640: P_ORGANIZATION_ID => main_rec.to_organization,
641: P_QUANTITY_RECEIVED => main_rec.quantity,

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

859: UPDATE JAI_CMN_RG_I_TRXS
860: SET register_id_part_ii = l_register_id_ii,cess_amt = ln_Cess_amount
861: WHERE register_id = l_register_id;
862: ELSE
863: UPDATE JAI_CMN_RG_23AC_I_TRXS SET register_id_part_ii = l_register_id_ii WHERE register_id = l_register_id;
864: END IF;
865: IF SQL%NOTFOUND THEN
866: stmt_name := 'UPDATE register_id = '||l_register_id||': processed_flag = '||processed_flag;
867: RAISE no_data_found;

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

868: END IF;
869: IF nvl(ln_cess_amount,0)<>0 THEN
870: /*
871: BEGIN
872: SELECT JAI_CMN_RG_23AC_I_TRXSI_S.CURRVAL INTO v_register_id FROM dual;
873: EXCEPTION when others THEN
874: SELECT JAI_CMN_RG_23AC_I_TRXSI_S.CURRVAL INTO v_register_id FROM dual;
875: END;
876: *//*commented the above by vkaranam for bug #5907436*/

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

870: /*
871: BEGIN
872: SELECT JAI_CMN_RG_23AC_I_TRXSI_S.CURRVAL INTO v_register_id FROM dual;
873: EXCEPTION when others THEN
874: SELECT JAI_CMN_RG_23AC_I_TRXSI_S.CURRVAL INTO v_register_id FROM dual;
875: END;
876: *//*commented the above by vkaranam for bug #5907436*/
877: BEGIN
878: stmt_name := 'Calling jai_cmn_rg_others_pkg.insert_row';