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

Line 222: pv_return_code := jai_constants.successful ;

218: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
219: -- End for bug 5243532
220:
221: BEGIN
222: pv_return_code := jai_constants.successful ;
223: /*-----------------------------------------------------------------------------------------------------------------------
224: CHANGE HISTORY: FILENAME: ja_in_reqn_tax_insert_trg.sql
225: S.No Date Author and Details
226: -------------------------------------------------------------------------------------------------------------------------

Line 886: AND Tax_Type <> jai_constants.tax_type_tds ; /* 'TDS' ;Ramananda for removal of SQL LITERALs */

882: INTO v_tax_amount
883: FROM JAI_PO_REQ_LINE_TAXES
884: WHERE Requisition_Header_Id = v_requisition_header_id
885: AND Requisition_Line_Id = v_requisition_line_id
886: AND Tax_Type <> jai_constants.tax_type_tds ; /* 'TDS' ;Ramananda for removal of SQL LITERALs */
887: v_total_amount := v_line_amount + v_tax_amount;
888:
889: -- cbabu for EnhancementBug# 2427465
890: UPDATE JAI_PO_REQ_LINES

Line 1085: AND Tax_Type <> jai_constants.tax_type_tds ; /* 'TDS'; Ramananda for removal of SQL LITERALs */

1081: CURSOR Tot_Amt_Cur IS
1082: SELECT SUM( NVL( Tax_Amount, 0 ) )
1083: FROM JAI_PO_TAXES
1084: WHERE line_location_id = v_line_loc_id
1085: AND Tax_Type <> jai_constants.tax_type_tds ; /* 'TDS'; Ramananda for removal of SQL LITERALs */
1086:
1087: -- Start Modification by Gaurav for PO Autocreate issue 17-aug-00
1088: CURSOR Chk_localization_entry IS
1089: SELECT COUNT(REQUISITION_LINE_ID)

Line 1168: pv_return_code := jai_constants.successful ;

1164: WHERE line_location_id = pr_new.line_location_id ;
1165: lv_tax_modified_flag VARCHAR2(1) ;
1166:
1167: BEGIN
1168: pv_return_code := jai_constants.successful ;
1169: /*------------------------------------------------------------------------------------------------------------------
1170: Change History for ja_in_po_dflt_taxes_trg.sql
1171: S.No DD/MM/YYYY Details
1172: ------------------------------------------------------------------------------------------------------------------

Line 1299: pv_return_code := jai_constants.successful ;

1295: v_requisition_header_id := pr_new.requisition_header_id;
1296:
1297: IF v_debug THEN
1298: BEGIN
1299: pv_return_code := jai_constants.successful ;
1300: SELECT DECODE(SUBSTR (value,1,INSTR(value,',') -1),NULL, Value,SUBSTR (value,1,INSTR(value,',') -1))
1301: INTO v_utl_location
1302: FROM v$parameter
1303: WHERE name = 'utl_file_dir';

Line 1693: jai_constants.tax_type_add_cvd , -- Date 03/11/2006 Bug 5228046 added by SACSETHI

1689: /* Added by LGOPALSA. Bug 4210102
1690: * Added Customs and CVD Education Cess */
1691:
1692: IF upper(v_tax_type) IN ( 'CUSTOMS', 'CVD',
1693: jai_constants.tax_type_add_cvd , -- Date 03/11/2006 Bug 5228046 added by SACSETHI
1694: jai_constants.tax_type_customs_edu_Cess,JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,
1695: jai_constants.tax_type_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS) --Added SH related entries by Bgowrava for forward porting bug#5989740
1696: THEN
1697: v_vendor_id := NULL;

Line 1694: jai_constants.tax_type_customs_edu_Cess,JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,

1690: * Added Customs and CVD Education Cess */
1691:
1692: IF upper(v_tax_type) IN ( 'CUSTOMS', 'CVD',
1693: jai_constants.tax_type_add_cvd , -- Date 03/11/2006 Bug 5228046 added by SACSETHI
1694: jai_constants.tax_type_customs_edu_Cess,JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,
1695: jai_constants.tax_type_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS) --Added SH related entries by Bgowrava for forward porting bug#5989740
1696: THEN
1697: v_vendor_id := NULL;
1698: ELSIF v_tax_type = 'TDS' THEN

Line 1695: jai_constants.tax_type_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS) --Added SH related entries by Bgowrava for forward porting bug#5989740

1691:
1692: IF upper(v_tax_type) IN ( 'CUSTOMS', 'CVD',
1693: jai_constants.tax_type_add_cvd , -- Date 03/11/2006 Bug 5228046 added by SACSETHI
1694: jai_constants.tax_type_customs_edu_Cess,JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,
1695: jai_constants.tax_type_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS) --Added SH related entries by Bgowrava for forward porting bug#5989740
1696: THEN
1697: v_vendor_id := NULL;
1698: ELSIF v_tax_type = 'TDS' THEN
1699: v_vendor_id := v_vendor1_id;

Line 2015: pv_return_code := jai_constants.successful ;

2011:
2012: /*rchandan for bug#5852041.. end*/ --pramasub FP end
2013:
2014: BEGIN
2015: pv_return_code := jai_constants.successful ;
2016: /*------------------------------------------------------------------------------------------
2017: CHANGE HISTORY: FILENAME: Ja_In_Reqn_Tax_Update_Trg.sql
2018: S.No Date Author and Details
2019: ------------------------------------------------------------------------------------------

Line 2316: IF pv_action = jai_constants.deleting THEN

2312: v_unit_price := pr_new.unit_price;
2313:
2314:
2315: --IF DELETING THEN
2316: IF pv_action = jai_constants.deleting THEN
2317: DELETE from JAI_PO_REQ_LINE_TAXES --ja_in_reqn_tax_lines
2318: WHERE requisition_line_id = pr_old.requisition_line_id ;
2319:
2320: DELETE from JAI_PO_REQ_LINES --ja_in_reqn_lines

Line 2326: ELSIF pv_action = jai_constants.updating

2322:
2323: RETURN;
2324:
2325: --ELSIF UPDATING AND NVL(pr_new.cancel_flag,'$') = 'Y' AND NVL(pr_old.cancel_flag,'#') <> 'Y' THEN
2326: ELSIF pv_action = jai_constants.updating
2327: AND NVL(pr_new.cancel_flag,'$') = 'Y' AND NVL(pr_old.cancel_flag,'#') <> 'Y' THEN
2328: DELETE from JAI_PO_REQ_LINE_TAXES --ja_in_reqn_tax_lines
2329: WHERE requisition_line_id = pr_old.requisition_line_id ;
2330:

Line 2795: pv_return_code := jai_constants.successful ;

2791: CURSOR Fetch_Mod_Flag_Cur IS SELECT Tax_modIFied_Flag
2792: From JAI_PO_REQ_LINES
2793: Where Requisition_Line_Id = v_line_id;
2794: BEGIN
2795: pv_return_code := jai_constants.successful ;
2796: /*------------------------------------------------------------------------------------------
2797: FILENAME: Ja_In_Reqn_Curr_Upd_Trg .sql
2798:
2799: CHANGE HISTORY: