The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_row
( p_row_id IN OUT NOCOPY VARCHAR2
, p_credit_usage_rule_set_id NUMBER
, p_credit_usage_rule_id NUMBER
, p_usage_type VARCHAR2
, p_user_code VARCHAR2
, p_exclude_flag VARCHAR2
, p_include_all_flag VARCHAR2
, p_creation_date DATE
, p_created_by NUMBER
, p_last_update_date DATE
, p_last_updated_by NUMBER
, p_last_update_login 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
)
IS
CURSOR usage_rule_csr IS
SELECT
rowid
FROM
HZ_CREDIT_USAGE_RULES
WHERE credit_usage_rule_id=p_credit_usage_rule_id;
INSERT INTO hz_credit_usage_rules
( credit_usage_rule_id
, usage_type
, user_code
, exclude_flag
, include_all_flag
, credit_usage_rule_set_id
, creation_date
, created_by
, last_update_date
, last_updated_by
, last_update_login
, program_application_id
, program_id
, program_update_date
, request_id
, attribute_category
, attribute1
, attribute2
, attribute3
, attribute4
, attribute5
, attribute6
, attribute7
, attribute8
, attribute9
, attribute10
, attribute11
, attribute12
, attribute13
, attribute14
, attribute15
)
VALUES
( p_credit_usage_rule_id
, p_usage_type
, p_user_code
, p_exclude_flag
, p_include_all_flag
, p_credit_usage_rule_set_id
, p_creation_date
, p_created_by
, p_last_update_date
, p_last_updated_by
, p_last_update_login
, null
, null
, null
, null
, 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
);
FND_MSG_PUB.Add_exc_msg(G_PKG_NAME,'Insert_row');
END Insert_row;
SELECT *
FROM HZ_CREDIT_USAGE_RULES
WHERE ROWID=CHARTOROWID(p_row_id)
FOR UPDATE OF user_code NOWAIT;
FND_MESSAGE.Set_name('FND', 'FORM_RECORD_DELETED');
PROCEDURE Update_row
( p_row_id VARCHAR2
, p_usage_type VARCHAR2
, p_user_code VARCHAR2
, p_exclude_flag VARCHAR2
, p_include_all_flag VARCHAR2
, p_last_update_date DATE
, p_last_updated_by 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
)
IS
BEGIN
UPDATE HZ_CREDIT_USAGE_RULES
SET
usage_type=p_usage_type
,user_code=p_user_code
,exclude_flag=p_exclude_flag
,include_all_flag=p_include_all_flag
,last_update_date=p_last_update_date
,last_updated_by=p_last_updated_by
, 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
WHERE ROWID=CHARTOROWID(p_row_id);
FND_MSG_PUB.Add_exc_msg(G_PKG_NAME,'Update_row');
END Update_Row;
PROCEDURE Delete_row
( p_credit_usage_rule_id NUMBER
)
IS
BEGIN
DELETE
FROM HZ_CREDIT_USAGE_RULES
WHERE credit_usage_rule_id=p_credit_usage_rule_id;
FND_MSG_PUB.Add_exc_msg(G_PKG_NAME,'Delete_row');
END Delete_row;