[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');
297:
298: For Multiple Bond Register Enhancement,
299: Instead of using the cursors for fetching the register associated with the invoice type , a call has been made to the procedures
300: of the jai_cmn_bond_register_pkg package. There enhancement has created dependency because of the
301: 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.
302:
303: 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
304:
305: Provision for letter of undertaking has been incorporated. In the case of the letter of undetaking , its also a type of bond register
303: 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
304:
305: Provision for letter of undertaking has been incorporated. In the case of the letter of undetaking , its also a type of bond register
306: but without validation for the balances.
307: This has been done by checking if the LOU_FLAG is 'Y' in the JAI_OM_OE_BOND_REG_HDRS table for the
308: associated register id , if yes , then validation is only based on bond expiry date .
309:
310: This bug has introduced huge dependency. All future bugs on this object should have this bug as a prereq
311: