DBA Data[Home] [Help]

APPS.JAI_OM_RG_PKG dependencies on JAI_OM_OE_BOND_REG_HDRS

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

1857: For Multiple Bond Register Enhancement,
1858:
1859: Instead of using the cursors for fetching the register associated with the order / invoice type , a call has been made to the procedures
1860: of the jai_cmn_bond_register_pkg package. There enhancement has created dependency because of the
1861: 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.
1862:
1863: 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
1864:
1865: Provision for letter of undertaking has been incorporated. In the case of the letter of undetaking , its also a type of bond register

Line 1867: This has been done by checking if the LOU_FLAG is 'Y' in the JAI_OM_OE_BOND_REG_HDRS table for the

1863: 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
1864:
1865: Provision for letter of undertaking has been incorporated. In the case of the letter of undetaking , its also a type of bond register
1866: but without validation for the balances.
1867: This has been done by checking if the LOU_FLAG is 'Y' in the JAI_OM_OE_BOND_REG_HDRS table for the
1868: associated register id , if yes , then validation is only based on bond expiry date .
1869:
1870: This fix has introduced huge dependency . All future changes in this object should have this bug as a prereq
1871:

Line 2829: v_register_code JAI_OM_OE_BOND_REG_HDRS.register_code%TYPE;

2825: v_excise_amount NUMBER := 0;
2826: v_ssi_unit_flag VARCHAR2(1);
2827:
2828: --Variables Added by Nagaraj.s for Enhancement
2829: v_register_code JAI_OM_OE_BOND_REG_HDRS.register_code%TYPE;
2830: v_basic_opening_balance NUMBER;
2831: v_basic_closing_balance NUMBER;
2832: v_additional_opening_balance NUMBER;
2833: v_additional_closing_balance NUMBER;

Line 2915: FROM JAI_OM_OE_BOND_REG_HDRS A, JAI_OM_OE_BOND_REG_DTLS b

2911: delivery_detail_id = p_header_id;
2912:
2913: CURSOR c_register_code IS
2914: SELECT A.register_code
2915: FROM JAI_OM_OE_BOND_REG_HDRS A, JAI_OM_OE_BOND_REG_DTLS b
2916: WHERE A.organization_id = p_org_id
2917: AND A.location_id = p_location_id
2918: AND A.register_id = b.register_id
2919: AND b.order_flag = 'Y'

Line 3937: WHERE register_id = (SELECT register_id FROM JAI_OM_OE_BOND_REG_HDRS

3933: CURSOR register_balance_cur IS
3934: SELECT register_balance
3935: FROM JAI_OM_OE_BOND_TRXS
3936: WHERE transaction_id = (SELECT MAX(transaction_id) FROM JAI_OM_OE_BOND_TRXS
3937: WHERE register_id = (SELECT register_id FROM JAI_OM_OE_BOND_REG_HDRS
3938: WHERE organization_id = p_org_id AND location_id = p_location_id
3939: AND register_code = p_register_code));
3940: CURSOR register_balance_cur1 IS
3941: SELECT rg23d_register_balance

Line 3944: WHERE register_id = (SELECT register_id FROM JAI_OM_OE_BOND_REG_HDRS

3940: CURSOR register_balance_cur1 IS
3941: SELECT rg23d_register_balance
3942: FROM JAI_OM_OE_BOND_TRXS
3943: WHERE transaction_id = (SELECT MAX(transaction_id) FROM JAI_OM_OE_BOND_TRXS
3944: WHERE register_id = (SELECT register_id FROM JAI_OM_OE_BOND_REG_HDRS
3945: WHERE organization_id = p_org_id AND location_id = p_location_id
3946: AND register_code = p_register_code));
3947: CURSOR register_id_cur IS
3948: SELECT register_ID

Line 3949: FROM JAI_OM_OE_BOND_REG_HDRS

3945: WHERE organization_id = p_org_id AND location_id = p_location_id
3946: AND register_code = p_register_code));
3947: CURSOR register_id_cur IS
3948: SELECT register_ID
3949: FROM JAI_OM_OE_BOND_REG_HDRS
3950: WHERE organization_id = p_org_id
3951: AND location_id = p_location_id
3952: AND register_code = p_register_code;
3953:

Line 4051: v_reg_expiry_date JAI_OM_OE_BOND_REG_HDRS.BOND_EXPIRY_DATE%type;

4047: where customer_trx_id = cp_customer_trx_id
4048: )
4049: and upper(jtc.tax_type) in (JAI_CONSTANTS.tax_type_sh_cvd_edu_cess,JAI_CONSTANTS.tax_type_sh_exc_edu_cess) ;
4050:
4051: v_reg_expiry_date JAI_OM_OE_BOND_REG_HDRS.BOND_EXPIRY_DATE%type;
4052: v_lou_flag JAI_OM_OE_BOND_REG_HDRS.LOU_FLAG%TYPE;
4053: v_asst_register_id JAI_OM_OE_BOND_REG_HDRS.register_id%type;
4054: v_order_type_id JAI_OM_OE_BOND_REG_DTLS.order_type_id%type;
4055: v_register_code JAI_OM_OE_BOND_REG_HDRS.register_code%type;

Line 4052: v_lou_flag JAI_OM_OE_BOND_REG_HDRS.LOU_FLAG%TYPE;

4048: )
4049: and upper(jtc.tax_type) in (JAI_CONSTANTS.tax_type_sh_cvd_edu_cess,JAI_CONSTANTS.tax_type_sh_exc_edu_cess) ;
4050:
4051: v_reg_expiry_date JAI_OM_OE_BOND_REG_HDRS.BOND_EXPIRY_DATE%type;
4052: v_lou_flag JAI_OM_OE_BOND_REG_HDRS.LOU_FLAG%TYPE;
4053: v_asst_register_id JAI_OM_OE_BOND_REG_HDRS.register_id%type;
4054: v_order_type_id JAI_OM_OE_BOND_REG_DTLS.order_type_id%type;
4055: v_register_code JAI_OM_OE_BOND_REG_HDRS.register_code%type;
4056: ln_header_id number;

Line 4053: v_asst_register_id JAI_OM_OE_BOND_REG_HDRS.register_id%type;

4049: and upper(jtc.tax_type) in (JAI_CONSTANTS.tax_type_sh_cvd_edu_cess,JAI_CONSTANTS.tax_type_sh_exc_edu_cess) ;
4050:
4051: v_reg_expiry_date JAI_OM_OE_BOND_REG_HDRS.BOND_EXPIRY_DATE%type;
4052: v_lou_flag JAI_OM_OE_BOND_REG_HDRS.LOU_FLAG%TYPE;
4053: v_asst_register_id JAI_OM_OE_BOND_REG_HDRS.register_id%type;
4054: v_order_type_id JAI_OM_OE_BOND_REG_DTLS.order_type_id%type;
4055: v_register_code JAI_OM_OE_BOND_REG_HDRS.register_code%type;
4056: ln_header_id number;
4057: ln_cess_amount number;

Line 4055: v_register_code JAI_OM_OE_BOND_REG_HDRS.register_code%type;

4051: v_reg_expiry_date JAI_OM_OE_BOND_REG_HDRS.BOND_EXPIRY_DATE%type;
4052: v_lou_flag JAI_OM_OE_BOND_REG_HDRS.LOU_FLAG%TYPE;
4053: v_asst_register_id JAI_OM_OE_BOND_REG_HDRS.register_id%type;
4054: v_order_type_id JAI_OM_OE_BOND_REG_DTLS.order_type_id%type;
4055: v_register_code JAI_OM_OE_BOND_REG_HDRS.register_code%type;
4056: ln_header_id number;
4057: ln_cess_amount number;
4058: ln_Cess_Ctr number;
4059: