The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row
( p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
p_return_status OUT NOCOPY VARCHAR2,
p_msg_count OUT NOCOPY NUMBER,
p_msg_data OUT NOCOPY VARCHAR2,
P_ALLOCATION_RULE_PERCENT_ID IN OUT NOCOPY NUMBER,
P_ALLOCATION_RULE_ID IN NUMBER,
P_PERIOD_NUM IN NUMBER,
P_MONTHLY IN NUMBER,
P_QUARTERLY IN NUMBER,
P_SEMI_ANNUAL IN NUMBER,
P_ATTRIBUTE1 IN VARCHAR2,
P_ATTRIBUTE2 IN VARCHAR2,
P_ATTRIBUTE3 IN VARCHAR2,
P_ATTRIBUTE4 IN VARCHAR2,
P_ATTRIBUTE5 IN VARCHAR2,
P_CONTEXT IN VARCHAR2,
P_LAST_UPDATE_DATE IN DATE,
P_LAST_UPDATED_BY IN NUMBER,
P_LAST_UPDATE_LOGIN IN NUMBER,
P_CREATED_BY IN NUMBER,
P_CREATION_DATE IN DATE
) IS
l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
select PSB_Allocrule_percents_S.NEXTVAL from DUAL ;
SAVEPOINT Insert_Row_Pvt;
INSERT INTO PSB_ALLOCRULE_PERCENTS (
allocation_rule_percent_id,
allocation_rule_id,
number_of_periods,
period_num,
percent,
last_update_date,
last_updated_by,
last_update_login,
created_by,
creation_date,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
context)
VALUES (
P_ALLOCATION_RULE_PERCENT_ID,
P_ALLOCATION_RULE_ID,
12,
P_PERIOD_NUM,
P_MONTHLY,
P_LAST_UPDATE_DATE,
P_LAST_UPDATED_BY,
P_LAST_UPDATE_LOGIN,
P_CREATED_BY,
P_CREATION_DATE,
P_ATTRIBUTE1,
P_ATTRIBUTE2,
P_ATTRIBUTE3,
P_ATTRIBUTE4,
P_ATTRIBUTE5,
P_CONTEXT);
INSERT INTO PSB_ALLOCRULE_PERCENTS (
allocation_rule_percent_id,
allocation_rule_id,
number_of_periods,
period_num,
percent,
last_update_date,
last_updated_by,
last_update_login,
created_by,
creation_date,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
context)
VALUES (
P_ALLOCATION_RULE_PERCENT_ID,
P_ALLOCATION_RULE_ID,
4,
P_PERIOD_NUM,
P_QUARTERLY,
P_LAST_UPDATE_DATE,
P_LAST_UPDATED_BY,
P_LAST_UPDATE_LOGIN,
P_CREATED_BY,
P_CREATION_DATE,
P_ATTRIBUTE1,
P_ATTRIBUTE2,
P_ATTRIBUTE3,
P_ATTRIBUTE4,
P_ATTRIBUTE5,
P_CONTEXT);
INSERT INTO PSB_ALLOCRULE_PERCENTS (
allocation_rule_percent_id,
allocation_rule_id,
number_of_periods,
period_num,
percent,
last_update_date,
last_updated_by,
last_update_login,
created_by,
creation_date,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
context)
VALUES (
P_ALLOCATION_RULE_PERCENT_ID,
P_ALLOCATION_RULE_ID,
2,
P_PERIOD_NUM,
P_SEMI_ANNUAL,
P_LAST_UPDATE_DATE,
P_LAST_UPDATED_BY,
P_LAST_UPDATE_LOGIN,
P_CREATED_BY,
P_CREATION_DATE,
P_ATTRIBUTE1,
P_ATTRIBUTE2,
P_ATTRIBUTE3,
P_ATTRIBUTE4,
P_ATTRIBUTE5,
P_CONTEXT);
rollback to Insert_Row_Pvt;
rollback to Insert_Row_Pvt;
rollback to Insert_Row_Pvt;
END Insert_Row;
PROCEDURE Update_Row
( p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
p_return_status OUT NOCOPY VARCHAR2,
p_msg_count OUT NOCOPY NUMBER,
p_msg_data OUT NOCOPY VARCHAR2,
P_ALLOCATION_RULE_ID IN NUMBER,
P_PERIOD_NUM IN NUMBER,
P_MONTHLY IN NUMBER,
P_QUARTERLY IN NUMBER,
P_SEMI_ANNUAL IN NUMBER,
P_ATTRIBUTE1 IN VARCHAR2,
P_ATTRIBUTE2 IN VARCHAR2,
P_ATTRIBUTE3 IN VARCHAR2,
P_ATTRIBUTE4 IN VARCHAR2,
P_ATTRIBUTE5 IN VARCHAR2,
P_CONTEXT IN VARCHAR2,
P_LAST_UPDATE_DATE IN DATE,
P_LAST_UPDATED_BY IN NUMBER,
P_LAST_UPDATE_LOGIN IN NUMBER
) IS
l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';
SAVEPOINT Update_Row_Pvt;
UPDATE PSB_ALLOCRULE_PERCENTS
SET
percent = P_MONTHLY,
last_update_date = P_LAST_UPDATE_DATE,
last_updated_by = P_LAST_UPDATED_BY,
last_update_login = P_LAST_UPDATE_LOGIN,
attribute1 = P_ATTRIBUTE1,
attribute2 = P_ATTRIBUTE2,
attribute3 = P_ATTRIBUTE3,
attribute4 = P_ATTRIBUTE4,
attribute5 = P_ATTRIBUTE5,
context = P_CONTEXT
WHERE allocation_rule_id = P_ALLOCATION_RULE_ID
AND number_of_periods = 12
AND period_num = P_PERIOD_NUM;
UPDATE PSB_ALLOCRULE_PERCENTS
SET
percent = P_QUARTERLY,
last_update_date = P_LAST_UPDATE_DATE,
last_updated_by = P_LAST_UPDATED_BY,
last_update_login = P_LAST_UPDATE_LOGIN,
attribute1 = P_ATTRIBUTE1,
attribute2 = P_ATTRIBUTE2,
attribute3 = P_ATTRIBUTE3,
attribute4 = P_ATTRIBUTE4,
attribute5 = P_ATTRIBUTE5,
context = P_CONTEXT
WHERE allocation_rule_id = P_ALLOCATION_RULE_ID
AND number_of_periods = 4
AND period_num = P_PERIOD_NUM;
UPDATE PSB_ALLOCRULE_PERCENTS
SET
percent = P_SEMI_ANNUAL,
last_update_date = P_LAST_UPDATE_DATE,
last_updated_by = P_LAST_UPDATED_BY,
last_update_login = P_LAST_UPDATE_LOGIN,
attribute1 = P_ATTRIBUTE1,
attribute2 = P_ATTRIBUTE2,
attribute3 = P_ATTRIBUTE3,
attribute4 = P_ATTRIBUTE4,
attribute5 = P_ATTRIBUTE5,
context = P_CONTEXT
WHERE allocation_rule_id = P_ALLOCATION_RULE_ID
AND number_of_periods = 2
AND period_num = P_PERIOD_NUM;
rollback to Update_Row_Pvt;
rollback to Update_Row_Pvt;
rollback to Update_Row_Pvt;
END Update_Row;
PROCEDURE Delete_Row
( p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
p_return_status OUT NOCOPY VARCHAR2,
p_msg_count OUT NOCOPY NUMBER,
p_msg_data OUT NOCOPY VARCHAR2,
P_ALLOCATION_RULE_ID IN NUMBER,
P_PERIOD_NUM IN NUMBER
) IS
l_api_name CONSTANT VARCHAR2(30) := 'Delete_Row';
select PSB_Allocrule_percents_S.NEXTVAL from DUAL ;
SAVEPOINT Delete_Row_Pvt;
DELETE FROM PSB_ALLOCRULE_PERCENTS
WHERE ALLOCATION_RULE_ID = P_ALLOCATION_RULE_ID
AND PERIOD_NUM = P_PERIOD_NUM;
rollback to Delete_Row_Pvt;
rollback to Delete_Row_Pvt;
rollback to Delete_Row_Pvt;
END Delete_Row;
SELECT ALLOCATION_RULE_ID,
PERIOD_NUM,
NUMBER_OF_PERIODS,
PERCENT
FROM PSB_ALLOCRULE_PERCENTS
WHERE ALLOCATION_RULE_ID = P_ALLOCATION_RULE_ID
AND PERIOD_NUM = P_PERIOD_NUM
ORDER BY NUMBER_OF_PERIODS
FOR UPDATE OF PERCENT NOWAIT;
FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');
FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');
FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');