[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(X_Agreement_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_Revenue_Limit_Flag VARCHAR2,
X_Start_Date_Active DATE,
X_End_Date_Active DATE,
X_Description VARCHAR2,
X_Term_Id NUMBER,
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,
X_return_status OUT NOCOPY VARCHAR2,/*File.sql.39*/
X_msg_count OUT NOCOPY NUMBER,/*File.sql.39*/
X_msg_data OUT NOCOPY VARCHAR2/*File.sql.39*/
)
IS
BEGIN
INSERT INTO Pa_agreement_types
( Agreement_type
, last_update_date
, last_updated_by
, creation_date
, created_by
, last_update_login
, revenue_limit_flag
, start_date_active
, end_date_active
, description
, term_id
, attribute_category
, attribute1
, attribute2
, attribute3
, attribute4
, attribute5
, attribute6
, attribute7
, attribute8
, attribute9
, attribute10
, attribute11
, attribute12
, attribute13
, attribute14
, attribute15 )
VALUES
( X_Agreement_type
, X_last_update_date
, X_last_updated_by
, X_creation_date
, X_created_by
, X_last_update_login
, X_revenue_limit_flag
, X_start_date_active
, X_end_date_active
, X_description
, X_term_id
, 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 );
p_procedure_name => 'Insert_Row');
X_Last_Update_Date DATE,
X_Last_Updated_By NUMBER,
X_Creation_Date DATE,
X_Created_By NUMBER,
X_Last_Update_Login NUMBER,
X_Revenue_Limit_Flag VARCHAR2,
X_Start_Date_Active DATE,
X_End_Date_Active DATE,
X_Description VARCHAR2,
X_Term_Id NUMBER,
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,
X_return_status OUT NOCOPY VARCHAR2,/*File.sql.39*/
X_msg_count OUT NOCOPY NUMBER,/*File.sql.39*/
X_msg_data OUT NOCOPY VARCHAR2/*File.sql.39*/
)
IS
CURSOR C IS
SELECT *
FROM Pa_Agreement_Types
WHERE Agreement_Type = X_Agreement_Type
FOR UPDATE of Agreement_Type NOWAIT;
PROCEDURE Update_Row(X_Agreement_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_Revenue_Limit_Flag VARCHAR2,
X_Start_Date_Active DATE,
X_End_Date_Active DATE,
X_Description VARCHAR2,
X_Term_Id NUMBER,
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,
X_return_status OUT NOCOPY VARCHAR2, /*File.sql.39*/
X_msg_count OUT NOCOPY NUMBER, /*File.sql.39*/
X_msg_data OUT NOCOPY VARCHAR2 /*File.sql.39*/
)
IS
BEGIN
UPDATE Pa_Agreement_Types SET
Last_Update_Date = X_Last_Update_Date ,
Last_Updated_By = X_Last_Updated_By ,
Creation_Date = X_Creation_Date ,
Created_By = X_Created_By ,
Last_Update_Login = X_Last_Update_Login ,
Revenue_Limit_Flag = X_Revenue_Limit_Flag ,
Start_Date_Active = X_Start_Date_Active ,
End_Date_Active = X_End_Date_Active ,
Description = X_Description ,
Term_Id = X_Term_Id ,
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 Agreement_Type = X_agreement_Type;
p_procedure_name => 'Update_Row');