APPS.JAI_PO_LLA_TRIGGER_PKG dependencies on JAI_CONSTANTS

Line 53: pv_return_code := jai_constants.successful ;

49:
50: ------ End of addition by Gsri on 12-jul-01
51:
52: BEGIN
53: pv_return_code := jai_constants.successful ;
54: /*------------------------------------------------------------------------------------------
55: FILENAME: Ja_In_Po_Tax_Delete_Trg.sql
56:
57: CHANGE HISTORY:

Line 260: pv_return_code := jai_constants.successful ;

256: WHERE line_location_id = p_line_location_id;
257:
258: v_hook_value VARCHAR2(10);
259: BEGIN
260: pv_return_code := jai_constants.successful ;
261:
262: /*------------------------------------------------------------------------------------------
263: CHANGE HISTORY:
264: S.No Date Author and Details

Line 822: tax_type <> jai_constants.tax_type_tds ; /*'TDS';Ramananda for removal of SQL LITERALs */

818: WHERE
819: po_line_id = v_po_line_id AND
820: po_header_id = v_po_hdr_id AND
821: line_location_id = v_line_loc_id AND
822: tax_type <> jai_constants.tax_type_tds ; /*'TDS';Ramananda for removal of SQL LITERALs */
823:
824: cur_rec_get_total REC_CALC_TOTAL_TAX%ROWTYPE;
825: l_total_tax_amount JAI_PO_LINE_LOCATIONS.TAX_AMOUNT%TYPE;
826:

Line 887: tax_type <> jai_constants.tax_type_tds ; /*'TDS';Ramananda for removal of SQL LITERALs */

883: JAI_PO_TAXES
884: WHERE
885: po_line_id = v_po_line_id AND
886: line_location_id = v_line_loc_id AND
887: tax_type <> jai_constants.tax_type_tds ; /*'TDS';Ramananda for removal of SQL LITERALs */
888:
889: CURSOR fetch_sum1_cur
890: IS
891: SELECT

Line 898: tax_type <> jai_constants.tax_type_tds ; /*'TDS';Ramananda for removal of SQL LITERALs */

894: JAI_PO_TAXES
895: WHERE
896: po_line_id = v_po_line_id AND
897: line_location_id is null AND
898: tax_type <> jai_constants.tax_type_tds ; /*'TDS';Ramananda for removal of SQL LITERALs */
899:
900: -- To Check whether record modified is localized or not
901: CURSOR localizaed_check_cur
902: IS

Line 976: pv_return_code := jai_constants.successful ;

972: lv_process_message VARCHAR2(2000);
973: --=====================================================
974:
975: BEGIN
976: pv_return_code := jai_constants.successful ;
977: /*------------------------------------------------------------------------------------------
978: FILENAME: Ja_In_Po_Tax_Update_Trg.sql
979:
980: S.No dd/mm/yyyy Author and Details