[Home] [Help]
127: WHERE organization_id = p_org_id AND
128: location_id = p_loc_id;
129: Cursor register_code_cur(p_org_id IN Number, p_loc_id IN Number, p_batch_source_id IN NUMBER) IS
130: SELECT register_code
131: FROM JAI_OM_OE_BOND_REG_HDRS
132: WHERE organization_id = p_org_id AND
133: location_id = p_loc_id AND
134: register_id in (SELECT register_id FROM JAI_OM_OE_BOND_REG_DTLS
135: WHERE order_type_id = p_batch_source_id and order_flag ='N');
323:
324: For Multiple Bond Register Enhancement,
325: Instead of using the cursors for fetching the register associated with the invoice type , a call has been made to the procedures
326: of the jai_cmn_bond_register_pkg package. There enhancement has created dependency because of the
327: introduction of 3 new columns in the JAI_OM_OE_BOND_REG_HDRS table and also call to the new package jai_cmn_bond_register_pkg.
328:
329: New Validations for checking the bond expiry date and to check the balance based on the call to the jai_cmn_bond_register_pkg has been added
330:
331: Provision for letter of undertaking has been incorporated. In the case of the letter of undetaking , its also a type of bond register
329: New Validations for checking the bond expiry date and to check the balance based on the call to the jai_cmn_bond_register_pkg has been added
330:
331: Provision for letter of undertaking has been incorporated. In the case of the letter of undetaking , its also a type of bond register
332: but without validation for the balances.
333: This has been done by checking if the LOU_FLAG is 'Y' in the JAI_OM_OE_BOND_REG_HDRS table for the
334: associated register id , if yes , then validation is only based on bond expiry date .
335:
336: This bug has introduced huge dependency. All future bugs on this object should have this bug as a prereq
337: