DBA Data[Home] [Help]

APPS.JAI_OM_RG_PKG dependencies on JAI_OM_OE_BOND_REG_HDRS

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 1960: This has been done by checking if the LOU_FLAG is 'Y' in the JAI_OM_OE_BOND_REG_HDRS table for the

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
1961: associated register id , if yes , then validation is only based on bond expiry date .
1962:
1963: This fix has introduced huge dependency . All future changes in this object should have this bug as a prereq
1964:

Line 3061: v_register_code JAI_OM_OE_BOND_REG_HDRS.register_code%TYPE;

3057: v_excise_amount NUMBER := 0;
3058: v_ssi_unit_flag VARCHAR2(1);
3059:
3060: --Variables Added by Nagaraj.s for Enhancement
3061: v_register_code JAI_OM_OE_BOND_REG_HDRS.register_code%TYPE;
3062: v_basic_opening_balance NUMBER;
3063: v_basic_closing_balance NUMBER;
3064: v_additional_opening_balance NUMBER;
3065: v_additional_closing_balance NUMBER;

Line 3147: FROM JAI_OM_OE_BOND_REG_HDRS A, JAI_OM_OE_BOND_REG_DTLS b

3143: delivery_detail_id = p_header_id;
3144:
3145: CURSOR c_register_code IS
3146: SELECT A.register_code
3147: FROM JAI_OM_OE_BOND_REG_HDRS A, JAI_OM_OE_BOND_REG_DTLS b
3148: WHERE A.organization_id = p_org_id
3149: AND A.location_id = p_location_id
3150: AND A.register_id = b.register_id
3151: AND b.order_flag = 'Y'

Line 4329: WHERE register_id = (SELECT register_id FROM JAI_OM_OE_BOND_REG_HDRS

4325: CURSOR register_balance_cur IS
4326: SELECT register_balance
4327: FROM JAI_OM_OE_BOND_TRXS
4328: WHERE transaction_id = (SELECT MAX(transaction_id) FROM JAI_OM_OE_BOND_TRXS
4329: WHERE register_id = (SELECT register_id FROM JAI_OM_OE_BOND_REG_HDRS
4330: WHERE organization_id = p_org_id AND location_id = p_location_id
4331: AND register_code = p_register_code));
4332: CURSOR register_balance_cur1 IS
4333: SELECT rg23d_register_balance

Line 4336: WHERE register_id = (SELECT register_id FROM JAI_OM_OE_BOND_REG_HDRS

4332: CURSOR register_balance_cur1 IS
4333: SELECT rg23d_register_balance
4334: FROM JAI_OM_OE_BOND_TRXS
4335: WHERE transaction_id = (SELECT MAX(transaction_id) FROM JAI_OM_OE_BOND_TRXS
4336: WHERE register_id = (SELECT register_id FROM JAI_OM_OE_BOND_REG_HDRS
4337: WHERE organization_id = p_org_id AND location_id = p_location_id
4338: AND register_code = p_register_code));
4339: CURSOR register_id_cur IS
4340: SELECT register_ID

Line 4341: FROM JAI_OM_OE_BOND_REG_HDRS

4337: WHERE organization_id = p_org_id AND location_id = p_location_id
4338: AND register_code = p_register_code));
4339: CURSOR register_id_cur IS
4340: SELECT register_ID
4341: FROM JAI_OM_OE_BOND_REG_HDRS
4342: WHERE organization_id = p_org_id
4343: AND location_id = p_location_id
4344: AND register_code = p_register_code;
4345:

Line 4460: v_reg_expiry_date JAI_OM_OE_BOND_REG_HDRS.BOND_EXPIRY_DATE%type;

4456: and order_line_id=cp_ref_line_id;
4457:
4458: -- added by nkodakan for the bug 16014871 ends
4459:
4460: v_reg_expiry_date JAI_OM_OE_BOND_REG_HDRS.BOND_EXPIRY_DATE%type;
4461: v_lou_flag JAI_OM_OE_BOND_REG_HDRS.LOU_FLAG%TYPE;
4462: v_asst_register_id JAI_OM_OE_BOND_REG_HDRS.register_id%type;
4463: v_order_type_id JAI_OM_OE_BOND_REG_DTLS.order_type_id%type;
4464: v_register_code JAI_OM_OE_BOND_REG_HDRS.register_code%type;

Line 4461: v_lou_flag JAI_OM_OE_BOND_REG_HDRS.LOU_FLAG%TYPE;

4457:
4458: -- added by nkodakan for the bug 16014871 ends
4459:
4460: v_reg_expiry_date JAI_OM_OE_BOND_REG_HDRS.BOND_EXPIRY_DATE%type;
4461: v_lou_flag JAI_OM_OE_BOND_REG_HDRS.LOU_FLAG%TYPE;
4462: v_asst_register_id JAI_OM_OE_BOND_REG_HDRS.register_id%type;
4463: v_order_type_id JAI_OM_OE_BOND_REG_DTLS.order_type_id%type;
4464: v_register_code JAI_OM_OE_BOND_REG_HDRS.register_code%type;
4465: ln_header_id number;

Line 4462: v_asst_register_id JAI_OM_OE_BOND_REG_HDRS.register_id%type;

4458: -- added by nkodakan for the bug 16014871 ends
4459:
4460: v_reg_expiry_date JAI_OM_OE_BOND_REG_HDRS.BOND_EXPIRY_DATE%type;
4461: v_lou_flag JAI_OM_OE_BOND_REG_HDRS.LOU_FLAG%TYPE;
4462: v_asst_register_id JAI_OM_OE_BOND_REG_HDRS.register_id%type;
4463: v_order_type_id JAI_OM_OE_BOND_REG_DTLS.order_type_id%type;
4464: v_register_code JAI_OM_OE_BOND_REG_HDRS.register_code%type;
4465: ln_header_id number;
4466: ln_cess_amount number;

Line 4464: v_register_code JAI_OM_OE_BOND_REG_HDRS.register_code%type;

4460: v_reg_expiry_date JAI_OM_OE_BOND_REG_HDRS.BOND_EXPIRY_DATE%type;
4461: v_lou_flag JAI_OM_OE_BOND_REG_HDRS.LOU_FLAG%TYPE;
4462: v_asst_register_id JAI_OM_OE_BOND_REG_HDRS.register_id%type;
4463: v_order_type_id JAI_OM_OE_BOND_REG_DTLS.order_type_id%type;
4464: v_register_code JAI_OM_OE_BOND_REG_HDRS.register_code%type;
4465: ln_header_id number;
4466: ln_cess_amount number;
4467: ln_Cess_Ctr number;
4468: