[Home] [Help]
57: p_tax_amount NUMBER;
58: v_assessable_value NUMBER;
59: ln_vat_assess_value NUMBER; -- Ravi for VAT
60:
61: v_tax_category_id_holder JAI_PO_LINE_LOCATIONS.tax_category_id%TYPE; -- cbabu for EnhancementBug# 2427465
62:
63: CURSOR Fetch_Org_Id_Cur IS
64: SELECT NVL(Operating_Unit,0)
65: FROM Org_Organization_Definitions
893: ln_vat_assess_value NUMBER; -- added rallamse bug#4250072 VAT
894: v_loc_count NUMBER;--File.Sql.35 Cbabu := 0; --new variable for loc chk on 17-aug-00
895:
896: v_tax_category_id JAI_PO_TAXES.tax_category_id%TYPE; -- cbabu for EnhancementBug# 2427465
897: v_tax_category_id_holder JAI_PO_LINE_LOCATIONS.tax_category_id%TYPE; -- cbabu for EnhancementBug# 2427465
898: v_style_id po_headers_all.style_id%TYPE; --Added by Sanjikum for Bug#4483042
899:
900: ------------------------------>
901: -- Check the vendor btn the vendor present in tax lines and that of suggested vendor in requisition lines
958: Commented the following cursor as it is
959: not used anywhere
960: CURSOR Fetch_Focus_Id_Cur( line_id IN NUMBER ) IS
961: SELECT Line_Focus_Id
962: FROM JAI_PO_LINE_LOCATIONS
963: WHERE Po_Line_Id = line_id
964: -- AND Line_Location_Id IS NULL
965: AND ( Line_Location_Id IS NULL OR line_location_id = 0 ); -- cbabu for EnhancementBug# 2427465
966: */
1049: requistion and ja_in_po_line_locations already exists */
1050:
1051: CURSOR Fetch_Focus_Id_Cur_for_req( line_id IN NUMBER , line_loc_id in Number ) IS
1052: SELECT Line_Focus_Id
1053: FROM JAI_PO_LINE_LOCATIONS
1054: WHERE Po_Line_Id = line_id
1055: AND Line_Location_Id = line_loc_id;
1056:
1057: Cursor fetch_Tax_cnt( cp_line_loc_id in number ) is
1071:
1072: --added, Bgowrava for Bug#6084636
1073: Cursor c_get_tax_modified_flag IS
1074: SELECT tax_modified_flag
1075: FROM JAI_PO_LINE_LOCATIONS
1076: WHERE line_location_id = pr_new.line_location_id ;
1077: lv_tax_modified_flag VARCHAR2(1) ;
1078:
1079: BEGIN
1088: 2 06/12/2002 cbabu for EnhancementBug# 2427465, FileVersion# 615.2
1089: tax_category_id column is populated into PO and SO localization tables, which will be used to
1090: identify from which tax_category the taxes are defaulted. Also the tax_category_id populated into
1091: the tax table will be useful to identify whether the tax is a defaulted or a manual tax.
1092: A cursor is modified to fetch tax_category_id. UPDATE statement of JAI_PO_LINE_LOCATIONS is modified to update
1093: tax_category_id column with defaulting tax category
1094: 3 04/02/2003 cbabu for Bug# 2782356, FileVersion# 615.3, Bug logged for IN60104
1095: Adhoc tax amounts are not defaulted from requisition taxes to STANDARD PO autocreated from requisition
1096:
1395: CLOSE Fetch_Vendor_Id;
1396: END IF;
1397:
1398: -- Vijay Shankar for Bug# 3193592
1399: select count(1) into v_line_loc_cnt from JAI_PO_LINE_LOCATIONS
1400: where line_location_id = pr_new.line_location_id;
1401:
1402: IF v_debug THEN -- bug 7218695. Added by Lakshmi Gopalsami
1403: UTL_FILE.PUT_LINE(v_myfilehandle, 'pr_new.line_location_id '|| pr_new.line_location_id);
1700: CLOSE c_get_tax_category_id;
1701:
1702:
1703:
1704: UPDATE JaI_Po_Line_Locations
1705: SET Tax_Amount = NVL( v_tax_amt, 0 ),
1706: Total_Amount = NVL( Line_Tot, 0 ) + NVL( v_tax_amt, 0 ),
1707: Last_Updated_By = v_last_upd_by,
1708: Last_Update_Date = v_last_upd_dt,