[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select Currency_code
from gl_sets_of_books
where set_of_books_id = v_gl_set_of_bks_id;
CURSOR Check_Llid_Cur IS SELECT COUNT( Line_Location_Id )
FROM JAI_PO_TAXES
WHERE Po_Line_Id = v_po_line_id;
FILENAME: Ja_In_Po_Lines_Tax_Delete_Trg.sql
CHANGE HISTORY:
S.No Date Author and Details
1 29-Nov-2004 Sanjikum for 4035297. Version 115.1
Changed the 'INR' check. Added the call to jai_cmn_utils_pkg.check_jai_exists
Dependency Due to this Bug:-
The current trigger becomes dependent on the function jai_cmn_utils_pkg.check_jai_exists version 115.0.
2. 08-Jun-2005 This Object is Modified to refer to New DB Entity names in place of Old
DB Entity as requiredfor CASE COMPLAINCE. Version 116.1
3. 13-Jun-2005 File Version: 116.2
Ramananda for bug#4428980. Removal of SQL LITERALs is done
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_Po_Lines_Tax_Delete_Trg.sql
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
115.1 4035297 IN60105D2+4033992 ja_in_util_pkg_s.sql 115.0 Sanjikum 29-Nov-2004 Call to this function.
ja_in_util_pkg_s.sql 115.0 Sanjikum
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------*/
--File.Sql.35 Cbabu
v_operating_id :=pr_new.ORG_ID;
DELETE FROM JAI_PO_LINE_LOCATIONS
WHERE Po_Line_Id = v_po_line_id;
DELETE FROM JAI_PO_TAXES
WHERE Po_Line_Id = v_po_line_id;
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, Vendor_id,
Vendor_Site_Id, Currency_Code, Ship_To_Location_Id
, from_header_id, from_type_lookup_code -- Vijay Shankar for Bug# 3466223
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 tax_modified_flag
FROM JAI_PO_LINE_LOCATIONS
WHERE po_line_id = p_po_line_id
AND line_location_id IS NULL;
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;
pr_new.PROGRAM_UPDATE_DATE ,
pr_new.CLOSED_DATE ,
pr_new.CLOSED_REASON ,
pr_new.CLOSED_BY ,
pr_new.TRANSACTION_REASON_CODE ,
pr_new.ORG_ID ,
pr_new.QC_GRADE ,
pr_new.BASE_UOM ,
pr_new.BASE_QTY ,
pr_new.SECONDARY_UOM ,
pr_new.SECONDARY_QTY ,
pr_new.LINE_REFERENCE_NUM ,
pr_new.PROJECT_ID ,
pr_new.TASK_ID ,
pr_new.EXPIRATION_DATE ,
pr_new.TAX_CODE_ID
);
Insert into JAI_PO_COPYDOC_T(
TYPE, PO_HEADER_ID, PO_LINE_ID, LINE_LOCATION_ID, LINE_NUM,
SHIPMENT_NUM, ITEM_ID, FROM_HEADER_ID, FROM_TYPE_LOOKUP_CODE,
CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN
) Values (
'L', v_po_hdr_id, v_po_line_id, NULL, pr_new.line_num,
NULL, v_item_id, v_from_header_id, v_from_type_lookup_code,
v_cre_dt, v_cre_by, v_last_upd_dt, v_last_upd_by, v_last_upd_login
);
jai_po_cmn_pkg.insert_line( 'CATALOG', NULL,
v_po_hdr_id, v_po_line_id, v_cre_dt,
v_cre_by, v_last_upd_dt, v_last_upd_by, v_last_upd_login, 'I'
);
select Currency_code
from gl_sets_of_books
where set_of_books_id = v_gl_set_of_bks_id;
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;
CURSOR POC_Cur IS SELECT Rowid
FROM Po_Headers_All
WHERE Po_Header_Id = v_po_hdr_id;
CURSOR Check_Rfq_Quot_Cur IS SELECT Type_Lookup_Code, Quotation_Class_Code, Vendor_id,
Vendor_Site_Id, Currency_Code, Ship_To_Location_Id,
style_id --Added by Sanjikum for Bug#4483042
FROM Po_Headers_All
WHERE Po_Header_Id = v_po_hdr_id;
CURSOR Fetch_Org_Id_Cur IS SELECT Inventory_Organization_Id
FROM Hr_Locations
WHERE Location_Id = v_ship_loc_id;
CURSOR Fetch_Lines_Cur IS SELECT Line_Location_Id, Price_Override, Quantity, Unit_Meas_Lookup_Code
FROM Po_Line_Locations_All
WHERE Po_Line_Id = v_po_line_id;
CURSOR Fetch_Flag_Cur( llid IN NUMBER ) IS SELECT NVL( Tax_Modified_Flag, 'N' ) Tax_Modified_Flag
FROM JAI_PO_LINE_LOCATIONS
WHERE Line_Location_Id = llid
AND Po_Line_Id = v_po_line_id;
FILENAME: Ja_In_Po_Lines_Tax_Update_Trg.sql
CHANGE HISTORY:
S.No Date Author and Details
1 29-Nov-2004 Sanjikum for 4035297. Version 115.1
Changed the 'INR' check. Added the call to jai_cmn_utils_pkg.check_jai_exists
2. 19-Mar-05 rallamse for bug#4227171 Version#115.2
Remove automatic GSCC errors
3. 19-Mar-05 rallamse for bug#4250072 Version#115.3
Changes for VAT
Dependency Due to this Bug:-
The current trigger becomes dependent on the function jai_cmn_utils_pkg.check_jai_exists version 115.0.
4. 08-Jun-2005 This Object is Modified to refer to New DB Entity names in place of Old DB Entity Names,
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.File Version: 116.3
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. 8-Jul-2005 File Version: 116.3
rchandan for bug#4479131
The object is modified to eliminate the paddr usage.
8. 12-Jul-2005 Sanjikum for Bug#4483042.File Version: 117.2
1) Added a new parameter in cursor - Check_Rfq_Quot_Cur
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_Po_Lines_Tax_Update_Trg.sql
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
115.1 4035297 IN60105D2+4033992 ja_in_util_pkg_s.sql 115.0 Sanjikum 29-Nov-2004 Call to this function.
ja_in_util_pkg_s.sql 115.0 Sanjikum
115.3 4250072 IN60106 +
4035297 +
4245089
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------*/
--File.Sql.35 Cbabu
v_operating_id :=pr_new.ORG_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;
P_PROGRAM_UPDATE_DATE =>pr_new.PROGRAM_UPDATE_DATE ,
P_CLOSED_DATE =>pr_new.CLOSED_DATE ,
P_CLOSED_REASON =>pr_new.CLOSED_REASON ,
P_CLOSED_BY =>pr_new.CLOSED_BY ,
P_TRANSACTION_REASON_CODE =>pr_new.TRANSACTION_REASON_CODE ,
P_ORG_ID =>pr_new.ORG_ID ,
P_QC_GRADE =>pr_new.QC_GRADE ,
P_BASE_UOM =>pr_new.BASE_UOM ,
P_BASE_QTY =>pr_new.BASE_QTY ,
P_SECONDARY_UOM =>pr_new.SECONDARY_UOM ,
P_SECONDARY_QTY =>pr_new.SECONDARY_QTY ,
P_LINE_REFERENCE_NUM =>pr_new.LINE_REFERENCE_NUM ,
P_PROJECT_ID =>pr_new.PROJECT_ID ,
P_TASK_ID =>pr_new.TASK_ID ,
P_EXPIRATION_DATE =>pr_new.EXPIRATION_DATE ,
P_TAX_CODE_ID =>pr_new.TAX_CODE_ID
);
DELETE FROM JAI_PO_TAXES
WHERE Line_Location_Id = v_line_loc_id;
jai_po_cmn_pkg.insert_line( 'CATALOG',
v_line_loc_id,
v_po_hdr_id,
v_po_line_id,
v_cre_dt,
v_cre_by,
v_last_upd_dt,
v_last_upd_by,
v_last_upd_login,
'U' );