[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
X_Event_type_Id NUMBER, /** 2363945 **/
X_Event_Type VARCHAR2,
X_Last_Update_Date DATE,
X_Last_Updated_By NUMBER,
X_Creation_Date DATE,
X_Created_By NUMBER,
X_Last_Update_Login NUMBER,
X_Start_Date_Active DATE,
X_Event_Type_Classification VARCHAR2,
X_End_Date_Active DATE,
X_Description VARCHAR2,
X_Revenue_Category_Code VARCHAR2,
/* X_Output_tax_code VARCHAR2, Shared Services*/
X_Attribute_Category VARCHAR2,
X_Attribute1 VARCHAR2,
X_Attribute2 VARCHAR2,
X_Attribute3 VARCHAR2,
X_Attribute4 VARCHAR2,
X_Attribute5 VARCHAR2,
X_Attribute6 VARCHAR2,
X_Attribute7 VARCHAR2,
X_Attribute8 VARCHAR2,
X_Attribute9 VARCHAR2,
X_Attribute10 VARCHAR2,
X_Attribute11 VARCHAR2,
X_Attribute12 VARCHAR2,
X_Attribute13 VARCHAR2,
X_Attribute14 VARCHAR2,
X_Attribute15 VARCHAR2
) IS
CURSOR C IS SELECT rowid FROM PA_EVENT_TYPES
WHERE event_type = X_Event_Type;
CURSOR T IS SELECT VAT_TAX_ID
FROM PA_OUTPUT_TAX_CODE_SETUP_V
WHERE TAX_CODE = X_Output_tax_code ;
CURSOR O IS SELECT ORG_ID
FROM PA_IMPLEMENTATIONS;
INSERT INTO PA_EVENT_TYPES(
event_type,
event_type_id,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
start_date_active,
event_type_classification,
end_date_active,
description,
revenue_category_code,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15
) VALUES (
X_Event_Type,
X_Event_Type_Id,
X_Last_Update_Date,
X_Last_Updated_By,
X_Creation_Date,
X_Created_By,
X_Last_Update_Login,
X_Start_Date_Active,
X_Event_Type_Classification,
X_End_Date_Active,
X_Description,
X_Revenue_Category_Code,
X_Attribute_Category,
X_Attribute1,
X_Attribute2,
X_Attribute3,
X_Attribute4,
X_Attribute5,
X_Attribute6,
X_Attribute7,
X_Attribute8,
X_Attribute9,
X_Attribute10,
X_Attribute11,
X_Attribute12,
X_Attribute13,
X_Attribute14,
X_Attribute15
);
INSERT INTO PA_EVENT_TYPE_OUS
( EVENT_TYPE,
OUTPUT_TAX_CLASSIFICATION_CODE,
LAST_UPDATE_DATE,
CREATION_DATE,
LAST_UPDATED_BY,
CREATED_BY,
LAST_UPDATE_LOGIN,
ORG_ID
)
VALUES
( X_Event_Type,
X_OUTPUT_TAX_CODE,
X_Last_Update_Date,
X_Creation_Date,
X_Last_Updated_By,
X_Created_By,
X_Last_Update_Login,
L_ORG_ID );
END Insert_Row;
SELECT ET.*
FROM PA_EVENT_TYPES ET
WHERE ET.rowid = RTRIM(X_Rowid)
FOR UPDATE of ET.Event_Type NOWAIT;
SELECT ET.*, EOUS.OUTPUT_TAX_CLASSIFICATION_CODE OUTPUT_TAX_CODE
FROM PA_EVENT_TYPES ET,
PA_EVENT_TYPE_OUS EOUS
WHERE ET.rowid = RTRIM(X_Rowid)
and RTRIM(ET.EVENT_TYPE) = RTRIM(EOUS.EVENT_TYPE(+))
FOR UPDATE of ET.Event_Type NOWAIT;*/
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
PROCEDURE Update_Row(X_Rowid VARCHAR2,
X_Event_Type VARCHAR2,
X_Last_Update_Date DATE,
X_Last_Updated_By NUMBER,
X_Last_Update_Login NUMBER,
X_Start_Date_Active DATE,
X_Event_Type_Classification VARCHAR2,
X_End_Date_Active DATE,
X_Description VARCHAR2,
X_Revenue_Category_Code VARCHAR2,
/* X_Output_tax_code VARCHAR2, Shared Services*/
X_Attribute_Category VARCHAR2,
X_Attribute1 VARCHAR2,
X_Attribute2 VARCHAR2,
X_Attribute3 VARCHAR2,
X_Attribute4 VARCHAR2,
X_Attribute5 VARCHAR2,
X_Attribute6 VARCHAR2,
X_Attribute7 VARCHAR2,
X_Attribute8 VARCHAR2,
X_Attribute9 VARCHAR2,
X_Attribute10 VARCHAR2,
X_Attribute11 VARCHAR2,
X_Attribute12 VARCHAR2,
X_Attribute13 VARCHAR2,
X_Attribute14 VARCHAR2,
X_Attribute15 VARCHAR2
) IS
/*
CURSOR T IS SELECT VAT_TAX_ID
FROM PA_OUTPUT_TAX_CODE_SETUP_V
WHERE TAX_CODE = X_Output_tax_code ;
CURSOR O IS SELECT ORG_ID
FROM PA_IMPLEMENTATIONS;*/
UPDATE PA_EVENT_TYPES
SET
event_type = X_Event_Type,
last_update_date = X_Last_Update_Date,
last_updated_by = X_Last_Updated_By,
last_update_login = X_Last_Update_Login,
start_date_active = X_Start_Date_Active,
event_type_classification = X_Event_Type_Classification,
end_date_active = X_End_Date_Active,
description = X_Description,
revenue_category_code = X_Revenue_Category_Code,
attribute_Category = X_Attribute_Category,
attribute1 = X_Attribute1,
attribute2 = X_Attribute2,
attribute3 = X_Attribute3,
attribute4 = X_Attribute4,
attribute5 = X_Attribute5,
attribute6 = X_Attribute6,
attribute7 = X_Attribute7,
attribute8 = X_Attribute8,
attribute9 = X_Attribute9,
attribute10 = X_Attribute10,
attribute11 = X_Attribute11,
attribute12 = X_Attribute12,
attribute13 = X_Attribute13,
attribute14 = X_Attribute14,
attribute15 = X_Attribute15
WHERE rowid = X_Rowid;
UPDATE PA_EVENT_TYPE_OUS
SET OUTPUT_TAX_CLASSIFICATION_CODE = x_output_tax_code,
LAST_UPDATE_DATE = X_Last_Update_Date,
LAST_UPDATED_BY = X_Last_Updated_By,
LAST_UPDATE_LOGIN = X_Last_Update_Login
WHERE EVENT_TYPE = X_Event_Type;
INSERT INTO PA_EVENT_TYPE_OUS
( EVENT_TYPE,
OUTPUT_TAX_CLASSIFICATION_CODE,
LAST_UPDATE_DATE,
CREATION_DATE,
LAST_UPDATED_BY,
CREATED_BY,
LAST_UPDATE_LOGIN,
ORG_ID
)
VALUES
( X_Event_Type,
X_OUTPUT_TAX_CODE,
X_Last_Update_Date,
X_Last_Update_Date,
X_Last_Updated_By,
X_Last_Updated_By,
X_Last_Update_Login,
L_ORG_ID );
END Update_Row;
PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
BEGIN /* Rearranged the DELETE statements for bug 3182079 */
BEGIN
/* Delete record from PA_EVENT_TYPE_OUS */
DELETE FROM PA_EVENT_TYPE_OUS_ALL
WHERE EVENT_TYPE = ( SELECT EVENT_TYPE
FROM PA_EVENT_TYPES
WHERE rowid = X_Rowid);
DELETE FROM PA_EVENT_TYPES
WHERE rowid = X_Rowid;
END Delete_Row;