The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT cn_srp_pmt_plans_s.nextval
INTO X_srp_pmt_plan_id
FROM dual;
PROCEDURE insert_row
(x_srp_pmt_plan_id IN OUT NOCOPY NUMBER
,x_pmt_plan_id IN NUMBER
,x_salesrep_id IN NUMBER
,x_org_id IN NUMBER
,x_role_id IN NUMBER
,x_credit_type_id IN NUMBER
,x_start_date DATE
,x_end_date DATE
,x_minimum_amount IN NUMBER
,x_maximum_amount IN NUMBER
,x_max_recovery_amount IN 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_Created_By NUMBER
,x_Creation_Date DATE
,x_Last_Updated_By NUMBER
,x_Last_Update_Date DATE
,x_Last_Update_Login NUMBER
,x_srp_role_id NUMBER
,x_role_pmt_plan_id NUMBER
,x_lock_flag VARCHAR2)
IS
l_dummy NUMBER;
INSERT INTO cn_srp_pmt_plans
(srp_pmt_plan_id
,pmt_plan_id
,salesrep_id
,org_id
,role_id
,credit_type_id
,start_date
,end_date
,minimum_amount
,maximum_amount
,max_recovery_amount
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,Created_By
,Creation_Date
,Last_Updated_By
,Last_Update_Date
,Last_Update_Login
,object_version_number
,srp_role_id
,role_pmt_plan_id
,lock_flag)
VALUES
(x_srp_pmt_plan_id
,x_pmt_plan_id
,x_salesrep_id
,x_org_id
,x_role_id
,x_credit_type_id
,x_start_date
,x_end_date
,x_minimum_amount
,x_maximum_amount
,x_max_recovery_amount
,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
,x_Created_By
,x_Creation_Date
,x_Last_Updated_By
,x_Last_Update_Date
,x_Last_Update_Login
,1
,x_srp_role_id
,x_role_pmt_plan_id
,NVL(x_lock_flag, 'N')
);
select 1 INTO l_dummy from CN_SRP_PMT_PLANS
where SRP_PMT_PLAN_ID = x_srp_pmt_plan_id;
END Insert_row;
SELECT *
FROM cn_srp_pmt_plans
WHERE srp_pmt_plan_id = x_srp_pmt_plan_id
FOR UPDATE of srp_pmt_plan_id NOWAIT;
fnd_message.Set_Name('FND', 'FORM_RECORD_DELETED');
PROCEDURE update_row
(x_srp_pmt_plan_id NUMBER
,x_pmt_plan_id NUMBER
,x_salesrep_id NUMBER
,x_org_id NUMBER
,x_role_id NUMBER
,x_credit_type_id NUMBER
,x_start_date DATE
,x_end_date DATE
,x_minimum_amount NUMBER
,x_maximum_amount NUMBER
,x_max_recovery_amount 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_Last_Updated_By NUMBER
,x_Last_Update_Date DATE
,x_Last_Update_Login NUMBER
,x_object_version_number NUMBER
,x_lock_flag VARCHAR2 ) IS
l_pmt_plan_id cn_srp_pmt_plans.pmt_plan_id%TYPE;
SELECT *
FROM cn_srp_pmt_plans
WHERE srp_pmt_plan_id = x_srp_pmt_plan_id
FOR UPDATE of srp_pmt_plan_id NOWAIT;
fnd_message.Set_Name('FND', 'FORM_RECORD_DELETED');
SELECT
decode(x_pmt_plan_id,
fnd_api.g_miss_num, oldrow.pmt_plan_id,
x_pmt_plan_id),
decode(x_salesrep_id,
fnd_api.g_miss_num, oldrow.salesrep_id,
x_salesrep_id),
decode(x_org_id,
fnd_api.g_miss_num, oldrow.org_id,
x_org_id),
decode(x_role_id,
fnd_api.g_miss_num, oldrow.role_id,
x_role_id),
decode(x_credit_type_id,
fnd_api.g_miss_num, oldrow.credit_type_id ,
x_credit_type_id),
decode(x_start_date,
fnd_api.g_miss_date, oldrow.start_date,
x_start_date),
decode(x_end_date,
fnd_api.g_miss_date, oldrow.end_date,
x_end_date),
decode(x_minimum_amount,
fnd_api.g_miss_num, oldrow.minimum_amount,
x_minimum_amount),
decode(x_maximum_amount,
fnd_api.g_miss_num, oldrow.maximum_amount,
x_maximum_amount),
decode(x_max_recovery_amount,
fnd_api.g_miss_num, oldrow.max_recovery_amount,
x_max_recovery_amount),
decode(x_attribute_category,
fnd_api.g_miss_char, oldrow.attribute_category,
x_attribute_category),
decode(x_attribute1,
fnd_api.g_miss_char, oldrow.attribute1,
x_attribute1),
decode(x_attribute2,
fnd_api.g_miss_char, oldrow.attribute2,
x_attribute2),
decode(x_attribute3,
fnd_api.g_miss_char, oldrow.attribute3,
x_attribute3),
decode(x_attribute4,
fnd_api.g_miss_char, oldrow.attribute4,
x_attribute4),
decode(x_attribute5,
fnd_api.g_miss_char, oldrow.attribute5,
x_attribute5),
decode(x_attribute6,
fnd_api.g_miss_char, oldrow.attribute6,
x_attribute6),
decode(x_attribute7,
fnd_api.g_miss_char, oldrow.attribute7,
x_attribute7),
decode(x_attribute8,
fnd_api.g_miss_char, oldrow.attribute8,
x_attribute8),
decode(x_attribute9,
fnd_api.g_miss_char, oldrow.attribute9,
x_attribute9),
decode(x_attribute10,
fnd_api.g_miss_char, oldrow.attribute10,
x_attribute10),
decode(x_attribute11,
fnd_api.g_miss_char, oldrow.attribute11,
x_attribute11),
decode(x_attribute12,
fnd_api.g_miss_char, oldrow.attribute12,
x_attribute12),
decode(x_attribute13,
fnd_api.g_miss_char, oldrow.attribute13,
x_attribute13),
decode(x_attribute14,
fnd_api.g_miss_char, oldrow.attribute14,
x_attribute14),
decode(x_attribute15,
fnd_api.g_miss_char, oldrow.attribute15,
x_attribute15),
decode(x_lock_flag,
fnd_api.g_miss_char, oldrow.lock_flag,
x_lock_flag)
INTO
l_pmt_plan_id,
l_salesrep_id,
l_org_id,
l_role_id,
l_credit_type_id,
l_start_date,
l_end_date,
l_minimum_amount,
l_maximum_amount,
l_max_recovery_amount,
l_attribute_category,
l_attribute1,
l_attribute2,
l_attribute3,
l_attribute4,
l_attribute5,
l_attribute6,
l_attribute7,
l_attribute8,
l_attribute9,
l_attribute10,
l_attribute11,
l_attribute12,
l_attribute13,
l_attribute14,
l_attribute15,
l_lock_flag
FROM dual;
UPDATE cn_srp_pmt_plans
SET
pmt_plan_id = l_pmt_plan_id,
salesrep_id = l_salesrep_id,
org_id = l_org_id,
role_id = l_role_id,
credit_type_id = l_credit_type_id,
start_date = l_start_date,
end_date = l_end_date,
minimum_amount = l_minimum_amount,
maximum_amount = l_maximum_amount,
max_recovery_amount = l_max_recovery_amount,
attribute_category = l_attribute_category,
attribute1 = l_attribute1,
attribute2 = l_attribute2,
attribute3 = l_attribute3,
attribute4 = l_attribute4,
attribute5 = l_attribute5,
attribute6 = l_attribute6,
attribute7 = l_attribute7,
attribute8 = l_attribute8,
attribute9 = l_attribute9,
attribute10 = l_attribute10,
attribute11 = l_attribute11,
attribute12 = l_attribute12,
attribute13 = l_attribute13,
attribute14 = l_attribute14,
attribute15 = l_attribute15,
last_update_date = x_Last_Update_Date,
last_updated_by = x_Last_Updated_By,
last_update_login = x_Last_Update_Login,
object_version_number = nvl(X_OBJECT_VERSION_NUMBER,0) + 1,
lock_flag = l_lock_flag
WHERE srp_pmt_plan_id = x_srp_pmt_plan_id ;
END Update_row;
PROCEDURE Delete_row( x_srp_pmt_plan_id NUMBER ) IS
BEGIN
DELETE FROM cn_srp_pmt_plans
WHERE srp_pmt_plan_id = x_srp_pmt_plan_id;
END Delete_row;