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 1277: SELECT DECODE(i, 1, jai_constants.tax_type_exc_edu_cess, 2, jai_constants.tax_type_cvd_edu_cess) tax_type,

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

Line 1285: v_tax_type := jai_constants.tax_type_exc_edu_cess;

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

Line 1289: v_tax_type := jai_constants.tax_type_cvd_edu_cess;

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

Line 1294: v_tax_type := jai_constants.tax_type_sh_exc_edu_cess;

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

Line 1298: v_tax_type := jai_constants.tax_type_sh_cvd_edu_cess;

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

Line 2071: 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/

2067: SELECT --Added the 6 columns by Sanjikum for Bug #4049363
2068: sum(decode(upper(b.tax_type), 'EXCISE', b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) excise_amt,
2069: sum(decode(upper(b.tax_type), 'ADDL. EXCISE', b.tax_amount * nvl(c.mod_cr_percentage, 0),
2070: 'CVD', b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) additional_excise_amt,
2071: 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*/
2072: sum(decode(upper(b.tax_type), 'OTHER EXCISE', b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) other_excise_amt,
2073: 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,
2074: 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 ,
2075: 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 2073: 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,

2069: sum(decode(upper(b.tax_type), 'ADDL. EXCISE', b.tax_amount * nvl(c.mod_cr_percentage, 0),
2070: 'CVD', b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) additional_excise_amt,
2071: 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*/
2072: sum(decode(upper(b.tax_type), 'OTHER EXCISE', b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) other_excise_amt,
2073: 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,
2074: 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 ,
2075: 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
2076: 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
2077: FROM JAI_RCV_LINE_TAXES b, JAI_CMN_TAXES_ALL c

Line 2074: 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 ,

2070: 'CVD', b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) additional_excise_amt,
2071: 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*/
2072: sum(decode(upper(b.tax_type), 'OTHER EXCISE', b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) other_excise_amt,
2073: 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,
2074: 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 ,
2075: 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
2076: 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
2077: FROM JAI_RCV_LINE_TAXES b, JAI_CMN_TAXES_ALL c
2078: WHERE b.shipment_line_id = cp_shipment_line_id

Line 2075: 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

2071: 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*/
2072: sum(decode(upper(b.tax_type), 'OTHER EXCISE', b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) other_excise_amt,
2073: 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,
2074: 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 ,
2075: 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
2076: 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
2077: FROM JAI_RCV_LINE_TAXES b, JAI_CMN_TAXES_ALL c
2078: WHERE b.shipment_line_id = cp_shipment_line_id
2079: AND b.tax_id = c.tax_id

Line 2076: 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

2072: sum(decode(upper(b.tax_type), 'OTHER EXCISE', b.tax_amount * nvl(c.mod_cr_percentage, 0), 0) /100) other_excise_amt,
2073: 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,
2074: 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 ,
2075: 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
2076: 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
2077: FROM JAI_RCV_LINE_TAXES b, JAI_CMN_TAXES_ALL c
2078: WHERE b.shipment_line_id = cp_shipment_line_id
2079: AND b.tax_id = c.tax_id
2080: AND upper(b.tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',JAI_CONSTANTS.tax_type_add_cvd,

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

2076: 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
2077: FROM JAI_RCV_LINE_TAXES b, JAI_CMN_TAXES_ALL c
2078: WHERE b.shipment_line_id = cp_shipment_line_id
2079: AND b.tax_id = c.tax_id
2080: AND upper(b.tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',JAI_CONSTANTS.tax_type_add_cvd,
2081: jai_constants.tax_type_exc_edu_cess, jai_constants.tax_type_cvd_edu_cess,
2082: 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
2083: )
2084: AND b.modvat_flag = 'Y';

Line 2081: jai_constants.tax_type_exc_edu_cess, jai_constants.tax_type_cvd_edu_cess,

2077: FROM JAI_RCV_LINE_TAXES b, JAI_CMN_TAXES_ALL c
2078: WHERE b.shipment_line_id = cp_shipment_line_id
2079: AND b.tax_id = c.tax_id
2080: AND upper(b.tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',JAI_CONSTANTS.tax_type_add_cvd,
2081: jai_constants.tax_type_exc_edu_cess, jai_constants.tax_type_cvd_edu_cess,
2082: 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
2083: )
2084: AND b.modvat_flag = 'Y';
2085:

Line 2082: 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

2078: WHERE b.shipment_line_id = cp_shipment_line_id
2079: AND b.tax_id = c.tax_id
2080: AND upper(b.tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',JAI_CONSTANTS.tax_type_add_cvd,
2081: jai_constants.tax_type_exc_edu_cess, jai_constants.tax_type_cvd_edu_cess,
2082: 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
2083: )
2084: AND b.modvat_flag = 'Y';
2085:
2086: v_already_rounded_chk NUMBER;

Line 2204: 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

2200: nvl(sum(a.dr_additional_cvd),0) dr_additional_cvd,/*5228046 Addtional cvd Enhancement*/
2201: nvl(sum(a.dr_other_ed), 0) dr_other_ed,
2202: nvl(sum( decode(c.tax_type, 'EXCISE_EDUCATION_CESS', c.credit, 0)), 0) cr_exc_edu_cess,
2203: nvl(sum( decode(c.tax_type, 'CVD_EDUCATION_CESS', c.credit, 0)), 0) cr_cvd_edu_cess,
2204: 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
2205: nvl(sum( decode(c.tax_type, jai_constants.tax_type_sh_cvd_edu_cess, c.credit, 0)), 0) cr_sh_cvd_edu_cess,
2206: nvl(sum( decode(c.tax_type, 'EXCISE_EDUCATION_CESS', c.debit, 0)), 0) dr_exc_edu_cess,
2207: nvl(sum( decode(c.tax_type, 'CVD_EDUCATION_CESS', c.debit, 0)), 0) dr_cvd_edu_cess,
2208: 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 2205: nvl(sum( decode(c.tax_type, jai_constants.tax_type_sh_cvd_edu_cess, c.credit, 0)), 0) cr_sh_cvd_edu_cess,

2201: nvl(sum(a.dr_other_ed), 0) dr_other_ed,
2202: nvl(sum( decode(c.tax_type, 'EXCISE_EDUCATION_CESS', c.credit, 0)), 0) cr_exc_edu_cess,
2203: nvl(sum( decode(c.tax_type, 'CVD_EDUCATION_CESS', c.credit, 0)), 0) cr_cvd_edu_cess,
2204: 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
2205: nvl(sum( decode(c.tax_type, jai_constants.tax_type_sh_cvd_edu_cess, c.credit, 0)), 0) cr_sh_cvd_edu_cess,
2206: nvl(sum( decode(c.tax_type, 'EXCISE_EDUCATION_CESS', c.debit, 0)), 0) dr_exc_edu_cess,
2207: nvl(sum( decode(c.tax_type, 'CVD_EDUCATION_CESS', c.debit, 0)), 0) dr_cvd_edu_cess,
2208: 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
2209: nvl(sum( decode(c.tax_type, jai_constants.tax_type_sh_cvd_edu_cess, c.debit, 0)), 0) dr_sh_cvd_edu_cess,

Line 2208: 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

2204: 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
2205: nvl(sum( decode(c.tax_type, jai_constants.tax_type_sh_cvd_edu_cess, c.credit, 0)), 0) cr_sh_cvd_edu_cess,
2206: nvl(sum( decode(c.tax_type, 'EXCISE_EDUCATION_CESS', c.debit, 0)), 0) dr_exc_edu_cess,
2207: nvl(sum( decode(c.tax_type, 'CVD_EDUCATION_CESS', c.debit, 0)), 0) dr_cvd_edu_cess,
2208: 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
2209: nvl(sum( decode(c.tax_type, jai_constants.tax_type_sh_cvd_edu_cess, c.debit, 0)), 0) dr_sh_cvd_edu_cess,
2210: null transaction_date
2211: -- 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
2212: from JAI_CMN_RG_23AC_II_TRXS a, JAI_RCV_TRANSACTIONS b, JAI_CMN_RG_OTHERS c

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

2205: nvl(sum( decode(c.tax_type, jai_constants.tax_type_sh_cvd_edu_cess, c.credit, 0)), 0) cr_sh_cvd_edu_cess,
2206: nvl(sum( decode(c.tax_type, 'EXCISE_EDUCATION_CESS', c.debit, 0)), 0) dr_exc_edu_cess,
2207: nvl(sum( decode(c.tax_type, 'CVD_EDUCATION_CESS', c.debit, 0)), 0) dr_cvd_edu_cess,
2208: 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
2209: nvl(sum( decode(c.tax_type, jai_constants.tax_type_sh_cvd_edu_cess, c.debit, 0)), 0) dr_sh_cvd_edu_cess,
2210: null transaction_date
2211: -- 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
2212: from JAI_CMN_RG_23AC_II_TRXS a, JAI_RCV_TRANSACTIONS b, JAI_CMN_RG_OTHERS c
2213: where a.RECEIPT_REF = b.transaction_id

Line 2958: v_tax_type := jai_constants.tax_type_exc_edu_cess;

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

Line 2962: v_tax_type := jai_constants.tax_type_cvd_edu_cess;

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

Line 2968: v_tax_type := jai_constants.tax_type_sh_exc_edu_cess;

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

Line 2972: v_tax_type := jai_constants.tax_type_sh_cvd_edu_cess;

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