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

Line 218: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI

214: ln_flag number; --0 indicate is not boe tax , 1 indicate belongs to boe tax.
215: BEGIN
216: if(UPPER(nvl(pv_tax_type,'###')) in
217: ('CVD',
218: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
219: 'CUSTOMS',
220: jai_constants.tax_type_cvd_Edu_cess,
221: jai_constants.tax_type_customs_edu_cess ,
222: jai_constants.tax_type_sh_customs_edu_cess, -- Date 18/06/2007 Bug 6130025 added by SACSETHI

Line 220: jai_constants.tax_type_cvd_Edu_cess,

216: if(UPPER(nvl(pv_tax_type,'###')) in
217: ('CVD',
218: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
219: 'CUSTOMS',
220: jai_constants.tax_type_cvd_Edu_cess,
221: jai_constants.tax_type_customs_edu_cess ,
222: jai_constants.tax_type_sh_customs_edu_cess, -- Date 18/06/2007 Bug 6130025 added by SACSETHI
223: jai_constants.tax_type_sh_cvd_edu_cess,
224: jai_constants.tax_type_boe_other1,

Line 221: jai_constants.tax_type_customs_edu_cess ,

217: ('CVD',
218: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
219: 'CUSTOMS',
220: jai_constants.tax_type_cvd_Edu_cess,
221: jai_constants.tax_type_customs_edu_cess ,
222: jai_constants.tax_type_sh_customs_edu_cess, -- Date 18/06/2007 Bug 6130025 added by SACSETHI
223: jai_constants.tax_type_sh_cvd_edu_cess,
224: jai_constants.tax_type_boe_other1,
225: jai_constants.tax_type_boe_other2,

Line 222: jai_constants.tax_type_sh_customs_edu_cess, -- Date 18/06/2007 Bug 6130025 added by SACSETHI

218: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
219: 'CUSTOMS',
220: jai_constants.tax_type_cvd_Edu_cess,
221: jai_constants.tax_type_customs_edu_cess ,
222: jai_constants.tax_type_sh_customs_edu_cess, -- Date 18/06/2007 Bug 6130025 added by SACSETHI
223: jai_constants.tax_type_sh_cvd_edu_cess,
224: jai_constants.tax_type_boe_other1,
225: jai_constants.tax_type_boe_other2,
226: jai_constants.tax_type_boe_other3,

Line 223: jai_constants.tax_type_sh_cvd_edu_cess,

219: 'CUSTOMS',
220: jai_constants.tax_type_cvd_Edu_cess,
221: jai_constants.tax_type_customs_edu_cess ,
222: jai_constants.tax_type_sh_customs_edu_cess, -- Date 18/06/2007 Bug 6130025 added by SACSETHI
223: jai_constants.tax_type_sh_cvd_edu_cess,
224: jai_constants.tax_type_boe_other1,
225: jai_constants.tax_type_boe_other2,
226: jai_constants.tax_type_boe_other3,
227: jai_constants.tax_type_boe_other4,

Line 224: jai_constants.tax_type_boe_other1,

220: jai_constants.tax_type_cvd_Edu_cess,
221: jai_constants.tax_type_customs_edu_cess ,
222: jai_constants.tax_type_sh_customs_edu_cess, -- Date 18/06/2007 Bug 6130025 added by SACSETHI
223: jai_constants.tax_type_sh_cvd_edu_cess,
224: jai_constants.tax_type_boe_other1,
225: jai_constants.tax_type_boe_other2,
226: jai_constants.tax_type_boe_other3,
227: jai_constants.tax_type_boe_other4,
228: jai_constants.tax_type_boe_other5,

Line 225: jai_constants.tax_type_boe_other2,

221: jai_constants.tax_type_customs_edu_cess ,
222: jai_constants.tax_type_sh_customs_edu_cess, -- Date 18/06/2007 Bug 6130025 added by SACSETHI
223: jai_constants.tax_type_sh_cvd_edu_cess,
224: jai_constants.tax_type_boe_other1,
225: jai_constants.tax_type_boe_other2,
226: jai_constants.tax_type_boe_other3,
227: jai_constants.tax_type_boe_other4,
228: jai_constants.tax_type_boe_other5,
229: jai_constants.tax_type_boe_surcharge_duty,

Line 226: jai_constants.tax_type_boe_other3,

222: jai_constants.tax_type_sh_customs_edu_cess, -- Date 18/06/2007 Bug 6130025 added by SACSETHI
223: jai_constants.tax_type_sh_cvd_edu_cess,
224: jai_constants.tax_type_boe_other1,
225: jai_constants.tax_type_boe_other2,
226: jai_constants.tax_type_boe_other3,
227: jai_constants.tax_type_boe_other4,
228: jai_constants.tax_type_boe_other5,
229: jai_constants.tax_type_boe_surcharge_duty,
230: jai_constants.tax_type_boe_add_customs))then

Line 227: jai_constants.tax_type_boe_other4,

223: jai_constants.tax_type_sh_cvd_edu_cess,
224: jai_constants.tax_type_boe_other1,
225: jai_constants.tax_type_boe_other2,
226: jai_constants.tax_type_boe_other3,
227: jai_constants.tax_type_boe_other4,
228: jai_constants.tax_type_boe_other5,
229: jai_constants.tax_type_boe_surcharge_duty,
230: jai_constants.tax_type_boe_add_customs))then
231: ln_flag := 1;

Line 228: jai_constants.tax_type_boe_other5,

224: jai_constants.tax_type_boe_other1,
225: jai_constants.tax_type_boe_other2,
226: jai_constants.tax_type_boe_other3,
227: jai_constants.tax_type_boe_other4,
228: jai_constants.tax_type_boe_other5,
229: jai_constants.tax_type_boe_surcharge_duty,
230: jai_constants.tax_type_boe_add_customs))then
231: ln_flag := 1;
232: else

Line 229: jai_constants.tax_type_boe_surcharge_duty,

225: jai_constants.tax_type_boe_other2,
226: jai_constants.tax_type_boe_other3,
227: jai_constants.tax_type_boe_other4,
228: jai_constants.tax_type_boe_other5,
229: jai_constants.tax_type_boe_surcharge_duty,
230: jai_constants.tax_type_boe_add_customs))then
231: ln_flag := 1;
232: else
233: ln_flag := 0;

Line 230: jai_constants.tax_type_boe_add_customs))then

226: jai_constants.tax_type_boe_other3,
227: jai_constants.tax_type_boe_other4,
228: jai_constants.tax_type_boe_other5,
229: jai_constants.tax_type_boe_surcharge_duty,
230: jai_constants.tax_type_boe_add_customs))then
231: ln_flag := 1;
232: else
233: ln_flag := 0;
234: end if;

Line 261: pv_override_manual_taxes IN VARCHAR2, -- DEFAULT 'N',--15 -- Use jai_constants.no in the call of this procedure. Ramananda for for File.Sql.35

257: p_document_no IN VARCHAR2, --11
258: p_release_no IN NUMBER, --12
259: p_document_line_no IN NUMBER, --13
260: p_shipment_no IN NUMBER, --14
261: pv_override_manual_taxes IN VARCHAR2, -- DEFAULT 'N',--15 -- Use jai_constants.no in the call of this procedure. Ramananda for for File.Sql.35
262: pn_commit_interval IN NUMBER, -- DEFAULT 50, --16 -- Added global variable gn_commit_interval in package spec. by Ramananda for File.Sql.35
263: pv_process_partial IN VARCHAR2, -- DEFAULT 'N', --17 -- Use jai_constants.no in the call of this procedure. Ramananda for for File.Sql.35
264: pv_debug IN VARCHAR2, -- DEFAULT 'N', --18 -- Use jai_constants.no in the call of this procedure. Ramananda for for File.Sql.35
265: pv_trace IN VARCHAR2 -- DEFAULT 'N' --19 -- Use jai_constants.no in the call of this procedure. Ramananda for for File.Sql.35

Line 263: pv_process_partial IN VARCHAR2, -- DEFAULT 'N', --17 -- Use jai_constants.no in the call of this procedure. Ramananda for for File.Sql.35

259: p_document_line_no IN NUMBER, --13
260: p_shipment_no IN NUMBER, --14
261: pv_override_manual_taxes IN VARCHAR2, -- DEFAULT 'N',--15 -- Use jai_constants.no in the call of this procedure. Ramananda for for File.Sql.35
262: pn_commit_interval IN NUMBER, -- DEFAULT 50, --16 -- Added global variable gn_commit_interval in package spec. by Ramananda for File.Sql.35
263: pv_process_partial IN VARCHAR2, -- DEFAULT 'N', --17 -- Use jai_constants.no in the call of this procedure. Ramananda for for File.Sql.35
264: pv_debug IN VARCHAR2, -- DEFAULT 'N', --18 -- Use jai_constants.no in the call of this procedure. Ramananda for for File.Sql.35
265: pv_trace IN VARCHAR2 -- DEFAULT 'N' --19 -- Use jai_constants.no in the call of this procedure. Ramananda for for File.Sql.35
266: ) IS
267:

Line 264: pv_debug IN VARCHAR2, -- DEFAULT 'N', --18 -- Use jai_constants.no in the call of this procedure. Ramananda for for File.Sql.35

260: p_shipment_no IN NUMBER, --14
261: pv_override_manual_taxes IN VARCHAR2, -- DEFAULT 'N',--15 -- Use jai_constants.no in the call of this procedure. Ramananda for for File.Sql.35
262: pn_commit_interval IN NUMBER, -- DEFAULT 50, --16 -- Added global variable gn_commit_interval in package spec. by Ramananda for File.Sql.35
263: pv_process_partial IN VARCHAR2, -- DEFAULT 'N', --17 -- Use jai_constants.no in the call of this procedure. Ramananda for for File.Sql.35
264: pv_debug IN VARCHAR2, -- DEFAULT 'N', --18 -- Use jai_constants.no in the call of this procedure. Ramananda for for File.Sql.35
265: pv_trace IN VARCHAR2 -- DEFAULT 'N' --19 -- Use jai_constants.no in the call of this procedure. Ramananda for for File.Sql.35
266: ) IS
267:
268: /* Ramananda for bug# 4336482 */

Line 265: pv_trace IN VARCHAR2 -- DEFAULT 'N' --19 -- Use jai_constants.no in the call of this procedure. Ramananda for for File.Sql.35

261: pv_override_manual_taxes IN VARCHAR2, -- DEFAULT 'N',--15 -- Use jai_constants.no in the call of this procedure. Ramananda for for File.Sql.35
262: pn_commit_interval IN NUMBER, -- DEFAULT 50, --16 -- Added global variable gn_commit_interval in package spec. by Ramananda for File.Sql.35
263: pv_process_partial IN VARCHAR2, -- DEFAULT 'N', --17 -- Use jai_constants.no in the call of this procedure. Ramananda for for File.Sql.35
264: pv_debug IN VARCHAR2, -- DEFAULT 'N', --18 -- Use jai_constants.no in the call of this procedure. Ramananda for for File.Sql.35
265: pv_trace IN VARCHAR2 -- DEFAULT 'N' --19 -- Use jai_constants.no in the call of this procedure. Ramananda for for File.Sql.35
266: ) IS
267:
268: /* Ramananda for bug# 4336482 */
269: p_from_date DATE; -- DEFAULT fnd_date.canonical_to_date(pv_from_date); --Ramananda for File.Sql.35

Line 472: -- DECODE(UPPER(b.tax_type), 'EXCISE', 1, 'ADDL. EXCISE', 1, 'OTHER EXCISE', 1, 'CVD', 1, jai_constants.tax_type_exc_edu_cess,1, 'TDS', 2, 0) tax_type_val,

468: a.precedence_8 p_8,
469: a.precedence_9 p_9,
470: a.precedence_10 p_10,
471: b.tax_rate, b.tax_amount, b.uom_code, b.end_date valid_date,
472: -- DECODE(UPPER(b.tax_type), 'EXCISE', 1, 'ADDL. EXCISE', 1, 'OTHER EXCISE', 1, 'CVD', 1, jai_constants.tax_type_exc_edu_cess,1, 'TDS', 2, 0) tax_type_val,
473: b.mod_cr_percentage, b.vendor_id, b.tax_type, nvl(b.rounding_factor,0) rounding_factor
474: from JAI_CMN_TAX_CTG_LINES a, JAI_CMN_TAXES_ALL b
475: WHERE a.tax_category_id = p_tax_category_id
476: AND a.tax_id = b.tax_id

Line 659: jai_constants.closed_code_open ,

655: AND (p_org_id IS NULL OR pha.org_id = p_org_id)
656: AND (plla.cancel_flag IS NULL OR plla.cancel_flag <> 'Y' )
657: AND trunc(plla.creation_date) BETWEEN p_from_date AND p_to_date
658: AND ( plla.closed_code IS NULL OR plla.closed_code IN (
659: jai_constants.closed_code_open ,
660: jai_constants.closed_code_inporcess ,
661: jai_constants.closed_code_approved ,
662: jai_constants.closed_code_preapproved ,
663: jai_constants.closed_code_req_appr ,

Line 660: jai_constants.closed_code_inporcess ,

656: AND (plla.cancel_flag IS NULL OR plla.cancel_flag <> 'Y' )
657: AND trunc(plla.creation_date) BETWEEN p_from_date AND p_to_date
658: AND ( plla.closed_code IS NULL OR plla.closed_code IN (
659: jai_constants.closed_code_open ,
660: jai_constants.closed_code_inporcess ,
661: jai_constants.closed_code_approved ,
662: jai_constants.closed_code_preapproved ,
663: jai_constants.closed_code_req_appr ,
664: jai_constants.closed_code_incomplete ))

Line 661: jai_constants.closed_code_approved ,

657: AND trunc(plla.creation_date) BETWEEN p_from_date AND p_to_date
658: AND ( plla.closed_code IS NULL OR plla.closed_code IN (
659: jai_constants.closed_code_open ,
660: jai_constants.closed_code_inporcess ,
661: jai_constants.closed_code_approved ,
662: jai_constants.closed_code_preapproved ,
663: jai_constants.closed_code_req_appr ,
664: jai_constants.closed_code_incomplete ))
665: --'OPEN', 'IN PROCESS', 'APPROVED', 'PRE-APPROVED', 'REQUIRES REAPPROVAL', 'INCOMPLETE') )

Line 662: jai_constants.closed_code_preapproved ,

658: AND ( plla.closed_code IS NULL OR plla.closed_code IN (
659: jai_constants.closed_code_open ,
660: jai_constants.closed_code_inporcess ,
661: jai_constants.closed_code_approved ,
662: jai_constants.closed_code_preapproved ,
663: jai_constants.closed_code_req_appr ,
664: jai_constants.closed_code_incomplete ))
665: --'OPEN', 'IN PROCESS', 'APPROVED', 'PRE-APPROVED', 'REQUIRES REAPPROVAL', 'INCOMPLETE') )
666: UNION -- if there are no base records in po_line_locations_all but JAI_PO_LINE_LOCATIONS have

Line 663: jai_constants.closed_code_req_appr ,

659: jai_constants.closed_code_open ,
660: jai_constants.closed_code_inporcess ,
661: jai_constants.closed_code_approved ,
662: jai_constants.closed_code_preapproved ,
663: jai_constants.closed_code_req_appr ,
664: jai_constants.closed_code_incomplete ))
665: --'OPEN', 'IN PROCESS', 'APPROVED', 'PRE-APPROVED', 'REQUIRES REAPPROVAL', 'INCOMPLETE') )
666: UNION -- if there are no base records in po_line_locations_all but JAI_PO_LINE_LOCATIONS have
667: SELECT 2 source, jipll.rowid,

Line 664: jai_constants.closed_code_incomplete ))

660: jai_constants.closed_code_inporcess ,
661: jai_constants.closed_code_approved ,
662: jai_constants.closed_code_preapproved ,
663: jai_constants.closed_code_req_appr ,
664: jai_constants.closed_code_incomplete ))
665: --'OPEN', 'IN PROCESS', 'APPROVED', 'PRE-APPROVED', 'REQUIRES REAPPROVAL', 'INCOMPLETE') )
666: UNION -- if there are no base records in po_line_locations_all but JAI_PO_LINE_LOCATIONS have
667: SELECT 2 source, jipll.rowid,
668: jipll.line_focus_id, jipll.line_location_id, jipll.po_line_id, jipll.po_header_id, jipll.tax_category_id,

Line 695: jai_constants.closed_code_open ,

691: AND (p_org_id IS NULL OR pha.org_id = p_org_id)
692: AND (pla.cancel_flag IS NULL OR pla.cancel_flag <> 'Y' )
693: AND trunc(pla.creation_date) BETWEEN p_from_date AND p_to_date
694: AND ( pla.closed_code IS NULL OR pla.closed_code IN (
695: jai_constants.closed_code_open ,
696: jai_constants.closed_code_inporcess ,
697: jai_constants.closed_code_approved ,
698: jai_constants.closed_code_preapproved ,
699: jai_constants.closed_code_req_appr ,

Line 696: jai_constants.closed_code_inporcess ,

692: AND (pla.cancel_flag IS NULL OR pla.cancel_flag <> 'Y' )
693: AND trunc(pla.creation_date) BETWEEN p_from_date AND p_to_date
694: AND ( pla.closed_code IS NULL OR pla.closed_code IN (
695: jai_constants.closed_code_open ,
696: jai_constants.closed_code_inporcess ,
697: jai_constants.closed_code_approved ,
698: jai_constants.closed_code_preapproved ,
699: jai_constants.closed_code_req_appr ,
700: jai_constants.closed_code_incomplete ))

Line 697: jai_constants.closed_code_approved ,

693: AND trunc(pla.creation_date) BETWEEN p_from_date AND p_to_date
694: AND ( pla.closed_code IS NULL OR pla.closed_code IN (
695: jai_constants.closed_code_open ,
696: jai_constants.closed_code_inporcess ,
697: jai_constants.closed_code_approved ,
698: jai_constants.closed_code_preapproved ,
699: jai_constants.closed_code_req_appr ,
700: jai_constants.closed_code_incomplete ))
701: --'OPEN', 'IN PROCESS', 'APPROVED', 'PRE-APPROVED', 'REQUIRES REAPPROVAL', 'INCOMPLETE') )

Line 698: jai_constants.closed_code_preapproved ,

694: AND ( pla.closed_code IS NULL OR pla.closed_code IN (
695: jai_constants.closed_code_open ,
696: jai_constants.closed_code_inporcess ,
697: jai_constants.closed_code_approved ,
698: jai_constants.closed_code_preapproved ,
699: jai_constants.closed_code_req_appr ,
700: jai_constants.closed_code_incomplete ))
701: --'OPEN', 'IN PROCESS', 'APPROVED', 'PRE-APPROVED', 'REQUIRES REAPPROVAL', 'INCOMPLETE') )
702: and (jipll.line_location_id IS NULL OR jipll.line_location_id = 0);

Line 699: jai_constants.closed_code_req_appr ,

695: jai_constants.closed_code_open ,
696: jai_constants.closed_code_inporcess ,
697: jai_constants.closed_code_approved ,
698: jai_constants.closed_code_preapproved ,
699: jai_constants.closed_code_req_appr ,
700: jai_constants.closed_code_incomplete ))
701: --'OPEN', 'IN PROCESS', 'APPROVED', 'PRE-APPROVED', 'REQUIRES REAPPROVAL', 'INCOMPLETE') )
702: and (jipll.line_location_id IS NULL OR jipll.line_location_id = 0);
703:

Line 700: jai_constants.closed_code_incomplete ))

696: jai_constants.closed_code_inporcess ,
697: jai_constants.closed_code_approved ,
698: jai_constants.closed_code_preapproved ,
699: jai_constants.closed_code_req_appr ,
700: jai_constants.closed_code_incomplete ))
701: --'OPEN', 'IN PROCESS', 'APPROVED', 'PRE-APPROVED', 'REQUIRES REAPPROVAL', 'INCOMPLETE') )
702: and (jipll.line_location_id IS NULL OR jipll.line_location_id = 0);
703:
704: /****************************************

Line 749: (jai_constants.closed_code_open ,

745: AND (p_org_id IS NULL OR plla.org_id = p_org_id)
746: AND (plla.cancel_flag IS NULL OR plla.cancel_flag <> 'Y' )
747: AND trunc(pra.creation_date) BETWEEN p_from_date AND p_to_date
748: AND ( plla.closed_code IS NULL OR plla.closed_code IN
749: (jai_constants.closed_code_open ,
750: jai_constants.closed_code_inporcess ,
751: jai_constants.closed_code_approved ,
752: jai_constants.closed_code_preapproved ,
753: jai_constants.closed_code_req_appr ,

Line 750: jai_constants.closed_code_inporcess ,

746: AND (plla.cancel_flag IS NULL OR plla.cancel_flag <> 'Y' )
747: AND trunc(pra.creation_date) BETWEEN p_from_date AND p_to_date
748: AND ( plla.closed_code IS NULL OR plla.closed_code IN
749: (jai_constants.closed_code_open ,
750: jai_constants.closed_code_inporcess ,
751: jai_constants.closed_code_approved ,
752: jai_constants.closed_code_preapproved ,
753: jai_constants.closed_code_req_appr ,
754: jai_constants.closed_code_incomplete ));

Line 751: jai_constants.closed_code_approved ,

747: AND trunc(pra.creation_date) BETWEEN p_from_date AND p_to_date
748: AND ( plla.closed_code IS NULL OR plla.closed_code IN
749: (jai_constants.closed_code_open ,
750: jai_constants.closed_code_inporcess ,
751: jai_constants.closed_code_approved ,
752: jai_constants.closed_code_preapproved ,
753: jai_constants.closed_code_req_appr ,
754: jai_constants.closed_code_incomplete ));
755: --'OPEN', 'IN PROCESS', 'APPROVED', 'PRE-APPROVED', 'REQUIRES REAPPROVAL', 'INCOMPLETE') );

Line 752: jai_constants.closed_code_preapproved ,

748: AND ( plla.closed_code IS NULL OR plla.closed_code IN
749: (jai_constants.closed_code_open ,
750: jai_constants.closed_code_inporcess ,
751: jai_constants.closed_code_approved ,
752: jai_constants.closed_code_preapproved ,
753: jai_constants.closed_code_req_appr ,
754: jai_constants.closed_code_incomplete ));
755: --'OPEN', 'IN PROCESS', 'APPROVED', 'PRE-APPROVED', 'REQUIRES REAPPROVAL', 'INCOMPLETE') );
756:

Line 753: jai_constants.closed_code_req_appr ,

749: (jai_constants.closed_code_open ,
750: jai_constants.closed_code_inporcess ,
751: jai_constants.closed_code_approved ,
752: jai_constants.closed_code_preapproved ,
753: jai_constants.closed_code_req_appr ,
754: jai_constants.closed_code_incomplete ));
755: --'OPEN', 'IN PROCESS', 'APPROVED', 'PRE-APPROVED', 'REQUIRES REAPPROVAL', 'INCOMPLETE') );
756:
757: /****************

Line 754: jai_constants.closed_code_incomplete ));

750: jai_constants.closed_code_inporcess ,
751: jai_constants.closed_code_approved ,
752: jai_constants.closed_code_preapproved ,
753: jai_constants.closed_code_req_appr ,
754: jai_constants.closed_code_incomplete ));
755: --'OPEN', 'IN PROCESS', 'APPROVED', 'PRE-APPROVED', 'REQUIRES REAPPROVAL', 'INCOMPLETE') );
756:
757: /****************
758: REQUISITIONS Cursor

Line 791: jai_constants.closed_code_open ,

787: AND (prla.cancel_flag IS NULL OR prla.cancel_flag <> 'Y' )
788: AND trunc(prla.creation_date) BETWEEN p_from_date AND p_to_date
789: AND ((prla.closed_date IS NULL) OR (prla.closed_date <= v_today))
790: AND ( prla.closed_code IS NULL OR prla.closed_code IN (
791: jai_constants.closed_code_open ,
792: jai_constants.closed_code_inporcess ,
793: jai_constants.closed_code_approved ,
794: jai_constants.closed_code_preapproved ,
795: jai_constants.closed_code_req_appr ,

Line 792: jai_constants.closed_code_inporcess ,

788: AND trunc(prla.creation_date) BETWEEN p_from_date AND p_to_date
789: AND ((prla.closed_date IS NULL) OR (prla.closed_date <= v_today))
790: AND ( prla.closed_code IS NULL OR prla.closed_code IN (
791: jai_constants.closed_code_open ,
792: jai_constants.closed_code_inporcess ,
793: jai_constants.closed_code_approved ,
794: jai_constants.closed_code_preapproved ,
795: jai_constants.closed_code_req_appr ,
796: jai_constants.closed_code_incomplete ));

Line 793: jai_constants.closed_code_approved ,

789: AND ((prla.closed_date IS NULL) OR (prla.closed_date <= v_today))
790: AND ( prla.closed_code IS NULL OR prla.closed_code IN (
791: jai_constants.closed_code_open ,
792: jai_constants.closed_code_inporcess ,
793: jai_constants.closed_code_approved ,
794: jai_constants.closed_code_preapproved ,
795: jai_constants.closed_code_req_appr ,
796: jai_constants.closed_code_incomplete ));
797: --'OPEN', 'IN PROCESS', 'APPROVED', 'PRE-APPROVED', 'REQUIRES REAPPROVAL', 'INCOMPLETE') )

Line 794: jai_constants.closed_code_preapproved ,

790: AND ( prla.closed_code IS NULL OR prla.closed_code IN (
791: jai_constants.closed_code_open ,
792: jai_constants.closed_code_inporcess ,
793: jai_constants.closed_code_approved ,
794: jai_constants.closed_code_preapproved ,
795: jai_constants.closed_code_req_appr ,
796: jai_constants.closed_code_incomplete ));
797: --'OPEN', 'IN PROCESS', 'APPROVED', 'PRE-APPROVED', 'REQUIRES REAPPROVAL', 'INCOMPLETE') )
798:

Line 795: jai_constants.closed_code_req_appr ,

791: jai_constants.closed_code_open ,
792: jai_constants.closed_code_inporcess ,
793: jai_constants.closed_code_approved ,
794: jai_constants.closed_code_preapproved ,
795: jai_constants.closed_code_req_appr ,
796: jai_constants.closed_code_incomplete ));
797: --'OPEN', 'IN PROCESS', 'APPROVED', 'PRE-APPROVED', 'REQUIRES REAPPROVAL', 'INCOMPLETE') )
798:
799: /****************

Line 796: jai_constants.closed_code_incomplete ));

792: jai_constants.closed_code_inporcess ,
793: jai_constants.closed_code_approved ,
794: jai_constants.closed_code_preapproved ,
795: jai_constants.closed_code_req_appr ,
796: jai_constants.closed_code_incomplete ));
797: --'OPEN', 'IN PROCESS', 'APPROVED', 'PRE-APPROVED', 'REQUIRES REAPPROVAL', 'INCOMPLETE') )
798:
799: /****************
800: SALES ORDERS Cursor

Line 1252: p_override_manual_taxes := nvl(pv_override_manual_taxes, jai_constants.no);

1248: lb_result := fnd_release.get_release(lv_release_name, lv_other_release_info);
1249:
1250:
1251: /* Ramananda for File.Sql.35 */
1252: p_override_manual_taxes := nvl(pv_override_manual_taxes, jai_constants.no);
1253: p_commit_interval := nvl(pn_commit_interval,50);
1254: p_process_partial := nvl(pv_process_partial, jai_constants.no);
1255: p_debug := nvl(pv_debug,jai_constants.no);
1256: p_trace :=nvl(pv_trace, jai_constants.no) ;

Line 1254: p_process_partial := nvl(pv_process_partial, jai_constants.no);

1250:
1251: /* Ramananda for File.Sql.35 */
1252: p_override_manual_taxes := nvl(pv_override_manual_taxes, jai_constants.no);
1253: p_commit_interval := nvl(pn_commit_interval,50);
1254: p_process_partial := nvl(pv_process_partial, jai_constants.no);
1255: p_debug := nvl(pv_debug,jai_constants.no);
1256: p_trace :=nvl(pv_trace, jai_constants.no) ;
1257: v_today := trunc(sysdate);
1258: v_created_by := nvl(FND_GLOBAL.USER_ID,-1);

Line 1255: p_debug := nvl(pv_debug,jai_constants.no);

1251: /* Ramananda for File.Sql.35 */
1252: p_override_manual_taxes := nvl(pv_override_manual_taxes, jai_constants.no);
1253: p_commit_interval := nvl(pn_commit_interval,50);
1254: p_process_partial := nvl(pv_process_partial, jai_constants.no);
1255: p_debug := nvl(pv_debug,jai_constants.no);
1256: p_trace :=nvl(pv_trace, jai_constants.no) ;
1257: v_today := trunc(sysdate);
1258: v_created_by := nvl(FND_GLOBAL.USER_ID,-1);
1259: v_login_id := nvl(FND_GLOBAL.LOGIN_ID,-1);

Line 1256: p_trace :=nvl(pv_trace, jai_constants.no) ;

1252: p_override_manual_taxes := nvl(pv_override_manual_taxes, jai_constants.no);
1253: p_commit_interval := nvl(pn_commit_interval,50);
1254: p_process_partial := nvl(pv_process_partial, jai_constants.no);
1255: p_debug := nvl(pv_debug,jai_constants.no);
1256: p_trace :=nvl(pv_trace, jai_constants.no) ;
1257: v_today := trunc(sysdate);
1258: v_created_by := nvl(FND_GLOBAL.USER_ID,-1);
1259: v_login_id := nvl(FND_GLOBAL.LOGIN_ID,-1);
1260: v_user_id := nvl(FND_GLOBAL.USER_ID,-1);

Line 1980: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI

1976: /* Added by LGOPALSA. Bu g4210102.
1977: * Added CVD and Customs education cess */
1978: IF upper(tax_rec.tax_type) IN (
1979: 'CVD',
1980: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
1981: 'CUSTOMS',
1982: jai_constants.tax_type_cvd_Edu_cess,
1983: jai_constants.tax_type_customs_edu_cess ,
1984: jai_constants.tax_type_sh_customs_edu_cess, -- Date 18/06/2007 Bug 6130025 added by SACSETHI

Line 1982: jai_constants.tax_type_cvd_Edu_cess,

1978: IF upper(tax_rec.tax_type) IN (
1979: 'CVD',
1980: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
1981: 'CUSTOMS',
1982: jai_constants.tax_type_cvd_Edu_cess,
1983: jai_constants.tax_type_customs_edu_cess ,
1984: jai_constants.tax_type_sh_customs_edu_cess, -- Date 18/06/2007 Bug 6130025 added by SACSETHI
1985: jai_constants.tax_type_sh_cvd_edu_cess
1986: )

Line 1983: jai_constants.tax_type_customs_edu_cess ,

1979: 'CVD',
1980: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
1981: 'CUSTOMS',
1982: jai_constants.tax_type_cvd_Edu_cess,
1983: jai_constants.tax_type_customs_edu_cess ,
1984: jai_constants.tax_type_sh_customs_edu_cess, -- Date 18/06/2007 Bug 6130025 added by SACSETHI
1985: jai_constants.tax_type_sh_cvd_edu_cess
1986: )
1987: THEN

Line 1984: jai_constants.tax_type_sh_customs_edu_cess, -- Date 18/06/2007 Bug 6130025 added by SACSETHI

1980: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
1981: 'CUSTOMS',
1982: jai_constants.tax_type_cvd_Edu_cess,
1983: jai_constants.tax_type_customs_edu_cess ,
1984: jai_constants.tax_type_sh_customs_edu_cess, -- Date 18/06/2007 Bug 6130025 added by SACSETHI
1985: jai_constants.tax_type_sh_cvd_edu_cess
1986: )
1987: THEN
1988: v_vendor_id := NULL;

Line 1985: jai_constants.tax_type_sh_cvd_edu_cess

1981: 'CUSTOMS',
1982: jai_constants.tax_type_cvd_Edu_cess,
1983: jai_constants.tax_type_customs_edu_cess ,
1984: jai_constants.tax_type_sh_customs_edu_cess, -- Date 18/06/2007 Bug 6130025 added by SACSETHI
1985: jai_constants.tax_type_sh_cvd_edu_cess
1986: )
1987: THEN
1988: v_vendor_id := NULL;
1989: ELSIF UPPER( tax_rec.tax_type ) LIKE UPPER( '%EXCISE%' ) THEN

Line 2569: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI

2565: * Added CVD and customs edu cess */
2566:
2567: IF upper(tax_rec.tax_type) IN (
2568: 'CVD',
2569: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
2570: 'CUSTOMS',
2571: jai_constants.tax_type_customs_edu_Cess,
2572: jai_constants.tax_type_cvd_edu_cess ,
2573: jai_constants.tax_type_sh_customs_edu_cess, -- Date 18/06/2007 Bug 6130025 added by SACSETHI

Line 2571: jai_constants.tax_type_customs_edu_Cess,

2567: IF upper(tax_rec.tax_type) IN (
2568: 'CVD',
2569: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
2570: 'CUSTOMS',
2571: jai_constants.tax_type_customs_edu_Cess,
2572: jai_constants.tax_type_cvd_edu_cess ,
2573: jai_constants.tax_type_sh_customs_edu_cess, -- Date 18/06/2007 Bug 6130025 added by SACSETHI
2574: jai_constants.tax_type_sh_cvd_edu_cess -- Date 18/06/2007 Bug 6130025 added by SACSETHI
2575: )

Line 2572: jai_constants.tax_type_cvd_edu_cess ,

2568: 'CVD',
2569: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
2570: 'CUSTOMS',
2571: jai_constants.tax_type_customs_edu_Cess,
2572: jai_constants.tax_type_cvd_edu_cess ,
2573: jai_constants.tax_type_sh_customs_edu_cess, -- Date 18/06/2007 Bug 6130025 added by SACSETHI
2574: jai_constants.tax_type_sh_cvd_edu_cess -- Date 18/06/2007 Bug 6130025 added by SACSETHI
2575: )
2576: THEN

Line 2573: jai_constants.tax_type_sh_customs_edu_cess, -- Date 18/06/2007 Bug 6130025 added by SACSETHI

2569: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
2570: 'CUSTOMS',
2571: jai_constants.tax_type_customs_edu_Cess,
2572: jai_constants.tax_type_cvd_edu_cess ,
2573: jai_constants.tax_type_sh_customs_edu_cess, -- Date 18/06/2007 Bug 6130025 added by SACSETHI
2574: jai_constants.tax_type_sh_cvd_edu_cess -- Date 18/06/2007 Bug 6130025 added by SACSETHI
2575: )
2576: THEN
2577: v_vendor_id := NULL;

Line 2574: jai_constants.tax_type_sh_cvd_edu_cess -- Date 18/06/2007 Bug 6130025 added by SACSETHI

2570: 'CUSTOMS',
2571: jai_constants.tax_type_customs_edu_Cess,
2572: jai_constants.tax_type_cvd_edu_cess ,
2573: jai_constants.tax_type_sh_customs_edu_cess, -- Date 18/06/2007 Bug 6130025 added by SACSETHI
2574: jai_constants.tax_type_sh_cvd_edu_cess -- Date 18/06/2007 Bug 6130025 added by SACSETHI
2575: )
2576: THEN
2577: v_vendor_id := NULL;
2578: ELSIF UPPER( tax_rec.tax_type ) LIKE UPPER( '%EXCISE%' ) THEN

Line 3166: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI

3162: * Added CVD and Cusotms education cess */
3163:
3164: IF upper(tax_rec.tax_type) IN (
3165: 'CVD',
3166: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
3167: 'CUSTOMS',
3168: jai_constants.tax_type_cvd_edu_Cess,
3169: jai_constants.tax_type_customs_edu_cess ,
3170: jai_constants.tax_type_sh_customs_edu_cess, -- Date 18/06/2007 Bug 6130025 added by SACSETHI

Line 3168: jai_constants.tax_type_cvd_edu_Cess,

3164: IF upper(tax_rec.tax_type) IN (
3165: 'CVD',
3166: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
3167: 'CUSTOMS',
3168: jai_constants.tax_type_cvd_edu_Cess,
3169: jai_constants.tax_type_customs_edu_cess ,
3170: jai_constants.tax_type_sh_customs_edu_cess, -- Date 18/06/2007 Bug 6130025 added by SACSETHI
3171: jai_constants.tax_type_sh_cvd_edu_cess
3172: )

Line 3169: jai_constants.tax_type_customs_edu_cess ,

3165: 'CVD',
3166: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
3167: 'CUSTOMS',
3168: jai_constants.tax_type_cvd_edu_Cess,
3169: jai_constants.tax_type_customs_edu_cess ,
3170: jai_constants.tax_type_sh_customs_edu_cess, -- Date 18/06/2007 Bug 6130025 added by SACSETHI
3171: jai_constants.tax_type_sh_cvd_edu_cess
3172: )
3173: THEN

Line 3170: jai_constants.tax_type_sh_customs_edu_cess, -- Date 18/06/2007 Bug 6130025 added by SACSETHI

3166: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
3167: 'CUSTOMS',
3168: jai_constants.tax_type_cvd_edu_Cess,
3169: jai_constants.tax_type_customs_edu_cess ,
3170: jai_constants.tax_type_sh_customs_edu_cess, -- Date 18/06/2007 Bug 6130025 added by SACSETHI
3171: jai_constants.tax_type_sh_cvd_edu_cess
3172: )
3173: THEN
3174: v_tax_vendor_id := NULL;

Line 3171: jai_constants.tax_type_sh_cvd_edu_cess

3167: 'CUSTOMS',
3168: jai_constants.tax_type_cvd_edu_Cess,
3169: jai_constants.tax_type_customs_edu_cess ,
3170: jai_constants.tax_type_sh_customs_edu_cess, -- Date 18/06/2007 Bug 6130025 added by SACSETHI
3171: jai_constants.tax_type_sh_cvd_edu_cess
3172: )
3173: THEN
3174: v_tax_vendor_id := NULL;
3175: -- ABC

Line 4867: v_manual := jai_constants.no; --Ramananda for File.Sql.35

4863: v_message variable will contain the error message.
4864: --------------------------------------------------------------------------------------------------------------------------*/
4865:
4866: p_success := 1; -- FLAG that indicates the tax recalculation can be applied by deleting old taxes that are defaulted from tax category
4867: v_manual := jai_constants.no; --Ramananda for File.Sql.35
4868: v_debug := jai_constants.no; --Ramananda for File.Sql.35
4869:
4870: IF p_document_type IN ( 'PO' ) THEN
4871:

Line 4868: v_debug := jai_constants.no; --Ramananda for File.Sql.35

4864: --------------------------------------------------------------------------------------------------------------------------*/
4865:
4866: p_success := 1; -- FLAG that indicates the tax recalculation can be applied by deleting old taxes that are defaulted from tax category
4867: v_manual := jai_constants.no; --Ramananda for File.Sql.35
4868: v_debug := jai_constants.no; --Ramananda for File.Sql.35
4869:
4870: IF p_document_type IN ( 'PO' ) THEN
4871:
4872: FOR processing_rec IN c_shipment_taxes(p_line_focus_id) LOOP