DBA Data[Home] [Help]

APPS.JAI_OM_WSH_PKG dependencies on JAI_CMN_BOND_REGISTER_PKG

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

749: 30. 2003/08/22 SSUMAITH Bug # 3021588 File Version 616.4 (Bond Register Enhancement)
750:
751: For Multiple Bond Register Enhancement,
752: Instead of using the cursors for fetching the register associated with the order type , a call has been made to the procedures
753: of the jai_cmn_bond_register_pkg package. There enhancement has created dependency because of the
754: 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.
755:
756: 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
757:

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

750:
751: For Multiple Bond Register Enhancement,
752: Instead of using the cursors for fetching the register associated with the order type , a call has been made to the procedures
753: of the jai_cmn_bond_register_pkg package. There enhancement has created dependency because of the
754: 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.
755:
756: 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
757:
758: Provision for letter of undertaking has been incorporated. In the case of the letter of undetaking , its also a type of bond register

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

752: Instead of using the cursors for fetching the register associated with the order type , a call has been made to the procedures
753: of the jai_cmn_bond_register_pkg package. There enhancement has created dependency because of the
754: 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.
755:
756: 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
757:
758: Provision for letter of undertaking has been incorporated. In the case of the letter of undetaking , its also a type of bond register
759: but without validation for the balances.
760: This has been done by checking if the LOU_FLAG is 'Y' in the JAI_OM_OE_BOND_REG_HDRS table for the

Line 1373: Calling the package jai_cmn_bond_register_pkg.GET_REGISTER_ID

1369:
1370:
1371: /*
1372: Code modified by sriram - bug # 3021588 - Multiple Bond Registers.
1373: Calling the package jai_cmn_bond_register_pkg.GET_REGISTER_ID
1374: */
1375:
1376:
1377: jai_cmn_bond_register_pkg.get_register_id ( v_organization_id ,

Line 1377: jai_cmn_bond_register_pkg.get_register_id ( v_organization_id ,

1373: Calling the package jai_cmn_bond_register_pkg.GET_REGISTER_ID
1374: */
1375:
1376:
1377: jai_cmn_bond_register_pkg.get_register_id ( v_organization_id ,
1378: v_location_id ,
1379: v_order_type_id , -- order type id
1380: 'Y' , -- order invoice type
1381: v_asst_register_id , -- out parameter to get the register id

Line 1550: Calling the package jai_cmn_bond_register_pkg.GET_REGISTER_ID

1546: lv_statement_no := '16';
1547:
1548: /*
1549: Code modified by sriram - bug # 3021588.
1550: Calling the package jai_cmn_bond_register_pkg.GET_REGISTER_ID
1551: */
1552:
1553: jai_cmn_bond_register_pkg.GET_REGISTER_ID ( v_organization_id ,
1554: v_location_id ,

Line 1553: jai_cmn_bond_register_pkg.GET_REGISTER_ID ( v_organization_id ,

1549: Code modified by sriram - bug # 3021588.
1550: Calling the package jai_cmn_bond_register_pkg.GET_REGISTER_ID
1551: */
1552:
1553: jai_cmn_bond_register_pkg.GET_REGISTER_ID ( v_organization_id ,
1554: v_location_id ,
1555: v_order_type_id , -- order type id
1556: 'Y' , -- order invoice type
1557: v_asst_register_id , -- out parameter to get the register id

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

1661: v_bond_tax_amount := NVL(v_tot_excise_amt,0) + NVL(v_bond_tax_amount,0);
1662: lv_statement_no := '20';
1663:
1664: -- Following code modified by sriram.
1665: -- call to the jai_cmn_bond_register_pkg is being done which
1666: -- fetches the balances.
1667: -- bug # 3021588
1668: jai_cmn_bond_register_pkg.get_register_details
1669: (v_asst_register_id,

Line 1668: jai_cmn_bond_register_pkg.get_register_details

1664: -- Following code modified by sriram.
1665: -- call to the jai_cmn_bond_register_pkg is being done which
1666: -- fetches the balances.
1667: -- bug # 3021588
1668: jai_cmn_bond_register_pkg.get_register_details
1669: (v_asst_register_id,
1670: v_register_balance,
1671: v_register_exp_date,
1672: v_lou_flag