DBA Data[Home] [Help]

APPS.JAI_OM_WSH_PKG dependencies on JAI_CMN_BOND_REGISTER_PKG

Line 725: of the jai_cmn_bond_register_pkg package. There enhancement has created dependency because of the

721: 30. 2003/08/22 SSUMAITH Bug # 3021588 File Version 616.4 (Bond Register Enhancement)
722:
723: For Multiple Bond Register Enhancement,
724: Instead of using the cursors for fetching the register associated with the order type , a call has been made to the procedures
725: of the jai_cmn_bond_register_pkg package. There enhancement has created dependency because of the
726: 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.
727:
728: 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
729:

Line 726: 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.

722:
723: For Multiple Bond Register Enhancement,
724: Instead of using the cursors for fetching the register associated with the order type , a call has been made to the procedures
725: of the jai_cmn_bond_register_pkg package. There enhancement has created dependency because of the
726: 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.
727:
728: 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
729:
730: Provision for letter of undertaking has been incorporated. In the case of the letter of undetaking , its also a type of bond register

Line 728: 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

724: Instead of using the cursors for fetching the register associated with the order type , a call has been made to the procedures
725: of the jai_cmn_bond_register_pkg package. There enhancement has created dependency because of the
726: 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.
727:
728: 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
729:
730: Provision for letter of undertaking has been incorporated. In the case of the letter of undetaking , its also a type of bond register
731: but without validation for the balances.
732: This has been done by checking if the LOU_FLAG is 'Y' in the JAI_OM_OE_BOND_REG_HDRS table for the

Line 1284: Calling the package jai_cmn_bond_register_pkg.GET_REGISTER_ID

1280: lv_statement_no := '9';
1281:
1282: /*
1283: Code modified by sriram - bug # 3021588 - Multiple Bond Registers.
1284: Calling the package jai_cmn_bond_register_pkg.GET_REGISTER_ID
1285: */
1286:
1287:
1288: jai_cmn_bond_register_pkg.get_register_id ( v_organization_id ,

Line 1288: jai_cmn_bond_register_pkg.get_register_id ( v_organization_id ,

1284: Calling the package jai_cmn_bond_register_pkg.GET_REGISTER_ID
1285: */
1286:
1287:
1288: jai_cmn_bond_register_pkg.get_register_id ( v_organization_id ,
1289: v_location_id ,
1290: v_order_type_id , -- order type id
1291: 'Y' , -- order invoice type
1292: v_asst_register_id , -- out parameter to get the register id

Line 1461: Calling the package jai_cmn_bond_register_pkg.GET_REGISTER_ID

1457: lv_statement_no := '16';
1458:
1459: /*
1460: Code modified by sriram - bug # 3021588.
1461: Calling the package jai_cmn_bond_register_pkg.GET_REGISTER_ID
1462: */
1463:
1464: jai_cmn_bond_register_pkg.GET_REGISTER_ID ( v_organization_id ,
1465: v_location_id ,

Line 1464: jai_cmn_bond_register_pkg.GET_REGISTER_ID ( v_organization_id ,

1460: Code modified by sriram - bug # 3021588.
1461: Calling the package jai_cmn_bond_register_pkg.GET_REGISTER_ID
1462: */
1463:
1464: jai_cmn_bond_register_pkg.GET_REGISTER_ID ( v_organization_id ,
1465: v_location_id ,
1466: v_order_type_id , -- order type id
1467: 'Y' , -- order invoice type
1468: v_asst_register_id , -- out parameter to get the register id

Line 1576: -- call to the jai_cmn_bond_register_pkg is being done which

1572: v_bond_tax_amount := NVL(v_tot_excise_amt,0) + NVL(v_bond_tax_amount,0);
1573: lv_statement_no := '20';
1574:
1575: -- Following code modified by sriram.
1576: -- call to the jai_cmn_bond_register_pkg is being done which
1577: -- fetches the balances.
1578: -- bug # 3021588
1579: jai_cmn_bond_register_pkg.get_register_details
1580: (v_asst_register_id,

Line 1579: jai_cmn_bond_register_pkg.get_register_details

1575: -- Following code modified by sriram.
1576: -- call to the jai_cmn_bond_register_pkg is being done which
1577: -- fetches the balances.
1578: -- bug # 3021588
1579: jai_cmn_bond_register_pkg.get_register_details
1580: (v_asst_register_id,
1581: v_register_balance,
1582: v_register_exp_date,
1583: v_lou_flag