[Home] [Help]
1856:
1857: For Multiple Bond Register Enhancement,
1858:
1859: Instead of using the cursors for fetching the register associated with the order / invoice type , a call has been made to the procedures
1860: of the jai_cmn_bond_register_pkg package. There enhancement has created dependency because of the
1861: 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.
1862:
1863: 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
1864:
1857: For Multiple Bond Register Enhancement,
1858:
1859: Instead of using the cursors for fetching the register associated with the order / invoice type , a call has been made to the procedures
1860: of the jai_cmn_bond_register_pkg package. There enhancement has created dependency because of the
1861: 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.
1862:
1863: 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
1864:
1865: Provision for letter of undertaking has been incorporated. In the case of the letter of undetaking , its also a type of bond register
1859: Instead of using the cursors for fetching the register associated with the order / invoice type , a call has been made to the procedures
1860: of the jai_cmn_bond_register_pkg package. There enhancement has created dependency because of the
1861: 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.
1862:
1863: 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
1864:
1865: Provision for letter of undertaking has been incorporated. In the case of the letter of undetaking , its also a type of bond register
1866: but without validation for the balances.
1867: This has been done by checking if the LOU_FLAG is 'Y' in the JAI_OM_OE_BOND_REG_HDRS table for the
2967: FETCH c_order_type_id INTO v_order_type_id;
2968: CLOSE c_order_type_id;
2969:
2970: --sriram - bug # 3021588 and using the following procedure call instead.
2971: Fnd_File.PUT_LINE(Fnd_File.LOG, '2 before call to jai_cmn_bond_register_pkg.get_register_id ');
2972:
2973: jai_cmn_bond_register_pkg.get_register_id (p_org_id ,
2974: p_location_id,
2975: v_order_type_id, -- order type id
2969:
2970: --sriram - bug # 3021588 and using the following procedure call instead.
2971: Fnd_File.PUT_LINE(Fnd_File.LOG, '2 before call to jai_cmn_bond_register_pkg.get_register_id ');
2972:
2973: jai_cmn_bond_register_pkg.get_register_id (p_org_id ,
2974: p_location_id,
2975: v_order_type_id, -- order type id
2976: 'Y', -- order invoice type
2977: v_asst_register_id, -- out parameter to get the register id
2976: 'Y', -- order invoice type
2977: v_asst_register_id, -- out parameter to get the register id
2978: v_register_code);
2979:
2980: Fnd_File.PUT_LINE(Fnd_File.LOG, '3 after call from jai_cmn_bond_register_pkg.get_register_id ');
2981: IF NVL(v_previous_serial_no,0) = 0 THEN
2982: v_previous_serial_no := 0;
2983: v_serial_no := 1;
2984: END IF;
4239: end if;
4240: /*Bug 5989740 bduvarag end*/
4241: end if;
4242:
4243: jai_cmn_bond_register_pkg.GET_REGISTER_ID (p_org_id ,
4244: p_location_id,
4245: v_order_type_id, -- order type id
4246: p_order_flag, -- order invoice type
4247: v_asst_register_id, -- out parameter to get the register id
4249:
4250: /*
4251: call to get the register balance and expiry details
4252: */
4253: jai_cmn_bond_register_pkg.GET_REGISTER_DETAILS(v_asst_register_id,
4254: v_register_balance,
4255: v_reg_expiry_date,
4256: v_lou_flag);
4257: