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

216: p_document_no IN VARCHAR2, --11
217: p_release_no IN NUMBER, --12
218: p_document_line_no IN NUMBER, --13
219: p_shipment_no IN NUMBER, --14
220: 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
221: pn_commit_interval IN NUMBER, -- DEFAULT 50, --16 -- Added global variable gn_commit_interval in package spec. by Ramananda for File.Sql.35
222: pv_process_partial IN VARCHAR2, -- DEFAULT 'N', --17 -- Use jai_constants.no in the call of this procedure. Ramananda for for File.Sql.35
223: pv_debug IN VARCHAR2, -- DEFAULT 'N', --18 -- Use jai_constants.no in the call of this procedure. Ramananda for for File.Sql.35
224: pv_trace IN VARCHAR2 -- DEFAULT 'N' --19 -- Use jai_constants.no in the call of this procedure. Ramananda for for File.Sql.35

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

218: p_document_line_no IN NUMBER, --13
219: p_shipment_no IN NUMBER, --14
220: 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
221: pn_commit_interval IN NUMBER, -- DEFAULT 50, --16 -- Added global variable gn_commit_interval in package spec. by Ramananda for File.Sql.35
222: pv_process_partial IN VARCHAR2, -- DEFAULT 'N', --17 -- Use jai_constants.no in the call of this procedure. Ramananda for for File.Sql.35
223: pv_debug IN VARCHAR2, -- DEFAULT 'N', --18 -- Use jai_constants.no in the call of this procedure. Ramananda for for File.Sql.35
224: pv_trace IN VARCHAR2 -- DEFAULT 'N' --19 -- Use jai_constants.no in the call of this procedure. Ramananda for for File.Sql.35
225: ) IS
226:

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

219: p_shipment_no IN NUMBER, --14
220: 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
221: pn_commit_interval IN NUMBER, -- DEFAULT 50, --16 -- Added global variable gn_commit_interval in package spec. by Ramananda for File.Sql.35
222: pv_process_partial IN VARCHAR2, -- DEFAULT 'N', --17 -- Use jai_constants.no in the call of this procedure. Ramananda for for File.Sql.35
223: pv_debug IN VARCHAR2, -- DEFAULT 'N', --18 -- Use jai_constants.no in the call of this procedure. Ramananda for for File.Sql.35
224: pv_trace IN VARCHAR2 -- DEFAULT 'N' --19 -- Use jai_constants.no in the call of this procedure. Ramananda for for File.Sql.35
225: ) IS
226:
227: /* Ramananda for bug# 4336482 */

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

220: 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
221: pn_commit_interval IN NUMBER, -- DEFAULT 50, --16 -- Added global variable gn_commit_interval in package spec. by Ramananda for File.Sql.35
222: pv_process_partial IN VARCHAR2, -- DEFAULT 'N', --17 -- Use jai_constants.no in the call of this procedure. Ramananda for for File.Sql.35
223: pv_debug IN VARCHAR2, -- DEFAULT 'N', --18 -- Use jai_constants.no in the call of this procedure. Ramananda for for File.Sql.35
224: pv_trace IN VARCHAR2 -- DEFAULT 'N' --19 -- Use jai_constants.no in the call of this procedure. Ramananda for for File.Sql.35
225: ) IS
226:
227: /* Ramananda for bug# 4336482 */
228: p_from_date DATE; -- DEFAULT fnd_date.canonical_to_date(pv_from_date); --Ramananda for File.Sql.35

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

379: a.precedence_8 p_8,
380: a.precedence_9 p_9,
381: a.precedence_10 p_10,
382: b.tax_rate, b.tax_amount, b.uom_code, b.end_date valid_date,
383: -- 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,
384: b.mod_cr_percentage, b.vendor_id, b.tax_type, nvl(b.rounding_factor,0) rounding_factor
385: from JAI_CMN_TAX_CTG_LINES a, JAI_CMN_TAXES_ALL b
386: WHERE a.tax_category_id = p_tax_category_id
387: AND a.tax_id = b.tax_id

Line 522: jai_constants.closed_code_open ,

518: AND (p_org_id IS NULL OR pha.org_id = p_org_id)
519: AND (plla.cancel_flag IS NULL OR plla.cancel_flag <> 'Y' )
520: AND trunc(plla.creation_date) BETWEEN p_from_date AND p_to_date
521: AND ( plla.closed_code IS NULL OR plla.closed_code IN (
522: jai_constants.closed_code_open ,
523: jai_constants.closed_code_inporcess ,
524: jai_constants.closed_code_approved ,
525: jai_constants.closed_code_preapproved ,
526: jai_constants.closed_code_req_appr ,

Line 523: jai_constants.closed_code_inporcess ,

519: AND (plla.cancel_flag IS NULL OR plla.cancel_flag <> 'Y' )
520: AND trunc(plla.creation_date) BETWEEN p_from_date AND p_to_date
521: AND ( plla.closed_code IS NULL OR plla.closed_code IN (
522: jai_constants.closed_code_open ,
523: jai_constants.closed_code_inporcess ,
524: jai_constants.closed_code_approved ,
525: jai_constants.closed_code_preapproved ,
526: jai_constants.closed_code_req_appr ,
527: jai_constants.closed_code_incomplete ))

Line 524: jai_constants.closed_code_approved ,

520: AND trunc(plla.creation_date) BETWEEN p_from_date AND p_to_date
521: AND ( plla.closed_code IS NULL OR plla.closed_code IN (
522: jai_constants.closed_code_open ,
523: jai_constants.closed_code_inporcess ,
524: jai_constants.closed_code_approved ,
525: jai_constants.closed_code_preapproved ,
526: jai_constants.closed_code_req_appr ,
527: jai_constants.closed_code_incomplete ))
528: --'OPEN', 'IN PROCESS', 'APPROVED', 'PRE-APPROVED', 'REQUIRES REAPPROVAL', 'INCOMPLETE') )

Line 525: jai_constants.closed_code_preapproved ,

521: AND ( plla.closed_code IS NULL OR plla.closed_code IN (
522: jai_constants.closed_code_open ,
523: jai_constants.closed_code_inporcess ,
524: jai_constants.closed_code_approved ,
525: jai_constants.closed_code_preapproved ,
526: jai_constants.closed_code_req_appr ,
527: jai_constants.closed_code_incomplete ))
528: --'OPEN', 'IN PROCESS', 'APPROVED', 'PRE-APPROVED', 'REQUIRES REAPPROVAL', 'INCOMPLETE') )
529: UNION -- if there are no base records in po_line_locations_all but JAI_PO_LINE_LOCATIONS have

Line 526: jai_constants.closed_code_req_appr ,

522: jai_constants.closed_code_open ,
523: jai_constants.closed_code_inporcess ,
524: jai_constants.closed_code_approved ,
525: jai_constants.closed_code_preapproved ,
526: jai_constants.closed_code_req_appr ,
527: jai_constants.closed_code_incomplete ))
528: --'OPEN', 'IN PROCESS', 'APPROVED', 'PRE-APPROVED', 'REQUIRES REAPPROVAL', 'INCOMPLETE') )
529: UNION -- if there are no base records in po_line_locations_all but JAI_PO_LINE_LOCATIONS have
530: SELECT 2 source, jipll.rowid,

Line 527: jai_constants.closed_code_incomplete ))

523: jai_constants.closed_code_inporcess ,
524: jai_constants.closed_code_approved ,
525: jai_constants.closed_code_preapproved ,
526: jai_constants.closed_code_req_appr ,
527: jai_constants.closed_code_incomplete ))
528: --'OPEN', 'IN PROCESS', 'APPROVED', 'PRE-APPROVED', 'REQUIRES REAPPROVAL', 'INCOMPLETE') )
529: UNION -- if there are no base records in po_line_locations_all but JAI_PO_LINE_LOCATIONS have
530: SELECT 2 source, jipll.rowid,
531: jipll.line_focus_id, jipll.line_location_id, jipll.po_line_id, jipll.po_header_id, jipll.tax_category_id,

Line 558: jai_constants.closed_code_open ,

554: AND (p_org_id IS NULL OR pha.org_id = p_org_id)
555: AND (pla.cancel_flag IS NULL OR pla.cancel_flag <> 'Y' )
556: AND trunc(pla.creation_date) BETWEEN p_from_date AND p_to_date
557: AND ( pla.closed_code IS NULL OR pla.closed_code IN (
558: jai_constants.closed_code_open ,
559: jai_constants.closed_code_inporcess ,
560: jai_constants.closed_code_approved ,
561: jai_constants.closed_code_preapproved ,
562: jai_constants.closed_code_req_appr ,

Line 559: jai_constants.closed_code_inporcess ,

555: AND (pla.cancel_flag IS NULL OR pla.cancel_flag <> 'Y' )
556: AND trunc(pla.creation_date) BETWEEN p_from_date AND p_to_date
557: AND ( pla.closed_code IS NULL OR pla.closed_code IN (
558: jai_constants.closed_code_open ,
559: jai_constants.closed_code_inporcess ,
560: jai_constants.closed_code_approved ,
561: jai_constants.closed_code_preapproved ,
562: jai_constants.closed_code_req_appr ,
563: jai_constants.closed_code_incomplete ))

Line 560: jai_constants.closed_code_approved ,

556: AND trunc(pla.creation_date) BETWEEN p_from_date AND p_to_date
557: AND ( pla.closed_code IS NULL OR pla.closed_code IN (
558: jai_constants.closed_code_open ,
559: jai_constants.closed_code_inporcess ,
560: jai_constants.closed_code_approved ,
561: jai_constants.closed_code_preapproved ,
562: jai_constants.closed_code_req_appr ,
563: jai_constants.closed_code_incomplete ))
564: --'OPEN', 'IN PROCESS', 'APPROVED', 'PRE-APPROVED', 'REQUIRES REAPPROVAL', 'INCOMPLETE') )

Line 561: jai_constants.closed_code_preapproved ,

557: AND ( pla.closed_code IS NULL OR pla.closed_code IN (
558: jai_constants.closed_code_open ,
559: jai_constants.closed_code_inporcess ,
560: jai_constants.closed_code_approved ,
561: jai_constants.closed_code_preapproved ,
562: jai_constants.closed_code_req_appr ,
563: jai_constants.closed_code_incomplete ))
564: --'OPEN', 'IN PROCESS', 'APPROVED', 'PRE-APPROVED', 'REQUIRES REAPPROVAL', 'INCOMPLETE') )
565: and (jipll.line_location_id IS NULL OR jipll.line_location_id = 0);

Line 562: jai_constants.closed_code_req_appr ,

558: jai_constants.closed_code_open ,
559: jai_constants.closed_code_inporcess ,
560: jai_constants.closed_code_approved ,
561: jai_constants.closed_code_preapproved ,
562: jai_constants.closed_code_req_appr ,
563: jai_constants.closed_code_incomplete ))
564: --'OPEN', 'IN PROCESS', 'APPROVED', 'PRE-APPROVED', 'REQUIRES REAPPROVAL', 'INCOMPLETE') )
565: and (jipll.line_location_id IS NULL OR jipll.line_location_id = 0);
566:

Line 563: jai_constants.closed_code_incomplete ))

559: jai_constants.closed_code_inporcess ,
560: jai_constants.closed_code_approved ,
561: jai_constants.closed_code_preapproved ,
562: jai_constants.closed_code_req_appr ,
563: jai_constants.closed_code_incomplete ))
564: --'OPEN', 'IN PROCESS', 'APPROVED', 'PRE-APPROVED', 'REQUIRES REAPPROVAL', 'INCOMPLETE') )
565: and (jipll.line_location_id IS NULL OR jipll.line_location_id = 0);
566:
567: /****************************************

Line 612: (jai_constants.closed_code_open ,

608: AND (p_org_id IS NULL OR plla.org_id = p_org_id)
609: AND (plla.cancel_flag IS NULL OR plla.cancel_flag <> 'Y' )
610: AND trunc(pra.creation_date) BETWEEN p_from_date AND p_to_date
611: AND ( plla.closed_code IS NULL OR plla.closed_code IN
612: (jai_constants.closed_code_open ,
613: jai_constants.closed_code_inporcess ,
614: jai_constants.closed_code_approved ,
615: jai_constants.closed_code_preapproved ,
616: jai_constants.closed_code_req_appr ,

Line 613: jai_constants.closed_code_inporcess ,

609: AND (plla.cancel_flag IS NULL OR plla.cancel_flag <> 'Y' )
610: AND trunc(pra.creation_date) BETWEEN p_from_date AND p_to_date
611: AND ( plla.closed_code IS NULL OR plla.closed_code IN
612: (jai_constants.closed_code_open ,
613: jai_constants.closed_code_inporcess ,
614: jai_constants.closed_code_approved ,
615: jai_constants.closed_code_preapproved ,
616: jai_constants.closed_code_req_appr ,
617: jai_constants.closed_code_incomplete ));

Line 614: jai_constants.closed_code_approved ,

610: AND trunc(pra.creation_date) BETWEEN p_from_date AND p_to_date
611: AND ( plla.closed_code IS NULL OR plla.closed_code IN
612: (jai_constants.closed_code_open ,
613: jai_constants.closed_code_inporcess ,
614: jai_constants.closed_code_approved ,
615: jai_constants.closed_code_preapproved ,
616: jai_constants.closed_code_req_appr ,
617: jai_constants.closed_code_incomplete ));
618: --'OPEN', 'IN PROCESS', 'APPROVED', 'PRE-APPROVED', 'REQUIRES REAPPROVAL', 'INCOMPLETE') );

Line 615: jai_constants.closed_code_preapproved ,

611: AND ( plla.closed_code IS NULL OR plla.closed_code IN
612: (jai_constants.closed_code_open ,
613: jai_constants.closed_code_inporcess ,
614: jai_constants.closed_code_approved ,
615: jai_constants.closed_code_preapproved ,
616: jai_constants.closed_code_req_appr ,
617: jai_constants.closed_code_incomplete ));
618: --'OPEN', 'IN PROCESS', 'APPROVED', 'PRE-APPROVED', 'REQUIRES REAPPROVAL', 'INCOMPLETE') );
619:

Line 616: jai_constants.closed_code_req_appr ,

612: (jai_constants.closed_code_open ,
613: jai_constants.closed_code_inporcess ,
614: jai_constants.closed_code_approved ,
615: jai_constants.closed_code_preapproved ,
616: jai_constants.closed_code_req_appr ,
617: jai_constants.closed_code_incomplete ));
618: --'OPEN', 'IN PROCESS', 'APPROVED', 'PRE-APPROVED', 'REQUIRES REAPPROVAL', 'INCOMPLETE') );
619:
620: /****************

Line 617: jai_constants.closed_code_incomplete ));

613: jai_constants.closed_code_inporcess ,
614: jai_constants.closed_code_approved ,
615: jai_constants.closed_code_preapproved ,
616: jai_constants.closed_code_req_appr ,
617: jai_constants.closed_code_incomplete ));
618: --'OPEN', 'IN PROCESS', 'APPROVED', 'PRE-APPROVED', 'REQUIRES REAPPROVAL', 'INCOMPLETE') );
619:
620: /****************
621: REQUISITIONS Cursor

Line 654: jai_constants.closed_code_open ,

650: AND (prla.cancel_flag IS NULL OR prla.cancel_flag <> 'Y' )
651: AND trunc(prla.creation_date) BETWEEN p_from_date AND p_to_date
652: AND ((prla.closed_date IS NULL) OR (prla.closed_date <= v_today))
653: AND ( prla.closed_code IS NULL OR prla.closed_code IN (
654: jai_constants.closed_code_open ,
655: jai_constants.closed_code_inporcess ,
656: jai_constants.closed_code_approved ,
657: jai_constants.closed_code_preapproved ,
658: jai_constants.closed_code_req_appr ,

Line 655: jai_constants.closed_code_inporcess ,

651: AND trunc(prla.creation_date) BETWEEN p_from_date AND p_to_date
652: AND ((prla.closed_date IS NULL) OR (prla.closed_date <= v_today))
653: AND ( prla.closed_code IS NULL OR prla.closed_code IN (
654: jai_constants.closed_code_open ,
655: jai_constants.closed_code_inporcess ,
656: jai_constants.closed_code_approved ,
657: jai_constants.closed_code_preapproved ,
658: jai_constants.closed_code_req_appr ,
659: jai_constants.closed_code_incomplete ));

Line 656: jai_constants.closed_code_approved ,

652: AND ((prla.closed_date IS NULL) OR (prla.closed_date <= v_today))
653: AND ( prla.closed_code IS NULL OR prla.closed_code IN (
654: jai_constants.closed_code_open ,
655: jai_constants.closed_code_inporcess ,
656: jai_constants.closed_code_approved ,
657: jai_constants.closed_code_preapproved ,
658: jai_constants.closed_code_req_appr ,
659: jai_constants.closed_code_incomplete ));
660: --'OPEN', 'IN PROCESS', 'APPROVED', 'PRE-APPROVED', 'REQUIRES REAPPROVAL', 'INCOMPLETE') )

Line 657: jai_constants.closed_code_preapproved ,

653: AND ( prla.closed_code IS NULL OR prla.closed_code IN (
654: jai_constants.closed_code_open ,
655: jai_constants.closed_code_inporcess ,
656: jai_constants.closed_code_approved ,
657: jai_constants.closed_code_preapproved ,
658: jai_constants.closed_code_req_appr ,
659: jai_constants.closed_code_incomplete ));
660: --'OPEN', 'IN PROCESS', 'APPROVED', 'PRE-APPROVED', 'REQUIRES REAPPROVAL', 'INCOMPLETE') )
661:

Line 658: jai_constants.closed_code_req_appr ,

654: jai_constants.closed_code_open ,
655: jai_constants.closed_code_inporcess ,
656: jai_constants.closed_code_approved ,
657: jai_constants.closed_code_preapproved ,
658: jai_constants.closed_code_req_appr ,
659: jai_constants.closed_code_incomplete ));
660: --'OPEN', 'IN PROCESS', 'APPROVED', 'PRE-APPROVED', 'REQUIRES REAPPROVAL', 'INCOMPLETE') )
661:
662: /****************

Line 659: jai_constants.closed_code_incomplete ));

655: jai_constants.closed_code_inporcess ,
656: jai_constants.closed_code_approved ,
657: jai_constants.closed_code_preapproved ,
658: jai_constants.closed_code_req_appr ,
659: jai_constants.closed_code_incomplete ));
660: --'OPEN', 'IN PROCESS', 'APPROVED', 'PRE-APPROVED', 'REQUIRES REAPPROVAL', 'INCOMPLETE') )
661:
662: /****************
663: SALES ORDERS Cursor

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

898: 120.3 Aiyer R12 JAI A Changed for bug 4565665. Spec and body change in jai_cmn_mtax_pkg
899: --------------------------------------------------------------------------------------------------------------------------*/
900:
901: /* Ramananda for File.Sql.35 */
902: p_override_manual_taxes := nvl(pv_override_manual_taxes, jai_constants.no);
903: p_commit_interval := nvl(pn_commit_interval,50);
904: p_process_partial := nvl(pv_process_partial, jai_constants.no);
905: p_debug := nvl(pv_debug,jai_constants.no);
906: p_trace :=nvl(pv_trace, jai_constants.no) ;

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

900:
901: /* Ramananda for File.Sql.35 */
902: p_override_manual_taxes := nvl(pv_override_manual_taxes, jai_constants.no);
903: p_commit_interval := nvl(pn_commit_interval,50);
904: p_process_partial := nvl(pv_process_partial, jai_constants.no);
905: p_debug := nvl(pv_debug,jai_constants.no);
906: p_trace :=nvl(pv_trace, jai_constants.no) ;
907: v_today := trunc(sysdate);
908: v_created_by := nvl(FND_GLOBAL.USER_ID,-1);

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

901: /* Ramananda for File.Sql.35 */
902: p_override_manual_taxes := nvl(pv_override_manual_taxes, jai_constants.no);
903: p_commit_interval := nvl(pn_commit_interval,50);
904: p_process_partial := nvl(pv_process_partial, jai_constants.no);
905: p_debug := nvl(pv_debug,jai_constants.no);
906: p_trace :=nvl(pv_trace, jai_constants.no) ;
907: v_today := trunc(sysdate);
908: v_created_by := nvl(FND_GLOBAL.USER_ID,-1);
909: v_login_id := nvl(FND_GLOBAL.LOGIN_ID,-1);

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

902: p_override_manual_taxes := nvl(pv_override_manual_taxes, jai_constants.no);
903: p_commit_interval := nvl(pn_commit_interval,50);
904: p_process_partial := nvl(pv_process_partial, jai_constants.no);
905: p_debug := nvl(pv_debug,jai_constants.no);
906: p_trace :=nvl(pv_trace, jai_constants.no) ;
907: v_today := trunc(sysdate);
908: v_created_by := nvl(FND_GLOBAL.USER_ID,-1);
909: v_login_id := nvl(FND_GLOBAL.LOGIN_ID,-1);
910: v_user_id := nvl(FND_GLOBAL.USER_ID,-1);

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

1573: /* Added by LGOPALSA. Bu g4210102.
1574: * Added CVD and Customs education cess */
1575: IF upper(tax_rec.tax_type) IN (
1576: 'CVD',
1577: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
1578: 'CUSTOMS',
1579: jai_constants.tax_type_cvd_Edu_cess,
1580: jai_constants.tax_type_customs_edu_cess ,
1581: jai_constants.tax_type_sh_customs_edu_cess, -- Date 18/06/2007 Bug 6130025 added by SACSETHI

Line 1579: jai_constants.tax_type_cvd_Edu_cess,

1575: IF upper(tax_rec.tax_type) IN (
1576: 'CVD',
1577: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
1578: 'CUSTOMS',
1579: jai_constants.tax_type_cvd_Edu_cess,
1580: jai_constants.tax_type_customs_edu_cess ,
1581: jai_constants.tax_type_sh_customs_edu_cess, -- Date 18/06/2007 Bug 6130025 added by SACSETHI
1582: jai_constants.tax_type_sh_cvd_edu_cess
1583: )

Line 1580: jai_constants.tax_type_customs_edu_cess ,

1576: 'CVD',
1577: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
1578: 'CUSTOMS',
1579: jai_constants.tax_type_cvd_Edu_cess,
1580: jai_constants.tax_type_customs_edu_cess ,
1581: jai_constants.tax_type_sh_customs_edu_cess, -- Date 18/06/2007 Bug 6130025 added by SACSETHI
1582: jai_constants.tax_type_sh_cvd_edu_cess
1583: )
1584: THEN

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

1577: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
1578: 'CUSTOMS',
1579: jai_constants.tax_type_cvd_Edu_cess,
1580: jai_constants.tax_type_customs_edu_cess ,
1581: jai_constants.tax_type_sh_customs_edu_cess, -- Date 18/06/2007 Bug 6130025 added by SACSETHI
1582: jai_constants.tax_type_sh_cvd_edu_cess
1583: )
1584: THEN
1585: v_vendor_id := NULL;

Line 1582: jai_constants.tax_type_sh_cvd_edu_cess

1578: 'CUSTOMS',
1579: jai_constants.tax_type_cvd_Edu_cess,
1580: jai_constants.tax_type_customs_edu_cess ,
1581: jai_constants.tax_type_sh_customs_edu_cess, -- Date 18/06/2007 Bug 6130025 added by SACSETHI
1582: jai_constants.tax_type_sh_cvd_edu_cess
1583: )
1584: THEN
1585: v_vendor_id := NULL;
1586: ELSIF UPPER( tax_rec.tax_type ) LIKE UPPER( '%EXCISE%' ) THEN

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

2137: * Added CVD and customs edu cess */
2138:
2139: IF upper(tax_rec.tax_type) IN (
2140: 'CVD',
2141: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
2142: 'CUSTOMS',
2143: jai_constants.tax_type_customs_edu_Cess,
2144: jai_constants.tax_type_cvd_edu_cess ,
2145: jai_constants.tax_type_sh_customs_edu_cess, -- Date 18/06/2007 Bug 6130025 added by SACSETHI

Line 2143: jai_constants.tax_type_customs_edu_Cess,

2139: IF upper(tax_rec.tax_type) IN (
2140: 'CVD',
2141: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
2142: 'CUSTOMS',
2143: jai_constants.tax_type_customs_edu_Cess,
2144: jai_constants.tax_type_cvd_edu_cess ,
2145: jai_constants.tax_type_sh_customs_edu_cess, -- Date 18/06/2007 Bug 6130025 added by SACSETHI
2146: jai_constants.tax_type_sh_cvd_edu_cess -- Date 18/06/2007 Bug 6130025 added by SACSETHI
2147: )

Line 2144: jai_constants.tax_type_cvd_edu_cess ,

2140: 'CVD',
2141: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
2142: 'CUSTOMS',
2143: jai_constants.tax_type_customs_edu_Cess,
2144: jai_constants.tax_type_cvd_edu_cess ,
2145: jai_constants.tax_type_sh_customs_edu_cess, -- Date 18/06/2007 Bug 6130025 added by SACSETHI
2146: jai_constants.tax_type_sh_cvd_edu_cess -- Date 18/06/2007 Bug 6130025 added by SACSETHI
2147: )
2148: THEN

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

2141: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
2142: 'CUSTOMS',
2143: jai_constants.tax_type_customs_edu_Cess,
2144: jai_constants.tax_type_cvd_edu_cess ,
2145: jai_constants.tax_type_sh_customs_edu_cess, -- Date 18/06/2007 Bug 6130025 added by SACSETHI
2146: jai_constants.tax_type_sh_cvd_edu_cess -- Date 18/06/2007 Bug 6130025 added by SACSETHI
2147: )
2148: THEN
2149: v_vendor_id := NULL;

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

2142: 'CUSTOMS',
2143: jai_constants.tax_type_customs_edu_Cess,
2144: jai_constants.tax_type_cvd_edu_cess ,
2145: jai_constants.tax_type_sh_customs_edu_cess, -- Date 18/06/2007 Bug 6130025 added by SACSETHI
2146: jai_constants.tax_type_sh_cvd_edu_cess -- Date 18/06/2007 Bug 6130025 added by SACSETHI
2147: )
2148: THEN
2149: v_vendor_id := NULL;
2150: ELSIF UPPER( tax_rec.tax_type ) LIKE UPPER( '%EXCISE%' ) THEN

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

2708: * Added CVD and Cusotms education cess */
2709:
2710: IF upper(tax_rec.tax_type) IN (
2711: 'CVD',
2712: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
2713: 'CUSTOMS',
2714: jai_constants.tax_type_cvd_edu_Cess,
2715: jai_constants.tax_type_customs_edu_cess ,
2716: jai_constants.tax_type_sh_customs_edu_cess, -- Date 18/06/2007 Bug 6130025 added by SACSETHI

Line 2714: jai_constants.tax_type_cvd_edu_Cess,

2710: IF upper(tax_rec.tax_type) IN (
2711: 'CVD',
2712: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
2713: 'CUSTOMS',
2714: jai_constants.tax_type_cvd_edu_Cess,
2715: jai_constants.tax_type_customs_edu_cess ,
2716: jai_constants.tax_type_sh_customs_edu_cess, -- Date 18/06/2007 Bug 6130025 added by SACSETHI
2717: jai_constants.tax_type_sh_cvd_edu_cess
2718: )

Line 2715: jai_constants.tax_type_customs_edu_cess ,

2711: 'CVD',
2712: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
2713: 'CUSTOMS',
2714: jai_constants.tax_type_cvd_edu_Cess,
2715: jai_constants.tax_type_customs_edu_cess ,
2716: jai_constants.tax_type_sh_customs_edu_cess, -- Date 18/06/2007 Bug 6130025 added by SACSETHI
2717: jai_constants.tax_type_sh_cvd_edu_cess
2718: )
2719: THEN

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

2712: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
2713: 'CUSTOMS',
2714: jai_constants.tax_type_cvd_edu_Cess,
2715: jai_constants.tax_type_customs_edu_cess ,
2716: jai_constants.tax_type_sh_customs_edu_cess, -- Date 18/06/2007 Bug 6130025 added by SACSETHI
2717: jai_constants.tax_type_sh_cvd_edu_cess
2718: )
2719: THEN
2720: v_tax_vendor_id := NULL;

Line 2717: jai_constants.tax_type_sh_cvd_edu_cess

2713: 'CUSTOMS',
2714: jai_constants.tax_type_cvd_edu_Cess,
2715: jai_constants.tax_type_customs_edu_cess ,
2716: jai_constants.tax_type_sh_customs_edu_cess, -- Date 18/06/2007 Bug 6130025 added by SACSETHI
2717: jai_constants.tax_type_sh_cvd_edu_cess
2718: )
2719: THEN
2720: v_tax_vendor_id := NULL;
2721: -- ABC

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

3696: v_message variable will contain the error message.
3697: --------------------------------------------------------------------------------------------------------------------------*/
3698:
3699: p_success := 1; -- FLAG that indicates the tax recalculation can be applied by deleting old taxes that are defaulted from tax category
3700: v_manual := jai_constants.no; --Ramananda for File.Sql.35
3701: v_debug := jai_constants.no; --Ramananda for File.Sql.35
3702:
3703: IF p_document_type IN ( 'PO' ) THEN
3704:

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

3697: --------------------------------------------------------------------------------------------------------------------------*/
3698:
3699: p_success := 1; -- FLAG that indicates the tax recalculation can be applied by deleting old taxes that are defaulted from tax category
3700: v_manual := jai_constants.no; --Ramananda for File.Sql.35
3701: v_debug := jai_constants.no; --Ramananda for File.Sql.35
3702:
3703: IF p_document_type IN ( 'PO' ) THEN
3704:
3705: FOR processing_rec IN c_shipment_taxes(p_line_focus_id) LOOP