66:
67: ------ End of addition by Gsri on 12-jul-01
68:
69: BEGIN
70: pv_return_code := jai_constants.successful ;
71: /*------------------------------------------------------------------------------------------
72: FILENAME: Ja_In_Po_Tax_Delete_Trg.sql
73:
74: CHANGE HISTORY:
293: /*Bug 8586635 - End*/
294:
295: v_hook_value VARCHAR2(10);
296: BEGIN
297: pv_return_code := jai_constants.successful ;
298:
299: /*------------------------------------------------------------------------------------------
300: CHANGE HISTORY:
301: S.No Date Author and Details
969: WHERE
970: po_line_id = v_po_line_id AND
971: po_header_id = v_po_hdr_id AND
972: line_location_id = v_line_loc_id AND
973: tax_type <> jai_constants.tax_type_tds ; /*'TDS';Ramananda for removal of SQL LITERALs */
974:
975: cur_rec_get_total REC_CALC_TOTAL_TAX%ROWTYPE;
976: l_total_tax_amount JAI_PO_LINE_LOCATIONS.TAX_AMOUNT%TYPE;
977:
1034: JAI_PO_TAXES
1035: WHERE
1036: po_line_id = v_po_line_id AND
1037: line_location_id = v_line_loc_id AND
1038: tax_type <> jai_constants.tax_type_tds ; /*'TDS';Ramananda for removal of SQL LITERALs */
1039:
1040: CURSOR fetch_sum1_cur
1041: IS
1042: SELECT
1045: JAI_PO_TAXES
1046: WHERE
1047: po_line_id = v_po_line_id AND
1048: line_location_id is null AND
1049: tax_type <> jai_constants.tax_type_tds ; /*'TDS';Ramananda for removal of SQL LITERALs */
1050:
1051: -- To Check whether record modified is localized or not
1052: CURSOR localizaed_check_cur
1053: IS
1123: lv_process_message VARCHAR2(2000);
1124: --=====================================================
1125:
1126: BEGIN
1127: pv_return_code := jai_constants.successful ;
1128: /*------------------------------------------------------------------------------------------
1129: FILENAME: Ja_In_Po_Tax_Update_Trg.sql
1130:
1131: S.No dd/mm/yyyy Author and Details