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

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

11: REM +======================================================================+
12: */
13: 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
14: /*
15: This cursor is to fetch the Information regarding vendor change from JAI_RCV_CENVAT_CLAIMS.
16: */
17:
18: CURSOR c_fetch_vendor_info(cp_transaction_type IN rcv_transactions.transaction_type%type)
19: IS

Line 25: JAI_RCV_CENVAT_CLAIMS

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

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

38: parent_transaction_id = transaction_id
39: );
40:
41: --Variable definitions
42: v_vendor_change JAI_RCV_CENVAT_CLAIMS.vendor_changed_flag%type ; /* To hold the Flag value whether vendor is changed or not. */
43: v_vendor_id JAI_RCV_CENVAT_CLAIMS.vendor_id%type ; /* To hold the vendor id of ja_in_receipt_cenvat. */
44: v_vendor_site_id JAI_RCV_CENVAT_CLAIMS.vendor_site_id%type ; /* To hold the vendor site id of ja_in_receipt_cenvat. */
45: v_range_no JAI_CMN_VENDOR_SITES.excise_duty_range%type ;
46: v_division_no JAI_CMN_VENDOR_SITES.excise_duty_division%type ;

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

39: );
40:
41: --Variable definitions
42: v_vendor_change JAI_RCV_CENVAT_CLAIMS.vendor_changed_flag%type ; /* To hold the Flag value whether vendor is changed or not. */
43: v_vendor_id JAI_RCV_CENVAT_CLAIMS.vendor_id%type ; /* To hold the vendor id of ja_in_receipt_cenvat. */
44: v_vendor_site_id JAI_RCV_CENVAT_CLAIMS.vendor_site_id%type ; /* To hold the vendor site id of ja_in_receipt_cenvat. */
45: v_range_no JAI_CMN_VENDOR_SITES.excise_duty_range%type ;
46: v_division_no JAI_CMN_VENDOR_SITES.excise_duty_division%type ;
47: --Added the below 4 variables by Sanjikum for Bug #3964409

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

40:
41: --Variable definitions
42: v_vendor_change JAI_RCV_CENVAT_CLAIMS.vendor_changed_flag%type ; /* To hold the Flag value whether vendor is changed or not. */
43: v_vendor_id JAI_RCV_CENVAT_CLAIMS.vendor_id%type ; /* To hold the vendor id of ja_in_receipt_cenvat. */
44: v_vendor_site_id JAI_RCV_CENVAT_CLAIMS.vendor_site_id%type ; /* To hold the vendor site id of ja_in_receipt_cenvat. */
45: v_range_no JAI_CMN_VENDOR_SITES.excise_duty_range%type ;
46: v_division_no JAI_CMN_VENDOR_SITES.excise_duty_division%type ;
47: --Added the below 4 variables by Sanjikum for Bug #3964409
48: ln_slno JAI_CMN_RG_23AC_II_TRXS.slno%TYPE;

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

59:
60: Enhancement Bug : 3025626
61:
62: Purpose : Modify the vendor_id, vendor_site_id, Range and Division information in JAI_CMN_RG_PLA_TRXS table from the
63: JAI_RCV_CENVAT_CLAIMS table when a third party supplier information has been registered through the
64: Claim Modvat On Receipt form.
65:
66: Dependency : - The following dependency has been created in this bug
67: 1. Technical dependency due to datamodel change :-

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

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

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

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