DBA Data[Home] [Help]

APPS.JAI_JRG_23AC2_TRIGGER_PKG dependencies on JAI_CMN_RG_23AC_II_TRXS

Line 49: ln_slno JAI_CMN_RG_23AC_II_TRXS.slno%TYPE;

45: v_vendor_site_id JAI_RCV_CENVAT_CLAIMS.vendor_site_id%type ; /* To hold the vendor site id of ja_in_receipt_cenvat. */
46: v_range_no JAI_CMN_VENDOR_SITES.excise_duty_range%type ;
47: v_division_no JAI_CMN_VENDOR_SITES.excise_duty_division%type ;
48: --Added the below 4 variables by Sanjikum for Bug #3964409
49: ln_slno JAI_CMN_RG_23AC_II_TRXS.slno%TYPE;
50: ln_opening_balance JAI_CMN_RG_23AC_II_TRXS.opening_balance%TYPE;
51: ln_closing_balance JAI_CMN_RG_23AC_II_TRXS.closing_balance%TYPE;
52: ln_txn_amt JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE;
53: BEGIN

Line 50: ln_opening_balance JAI_CMN_RG_23AC_II_TRXS.opening_balance%TYPE;

46: v_range_no JAI_CMN_VENDOR_SITES.excise_duty_range%type ;
47: v_division_no JAI_CMN_VENDOR_SITES.excise_duty_division%type ;
48: --Added the below 4 variables by Sanjikum for Bug #3964409
49: ln_slno JAI_CMN_RG_23AC_II_TRXS.slno%TYPE;
50: ln_opening_balance JAI_CMN_RG_23AC_II_TRXS.opening_balance%TYPE;
51: ln_closing_balance JAI_CMN_RG_23AC_II_TRXS.closing_balance%TYPE;
52: ln_txn_amt JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE;
53: BEGIN
54: pv_return_code := jai_constants.successful ;

Line 51: ln_closing_balance JAI_CMN_RG_23AC_II_TRXS.closing_balance%TYPE;

47: v_division_no JAI_CMN_VENDOR_SITES.excise_duty_division%type ;
48: --Added the below 4 variables by Sanjikum for Bug #3964409
49: ln_slno JAI_CMN_RG_23AC_II_TRXS.slno%TYPE;
50: ln_opening_balance JAI_CMN_RG_23AC_II_TRXS.opening_balance%TYPE;
51: ln_closing_balance JAI_CMN_RG_23AC_II_TRXS.closing_balance%TYPE;
52: ln_txn_amt JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE;
53: BEGIN
54: pv_return_code := jai_constants.successful ;
55: /*********************************************************************************************************************************************************************

Line 52: ln_txn_amt JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE;

48: --Added the below 4 variables by Sanjikum for Bug #3964409
49: ln_slno JAI_CMN_RG_23AC_II_TRXS.slno%TYPE;
50: ln_opening_balance JAI_CMN_RG_23AC_II_TRXS.opening_balance%TYPE;
51: ln_closing_balance JAI_CMN_RG_23AC_II_TRXS.closing_balance%TYPE;
52: ln_txn_amt JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE;
53: BEGIN
54: pv_return_code := jai_constants.successful ;
55: /*********************************************************************************************************************************************************************
56:

Line 63: Purpose : Modify the vendor_id, vendor_site_id, Range and Division information in JAI_CMN_RG_23AC_II_TRXS table from the

59: Creation Date : 21-Jul-2003
60:
61: Enhancement Bug : 3025626
62:
63: Purpose : Modify the vendor_id, vendor_site_id, Range and Division information in JAI_CMN_RG_23AC_II_TRXS table from the
64: JAI_RCV_CENVAT_CLAIMS table when a third party supplier information has been registered through the
65: Claim Modvat On Receipt form.
66:
67: Dependency : - The following dependency has been created in this bug