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_RCV_RND_PKG dependencies on JAI_CONSTANTS

Line 156: AND a.source_register = DECODE(p_register_type,'A',jai_constants.reg_rg23a_2, 'C', jai_constants.reg_rg23c_2) --'RG23A_P2','C','RG23C_P2')

152: p_tax_type IN VARCHAR2) is
153: Select nvl(a.closing_balance,0) closing_balance
154: from JAI_CMN_RG_OTHERS a
155: Where a.source_type = 1 --1 is for JAI_CMN_RG_23AC_II_TRXS
156: AND a.source_register = DECODE(p_register_type,'A',jai_constants.reg_rg23a_2, 'C', jai_constants.reg_rg23c_2) --'RG23A_P2','C','RG23C_P2')
157: and a.tax_type = p_tax_type
158: AND abs(a.source_register_id) IN (Select max(abs(c.source_register_id))
159: from JAI_CMN_RG_23AC_II_TRXS b,
160: JAI_CMN_RG_OTHERS c

Line 162: AND c.source_register = DECODE(p_register_type,'A',jai_constants.reg_rg23a_2, 'C', jai_constants.reg_rg23c_2) --'RG23A_P2','C','RG23C_P2')

158: AND abs(a.source_register_id) IN (Select max(abs(c.source_register_id))
159: from JAI_CMN_RG_23AC_II_TRXS b,
160: JAI_CMN_RG_OTHERS c
161: Where c.source_type = 1 --1 is for JAI_CMN_RG_23AC_II_TRXS
162: AND c.source_register = DECODE(p_register_type,'A',jai_constants.reg_rg23a_2, 'C', jai_constants.reg_rg23c_2) --'RG23A_P2','C','RG23C_P2')
163: AND b.register_id = c.source_register_id
164: AND b.organization_id = p_organization_id
165: and b.location_id = p_location_id
166: and c.tax_type = p_tax_type

Line 202: sum(decode(b.tax_type, jai_constants.tax_type_add_cvd, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) additional_cvd , /Changed by SACSETHI for the bug 5228046 -Additional CVD Enhancement/

198: CURSOR c_receipt_tax_amount(cp_shipment_line_id IN NUMBER) IS /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
199: SELECT --Added the 6 columns by Sanjikum for Bug #4049363
200: sum(decode(b.tax_type, 'Excise', b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) excise_amt,
201: sum(decode(b.tax_type, 'Addl. Excise', b.tax_amount * nvl(c.mod_cr_percentage, 0), 'CVD', b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) additional_excise_amt,
202: sum(decode(b.tax_type, jai_constants.tax_type_add_cvd, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) additional_cvd , /*Changed by SACSETHI for the bug 5228046 -Additional CVD Enhancement*/
203: sum(decode(b.tax_type, 'Other Excise', b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) other_excise_amt,
204: sum(decode(b.tax_type, jai_constants.tax_type_exc_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) excise_edu_cess_amt,
205: sum(decode(b.tax_type, jai_constants.tax_type_cvd_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) cvd_edu_cess_amt ,
206: sum(decode(b.tax_type, jai_constants.tax_type_sh_exc_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) sh_excise_edu_cess_amt, -- Date 16/04/2007 by

Line 204: sum(decode(b.tax_type, jai_constants.tax_type_exc_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) excise_edu_cess_amt,

200: sum(decode(b.tax_type, 'Excise', b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) excise_amt,
201: sum(decode(b.tax_type, 'Addl. Excise', b.tax_amount * nvl(c.mod_cr_percentage, 0), 'CVD', b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) additional_excise_amt,
202: sum(decode(b.tax_type, jai_constants.tax_type_add_cvd, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) additional_cvd , /*Changed by SACSETHI for the bug 5228046 -Additional CVD Enhancement*/
203: sum(decode(b.tax_type, 'Other Excise', b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) other_excise_amt,
204: sum(decode(b.tax_type, jai_constants.tax_type_exc_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) excise_edu_cess_amt,
205: sum(decode(b.tax_type, jai_constants.tax_type_cvd_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) cvd_edu_cess_amt ,
206: sum(decode(b.tax_type, jai_constants.tax_type_sh_exc_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) sh_excise_edu_cess_amt, -- Date 16/04/2007 by
207: sum(decode(b.tax_type, jai_constants.tax_type_sh_cvd_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) sh_cvd_edu_cess_amt -- sacsethi for Bug#5989740
208: FROM JAI_RCV_LINE_TAXES b, JAI_CMN_TAXES_ALL c

Line 205: sum(decode(b.tax_type, jai_constants.tax_type_cvd_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) cvd_edu_cess_amt ,

201: sum(decode(b.tax_type, 'Addl. Excise', b.tax_amount * nvl(c.mod_cr_percentage, 0), 'CVD', b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) additional_excise_amt,
202: sum(decode(b.tax_type, jai_constants.tax_type_add_cvd, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) additional_cvd , /*Changed by SACSETHI for the bug 5228046 -Additional CVD Enhancement*/
203: sum(decode(b.tax_type, 'Other Excise', b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) other_excise_amt,
204: sum(decode(b.tax_type, jai_constants.tax_type_exc_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) excise_edu_cess_amt,
205: sum(decode(b.tax_type, jai_constants.tax_type_cvd_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) cvd_edu_cess_amt ,
206: sum(decode(b.tax_type, jai_constants.tax_type_sh_exc_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) sh_excise_edu_cess_amt, -- Date 16/04/2007 by
207: sum(decode(b.tax_type, jai_constants.tax_type_sh_cvd_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) sh_cvd_edu_cess_amt -- sacsethi for Bug#5989740
208: FROM JAI_RCV_LINE_TAXES b, JAI_CMN_TAXES_ALL c
209: WHERE b.shipment_line_id = cp_shipment_line_id

Line 206: sum(decode(b.tax_type, jai_constants.tax_type_sh_exc_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) sh_excise_edu_cess_amt, -- Date 16/04/2007 by

202: sum(decode(b.tax_type, jai_constants.tax_type_add_cvd, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) additional_cvd , /*Changed by SACSETHI for the bug 5228046 -Additional CVD Enhancement*/
203: sum(decode(b.tax_type, 'Other Excise', b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) other_excise_amt,
204: sum(decode(b.tax_type, jai_constants.tax_type_exc_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) excise_edu_cess_amt,
205: sum(decode(b.tax_type, jai_constants.tax_type_cvd_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) cvd_edu_cess_amt ,
206: sum(decode(b.tax_type, jai_constants.tax_type_sh_exc_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) sh_excise_edu_cess_amt, -- Date 16/04/2007 by
207: sum(decode(b.tax_type, jai_constants.tax_type_sh_cvd_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) sh_cvd_edu_cess_amt -- sacsethi for Bug#5989740
208: FROM JAI_RCV_LINE_TAXES b, JAI_CMN_TAXES_ALL c
209: WHERE b.shipment_line_id = cp_shipment_line_id
210: AND b.tax_id = c.tax_id

Line 207: sum(decode(b.tax_type, jai_constants.tax_type_sh_cvd_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) sh_cvd_edu_cess_amt -- sacsethi for Bug#5989740

203: sum(decode(b.tax_type, 'Other Excise', b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) other_excise_amt,
204: sum(decode(b.tax_type, jai_constants.tax_type_exc_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) excise_edu_cess_amt,
205: sum(decode(b.tax_type, jai_constants.tax_type_cvd_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) cvd_edu_cess_amt ,
206: sum(decode(b.tax_type, jai_constants.tax_type_sh_exc_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) sh_excise_edu_cess_amt, -- Date 16/04/2007 by
207: sum(decode(b.tax_type, jai_constants.tax_type_sh_cvd_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) sh_cvd_edu_cess_amt -- sacsethi for Bug#5989740
208: FROM JAI_RCV_LINE_TAXES b, JAI_CMN_TAXES_ALL c
209: WHERE b.shipment_line_id = cp_shipment_line_id
210: AND b.tax_id = c.tax_id
211: AND b.tax_type IN (jai_constants.tax_type_excise, jai_constants.tax_type_exc_additional, jai_constants.tax_type_exc_other,

Line 211: AND b.tax_type IN (jai_constants.tax_type_excise, jai_constants.tax_type_exc_additional, jai_constants.tax_type_exc_other,

207: sum(decode(b.tax_type, jai_constants.tax_type_sh_cvd_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) sh_cvd_edu_cess_amt -- sacsethi for Bug#5989740
208: FROM JAI_RCV_LINE_TAXES b, JAI_CMN_TAXES_ALL c
209: WHERE b.shipment_line_id = cp_shipment_line_id
210: AND b.tax_id = c.tax_id
211: AND b.tax_type IN (jai_constants.tax_type_excise, jai_constants.tax_type_exc_additional, jai_constants.tax_type_exc_other,
212: jai_constants.tax_type_cvd, jai_constants.tax_type_exc_edu_cess, jai_constants.tax_type_cvd_edu_cess ,
213: jai_constants.tax_type_sh_exc_edu_cess, jai_constants.tax_type_sh_cvd_edu_cess -- Date 16/04/2007 by sacsethi for Bug#5989740
214: )
215: --AND b.tax_type IN ('Excise', 'Addl. Excise', 'Other Excise', 'CVD', jai_constants.tax_type_exc_edu_cess, jai_constants.tax_type_cvd_edu_cess)

Line 212: jai_constants.tax_type_cvd, jai_constants.tax_type_exc_edu_cess, jai_constants.tax_type_cvd_edu_cess ,

208: FROM JAI_RCV_LINE_TAXES b, JAI_CMN_TAXES_ALL c
209: WHERE b.shipment_line_id = cp_shipment_line_id
210: AND b.tax_id = c.tax_id
211: AND b.tax_type IN (jai_constants.tax_type_excise, jai_constants.tax_type_exc_additional, jai_constants.tax_type_exc_other,
212: jai_constants.tax_type_cvd, jai_constants.tax_type_exc_edu_cess, jai_constants.tax_type_cvd_edu_cess ,
213: jai_constants.tax_type_sh_exc_edu_cess, jai_constants.tax_type_sh_cvd_edu_cess -- Date 16/04/2007 by sacsethi for Bug#5989740
214: )
215: --AND b.tax_type IN ('Excise', 'Addl. Excise', 'Other Excise', 'CVD', jai_constants.tax_type_exc_edu_cess, jai_constants.tax_type_cvd_edu_cess)
216: AND b.modvat_flag = 'Y';

Line 213: jai_constants.tax_type_sh_exc_edu_cess, jai_constants.tax_type_sh_cvd_edu_cess -- Date 16/04/2007 by sacsethi for Bug#5989740

209: WHERE b.shipment_line_id = cp_shipment_line_id
210: AND b.tax_id = c.tax_id
211: AND b.tax_type IN (jai_constants.tax_type_excise, jai_constants.tax_type_exc_additional, jai_constants.tax_type_exc_other,
212: jai_constants.tax_type_cvd, jai_constants.tax_type_exc_edu_cess, jai_constants.tax_type_cvd_edu_cess ,
213: jai_constants.tax_type_sh_exc_edu_cess, jai_constants.tax_type_sh_cvd_edu_cess -- Date 16/04/2007 by sacsethi for Bug#5989740
214: )
215: --AND b.tax_type IN ('Excise', 'Addl. Excise', 'Other Excise', 'CVD', jai_constants.tax_type_exc_edu_cess, jai_constants.tax_type_cvd_edu_cess)
216: AND b.modvat_flag = 'Y';
217:

Line 215: --AND b.tax_type IN ('Excise', 'Addl. Excise', 'Other Excise', 'CVD', jai_constants.tax_type_exc_edu_cess, jai_constants.tax_type_cvd_edu_cess)

211: AND b.tax_type IN (jai_constants.tax_type_excise, jai_constants.tax_type_exc_additional, jai_constants.tax_type_exc_other,
212: jai_constants.tax_type_cvd, jai_constants.tax_type_exc_edu_cess, jai_constants.tax_type_cvd_edu_cess ,
213: jai_constants.tax_type_sh_exc_edu_cess, jai_constants.tax_type_sh_cvd_edu_cess -- Date 16/04/2007 by sacsethi for Bug#5989740
214: )
215: --AND b.tax_type IN ('Excise', 'Addl. Excise', 'Other Excise', 'CVD', jai_constants.tax_type_exc_edu_cess, jai_constants.tax_type_cvd_edu_cess)
216: AND b.modvat_flag = 'Y';
217:
218: v_already_rounded_chk NUMBER;
219: v_excise_inv_rnd_cnt NUMBER;

Line 1278: SELECT DECODE(i, 1, jai_constants.tax_type_exc_edu_cess, 2, jai_constants.tax_type_cvd_edu_cess) tax_type,

1274:
1275: FOR I in 1..4 LOOP -- Date 16/04/2007 by sacsethi for Bug#5989740
1276:
1277: /* Vijay Shankar for Bug#4103161
1278: SELECT DECODE(i, 1, jai_constants.tax_type_exc_edu_cess, 2, jai_constants.tax_type_cvd_edu_cess) tax_type,
1279: DECODE(i, 1, v_rounded_dr_oth_amount.excise_edu_cess, 2, v_rounded_dr_oth_amount.cvd_edu_cess) dr_cess_amount,
1280: DECODE(i, 1, v_rounded_cr_oth_amount.excise_edu_cess, 2, v_rounded_cr_oth_amount.cvd_edu_cess) cr_cess_amount
1281: INTO v_tax_type, v_dr_amt, v_cr_amt
1282: FROM dual;

Line 1286: v_tax_type := jai_constants.tax_type_exc_edu_cess;

1282: FROM dual;
1283: */
1284:
1285: if i = 1 then
1286: v_tax_type := jai_constants.tax_type_exc_edu_cess;
1287: v_dr_amt := v_rounded_dr_oth_amount.excise_edu_cess;
1288: v_cr_amt := v_rounded_cr_oth_amount.excise_edu_cess;
1289: elsif i = 2 then
1290: v_tax_type := jai_constants.tax_type_cvd_edu_cess;

Line 1290: v_tax_type := jai_constants.tax_type_cvd_edu_cess;

1286: v_tax_type := jai_constants.tax_type_exc_edu_cess;
1287: v_dr_amt := v_rounded_dr_oth_amount.excise_edu_cess;
1288: v_cr_amt := v_rounded_cr_oth_amount.excise_edu_cess;
1289: elsif i = 2 then
1290: v_tax_type := jai_constants.tax_type_cvd_edu_cess;
1291: v_dr_amt := v_rounded_dr_oth_amount.cvd_edu_cess;
1292: v_cr_amt := v_rounded_cr_oth_amount.cvd_edu_cess;
1293: -- Date 16/04/2007 by sacsethi for Bug#5989740
1294: elsif i = 3 then

Line 1295: v_tax_type := jai_constants.tax_type_sh_exc_edu_cess;

1291: v_dr_amt := v_rounded_dr_oth_amount.cvd_edu_cess;
1292: v_cr_amt := v_rounded_cr_oth_amount.cvd_edu_cess;
1293: -- Date 16/04/2007 by sacsethi for Bug#5989740
1294: elsif i = 3 then
1295: v_tax_type := jai_constants.tax_type_sh_exc_edu_cess;
1296: v_dr_amt := v_rounded_dr_oth_amount.sh_excise_edu_cess;
1297: v_cr_amt := v_rounded_cr_oth_amount.sh_excise_edu_cess;
1298: elsif i = 4 then
1299: v_tax_type := jai_constants.tax_type_sh_cvd_edu_cess;

Line 1299: v_tax_type := jai_constants.tax_type_sh_cvd_edu_cess;

1295: v_tax_type := jai_constants.tax_type_sh_exc_edu_cess;
1296: v_dr_amt := v_rounded_dr_oth_amount.sh_excise_edu_cess;
1297: v_cr_amt := v_rounded_cr_oth_amount.sh_excise_edu_cess;
1298: elsif i = 4 then
1299: v_tax_type := jai_constants.tax_type_sh_cvd_edu_cess;
1300: v_dr_amt := v_rounded_dr_oth_amount.sh_cvd_edu_cess;
1301: v_cr_amt := v_rounded_cr_oth_amount.sh_cvd_edu_cess;
1302: -- end 5989740
1303: end if;

Line 2072: sum(decode(upper(b.tax_type), jai_constants.tax_type_add_cvd, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) additional_cvd,/5228046 Addtional cvd Enhancement/

2068: SELECT --Added the 6 columns by Sanjikum for Bug #4049363
2069: sum(decode(upper(b.tax_type), 'EXCISE', b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) excise_amt,
2070: sum(decode(upper(b.tax_type), 'ADDL. EXCISE', b.tax_amount * nvl(c.mod_cr_percentage, 0),
2071: 'CVD', b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) additional_excise_amt,
2072: sum(decode(upper(b.tax_type), jai_constants.tax_type_add_cvd, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) additional_cvd,/*5228046 Addtional cvd Enhancement*/
2073: sum(decode(upper(b.tax_type), 'OTHER EXCISE', b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) other_excise_amt,
2074: sum(decode(b.tax_type, jai_constants.tax_type_exc_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) excise_edu_cess_amt,
2075: sum(decode(b.tax_type, jai_constants.tax_type_cvd_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) cvd_edu_cess_amt ,
2076: sum(decode(b.tax_type, jai_constants.tax_type_sh_exc_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) sh_excise_edu_cess_amt, -- Date 16/04/2007 by sacsethi for Bug#5989740

Line 2074: sum(decode(b.tax_type, jai_constants.tax_type_exc_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) excise_edu_cess_amt,

2070: sum(decode(upper(b.tax_type), 'ADDL. EXCISE', b.tax_amount * nvl(c.mod_cr_percentage, 0),
2071: 'CVD', b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) additional_excise_amt,
2072: sum(decode(upper(b.tax_type), jai_constants.tax_type_add_cvd, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) additional_cvd,/*5228046 Addtional cvd Enhancement*/
2073: sum(decode(upper(b.tax_type), 'OTHER EXCISE', b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) other_excise_amt,
2074: sum(decode(b.tax_type, jai_constants.tax_type_exc_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) excise_edu_cess_amt,
2075: sum(decode(b.tax_type, jai_constants.tax_type_cvd_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) cvd_edu_cess_amt ,
2076: sum(decode(b.tax_type, jai_constants.tax_type_sh_exc_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) sh_excise_edu_cess_amt, -- Date 16/04/2007 by sacsethi for Bug#5989740
2077: sum(decode(b.tax_type, jai_constants.tax_type_sh_cvd_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) sh_cvd_edu_cess_amt
2078: FROM JAI_RCV_LINE_TAXES b, JAI_CMN_TAXES_ALL c

Line 2075: sum(decode(b.tax_type, jai_constants.tax_type_cvd_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) cvd_edu_cess_amt ,

2071: 'CVD', b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) additional_excise_amt,
2072: sum(decode(upper(b.tax_type), jai_constants.tax_type_add_cvd, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) additional_cvd,/*5228046 Addtional cvd Enhancement*/
2073: sum(decode(upper(b.tax_type), 'OTHER EXCISE', b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) other_excise_amt,
2074: sum(decode(b.tax_type, jai_constants.tax_type_exc_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) excise_edu_cess_amt,
2075: sum(decode(b.tax_type, jai_constants.tax_type_cvd_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) cvd_edu_cess_amt ,
2076: sum(decode(b.tax_type, jai_constants.tax_type_sh_exc_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) sh_excise_edu_cess_amt, -- Date 16/04/2007 by sacsethi for Bug#5989740
2077: sum(decode(b.tax_type, jai_constants.tax_type_sh_cvd_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) sh_cvd_edu_cess_amt
2078: FROM JAI_RCV_LINE_TAXES b, JAI_CMN_TAXES_ALL c
2079: WHERE b.shipment_line_id = cp_shipment_line_id

Line 2076: sum(decode(b.tax_type, jai_constants.tax_type_sh_exc_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) sh_excise_edu_cess_amt, -- Date 16/04/2007 by sacsethi for Bug#5989740

2072: sum(decode(upper(b.tax_type), jai_constants.tax_type_add_cvd, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) additional_cvd,/*5228046 Addtional cvd Enhancement*/
2073: sum(decode(upper(b.tax_type), 'OTHER EXCISE', b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) other_excise_amt,
2074: sum(decode(b.tax_type, jai_constants.tax_type_exc_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) excise_edu_cess_amt,
2075: sum(decode(b.tax_type, jai_constants.tax_type_cvd_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) cvd_edu_cess_amt ,
2076: sum(decode(b.tax_type, jai_constants.tax_type_sh_exc_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) sh_excise_edu_cess_amt, -- Date 16/04/2007 by sacsethi for Bug#5989740
2077: sum(decode(b.tax_type, jai_constants.tax_type_sh_cvd_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) sh_cvd_edu_cess_amt
2078: FROM JAI_RCV_LINE_TAXES b, JAI_CMN_TAXES_ALL c
2079: WHERE b.shipment_line_id = cp_shipment_line_id
2080: AND b.tax_id = c.tax_id

Line 2077: sum(decode(b.tax_type, jai_constants.tax_type_sh_cvd_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) sh_cvd_edu_cess_amt

2073: sum(decode(upper(b.tax_type), 'OTHER EXCISE', b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) other_excise_amt,
2074: sum(decode(b.tax_type, jai_constants.tax_type_exc_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) excise_edu_cess_amt,
2075: sum(decode(b.tax_type, jai_constants.tax_type_cvd_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) cvd_edu_cess_amt ,
2076: sum(decode(b.tax_type, jai_constants.tax_type_sh_exc_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) sh_excise_edu_cess_amt, -- Date 16/04/2007 by sacsethi for Bug#5989740
2077: sum(decode(b.tax_type, jai_constants.tax_type_sh_cvd_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) sh_cvd_edu_cess_amt
2078: FROM JAI_RCV_LINE_TAXES b, JAI_CMN_TAXES_ALL c
2079: WHERE b.shipment_line_id = cp_shipment_line_id
2080: AND b.tax_id = c.tax_id
2081: AND upper(b.tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',JAI_CONSTANTS.tax_type_add_cvd,

Line 2081: AND upper(b.tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',JAI_CONSTANTS.tax_type_add_cvd,

2077: sum(decode(b.tax_type, jai_constants.tax_type_sh_cvd_edu_cess, b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) sh_cvd_edu_cess_amt
2078: FROM JAI_RCV_LINE_TAXES b, JAI_CMN_TAXES_ALL c
2079: WHERE b.shipment_line_id = cp_shipment_line_id
2080: AND b.tax_id = c.tax_id
2081: AND upper(b.tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',JAI_CONSTANTS.tax_type_add_cvd,
2082: jai_constants.tax_type_exc_edu_cess, jai_constants.tax_type_cvd_edu_cess,
2083: jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess -- Date 16/04/2007 by sacsethi for Bug#5989740
2084: )
2085: AND b.modvat_flag = 'Y';

Line 2082: jai_constants.tax_type_exc_edu_cess, jai_constants.tax_type_cvd_edu_cess,

2078: FROM JAI_RCV_LINE_TAXES b, JAI_CMN_TAXES_ALL c
2079: WHERE b.shipment_line_id = cp_shipment_line_id
2080: AND b.tax_id = c.tax_id
2081: AND upper(b.tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',JAI_CONSTANTS.tax_type_add_cvd,
2082: jai_constants.tax_type_exc_edu_cess, jai_constants.tax_type_cvd_edu_cess,
2083: jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess -- Date 16/04/2007 by sacsethi for Bug#5989740
2084: )
2085: AND b.modvat_flag = 'Y';
2086:

Line 2083: jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess -- Date 16/04/2007 by sacsethi for Bug#5989740

2079: WHERE b.shipment_line_id = cp_shipment_line_id
2080: AND b.tax_id = c.tax_id
2081: AND upper(b.tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',JAI_CONSTANTS.tax_type_add_cvd,
2082: jai_constants.tax_type_exc_edu_cess, jai_constants.tax_type_cvd_edu_cess,
2083: jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess -- Date 16/04/2007 by sacsethi for Bug#5989740
2084: )
2085: AND b.modvat_flag = 'Y';
2086:
2087: v_already_rounded_chk NUMBER;

Line 2205: nvl(sum( decode(c.tax_type, jai_constants.tax_type_sh_exc_edu_cess, c.credit, 0)), 0) cr_sh_exc_edu_cess, -- Date 16/04/2007 by sacsethi for Bug#5989740

2201: nvl(sum(a.dr_additional_cvd),0) dr_additional_cvd,/*5228046 Addtional cvd Enhancement*/
2202: nvl(sum(a.dr_other_ed), 0) dr_other_ed,
2203: nvl(sum( decode(c.tax_type, 'EXCISE_EDUCATION_CESS', c.credit, 0)), 0) cr_exc_edu_cess,
2204: nvl(sum( decode(c.tax_type, 'CVD_EDUCATION_CESS', c.credit, 0)), 0) cr_cvd_edu_cess,
2205: nvl(sum( decode(c.tax_type, jai_constants.tax_type_sh_exc_edu_cess, c.credit, 0)), 0) cr_sh_exc_edu_cess, -- Date 16/04/2007 by sacsethi for Bug#5989740
2206: nvl(sum( decode(c.tax_type, jai_constants.tax_type_sh_cvd_edu_cess, c.credit, 0)), 0) cr_sh_cvd_edu_cess,
2207: nvl(sum( decode(c.tax_type, 'EXCISE_EDUCATION_CESS', c.debit, 0)), 0) dr_exc_edu_cess,
2208: nvl(sum( decode(c.tax_type, 'CVD_EDUCATION_CESS', c.debit, 0)), 0) dr_cvd_edu_cess,
2209: nvl(sum( decode(c.tax_type, jai_constants.tax_type_sh_exc_edu_cess, c.debit, 0)), 0) dr_sh_exc_edu_cess, -- Date 16/04/2007 by sacsethi for Bug#5989740

Line 2206: nvl(sum( decode(c.tax_type, jai_constants.tax_type_sh_cvd_edu_cess, c.credit, 0)), 0) cr_sh_cvd_edu_cess,

2202: nvl(sum(a.dr_other_ed), 0) dr_other_ed,
2203: nvl(sum( decode(c.tax_type, 'EXCISE_EDUCATION_CESS', c.credit, 0)), 0) cr_exc_edu_cess,
2204: nvl(sum( decode(c.tax_type, 'CVD_EDUCATION_CESS', c.credit, 0)), 0) cr_cvd_edu_cess,
2205: nvl(sum( decode(c.tax_type, jai_constants.tax_type_sh_exc_edu_cess, c.credit, 0)), 0) cr_sh_exc_edu_cess, -- Date 16/04/2007 by sacsethi for Bug#5989740
2206: nvl(sum( decode(c.tax_type, jai_constants.tax_type_sh_cvd_edu_cess, c.credit, 0)), 0) cr_sh_cvd_edu_cess,
2207: nvl(sum( decode(c.tax_type, 'EXCISE_EDUCATION_CESS', c.debit, 0)), 0) dr_exc_edu_cess,
2208: nvl(sum( decode(c.tax_type, 'CVD_EDUCATION_CESS', c.debit, 0)), 0) dr_cvd_edu_cess,
2209: nvl(sum( decode(c.tax_type, jai_constants.tax_type_sh_exc_edu_cess, c.debit, 0)), 0) dr_sh_exc_edu_cess, -- Date 16/04/2007 by sacsethi for Bug#5989740
2210: nvl(sum( decode(c.tax_type, jai_constants.tax_type_sh_cvd_edu_cess, c.debit, 0)), 0) dr_sh_cvd_edu_cess,

Line 2209: nvl(sum( decode(c.tax_type, jai_constants.tax_type_sh_exc_edu_cess, c.debit, 0)), 0) dr_sh_exc_edu_cess, -- Date 16/04/2007 by sacsethi for Bug#5989740

2205: nvl(sum( decode(c.tax_type, jai_constants.tax_type_sh_exc_edu_cess, c.credit, 0)), 0) cr_sh_exc_edu_cess, -- Date 16/04/2007 by sacsethi for Bug#5989740
2206: nvl(sum( decode(c.tax_type, jai_constants.tax_type_sh_cvd_edu_cess, c.credit, 0)), 0) cr_sh_cvd_edu_cess,
2207: nvl(sum( decode(c.tax_type, 'EXCISE_EDUCATION_CESS', c.debit, 0)), 0) dr_exc_edu_cess,
2208: nvl(sum( decode(c.tax_type, 'CVD_EDUCATION_CESS', c.debit, 0)), 0) dr_cvd_edu_cess,
2209: nvl(sum( decode(c.tax_type, jai_constants.tax_type_sh_exc_edu_cess, c.debit, 0)), 0) dr_sh_exc_edu_cess, -- Date 16/04/2007 by sacsethi for Bug#5989740
2210: nvl(sum( decode(c.tax_type, jai_constants.tax_type_sh_cvd_edu_cess, c.debit, 0)), 0) dr_sh_cvd_edu_cess,
2211: null transaction_date
2212: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. from JAI_CMN_RG_23AC_II_TRXS a, rcv_transactions b, JAI_CMN_RG_OTHERS c
2213: from JAI_CMN_RG_23AC_II_TRXS a, JAI_RCV_TRANSACTIONS b, JAI_CMN_RG_OTHERS c

Line 2210: nvl(sum( decode(c.tax_type, jai_constants.tax_type_sh_cvd_edu_cess, c.debit, 0)), 0) dr_sh_cvd_edu_cess,

2206: nvl(sum( decode(c.tax_type, jai_constants.tax_type_sh_cvd_edu_cess, c.credit, 0)), 0) cr_sh_cvd_edu_cess,
2207: nvl(sum( decode(c.tax_type, 'EXCISE_EDUCATION_CESS', c.debit, 0)), 0) dr_exc_edu_cess,
2208: nvl(sum( decode(c.tax_type, 'CVD_EDUCATION_CESS', c.debit, 0)), 0) dr_cvd_edu_cess,
2209: nvl(sum( decode(c.tax_type, jai_constants.tax_type_sh_exc_edu_cess, c.debit, 0)), 0) dr_sh_exc_edu_cess, -- Date 16/04/2007 by sacsethi for Bug#5989740
2210: nvl(sum( decode(c.tax_type, jai_constants.tax_type_sh_cvd_edu_cess, c.debit, 0)), 0) dr_sh_cvd_edu_cess,
2211: null transaction_date
2212: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. from JAI_CMN_RG_23AC_II_TRXS a, rcv_transactions b, JAI_CMN_RG_OTHERS c
2213: from JAI_CMN_RG_23AC_II_TRXS a, JAI_RCV_TRANSACTIONS b, JAI_CMN_RG_OTHERS c
2214: where a.RECEIPT_REF = b.transaction_id

Line 2961: v_tax_type := jai_constants.tax_type_exc_edu_cess;

2957: BEGIN
2958: FOR I in 1..4 LOOP -- Date 16/04/2007 by sacsethi for Bug#5989740 changed the loop counter from 2 to 4
2959:
2960: if i = 1 then
2961: v_tax_type := jai_constants.tax_type_exc_edu_cess;
2962: v_dr_amt := v_rounded_dr_oth_amount.excise_edu_cess;
2963: v_cr_amt := v_rounded_cr_oth_amount.excise_edu_cess;
2964: elsif i = 2 then
2965: v_tax_type := jai_constants.tax_type_cvd_edu_cess;

Line 2965: v_tax_type := jai_constants.tax_type_cvd_edu_cess;

2961: v_tax_type := jai_constants.tax_type_exc_edu_cess;
2962: v_dr_amt := v_rounded_dr_oth_amount.excise_edu_cess;
2963: v_cr_amt := v_rounded_cr_oth_amount.excise_edu_cess;
2964: elsif i = 2 then
2965: v_tax_type := jai_constants.tax_type_cvd_edu_cess;
2966: v_dr_amt := v_rounded_dr_oth_amount.cvd_edu_cess;
2967: v_cr_amt := v_rounded_cr_oth_amount.cvd_edu_cess;
2968: -- Date 16/04/2007 by sacsethi for Bug#5989740
2969: -- start 5989740

Line 2971: v_tax_type := jai_constants.tax_type_sh_exc_edu_cess;

2967: v_cr_amt := v_rounded_cr_oth_amount.cvd_edu_cess;
2968: -- Date 16/04/2007 by sacsethi for Bug#5989740
2969: -- start 5989740
2970: elsif i = 3 then
2971: v_tax_type := jai_constants.tax_type_sh_exc_edu_cess;
2972: v_dr_amt := v_rounded_dr_oth_amount.sh_excise_edu_cess;
2973: v_cr_amt := v_rounded_cr_oth_amount.sh_excise_edu_cess;
2974: elsif i = 4 then
2975: v_tax_type := jai_constants.tax_type_sh_cvd_edu_cess;

Line 2975: v_tax_type := jai_constants.tax_type_sh_cvd_edu_cess;

2971: v_tax_type := jai_constants.tax_type_sh_exc_edu_cess;
2972: v_dr_amt := v_rounded_dr_oth_amount.sh_excise_edu_cess;
2973: v_cr_amt := v_rounded_cr_oth_amount.sh_excise_edu_cess;
2974: elsif i = 4 then
2975: v_tax_type := jai_constants.tax_type_sh_cvd_edu_cess;
2976: v_dr_amt := v_rounded_dr_oth_amount.sh_cvd_edu_cess;
2977: v_cr_amt := v_rounded_cr_oth_amount.sh_cvd_edu_cess;
2978: -- end 5989740
2979: end if;