[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(p_Rowid IN OUT NOCOPY VARCHAR2,
p_Tax_exemption_id IN OUT NOCOPY NUMBER,
p_Last_updated_by NUMBER,
p_Last_update_date DATE,
p_Created_by NUMBER,
p_Creation_date DATE,
p_Status VARCHAR2,
p_Inventory_item_id NUMBER,
p_Customer_id NUMBER,
p_Site_use_id NUMBER,
p_Exemption_type VARCHAR2,
p_Tax_code VARCHAR2,
p_Percent_exempt NUMBER,
p_Customer_exemption_number VARCHAR2,
p_Start_date DATE,
p_End_date DATE,
p_Location_context VARCHAR2,
p_Location_id_segment_1 NUMBER,
p_Location_id_segment_2 NUMBER,
p_Location_id_segment_3 NUMBER,
p_Location_id_segment_4 NUMBER,
p_Location_id_segment_5 NUMBER,
p_Location_id_segment_6 NUMBER,
p_Location_id_segment_7 NUMBER,
p_Location_id_segment_8 NUMBER,
p_Location_id_segment_9 NUMBER,
p_Location_id_segment_10 NUMBER,
p_Attribute_category VARCHAR2,
p_Attribute1 VARCHAR2,
p_Attribute2 VARCHAR2,
p_Attribute3 VARCHAR2,
p_Attribute4 VARCHAR2,
p_Attribute5 VARCHAR2,
p_Attribute6 VARCHAR2,
p_Attribute7 VARCHAR2,
p_Attribute8 VARCHAR2,
p_Attribute9 VARCHAR2,
p_Attribute10 VARCHAR2,
p_Attribute11 VARCHAR2,
p_Attribute12 VARCHAR2,
p_Attribute13 VARCHAR2,
p_Attribute14 VARCHAR2,
p_Attribute15 VARCHAR2,
p_In_use_flag VARCHAR2,
p_Program_id NUMBER,
p_Program_update_date DATE,
p_Request_id NUMBER,
p_Program_application_id NUMBER,
p_Reason_code VARCHAR2,
p_Exempt_Context VARCHAR2,
p_Exempt_percent1 NUMBER,
p_Exempt_percent2 NUMBER,
p_Exempt_percent3 NUMBER,
p_Exempt_percent4 NUMBER,
p_Exempt_percent5 NUMBER,
p_Exempt_percent6 NUMBER,
p_Exempt_percent7 NUMBER,
p_Exempt_percent8 NUMBER,
p_Exempt_percent9 NUMBER,
p_Exempt_percent10 NUMBER,
p_org_id NUMBER
)
IS
CURSOR C IS SELECT rowid FROM RA_TAX_EXEMPTIONS
WHERE tax_exemption_id = p_Tax_exemption_id;
CURSOR C2 IS SELECT ra_tax_exemptions_s.nextval FROM dual;
INSERT INTO RA_TAX_EXEMPTIONS(
Tax_exemption_id,
Last_updated_by,
Last_update_date,
Created_by,
Creation_date,
Status,
Inventory_item_id,
Customer_id,
Site_use_id,
Exemption_type,
Tax_code,
Percent_exempt,
Customer_exemption_number,
Start_date,
End_date,
Location_context,
Location_id_segment_1,
Location_id_segment_2,
Location_id_segment_3,
Location_id_segment_4,
Location_id_segment_5,
Location_id_segment_6,
Location_id_segment_7,
Location_id_segment_8,
Location_id_segment_9,
Location_id_segment_10,
Attribute_category,
Attribute1,
Attribute2,
Attribute3,
Attribute4,
Attribute5,
Attribute6,
Attribute7,
Attribute8,
Attribute9,
Attribute10,
Attribute11,
Attribute12,
Attribute13,
Attribute14,
Attribute15,
In_use_flag,
Program_id,
Program_update_date,
Request_id,
Program_application_id,
Reason_code,
Exempt_Context,
Exempt_percent1,
Exempt_percent2,
Exempt_percent3,
Exempt_percent4,
Exempt_percent5,
Exempt_percent6,
Exempt_percent7,
Exempt_percent8,
Exempt_percent9,
Exempt_percent10,
org_id
)
VALUES (
p_Tax_exemption_id,
p_Last_updated_by,
p_Last_update_date,
p_Created_by,
p_Creation_date,
p_Status,
p_Inventory_item_id,
p_Customer_id,
p_Site_use_id,
p_Exemption_type,
p_Tax_code,
p_Percent_exempt,
p_Customer_exemption_number,
p_Start_date,
p_End_date,
p_Location_context,
p_Location_id_segment_1,
p_Location_id_segment_2,
p_Location_id_segment_3,
p_Location_id_segment_4,
p_Location_id_segment_5,
p_Location_id_segment_6,
p_Location_id_segment_7,
p_Location_id_segment_8,
p_Location_id_segment_9,
p_Location_id_segment_10,
p_Attribute_category,
p_Attribute1,
p_Attribute2,
p_Attribute3,
p_Attribute4,
p_Attribute5,
p_Attribute6,
p_Attribute7,
p_Attribute8,
p_Attribute9,
p_Attribute10,
p_Attribute11,
p_Attribute12,
p_Attribute13,
p_Attribute14,
p_Attribute15,
p_In_use_flag,
p_Program_id,
p_Program_update_date,
p_Request_id,
p_Program_application_id,
p_Reason_code,
p_Exempt_Context,
p_Exempt_percent1,
p_Exempt_percent2,
p_Exempt_percent3,
p_Exempt_percent4,
p_Exempt_percent5,
p_Exempt_percent6,
p_Exempt_percent7,
p_Exempt_percent8,
p_Exempt_percent9,
p_Exempt_percent10,
p_org_id
);
END Insert_Row;
p_Last_updated_by NUMBER,
p_Last_update_date DATE,
p_Created_by NUMBER,
p_Creation_date DATE,
p_Status VARCHAR2,
p_Inventory_item_id NUMBER,
p_Customer_id NUMBER,
p_Site_use_id NUMBER,
p_Exemption_type VARCHAR2,
p_Tax_code VARCHAR2,
p_Percent_exempt NUMBER,
p_Customer_exemption_number VARCHAR2,
p_Start_date DATE,
p_End_date DATE,
p_Location_context VARCHAR2,
p_Location_id_segment_1 NUMBER,
p_Location_id_segment_2 NUMBER,
p_Location_id_segment_3 NUMBER,
p_Location_id_segment_4 NUMBER,
p_Location_id_segment_5 NUMBER,
p_Location_id_segment_6 NUMBER,
p_Location_id_segment_7 NUMBER,
p_Location_id_segment_8 NUMBER,
p_Location_id_segment_9 NUMBER,
p_Location_id_segment_10 NUMBER,
p_Attribute_category VARCHAR2,
p_Attribute1 VARCHAR2,
p_Attribute2 VARCHAR2,
p_Attribute3 VARCHAR2,
p_Attribute4 VARCHAR2,
p_Attribute5 VARCHAR2,
p_Attribute6 VARCHAR2,
p_Attribute7 VARCHAR2,
p_Attribute8 VARCHAR2,
p_Attribute9 VARCHAR2,
p_Attribute10 VARCHAR2,
p_Attribute11 VARCHAR2,
p_Attribute12 VARCHAR2,
p_Attribute13 VARCHAR2,
p_Attribute14 VARCHAR2,
p_Attribute15 VARCHAR2,
p_In_use_flag VARCHAR2,
p_Program_id NUMBER,
p_Program_update_date DATE,
p_Request_id NUMBER,
p_Program_application_id NUMBER,
p_Reason_code VARCHAR2,
p_Exempt_Context VARCHAR2,
p_Exempt_percent1 NUMBER,
p_Exempt_percent2 NUMBER,
p_Exempt_percent3 NUMBER,
p_Exempt_percent4 NUMBER,
p_Exempt_percent5 NUMBER,
p_Exempt_percent6 NUMBER,
p_Exempt_percent7 NUMBER,
p_Exempt_percent8 NUMBER,
p_Exempt_percent9 NUMBER,
p_Exempt_percent10 NUMBER
) IS
CURSOR C IS
SELECT *
FROM RA_TAX_EXEMPTIONS
WHERE rowid = p_Rowid
FOR UPDATE of Tax_Exemption_Id NOWAIT;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
AND ( (Recinfo.program_update_date = p_program_update_date)
OR ( (Recinfo.program_update_date IS NULL)
AND (p_program_update_date IS NULL)))
AND ( (Recinfo.request_id = p_request_id)
OR ( (Recinfo.request_id IS NULL)
AND (p_request_id IS NULL)))
AND ( (Recinfo.program_application_id = p_program_application_id)
OR ( (Recinfo.program_application_id IS NULL)
AND (p_program_application_id IS NULL)))
AND ( (Recinfo.reason_code = p_reason_code)
OR ( (Recinfo.reason_code IS NULL)
AND (p_reason_code IS NULL)))
AND ( (Recinfo.Exempt_Context = p_Exempt_Context)
OR ( (Recinfo.Exempt_Context IS NULL)
AND (p_Exempt_context IS NULL)))
AND ( (Recinfo.Exempt_Percent1 = p_Exempt_Percent1)
OR ( (Recinfo.Exempt_Percent1 IS NULL)
AND (p_Exempt_Percent1 IS NULL)))
AND ( (Recinfo.Exempt_Percent2 = p_Exempt_Percent2)
OR ( (Recinfo.Exempt_Percent2 IS NULL)
AND (p_Exempt_Percent2 IS NULL)))
AND ( (Recinfo.Exempt_Percent3 = p_Exempt_Percent3)
OR ( (Recinfo.Exempt_Percent3 IS NULL)
AND (p_Exempt_Percent3 IS NULL)))
AND ( (Recinfo.Exempt_Percent4 = p_Exempt_Percent4)
OR ( (Recinfo.Exempt_Percent4 IS NULL)
AND (p_Exempt_Percent4 IS NULL)))
AND ( (Recinfo.Exempt_Percent5 = p_Exempt_Percent5)
OR ( (Recinfo.Exempt_Percent5 IS NULL)
AND (p_Exempt_Percent5 IS NULL)))
AND ( (Recinfo.Exempt_Percent6 = p_Exempt_Percent6)
OR ( (Recinfo.Exempt_Percent6 IS NULL)
AND (p_Exempt_Percent6 IS NULL)))
AND ( (Recinfo.Exempt_Percent7 = p_Exempt_Percent7)
OR ( (Recinfo.Exempt_Percent7 IS NULL)
AND (p_Exempt_Percent7 IS NULL)))
AND ( (Recinfo.Exempt_Percent8 = p_Exempt_Percent8)
OR ( (Recinfo.Exempt_Percent8 IS NULL)
AND (p_Exempt_Percent8 IS NULL)))
AND ( (Recinfo.Exempt_Percent9 = p_Exempt_Percent9)
OR ( (Recinfo.Exempt_Percent9 IS NULL)
AND (p_Exempt_Percent9 IS NULL)))
AND ( (Recinfo.Exempt_Percent10 = p_Exempt_Percent10)
OR ( (Recinfo.Exempt_Percent10 IS NULL)
AND (p_Exempt_Percent10 IS NULL)))
) then
return;
PROCEDURE Update_Row(p_Rowid VARCHAR2,
p_Tax_exemption_id NUMBER,
p_Last_updated_by NUMBER,
p_Last_update_date DATE,
p_Created_by NUMBER,
p_Creation_date DATE,
p_Status VARCHAR2,
p_Inventory_item_id NUMBER,
p_Customer_id NUMBER,
p_Site_use_id NUMBER,
p_Exemption_type VARCHAR2,
p_Tax_code VARCHAR2,
p_Percent_exempt NUMBER,
p_Customer_exemption_number VARCHAR2,
p_Start_date DATE,
p_End_date DATE,
p_Location_context VARCHAR2,
p_Location_id_segment_1 NUMBER,
p_Location_id_segment_2 NUMBER,
p_Location_id_segment_3 NUMBER,
p_Location_id_segment_4 NUMBER,
p_Location_id_segment_5 NUMBER,
p_Location_id_segment_6 NUMBER,
p_Location_id_segment_7 NUMBER,
p_Location_id_segment_8 NUMBER,
p_Location_id_segment_9 NUMBER,
p_Location_id_segment_10 NUMBER,
p_Attribute_category VARCHAR2,
p_Attribute1 VARCHAR2,
p_Attribute2 VARCHAR2,
p_Attribute3 VARCHAR2,
p_Attribute4 VARCHAR2,
p_Attribute5 VARCHAR2,
p_Attribute6 VARCHAR2,
p_Attribute7 VARCHAR2,
p_Attribute8 VARCHAR2,
p_Attribute9 VARCHAR2,
p_Attribute10 VARCHAR2,
p_Attribute11 VARCHAR2,
p_Attribute12 VARCHAR2,
p_Attribute13 VARCHAR2,
p_Attribute14 VARCHAR2,
p_Attribute15 VARCHAR2,
p_In_use_flag VARCHAR2,
p_Program_id NUMBER,
p_Program_update_date DATE,
p_Request_id NUMBER,
p_Program_application_id NUMBER,
p_Reason_code VARCHAR2,
p_Exempt_Context VARCHAR2,
p_Exempt_percent1 NUMBER,
p_Exempt_percent2 NUMBER,
p_Exempt_percent3 NUMBER,
p_Exempt_percent4 NUMBER,
p_Exempt_percent5 NUMBER,
p_Exempt_percent6 NUMBER,
p_Exempt_percent7 NUMBER,
p_Exempt_percent8 NUMBER,
p_Exempt_percent9 NUMBER,
p_Exempt_percent10 NUMBER
) IS
BEGIN
UPDATE RA_TAX_EXEMPTIONS
SET
Tax_exemption_id = p_Tax_exemption_id,
Last_updated_by = p_Last_updated_by,
Last_update_date = p_Last_update_date,
Created_by = p_Created_by,
Creation_date = p_Creation_date,
Status = p_Status,
Inventory_item_id = p_Inventory_item_id,
Customer_id = p_Customer_id,
Site_use_id = p_Site_use_id,
Exemption_type = p_Exemption_type,
Tax_code = p_Tax_code,
Percent_exempt = p_Percent_exempt,
Customer_exemption_number = p_Customer_exemption_number,
Start_date = p_Start_date,
End_date = p_End_date,
Location_context = p_Location_context,
Location_id_segment_1 = p_Location_id_segment_1,
Location_id_segment_2 = p_Location_id_segment_2,
Location_id_segment_3 = p_Location_id_segment_3,
Location_id_segment_4 = p_Location_id_segment_4,
Location_id_segment_5 = p_Location_id_segment_5,
Location_id_segment_6 = p_Location_id_segment_6,
Location_id_segment_7 = p_Location_id_segment_7,
Location_id_segment_8 = p_Location_id_segment_8,
Location_id_segment_9 = p_Location_id_segment_9,
Location_id_segment_10 = p_Location_id_segment_10,
Attribute_category = p_Attribute_category,
Attribute1 = p_Attribute1,
Attribute2 = p_Attribute2,
Attribute3 = p_Attribute3,
Attribute4 = p_Attribute4,
Attribute5 = p_Attribute5,
Attribute6 = p_Attribute6,
Attribute7 = p_Attribute7,
Attribute8 = p_Attribute8,
Attribute9 = p_Attribute9,
Attribute10 = p_Attribute10,
Attribute11 = p_Attribute11,
Attribute12 = p_Attribute12,
Attribute13 = p_Attribute13,
Attribute14 = p_Attribute14,
Attribute15 = p_Attribute15,
In_use_flag = p_In_use_flag,
Program_id = p_Program_id,
Program_update_date = p_Program_update_date,
Request_id = p_Request_id,
Program_application_id = p_Program_application_id,
Reason_code = p_Reason_code,
Exempt_Context = p_Exempt_Context,
Exempt_Percent1 = p_Exempt_percent1,
Exempt_Percent2 = p_Exempt_percent2,
Exempt_Percent3 = p_Exempt_percent3,
Exempt_Percent4 = p_Exempt_percent4,
Exempt_Percent5 = p_Exempt_percent5,
Exempt_Percent6 = p_Exempt_percent6,
Exempt_Percent7 = p_Exempt_percent7,
Exempt_Percent8 = p_Exempt_percent8,
Exempt_Percent9 = p_Exempt_percent9,
Exempt_Percent10 = p_Exempt_percent10
WHERE rowid = p_Rowid;
END Update_Row;
PROCEDURE Delete_Row(p_Rowid VARCHAR2) IS
BEGIN
DELETE FROM RA_TAX_EXEMPTIONS
WHERE rowid = p_Rowid;
END Delete_Row;