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_JRG_23AC2_TRIGGER_PKG dependencies on JAI_RCV_CENVAT_CLAIMS

Line 16: This cursor is to fetch the Information regarding vendor change from JAI_RCV_CENVAT_CLAIMS.

12: REM +======================================================================+
13: */
14: PROCEDURE BRI_T1 ( pr_old t_rec%type , pr_new in out t_rec%type , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) IS
15: /*
16: This cursor is to fetch the Information regarding vendor change from JAI_RCV_CENVAT_CLAIMS.
17: */
18:
19: CURSOR c_fetch_vendor_info(cp_transaction_type rcv_transactions.transaction_type%type)
20: IS

Line 26: JAI_RCV_CENVAT_CLAIMS

22: vendor_changed_flag ,
23: vendor_id ,
24: vendor_site_id
25: FROM
26: JAI_RCV_CENVAT_CLAIMS
27: WHERE
28: transaction_id in
29: (
30: SELECT

Line 43: v_vendor_change JAI_RCV_CENVAT_CLAIMS.vendor_changed_flag%type ; /* To hold the Flag value whether vendor is changed or not. */

39: parent_transaction_id = transaction_id
40: );
41:
42: --Variable definitions
43: v_vendor_change JAI_RCV_CENVAT_CLAIMS.vendor_changed_flag%type ; /* To hold the Flag value whether vendor is changed or not. */
44: v_vendor_id JAI_RCV_CENVAT_CLAIMS.vendor_id%type ; /* To hold the vendor id of ja_in_receipt_cenvat. */
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 ;

Line 44: v_vendor_id JAI_RCV_CENVAT_CLAIMS.vendor_id%type ; /* To hold the vendor id of ja_in_receipt_cenvat. */

40: );
41:
42: --Variable definitions
43: v_vendor_change JAI_RCV_CENVAT_CLAIMS.vendor_changed_flag%type ; /* To hold the Flag value whether vendor is changed or not. */
44: v_vendor_id JAI_RCV_CENVAT_CLAIMS.vendor_id%type ; /* To hold the vendor id of ja_in_receipt_cenvat. */
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

Line 45: v_vendor_site_id JAI_RCV_CENVAT_CLAIMS.vendor_site_id%type ; /* To hold the vendor site id of ja_in_receipt_cenvat. */

41:
42: --Variable definitions
43: v_vendor_change JAI_RCV_CENVAT_CLAIMS.vendor_changed_flag%type ; /* To hold the Flag value whether vendor is changed or not. */
44: v_vendor_id JAI_RCV_CENVAT_CLAIMS.vendor_id%type ; /* To hold the vendor id of ja_in_receipt_cenvat. */
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;

Line 64: JAI_RCV_CENVAT_CLAIMS table when a third party supplier information has been registered through the

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
68: 1. Technical dependency due to datamodel change :-

Line 70: been added to the table JAI_RCV_CENVAT_CLAIMS and the view JAI_RCV_CLAIM_MODVAT_V

66:
67: Dependency : - The following dependency has been created in this bug
68: 1. Technical dependency due to datamodel change :-
69: 3 new fields VENDOR_CHANGED_FLAG,VENDOR_ID and VENDOR_SITE_ID have
70: been added to the table JAI_RCV_CENVAT_CLAIMS and the view JAI_RCV_CLAIM_MODVAT_V
71: (base view of the form JAINMVAT.fmb) has been modified to add vendor_changed_flag
72: and vendor_site_id. Also the way the vendor_id is fetched in the view has also been changed.
73:
74: 2. Functional Dependency:-

Line 125: 2. JAI_RCV_CLAIM_MODVAT_V.sql 616.1 model changes in table JAI_RCV_CENVAT_CLAIMS,

121: Of File On Bug/Patchset Dependent On
122: ja_in_rg23_part_ii_bi_trg.sql
123: ----------------------------------------------------------------------------------------------------------------------------------------------------
124: 616.1 3025626 IN60104D1+3025626 1. ja_3025626_alter.sql 616.1 Aiyer 21/07/2003 Enhancement, Introduced data
125: 2. JAI_RCV_CLAIM_MODVAT_V.sql 616.1 model changes in table JAI_RCV_CENVAT_CLAIMS,
126: 3. ja_in_pla_bi_trg.sql 616.1 alterations in view JAI_RCV_CLAIM_MODVAT_V,
127: 4. ja_in_rg23_part_i_bi_trg.sql 616.1 added 3 new fields in form JAINMVAT.fmb and
128: 5. JAINMVAT.fmb 616.4 2 new triggers - ja_in_pla_bi_trg.sql and
129: 6. JAF23A_1.rdf 616.1 ja_in_rg23_part_i_bi_trg.sql. All present in patch 3025626.