[Home] [Help]
63: ln_vat_assess_value NUMBER; -- Ravi for VAT
64:
65: -- ln_gst_assessable_value NUMBER; -- Added by Jia for GST Bug#10091373 on 2010/09/10
66:
67: v_tax_category_id_holder JAI_PO_LINE_LOCATIONS.tax_category_id%TYPE; -- cbabu for EnhancementBug# 2427465
68:
69: CURSOR Fetch_Org_Id_Cur IS
70: SELECT NVL(Operating_Unit,0)
71: FROM Org_Organization_Definitions
980: -- ln_gst_assessable_value NUMBER; -- Added by Jia for GST Bug#10091373 on 2010/09/10
981: v_loc_count NUMBER;--File.Sql.35 Cbabu := 0; --new variable for loc chk on 17-aug-00
982:
983: v_tax_category_id JAI_PO_TAXES.tax_category_id%TYPE; -- cbabu for EnhancementBug# 2427465
984: v_tax_category_id_holder JAI_PO_LINE_LOCATIONS.tax_category_id%TYPE; -- cbabu for EnhancementBug# 2427465
985: v_style_id po_headers_all.style_id%TYPE; --Added by Sanjikum for Bug#4483042
986:
987: ------------------------------>
988: -- Check the vendor btn the vendor present in tax lines and that of suggested vendor in requisition lines
1045: Commented the following cursor as it is
1046: not used anywhere
1047: CURSOR Fetch_Focus_Id_Cur( line_id IN NUMBER ) IS
1048: SELECT Line_Focus_Id
1049: FROM JAI_PO_LINE_LOCATIONS
1050: WHERE Po_Line_Id = line_id
1051: -- AND Line_Location_Id IS NULL
1052: AND ( Line_Location_Id IS NULL OR line_location_id = 0 ); -- cbabu for EnhancementBug# 2427465
1053: */
1137: requistion and ja_in_po_line_locations already exists */
1138:
1139: CURSOR Fetch_Focus_Id_Cur_for_req( line_id IN NUMBER , line_loc_id in Number ) IS
1140: SELECT Line_Focus_Id
1141: FROM JAI_PO_LINE_LOCATIONS
1142: WHERE Po_Line_Id = line_id
1143: AND Line_Location_Id = line_loc_id;
1144:
1145: Cursor fetch_Tax_cnt( cp_line_loc_id in number ) is
1159:
1160: --added, Bgowrava for Bug#6084636
1161: Cursor c_get_tax_modified_flag IS
1162: SELECT tax_modified_flag
1163: FROM JAI_PO_LINE_LOCATIONS
1164: WHERE line_location_id = pr_new.line_location_id ;
1165: lv_tax_modified_flag VARCHAR2(1) ;
1166:
1167: BEGIN
1176: 2 06/12/2002 cbabu for EnhancementBug# 2427465, FileVersion# 615.2
1177: tax_category_id column is populated into PO and SO localization tables, which will be used to
1178: identify from which tax_category the taxes are defaulted. Also the tax_category_id populated into
1179: the tax table will be useful to identify whether the tax is a defaulted or a manual tax.
1180: A cursor is modified to fetch tax_category_id. UPDATE statement of JAI_PO_LINE_LOCATIONS is modified to update
1181: tax_category_id column with defaulting tax category
1182: 3 04/02/2003 cbabu for Bug# 2782356, FileVersion# 615.3, Bug logged for IN60104
1183: Adhoc tax amounts are not defaulted from requisition taxes to STANDARD PO autocreated from requisition
1184:
1244:
1245: 15. 26-Aug-2009 Bgowrava for Bug#8766851 , File Version
1246: Issue: CAN'T AUTOCREATE PO FOR INDIA OPERATING ORG
1247: Fix: Introduced the v_reqn_tax variable to hold the value of number of taxes on the purchase requisition and if this is greater than zero then
1248: the code for calculating tax and updating JaI_Po_Line_Locations is done.
1249:
1250: 16. 10-Sep-2010 Jia for GST Bug#10091373.
1251:
1252: 17. 19-Apr-2011 Xiao for bug#12344603
1496: CLOSE Fetch_Vendor_Id;
1497: END IF;
1498:
1499: -- Vijay Shankar for Bug# 3193592
1500: select count(1) into v_line_loc_cnt from JAI_PO_LINE_LOCATIONS
1501: where line_location_id = pr_new.line_location_id;
1502:
1503: IF v_debug THEN -- bug 7218695. Added by Lakshmi Gopalsami
1504: UTL_FILE.PUT_LINE(v_myfilehandle, 'pr_new.line_location_id '|| pr_new.line_location_id);
1827: CLOSE c_get_tax_category_id;
1828:
1829:
1830:
1831: UPDATE JaI_Po_Line_Locations
1832: SET Tax_Amount = NVL( v_tax_amt, 0 ),
1833: Total_Amount = NVL( Line_Tot, 0 ) + NVL( v_tax_amt, 0 ),
1834: Last_Updated_By = v_last_upd_by,
1835: Last_Update_Date = v_last_upd_dt,