DBA Data[Home] [Help]

APPS.JAI_OM_RG_PKG dependencies on JAI_CMN_BOND_REGISTER_PKG

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

1949:
1950: For Multiple Bond Register Enhancement,
1951:
1952: Instead of using the cursors for fetching the register associated with the order / invoice type , a call has been made to the procedures
1953: of the jai_cmn_bond_register_pkg package. There enhancement has created dependency because of the
1954: 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.
1955:
1956: 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
1957:

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

1950: For Multiple Bond Register Enhancement,
1951:
1952: Instead of using the cursors for fetching the register associated with the order / invoice type , a call has been made to the procedures
1953: of the jai_cmn_bond_register_pkg package. There enhancement has created dependency because of the
1954: 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.
1955:
1956: 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
1957:
1958: Provision for letter of undertaking has been incorporated. In the case of the letter of undetaking , its also a type of bond register

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

1952: Instead of using the cursors for fetching the register associated with the order / invoice type , a call has been made to the procedures
1953: of the jai_cmn_bond_register_pkg package. There enhancement has created dependency because of the
1954: 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.
1955:
1956: 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
1957:
1958: Provision for letter of undertaking has been incorporated. In the case of the letter of undetaking , its also a type of bond register
1959: but without validation for the balances.
1960: This has been done by checking if the LOU_FLAG is 'Y' in the JAI_OM_OE_BOND_REG_HDRS table for the

Line 3232: Fnd_File.PUT_LINE(Fnd_File.LOG, '2 before call to jai_cmn_bond_register_pkg.get_register_id ');

3228: FETCH c_order_type_id INTO v_order_type_id;
3229: CLOSE c_order_type_id;
3230:
3231: --sriram - bug # 3021588 and using the following procedure call instead.
3232: Fnd_File.PUT_LINE(Fnd_File.LOG, '2 before call to jai_cmn_bond_register_pkg.get_register_id ');
3233:
3234: jai_cmn_bond_register_pkg.get_register_id (p_org_id ,
3235: p_location_id,
3236: v_order_type_id, -- order type id

Line 3234: jai_cmn_bond_register_pkg.get_register_id (p_org_id ,

3230:
3231: --sriram - bug # 3021588 and using the following procedure call instead.
3232: Fnd_File.PUT_LINE(Fnd_File.LOG, '2 before call to jai_cmn_bond_register_pkg.get_register_id ');
3233:
3234: jai_cmn_bond_register_pkg.get_register_id (p_org_id ,
3235: p_location_id,
3236: v_order_type_id, -- order type id
3237: 'Y', -- order invoice type
3238: v_asst_register_id, -- out parameter to get the register id

Line 3241: Fnd_File.PUT_LINE(Fnd_File.LOG, '3 after call from jai_cmn_bond_register_pkg.get_register_id ');

3237: 'Y', -- order invoice type
3238: v_asst_register_id, -- out parameter to get the register id
3239: v_register_code);
3240:
3241: Fnd_File.PUT_LINE(Fnd_File.LOG, '3 after call from jai_cmn_bond_register_pkg.get_register_id ');
3242: IF NVL(v_previous_serial_no,0) = 0 THEN
3243: v_previous_serial_no := 0;
3244: v_serial_no := 1;
3245: END IF;

Line 4679: jai_cmn_bond_register_pkg.GET_REGISTER_ID (p_org_id ,

4675: end if;
4676: /*Bug 5989740 bduvarag end*/
4677: end if;
4678:
4679: jai_cmn_bond_register_pkg.GET_REGISTER_ID (p_org_id ,
4680: p_location_id,
4681: v_order_type_id, -- order type id
4682: p_order_flag, -- order invoice type
4683: v_asst_register_id, -- out parameter to get the register id

Line 4689: jai_cmn_bond_register_pkg.GET_REGISTER_DETAILS(v_asst_register_id,

4685:
4686: /*
4687: call to get the register balance and expiry details
4688: */
4689: jai_cmn_bond_register_pkg.GET_REGISTER_DETAILS(v_asst_register_id,
4690: v_register_balance,
4691: v_reg_expiry_date,
4692: v_lou_flag);
4693: