eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_OM_WDD_TRIGGER_PKG dependencies on JAI_CMN_BOND_REGISTER_PKG

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

1730: 15. 22/08/2003 Bug # 3021588 (Bond Register Enhancement) Version 616.2
1731:
1732: For Multiple Bond Register Enhancement,
1733: Instead of using the cursors for fetching the register associated with the order type , a call has been made to the procedures
1734: of the jai_cmn_bond_register_pkg package. There enhancement has created dependency because of the
1735: 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.
1736:
1737: 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
1738:

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

1731:
1732: For Multiple Bond Register Enhancement,
1733: Instead of using the cursors for fetching the register associated with the order type , a call has been made to the procedures
1734: of the jai_cmn_bond_register_pkg package. There enhancement has created dependency because of the
1735: 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.
1736:
1737: 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
1738:
1739: Provision for letter of undertaking has been incorporated. Letter of undetaking is also a type of bond register but without validation for the balances.

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

1733: Instead of using the cursors for fetching the register associated with the order type , a call has been made to the procedures
1734: of the jai_cmn_bond_register_pkg package. There enhancement has created dependency because of the
1735: 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.
1736:
1737: 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
1738:
1739: Provision for letter of undertaking has been incorporated. Letter of undetaking is also a type of bond register but without validation for the balances.
1740: This has been done by checking if the LOU_FLAG is 'Y' in the JAI_OM_OE_BOND_REG_HDRS table for the
1741: associated register id , if yes , then validation is only based on bond expiry date .

Line 2924: jai_cmn_bond_register_pkg.GET_REGISTER_ID(v_organization_id,

2920: END IF;
2921:
2922: -- added by sriram - bug # 3021588
2923:
2924: jai_cmn_bond_register_pkg.GET_REGISTER_ID(v_organization_id,
2925: v_location_id,
2926: v_order_type_id,
2927: 'Y',
2928: v_asst_register_id,

Line 2933: -- following cursor has been commented and instead call to the jai_cmn_bond_register_pkg package has been done

2929: v_register_code
2930: );
2931:
2932:
2933: -- following cursor has been commented and instead call to the jai_cmn_bond_register_pkg package has been done
2934:
2935: /*OPEN register_code_cur(v_organization_id, v_location_id,v_order_type_id);
2936: FETCH register_code_cur INTO v_register_code;
2937: CLOSE register_code_cur;

Line 2991: jai_cmn_bond_register_pkg.GET_REGISTER_ID(v_organization_id,

2987:
2988:
2989: -- added by sriram - bug # 3021588
2990:
2991: jai_cmn_bond_register_pkg.GET_REGISTER_ID(v_organization_id,
2992: v_location_id,
2993: v_order_type_id,
2994: 'Y',
2995: v_asst_register_id,

Line 2999: -- call to the jai_cmn_bond_register_pkg package has been included instead of using the cursors

2995: v_asst_register_id,
2996: v_register_code
2997: );
2998:
2999: -- call to the jai_cmn_bond_register_pkg package has been included instead of using the cursors
3000: -- to get the bond register balance info and other bond register details
3001:
3002: /*OPEN register_code_cur(v_organization_id, v_location_id, v_order_type_id);
3003: FETCH register_code_cur INTO v_register_code;

Line 3153: jai_cmn_bond_register_pkg.GET_REGISTER_DETAILS(v_asst_register_id,

3149: FETCH register_balance_cur INTO v_register_balance;
3150: CLOSE register_balance_cur;
3151: */
3152:
3153: jai_cmn_bond_register_pkg.GET_REGISTER_DETAILS(v_asst_register_id,
3154: v_register_balance,
3155: v_reg_exp_date ,
3156: v_lou_flag);
3157: