[Home] [Help]
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_DISTRIBUTION_ID IN NUMBER,
P_POSITION_SET_GROUP_ID in NUMBER,
P_CHART_OF_ACCOUNTS_ID IN NUMBER,
P_EFFECTIVE_START_DATE IN DATE,
P_EFFECTIVE_END_DATE IN DATE,
P_DISTRIBUTION_PERCENT IN NUMBER,
P_CONCATENATED_SEGMENTS IN VARCHAR2,
P_CODE_COMBINATION_ID IN NUMBER,
P_DISTRIBUTION_SET_ID IN NUMBER,
P_SEGMENT1 IN VARCHAR2,
P_SEGMENT2 IN VARCHAR2,
P_SEGMENT3 IN VARCHAR2,
P_SEGMENT4 IN VARCHAR2,
P_SEGMENT5 IN VARCHAR2,
P_SEGMENT6 IN VARCHAR2,
P_SEGMENT7 IN VARCHAR2,
P_SEGMENT8 IN VARCHAR2,
P_SEGMENT9 IN VARCHAR2,
P_SEGMENT10 IN VARCHAR2,
P_SEGMENT11 IN VARCHAR2,
P_SEGMENT12 IN VARCHAR2,
P_SEGMENT13 IN VARCHAR2,
P_SEGMENT14 IN VARCHAR2,
P_SEGMENT15 IN VARCHAR2,
P_SEGMENT16 IN VARCHAR2,
P_SEGMENT17 IN VARCHAR2,
P_SEGMENT18 IN VARCHAR2,
P_SEGMENT19 IN VARCHAR2,
P_SEGMENT20 IN VARCHAR2,
P_SEGMENT21 IN VARCHAR2,
P_SEGMENT22 IN VARCHAR2,
P_SEGMENT23 IN VARCHAR2,
P_SEGMENT24 IN VARCHAR2,
P_SEGMENT25 IN VARCHAR2,
P_SEGMENT26 IN VARCHAR2,
P_SEGMENT27 IN VARCHAR2,
P_SEGMENT28 IN VARCHAR2,
P_SEGMENT29 IN VARCHAR2,
P_SEGMENT30 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 ROWID from psb_pay_element_distributions
where distribution_id = p_distribution_id
and position_set_group_id = p_position_set_group_id
and chart_of_accounts_id = p_chart_of_accounts_id
and effective_start_date = p_effective_start_date;
SAVEPOINT INSERT_ROW_PVT;
INSERT INTO psb_pay_element_distributions
(
DISTRIBUTION_ID ,
POSITION_SET_GROUP_ID ,
CHART_OF_ACCOUNTS_ID ,
EFFECTIVE_START_DATE ,
EFFECTIVE_END_DATE ,
DISTRIBUTION_PERCENT ,
CONCATENATED_SEGMENTS ,
CODE_COMBINATION_ID ,
DISTRIBUTION_SET_ID ,
SEGMENT1 ,
SEGMENT2 ,
SEGMENT3 ,
SEGMENT4 ,
SEGMENT5 ,
SEGMENT6 ,
SEGMENT7 ,
SEGMENT8 ,
SEGMENT9 ,
SEGMENT10 ,
SEGMENT11 ,
SEGMENT12 ,
SEGMENT13 ,
SEGMENT14 ,
SEGMENT15 ,
SEGMENT16 ,
SEGMENT17 ,
SEGMENT18 ,
SEGMENT19 ,
SEGMENT20 ,
SEGMENT21 ,
SEGMENT22 ,
SEGMENT23 ,
SEGMENT24 ,
SEGMENT25 ,
SEGMENT26 ,
SEGMENT27 ,
SEGMENT28 ,
SEGMENT29 ,
SEGMENT30 ,
LAST_UPDATE_DATE ,
LAST_UPDATED_BY ,
LAST_UPDATE_LOGIN ,
CREATED_BY ,
CREATION_DATE
)
VALUES
(
P_DISTRIBUTION_ID ,
P_POSITION_SET_GROUP_ID ,
P_CHART_OF_ACCOUNTS_ID ,
P_EFFECTIVE_START_DATE ,
P_EFFECTIVE_END_DATE ,
P_DISTRIBUTION_PERCENT ,
P_CONCATENATED_SEGMENTS ,
P_CODE_COMBINATION_ID ,
P_DISTRIBUTION_SET_ID ,
P_SEGMENT1 ,
P_SEGMENT2 ,
P_SEGMENT3 ,
P_SEGMENT4 ,
P_SEGMENT5 ,
P_SEGMENT6 ,
P_SEGMENT7 ,
P_SEGMENT8 ,
P_SEGMENT9 ,
P_SEGMENT10 ,
P_SEGMENT11 ,
P_SEGMENT12 ,
P_SEGMENT13 ,
P_SEGMENT14 ,
P_SEGMENT15 ,
P_SEGMENT16 ,
P_SEGMENT17 ,
P_SEGMENT18 ,
P_SEGMENT19 ,
P_SEGMENT20 ,
P_SEGMENT21 ,
P_SEGMENT22 ,
P_SEGMENT23 ,
P_SEGMENT24 ,
P_SEGMENT25 ,
P_SEGMENT26 ,
P_SEGMENT27 ,
P_SEGMENT28 ,
P_SEGMENT29 ,
P_SEGMENT30 ,
P_LAST_UPDATE_DATE ,
P_LAST_UPDATED_BY ,
P_LAST_UPDATE_LOGIN ,
P_CREATED_BY ,
P_CREATION_DATE
);
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_DISTRIBUTION_ID IN NUMBER,
P_POSITION_SET_GROUP_ID in NUMBER,
P_CHART_OF_ACCOUNTS_ID IN NUMBER,
P_EFFECTIVE_START_DATE IN DATE,
P_EFFECTIVE_END_DATE IN DATE,
P_DISTRIBUTION_PERCENT IN NUMBER,
P_CONCATENATED_SEGMENTS IN VARCHAR2,
P_CODE_COMBINATION_ID IN NUMBER,
P_DISTRIBUTION_SET_ID IN NUMBER,
P_SEGMENT1 IN VARCHAR2,
P_SEGMENT2 IN VARCHAR2,
P_SEGMENT3 IN VARCHAR2,
P_SEGMENT4 IN VARCHAR2,
P_SEGMENT5 IN VARCHAR2,
P_SEGMENT6 IN VARCHAR2,
P_SEGMENT7 IN VARCHAR2,
P_SEGMENT8 IN VARCHAR2,
P_SEGMENT9 IN VARCHAR2,
P_SEGMENT10 IN VARCHAR2,
P_SEGMENT11 IN VARCHAR2,
P_SEGMENT12 IN VARCHAR2,
P_SEGMENT13 IN VARCHAR2,
P_SEGMENT14 IN VARCHAR2,
P_SEGMENT15 IN VARCHAR2,
P_SEGMENT16 IN VARCHAR2,
P_SEGMENT17 IN VARCHAR2,
P_SEGMENT18 IN VARCHAR2,
P_SEGMENT19 IN VARCHAR2,
P_SEGMENT20 IN VARCHAR2,
P_SEGMENT21 IN VARCHAR2,
P_SEGMENT22 IN VARCHAR2,
P_SEGMENT23 IN VARCHAR2,
P_SEGMENT24 IN VARCHAR2,
P_SEGMENT25 IN VARCHAR2,
P_SEGMENT26 IN VARCHAR2,
P_SEGMENT27 IN VARCHAR2,
P_SEGMENT28 IN VARCHAR2,
P_SEGMENT29 IN VARCHAR2,
P_SEGMENT30 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_pay_element_distributions SET
EFFECTIVE_START_DATE = P_EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE = P_EFFECTIVE_END_DATE,
DISTRIBUTION_PERCENT = P_DISTRIBUTION_PERCENT,
CONCATENATED_SEGMENTS = P_CONCATENATED_SEGMENTS,
CODE_COMBINATION_ID = P_CODE_COMBINATION_ID,
DISTRIBUTION_SET_ID = P_DISTRIBUTION_SET_ID,
SEGMENT1 = P_SEGMENT1,
SEGMENT2 = P_SEGMENT2,
SEGMENT3 = P_SEGMENT3,
SEGMENT4 = P_SEGMENT4,
SEGMENT5 = P_SEGMENT5,
SEGMENT6 = P_SEGMENT6,
SEGMENT7 = P_SEGMENT7,
SEGMENT8 = P_SEGMENT8,
SEGMENT9 = P_SEGMENT9,
SEGMENT10 = P_SEGMENT10,
SEGMENT11 = P_SEGMENT11,
SEGMENT12 = P_SEGMENT12,
SEGMENT13 = P_SEGMENT13,
SEGMENT14 = P_SEGMENT14,
SEGMENT15 = P_SEGMENT15,
SEGMENT16 = P_SEGMENT16,
SEGMENT17 = P_SEGMENT17,
SEGMENT18 = P_SEGMENT18,
SEGMENT19 = P_SEGMENT19,
SEGMENT20 = P_SEGMENT20,
SEGMENT21 = P_SEGMENT21,
SEGMENT22 = P_SEGMENT22,
SEGMENT23 = P_SEGMENT23,
SEGMENT24 = P_SEGMENT24,
SEGMENT25 = P_SEGMENT25,
SEGMENT26 = P_SEGMENT26,
SEGMENT27 = P_SEGMENT27,
SEGMENT28 = P_SEGMENT28,
SEGMENT29 = P_SEGMENT29,
SEGMENT30 = P_SEGMENT30,
LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
LAST_UPDATED_BY = P_LAST_UPDATED_BY,
LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN
where DISTRIBUTION_ID = P_DISTRIBUTION_ID
and POSITION_SET_GROUP_ID = P_POSITION_SET_GROUP_ID
and CHART_OF_ACCOUNTS_ID = P_CHART_OF_ACCOUNTS_ID;
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_DISTRIBUTION_ID IN NUMBER,
P_POSITION_SET_GROUP_ID IN NUMBER,
P_CHART_OF_ACCOUNTS_ID IN NUMBER,
P_EFFECTIVE_START_DATE IN DATE
) IS
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_ROW';
SAVEPOINT DELETE_ROW_PVT;
DELETE FROM psb_pay_element_distributions
where DISTRIBUTION_ID = P_DISTRIBUTION_ID
and POSITION_SET_GROUP_ID = P_POSITION_SET_GROUP_ID
and CHART_OF_ACCOUNTS_ID = P_CHART_OF_ACCOUNTS_ID
and EFFECTIVE_START_DATE = P_EFFECTIVE_START_DATE;
rollback to DELETE_ROW_PVT;
rollback to DELETE_ROW_PVT;
rollback to DELETE_ROW_PVT;
END DELETE_ROW;
CURSOR C IS SELECT * FROM PSB_PAY_ELEMENT_DISTRIBUTIONS
WHERE DISTRIBUTION_ID = P_DISTRIBUTION_ID
AND POSITION_SET_GROUP_ID = P_POSITION_SET_GROUP_ID
FOR UPDATE of DISTRIBUTION_Id NOWAIT;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
SELECT '1'
FROM psb_pay_element_distributions
WHERE ( (effective_start_date >= p_effective_start_date
AND effective_start_date <= p_effective_end_date)
OR (effective_end_date >= p_effective_start_date
AND effective_end_date <= p_effective_end_date) )
AND (position_set_group_id = p_position_set_group_id)
AND (distribution_set_id <> p_distribution_set_id);
SELECT '1'
FROM psb_pay_element_distributions
WHERE code_combination_id = p_code_combination_id
AND position_set_group_id = p_position_set_group_id
AND distribution_set_id = p_distribution_set_id;