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_23AC1_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:

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:
49: /*Bug 9122545*/

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

68:
69: Enhancement Bug : 3025626
70:
71: Purpose : Modify the vendor_id, vendor_site_id, Range and Division information in JAI_CMN_RG_23AC_I_TRXS table from the
72: JAI_RCV_CENVAT_CLAIMS table when a third party supplier information has been registered through the
73: Claim Modvat On Receipt form.
74:
75: Dependency : - The following dependency has been created in this bug
76: 1. Technical dependency due to datamodel change :-

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

74:
75: Dependency : - The following dependency has been created in this bug
76: 1. Technical dependency due to datamodel change :-
77: 3 new fields VENDOR_CHANGED_FLAG,VENDOR_ID and VENDOR_SITE_ID have
78: been added to the table JAI_RCV_CENVAT_CLAIMS and the view JAI_RCV_CLAIM_MODVAT_V
79: (base view of the form JAINMVAT.fmb) has been modified to add vendor_changed_flag
80: and vendor_site_id. Also the way the vendor_id is fetched in the view has also been changed.
81:
82: 2. Functional Dependency:-

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

113: Of File On Bug/Patchset Dependent On
114: ja_in_rg23_part_i_bi_trg.sql
115: ----------------------------------------------------------------------------------------------------------------------------------------------------
116: 616.1 3025626 IN60104D1+3025626 1. ja_3025626_alter.sql 616.1 Aiyer 21/07/2003 Enhancement, Introduced data
117: \ 2. JAI_RCV_CLAIM_MODVAT_V.sql 616.1 model changes in table JAI_RCV_CENVAT_CLAIMS,
118: model changes in table JAI_RCV_CENVAT_CLAIMS
119: 3. ja_in_pla_bi_trg.sql 616.1 alterations in view JAI_RCV_CLAIM_MODVAT_V,
120: 4. ja_in_rg23_part_ii_bi_trg.sql 616.1 added 3 new fields in form JAINMVAT.fmb and
121: 5. JAINMVAT.fmb 616.4 2 new triggers - ja_in_pla_bi_trg.sql and

Line 118: model changes in table JAI_RCV_CENVAT_CLAIMS

114: ja_in_rg23_part_i_bi_trg.sql
115: ----------------------------------------------------------------------------------------------------------------------------------------------------
116: 616.1 3025626 IN60104D1+3025626 1. ja_3025626_alter.sql 616.1 Aiyer 21/07/2003 Enhancement, Introduced data
117: \ 2. JAI_RCV_CLAIM_MODVAT_V.sql 616.1 model changes in table JAI_RCV_CENVAT_CLAIMS,
118: model changes in table JAI_RCV_CENVAT_CLAIMS
119: 3. ja_in_pla_bi_trg.sql 616.1 alterations in view JAI_RCV_CLAIM_MODVAT_V,
120: 4. ja_in_rg23_part_ii_bi_trg.sql 616.1 added 3 new fields in form JAINMVAT.fmb and
121: 5. JAINMVAT.fmb 616.4 2 new triggers - ja_in_pla_bi_trg.sql and
122: 6. JAF23A_1.rdf 616.1 ja_in_rg23_part_ii_bi_trg.sql. All present in patch 3025626.