APPS.JAI_OM_RG_PKG dependencies on JAI_OM_OE_BOND_TRXS

Line 144: the excise invoice number was being inserted into the picking_header_id field in the JAI_OM_OE_BOND_TRXS table.

140:
141: Issue :
142:
143: When the excise invoice number is having characters in it,the bond register transaction is failing as
144: the excise invoice number was being inserted into the picking_header_id field in the JAI_OM_OE_BOND_TRXS table.
145: the picking header id field was of type number and hence a character insert is causing an invalid number error.
146:
147: Fix :
148:

Line 150: a) in the jai_om_rg_pkg, when the insert into the JAI_OM_OE_BOND_TRXS table happens through the ja_in_register_txn_entry procedure , insert of excise invoice number into picking header id has been removed.

146:
147: Fix :
148:
149: Made the following changes
150: a) in the jai_om_rg_pkg, when the insert into the JAI_OM_OE_BOND_TRXS table happens through the ja_in_register_txn_entry procedure , insert of excise invoice number into picking header id has been removed.
151: Instead the picking_line_id is stamped with the delivery_id / customer_trx_line_id in case of OM / AR respectively.
152:
153: 34. 14-May-2008 Changes by nprashar for bug # 6710747.
154: Issue:INTER-ORGANIZATION TRANSFER WITH EXCISE TAXES FAILS

Line 3935: FROM JAI_OM_OE_BOND_TRXS

3931: v_rg23d_transaction_amount NUMBER := 0;
3932: v_reg_transaction_amount NUMBER := 0;
3933: CURSOR register_balance_cur IS
3934: SELECT register_balance
3935: FROM JAI_OM_OE_BOND_TRXS
3936: WHERE transaction_id = (SELECT MAX(transaction_id) FROM JAI_OM_OE_BOND_TRXS
3937: WHERE register_id = (SELECT register_id FROM JAI_OM_OE_BOND_REG_HDRS
3938: WHERE organization_id = p_org_id AND location_id = p_location_id
3939: AND register_code = p_register_code));

Line 3936: WHERE transaction_id = (SELECT MAX(transaction_id) FROM JAI_OM_OE_BOND_TRXS

3932: v_reg_transaction_amount NUMBER := 0;
3933: CURSOR register_balance_cur IS
3934: SELECT register_balance
3935: FROM JAI_OM_OE_BOND_TRXS
3936: WHERE transaction_id = (SELECT MAX(transaction_id) FROM JAI_OM_OE_BOND_TRXS
3937: WHERE register_id = (SELECT register_id FROM JAI_OM_OE_BOND_REG_HDRS
3938: WHERE organization_id = p_org_id AND location_id = p_location_id
3939: AND register_code = p_register_code));
3940: CURSOR register_balance_cur1 IS

Line 3942: FROM JAI_OM_OE_BOND_TRXS

3938: WHERE organization_id = p_org_id AND location_id = p_location_id
3939: AND register_code = p_register_code));
3940: CURSOR register_balance_cur1 IS
3941: SELECT rg23d_register_balance
3942: FROM JAI_OM_OE_BOND_TRXS
3943: WHERE transaction_id = (SELECT MAX(transaction_id) FROM JAI_OM_OE_BOND_TRXS
3944: WHERE register_id = (SELECT register_id FROM JAI_OM_OE_BOND_REG_HDRS
3945: WHERE organization_id = p_org_id AND location_id = p_location_id
3946: AND register_code = p_register_code));

Line 3943: WHERE transaction_id = (SELECT MAX(transaction_id) FROM JAI_OM_OE_BOND_TRXS

3939: AND register_code = p_register_code));
3940: CURSOR register_balance_cur1 IS
3941: SELECT rg23d_register_balance
3942: FROM JAI_OM_OE_BOND_TRXS
3943: WHERE transaction_id = (SELECT MAX(transaction_id) FROM JAI_OM_OE_BOND_TRXS
3944: WHERE register_id = (SELECT register_id FROM JAI_OM_OE_BOND_REG_HDRS
3945: WHERE organization_id = p_org_id AND location_id = p_location_id
3946: AND register_code = p_register_code));
3947: CURSOR register_id_cur IS

Line 4281: INSERT INTO JAI_OM_OE_BOND_TRXS(transaction_id,

4277:
4278: --IF v_charge_amount >= p_transaction_amount THEN
4279: if ((nvl(v_lou_flag,'N') = 'Y') or ( v_register_balance >= p_transaction_amount) ) then
4280: if NVL(v_reg_expiry_date,sysdate) >= p_creation_date then
4281: INSERT INTO JAI_OM_OE_BOND_TRXS(transaction_id,
4282: register_id ,
4283: transaction_name,
4284: order_flag,
4285: order_header_id,

Line 4300: JAI_OM_OE_BOND_TRXS_S.NEXTVAL,

4296: last_update_date,
4297: last_updated_by
4298: )
4299: VALUES (
4300: JAI_OM_OE_BOND_TRXS_S.NEXTVAL,
4301: v_register_id,
4302: p_transaction_name,
4303: p_order_flag,
4304: ln_header_id ,