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 1974: of the jai_cmn_bond_register_pkg package. There enhancement has created dependency because of the

1970: 15. 22/08/2003 Bug # 3021588 (Bond Register Enhancement) Version 616.2
1971:
1972: For Multiple Bond Register Enhancement,
1973: Instead of using the cursors for fetching the register associated with the order type , a call has been made to the procedures
1974: of the jai_cmn_bond_register_pkg package. There enhancement has created dependency because of the
1975: 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.
1976:
1977: 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
1978:

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

1971:
1972: For Multiple Bond Register Enhancement,
1973: Instead of using the cursors for fetching the register associated with the order type , a call has been made to the procedures
1974: of the jai_cmn_bond_register_pkg package. There enhancement has created dependency because of the
1975: 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.
1976:
1977: 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
1978:
1979: 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 1977: 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

1973: Instead of using the cursors for fetching the register associated with the order type , a call has been made to the procedures
1974: of the jai_cmn_bond_register_pkg package. There enhancement has created dependency because of the
1975: 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.
1976:
1977: 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
1978:
1979: Provision for letter of undertaking has been incorporated. Letter of undetaking is also a type of bond register but without validation for the balances.
1980: This has been done by checking if the LOU_FLAG is 'Y' in the JAI_OM_OE_BOND_REG_HDRS table for the
1981: associated register id , if yes , then validation is only based on bond expiry date .

Line 3297: jai_cmn_bond_register_pkg.GET_REGISTER_ID(v_organization_id,

3293: END IF;
3294:
3295: -- added by sriram - bug # 3021588
3296:
3297: jai_cmn_bond_register_pkg.GET_REGISTER_ID(v_organization_id,
3298: v_location_id,
3299: v_order_type_id,
3300: 'Y',
3301: v_asst_register_id,

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

3302: v_register_code
3303: );
3304:
3305:
3306: -- following cursor has been commented and instead call to the jai_cmn_bond_register_pkg package has been done
3307:
3308: /*OPEN register_code_cur(v_organization_id, v_location_id,v_order_type_id);
3309: FETCH register_code_cur INTO v_register_code;
3310: CLOSE register_code_cur;

Line 3364: jai_cmn_bond_register_pkg.GET_REGISTER_ID(v_organization_id,

3360:
3361:
3362: -- added by sriram - bug # 3021588
3363:
3364: jai_cmn_bond_register_pkg.GET_REGISTER_ID(v_organization_id,
3365: v_location_id,
3366: v_order_type_id,
3367: 'Y',
3368: v_asst_register_id,

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

3368: v_asst_register_id,
3369: v_register_code
3370: );
3371:
3372: -- call to the jai_cmn_bond_register_pkg package has been included instead of using the cursors
3373: -- to get the bond register balance info and other bond register details
3374:
3375: /*OPEN register_code_cur(v_organization_id, v_location_id, v_order_type_id);
3376: FETCH register_code_cur INTO v_register_code;

Line 3526: jai_cmn_bond_register_pkg.GET_REGISTER_DETAILS(v_asst_register_id,

3522: FETCH register_balance_cur INTO v_register_balance;
3523: CLOSE register_balance_cur;
3524: */
3525:
3526: jai_cmn_bond_register_pkg.GET_REGISTER_DETAILS(v_asst_register_id,
3527: v_register_balance,
3528: v_reg_exp_date ,
3529: v_lou_flag);
3530: