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.

[Home] [Help]

APPS.JAI_PO_RLA_TRIGGER_PKG dependencies on JAI_CONSTANTS

Line 216: pv_return_code := jai_constants.successful ;

212: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
213: -- End for bug 5243532
214:
215: BEGIN
216: pv_return_code := jai_constants.successful ;
217: /*-----------------------------------------------------------------------------------------------------------------------
218: CHANGE HISTORY: FILENAME: ja_in_reqn_tax_insert_trg.sql
219: S.No Date Author and Details
220: -------------------------------------------------------------------------------------------------------------------------

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

796: INTO v_tax_amount
797: FROM JAI_PO_REQ_LINE_TAXES
798: WHERE Requisition_Header_Id = v_requisition_header_id
799: AND Requisition_Line_Id = v_requisition_line_id
800: AND Tax_Type <> jai_constants.tax_type_tds ; /* 'TDS' ;Ramananda for removal of SQL LITERALs */
801: v_total_amount := v_line_amount + v_tax_amount;
802:
803: -- cbabu for EnhancementBug# 2427465
804: UPDATE JAI_PO_REQ_LINES

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

994: CURSOR Tot_Amt_Cur IS
995: SELECT SUM( NVL( Tax_Amount, 0 ) )
996: FROM JAI_PO_TAXES
997: WHERE line_location_id = v_line_loc_id
998: AND Tax_Type <> jai_constants.tax_type_tds ; /* 'TDS'; Ramananda for removal of SQL LITERALs */
999:
1000: -- Start Modification by Gaurav for PO Autocreate issue 17-aug-00
1001: CURSOR Chk_localization_entry IS
1002: SELECT COUNT(REQUISITION_LINE_ID)

Line 1080: pv_return_code := jai_constants.successful ;

1076: WHERE line_location_id = pr_new.line_location_id ;
1077: lv_tax_modified_flag VARCHAR2(1) ;
1078:
1079: BEGIN
1080: pv_return_code := jai_constants.successful ;
1081: /*------------------------------------------------------------------------------------------------------------------
1082: Change History for ja_in_po_dflt_taxes_trg.sql
1083: S.No DD/MM/YYYY Details
1084: ------------------------------------------------------------------------------------------------------------------

Line 1198: pv_return_code := jai_constants.successful ;

1194: v_requisition_header_id := pr_new.requisition_header_id;
1195:
1196: IF v_debug THEN
1197: BEGIN
1198: pv_return_code := jai_constants.successful ;
1199: SELECT DECODE(SUBSTR (value,1,INSTR(value,',') -1),NULL, Value,SUBSTR (value,1,INSTR(value,',') -1))
1200: INTO v_utl_location
1201: FROM v$parameter
1202: WHERE name = 'utl_file_dir';

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

1586: /* Added by LGOPALSA. Bug 4210102
1587: * Added Customs and CVD Education Cess */
1588:
1589: IF upper(v_tax_type) IN ( 'CUSTOMS', 'CVD',
1590: jai_constants.tax_type_add_cvd , -- Date 03/11/2006 Bug 5228046 added by SACSETHI
1591: jai_constants.tax_type_customs_edu_Cess,JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,
1592: 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
1593: THEN
1594: v_vendor_id := NULL;

Line 1591: jai_constants.tax_type_customs_edu_Cess,JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,

1587: * Added Customs and CVD Education Cess */
1588:
1589: IF upper(v_tax_type) IN ( 'CUSTOMS', 'CVD',
1590: jai_constants.tax_type_add_cvd , -- Date 03/11/2006 Bug 5228046 added by SACSETHI
1591: jai_constants.tax_type_customs_edu_Cess,JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,
1592: 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
1593: THEN
1594: v_vendor_id := NULL;
1595: ELSIF v_tax_type = 'TDS' THEN

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

1588:
1589: IF upper(v_tax_type) IN ( 'CUSTOMS', 'CVD',
1590: jai_constants.tax_type_add_cvd , -- Date 03/11/2006 Bug 5228046 added by SACSETHI
1591: jai_constants.tax_type_customs_edu_Cess,JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,
1592: 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
1593: THEN
1594: v_vendor_id := NULL;
1595: ELSIF v_tax_type = 'TDS' THEN
1596: v_vendor_id := v_vendor1_id;

Line 1884: pv_return_code := jai_constants.successful ;

1880:
1881: /*rchandan for bug#5852041.. end*/ --pramasub FP end
1882:
1883: BEGIN
1884: pv_return_code := jai_constants.successful ;
1885: /*------------------------------------------------------------------------------------------
1886: CHANGE HISTORY: FILENAME: Ja_In_Reqn_Tax_Update_Trg.sql
1887: S.No Date Author and Details
1888: ------------------------------------------------------------------------------------------

Line 2182: IF pv_action = jai_constants.deleting THEN

2178: v_unit_price := pr_new.unit_price;
2179:
2180:
2181: --IF DELETING THEN
2182: IF pv_action = jai_constants.deleting THEN
2183: DELETE from JAI_PO_REQ_LINE_TAXES --ja_in_reqn_tax_lines
2184: WHERE requisition_line_id = pr_old.requisition_line_id ;
2185:
2186: DELETE from JAI_PO_REQ_LINES --ja_in_reqn_lines

Line 2192: ELSIF pv_action = jai_constants.updating

2188:
2189: RETURN;
2190:
2191: --ELSIF UPDATING AND NVL(pr_new.cancel_flag,'$') = 'Y' AND NVL(pr_old.cancel_flag,'#') <> 'Y' THEN
2192: ELSIF pv_action = jai_constants.updating
2193: AND NVL(pr_new.cancel_flag,'$') = 'Y' AND NVL(pr_old.cancel_flag,'#') <> 'Y' THEN
2194: DELETE from JAI_PO_REQ_LINE_TAXES --ja_in_reqn_tax_lines
2195: WHERE requisition_line_id = pr_old.requisition_line_id ;
2196:

Line 2572: pv_return_code := jai_constants.successful ;

2568: CURSOR Fetch_Mod_Flag_Cur IS SELECT Tax_modIFied_Flag
2569: From JAI_PO_REQ_LINES
2570: Where Requisition_Line_Id = v_line_id;
2571: BEGIN
2572: pv_return_code := jai_constants.successful ;
2573: /*------------------------------------------------------------------------------------------
2574: FILENAME: Ja_In_Reqn_Curr_Upd_Trg .sql
2575:
2576: CHANGE HISTORY: