The following lines contain the word 'select', 'insert', 'update' or 'delete':
v_last_upd_dt DATE ; --File.Sql.35 Cbabu := pr_new.Last_Update_Date ;
v_last_upd_by NUMBER; --File.Sql.35 Cbabu := pr_new.Last_Updated_By;
v_last_upd_login NUMBER; --File.Sql.35 Cbabu := pr_new.Last_Update_Login;
SELECT type_lookup_code,Quotation_Class_Code,Ship_To_Location_Id,
rate, rate_type, rate_date,currency_code,
style_id --Added by Sanjikum for Bug#4483042
FROM po_headers_all
WHERE po_header_id = v_po_hdr_id;
SELECT Inventory_Organization_Id
FROM Hr_Locations
WHERE Location_Id = v_ship_loc_id;
SELECT override_flag
FROM JAI_CMN_VENDOR_SITES
WHERE vendor_id = c_supplier_id
AND vendor_site_id = c_supp_site_id;
SELECT tax_modified_flag
FROM JAI_PO_LINE_LOCATIONS
WHERE line_location_id = pr_new.line_location_id ;
SELECT nvl(Vendor_id,0), nvl(vendor_Site_Id,0)
/* Added by Brathod for bug#4242351 */
,rate
,rate_type
,rate_date
,currency_code
/* End of Bug#4242351 */
FROM Po_Headers_All
WHERE Po_Header_Id = v_po_hdr_id;
SELECT Line_Location_Id
FROM po_line_locations_all
WHERE Po_Line_Id = lineid;
FILENAME: Ja_In_Po_dist_Tax_Insert_Trg.sql
CHANGE HISTORY:
S.No Date Author and Details
1. 09/11/2004 ssumaith - bug# 3949401 Version#115.1
commented the code which returns when the new.po_release_id is null
moved the code which returns the control if taxes are already present in the JAI_PO_TAXES table
for the current line_location_id to the else part of the shipment_type <> 'BLANKET'
Added code to delete taxes from the JAI_PO_LINE_LOCATIONS and JAI_PO_TAXES
when the new.req_distribution_id is not null
Added cursor and code for INR check and returning code if set of books currency is a non india currency.
2. 29/Nov/2004 Aiyer for bug#4035566. Version#115.2
Issue:-
The trigger should not get fired when the non-INR based set of books is attached to the current operating unit
where transaction is being done.
Fix:-
Function jai_cmn_utils_pkg.check_jai_exists is being called which returns the TRUE if the currency is INR and FALSE if the currency is
NON-INR
Removed the cursor c_Sob_Cur and the variable lv_currency_code
Dependency Due to this Bug:-
The current trigger becomes dependent on the function jai_cmn_utils_pkg.check_jai_exists version 115.0. introduced through the bug 4033992
3. 31/MAR/2005 BRATHOD For Bug#4242351, Version#115.4
Issue :- Procedure jai_po_tax_pkg.copy_reqn_taxes is modified for mutating error and procedure signature
has been changed and four new arguments are added. So call to jai_po_tax_pkg.copy_reqn_taxes
procedure in this trigger needs to be modified.
Resolution:- Call to jai_po_tax_pkg.copy_reqn_taxes is modified by passing required arguments.
4. 08-Jun-2005 This Object is Modified to refer to New DB Entity names in place of Old
DB Entity as required for CASE COMPLAINCE. Version 116.1
5. 13-Jun-2005 File Version: 116.2
Ramananda for bug#4428980. Removal of SQL LITERALs is done
6. 08-Jul-2005 Sanjikum for Bug#4483042
1) Added a call to jai_cmn_utils_pkg.validate_po_type, to check whether for the current PO
IL functionality should work or not.
7. 08-Jul-2005 Sanjikum for Bug#4483042, file version 117.2
1) Added a new column style_id in the cursor - get_po_hdr
8. 17-Aug-2005 Ramananda for bug#4513549 during R12 Sanity Testing. jai_mrg_t.sql File Version 120.2
Ported the jai_po_da_t1.sql 120.2 changes
Commented out the code which is deleting the taxes for the current
line location id. This is not required after the current fix
9. 04-Jun-2007 Bgowrava for Bug#6084636
Issue :
When the tax_override_flag = 'Y', existing taxes must be deleted and Requisition taxes
must get defaulted.
Fix :
Added code to delete taxes if the tax_modified_flag is 'N' and tax_override_flag = 'N'
Dependency :
There is a functional dependency on this Bug for all future Bugs.
Future Dependencies For the release Of this Object:-
(Please add a row in the section below only if your bug introduces a dependency due to spec change/ A new call to a object/
A datamodel change )
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Current Version Current Bug Dependent Files Version Author Date Remarks
Of File On Bug/Patchset Dependent On
ja_in_intrfc_lines_aft_ins_trg
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
115.2 4035566 IN60105D2 + ja_in_util_pkg_s.sql 115.0 Aiyer 29-Nov-2004 Call to this function.
4033992 ja_in_util_pkg_b.sql 115.0
120.2 jai_po_rla_t1.sql 120.2
(Functional)
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------*/
--File.Sql.35 Cbabu
v_po_line_id := pr_new.Po_Line_Id ;
v_last_upd_dt := pr_new.Last_Update_Date ;
v_last_upd_by := pr_new.Last_Updated_By;
v_last_upd_login := pr_new.Last_Update_Login;
/* Bug 4513549. Commented delete as this is no more required
after the new functionality change */
/*
if pr_new.po_release_id is null then
DELETE from ja_in_po_line_location_taxes
WHERE line_location_id = v_line_location_id;
DELETE from ja_in_po_line_locations
WHERE line_location_id = v_line_location_id;
DELETE from JAI_PO_TAXES
WHERE line_location_id = v_line_location_id;
DELETE from JAI_PO_LINE_LOCATIONS
WHERE line_location_id = v_line_location_id;
SELECT count(line_location_id)
into v_count1
FROM JAI_PO_LINE_LOCATIONS
WHERE line_location_id=v_line_location_id;