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 4327: FROM JAI_OM_OE_BOND_TRXS

4323: v_rg23d_transaction_amount NUMBER := 0;
4324: v_reg_transaction_amount NUMBER := 0;
4325: CURSOR register_balance_cur IS
4326: SELECT register_balance
4327: FROM JAI_OM_OE_BOND_TRXS
4328: WHERE transaction_id = (SELECT MAX(transaction_id) FROM JAI_OM_OE_BOND_TRXS
4329: WHERE register_id = (SELECT register_id FROM JAI_OM_OE_BOND_REG_HDRS
4330: WHERE organization_id = p_org_id AND location_id = p_location_id
4331: AND register_code = p_register_code));

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

4324: v_reg_transaction_amount NUMBER := 0;
4325: CURSOR register_balance_cur IS
4326: SELECT register_balance
4327: FROM JAI_OM_OE_BOND_TRXS
4328: WHERE transaction_id = (SELECT MAX(transaction_id) FROM JAI_OM_OE_BOND_TRXS
4329: WHERE register_id = (SELECT register_id FROM JAI_OM_OE_BOND_REG_HDRS
4330: WHERE organization_id = p_org_id AND location_id = p_location_id
4331: AND register_code = p_register_code));
4332: CURSOR register_balance_cur1 IS

Line 4334: FROM JAI_OM_OE_BOND_TRXS

4330: WHERE organization_id = p_org_id AND location_id = p_location_id
4331: AND register_code = p_register_code));
4332: CURSOR register_balance_cur1 IS
4333: SELECT rg23d_register_balance
4334: FROM JAI_OM_OE_BOND_TRXS
4335: WHERE transaction_id = (SELECT MAX(transaction_id) FROM JAI_OM_OE_BOND_TRXS
4336: WHERE register_id = (SELECT register_id FROM JAI_OM_OE_BOND_REG_HDRS
4337: WHERE organization_id = p_org_id AND location_id = p_location_id
4338: AND register_code = p_register_code));

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

4331: AND register_code = p_register_code));
4332: CURSOR register_balance_cur1 IS
4333: SELECT rg23d_register_balance
4334: FROM JAI_OM_OE_BOND_TRXS
4335: WHERE transaction_id = (SELECT MAX(transaction_id) FROM JAI_OM_OE_BOND_TRXS
4336: WHERE register_id = (SELECT register_id FROM JAI_OM_OE_BOND_REG_HDRS
4337: WHERE organization_id = p_org_id AND location_id = p_location_id
4338: AND register_code = p_register_code));
4339: CURSOR register_id_cur IS

Line 4717: INSERT INTO JAI_OM_OE_BOND_TRXS(transaction_id,

4713:
4714: --IF v_charge_amount >= p_transaction_amount THEN
4715: if ((nvl(v_lou_flag,'N') = 'Y') or ( v_register_balance >= p_transaction_amount) ) then
4716: if NVL(v_reg_expiry_date,sysdate) >= p_creation_date then
4717: INSERT INTO JAI_OM_OE_BOND_TRXS(transaction_id,
4718: register_id ,
4719: transaction_name,
4720: order_flag,
4721: order_header_id,

Line 4736: JAI_OM_OE_BOND_TRXS_S.NEXTVAL,

4732: last_update_date,
4733: last_updated_by
4734: )
4735: VALUES (
4736: JAI_OM_OE_BOND_TRXS_S.NEXTVAL,
4737: v_register_id,
4738: p_transaction_name,
4739: p_order_flag,
4740: ln_header_id ,