[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE INSERT_ROW(P_ROWID IN OUT NOCOPY VARCHAR2,
P_PERSONAL_PAYMENT_METHOD_ID IN OUT NOCOPY NUMBER,
P_EFFECTIVE_START_DATE DATE,
P_EFFECTIVE_END_DATE DATE,
P_BUSINESS_GROUP_ID NUMBER,
P_EXTERNAL_ACCOUNT_ID NUMBER,
P_ASSIGNMENT_ID NUMBER,
P_PERSON_ID NUMBER,
P_RUN_TYPE_ID NUMBER,
P_ORG_PAYMENT_METHOD_ID NUMBER,
P_AMOUNT NUMBER,
P_COMMENT_ID NUMBER,
P_PERCENTAGE NUMBER,
P_PRIORITY NUMBER,
P_PAYEE_TYPE VARCHAR2,
P_PAYEE_ID 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,
P_ATTRIBUTE16 VARCHAR2,
P_ATTRIBUTE17 VARCHAR2,
P_ATTRIBUTE18 VARCHAR2,
P_ATTRIBUTE19 VARCHAR2,
P_ATTRIBUTE20 VARCHAR2,
P_PRENOTE_DATE DATE,
/** sbilling **/
P_TERRITORY_CODE VARCHAR2,
P_PPM_INFORMATION_CATEGORY VARCHAR2,
P_PPM_INFORMATION1 VARCHAR2,
P_PPM_INFORMATION2 VARCHAR2,
P_PPM_INFORMATION3 VARCHAR2,
P_PPM_INFORMATION4 VARCHAR2,
P_PPM_INFORMATION5 VARCHAR2,
P_PPM_INFORMATION6 VARCHAR2,
P_PPM_INFORMATION7 VARCHAR2,
P_PPM_INFORMATION8 VARCHAR2,
P_PPM_INFORMATION9 VARCHAR2,
P_PPM_INFORMATION10 VARCHAR2,
P_PPM_INFORMATION11 VARCHAR2,
P_PPM_INFORMATION12 VARCHAR2,
P_PPM_INFORMATION13 VARCHAR2,
P_PPM_INFORMATION14 VARCHAR2,
P_PPM_INFORMATION15 VARCHAR2,
P_PPM_INFORMATION16 VARCHAR2,
P_PPM_INFORMATION17 VARCHAR2,
P_PPM_INFORMATION18 VARCHAR2,
P_PPM_INFORMATION19 VARCHAR2,
P_PPM_INFORMATION20 VARCHAR2,
P_PPM_INFORMATION21 VARCHAR2,
P_PPM_INFORMATION22 VARCHAR2,
P_PPM_INFORMATION23 VARCHAR2,
P_PPM_INFORMATION24 VARCHAR2,
P_PPM_INFORMATION25 VARCHAR2,
P_PPM_INFORMATION26 VARCHAR2,
P_PPM_INFORMATION27 VARCHAR2,
P_PPM_INFORMATION28 VARCHAR2,
P_PPM_INFORMATION29 VARCHAR2,
P_PPM_INFORMATION30 VARCHAR2
) IS
CURSOR C IS
SELECT ROWID
FROM PAY_PERSONAL_PAYMENT_METHODS_F
WHERE PERSONAL_PAYMENT_METHOD_ID = P_PERSONAL_PAYMENT_METHOD_ID;
SELECT pay_personal_payment_methods_s.nextval
FROM sys.dual;
INSERT INTO PAY_PERSONAL_PAYMENT_METHODS_F (PERSONAL_PAYMENT_METHOD_ID,
EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE,
BUSINESS_GROUP_ID,
EXTERNAL_ACCOUNT_ID,
ASSIGNMENT_ID,
PERSON_ID,
RUN_TYPE_ID,
ORG_PAYMENT_METHOD_ID,
AMOUNT,
COMMENT_ID,
PERCENTAGE,
PRIORITY,
PAYEE_TYPE,
PAYEE_ID,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
ATTRIBUTE16,
ATTRIBUTE17,
ATTRIBUTE18,
ATTRIBUTE19,
ATTRIBUTE20,
PPM_INFORMATION_CATEGORY,
PPM_INFORMATION1,
PPM_INFORMATION2,
PPM_INFORMATION3,
PPM_INFORMATION4,
PPM_INFORMATION5,
PPM_INFORMATION6,
PPM_INFORMATION7,
PPM_INFORMATION8,
PPM_INFORMATION9,
PPM_INFORMATION10,
PPM_INFORMATION11,
PPM_INFORMATION12,
PPM_INFORMATION13,
PPM_INFORMATION14,
PPM_INFORMATION15,
PPM_INFORMATION16,
PPM_INFORMATION17,
PPM_INFORMATION18,
PPM_INFORMATION19,
PPM_INFORMATION20,
PPM_INFORMATION21,
PPM_INFORMATION22,
PPM_INFORMATION23,
PPM_INFORMATION24,
PPM_INFORMATION25,
PPM_INFORMATION26,
PPM_INFORMATION27,
PPM_INFORMATION28,
PPM_INFORMATION29,
PPM_INFORMATION30)
VALUES(P_PERSONAL_PAYMENT_METHOD_ID,P_EFFECTIVE_START_DATE,
P_EFFECTIVE_END_DATE,P_BUSINESS_GROUP_ID,P_EXTERNAL_ACCOUNT_ID,
P_ASSIGNMENT_ID,P_PERSON_ID,P_RUN_TYPE_ID,P_ORG_PAYMENT_METHOD_ID,P_AMOUNT,P_COMMENT_ID,
P_PERCENTAGE,P_PRIORITY,P_PAYEE_TYPE,P_PAYEE_ID,
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,P_ATTRIBUTE16,
P_ATTRIBUTE17,P_ATTRIBUTE18,P_ATTRIBUTE19,P_ATTRIBUTE20,
P_PPM_INFORMATION_CATEGORY,P_PPM_INFORMATION1,P_PPM_INFORMATION2,
P_PPM_INFORMATION3,P_PPM_INFORMATION4,P_PPM_INFORMATION5,P_PPM_INFORMATION6,
P_PPM_INFORMATION7,P_PPM_INFORMATION8,P_PPM_INFORMATION9,P_PPM_INFORMATION10,
P_PPM_INFORMATION11,P_PPM_INFORMATION12,P_PPM_INFORMATION13,P_PPM_INFORMATION14,
P_PPM_INFORMATION15,P_PPM_INFORMATION16,P_PPM_INFORMATION17,P_PPM_INFORMATION18,
P_PPM_INFORMATION19,P_PPM_INFORMATION20,P_PPM_INFORMATION21,P_PPM_INFORMATION22,
P_PPM_INFORMATION23,P_PPM_INFORMATION24,P_PPM_INFORMATION25,P_PPM_INFORMATION26,
P_PPM_INFORMATION27,P_PPM_INFORMATION28,P_PPM_INFORMATION29,P_PPM_INFORMATION30 );
hr_utility.set_message_token('PROCEDURE','Insert_row');
UPDATE PAY_EXTERNAL_ACCOUNTS
SET PRENOTE_DATE = P_PRENOTE_DATE
WHERE EXTERNAL_ACCOUNT_ID = P_EXTERNAL_ACCOUNT_ID;
UPDATE PAY_EXTERNAL_ACCOUNTS
SET TERRITORY_CODE = P_TERRITORY_CODE
WHERE EXTERNAL_ACCOUNT_ID = P_EXTERNAL_ACCOUNT_ID;
END INSERT_ROW;
PROCEDURE UPDATE_ROW(P_ROWID VARCHAR2,
P_PERSONAL_PAYMENT_METHOD_ID NUMBER,
P_EFFECTIVE_START_DATE DATE,
P_EFFECTIVE_END_DATE DATE,
P_BUSINESS_GROUP_ID NUMBER,
P_EXTERNAL_ACCOUNT_ID NUMBER,
P_ASSIGNMENT_ID NUMBER,
P_PERSON_ID NUMBER,
P_RUN_TYPE_ID NUMBER,
P_ORG_PAYMENT_METHOD_ID NUMBER,
P_AMOUNT NUMBER,
P_COMMENT_ID NUMBER,
P_PERCENTAGE NUMBER,
P_PRIORITY NUMBER,
P_PAYEE_TYPE VARCHAR2,
P_PAYEE_ID 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,
P_ATTRIBUTE16 VARCHAR2,
P_ATTRIBUTE17 VARCHAR2,
P_ATTRIBUTE18 VARCHAR2,
P_ATTRIBUTE19 VARCHAR2,
P_ATTRIBUTE20 VARCHAR2,
P_PRENOTE_DATE DATE,
/** sbilling **/
P_TERRITORY_CODE VARCHAR2,
P_PPM_INFORMATION_CATEGORY VARCHAR2,
P_PPM_INFORMATION1 VARCHAR2,
P_PPM_INFORMATION2 VARCHAR2,
P_PPM_INFORMATION3 VARCHAR2,
P_PPM_INFORMATION4 VARCHAR2,
P_PPM_INFORMATION5 VARCHAR2,
P_PPM_INFORMATION6 VARCHAR2,
P_PPM_INFORMATION7 VARCHAR2,
P_PPM_INFORMATION8 VARCHAR2,
P_PPM_INFORMATION9 VARCHAR2,
P_PPM_INFORMATION10 VARCHAR2,
P_PPM_INFORMATION11 VARCHAR2,
P_PPM_INFORMATION12 VARCHAR2,
P_PPM_INFORMATION13 VARCHAR2,
P_PPM_INFORMATION14 VARCHAR2,
P_PPM_INFORMATION15 VARCHAR2,
P_PPM_INFORMATION16 VARCHAR2,
P_PPM_INFORMATION17 VARCHAR2,
P_PPM_INFORMATION18 VARCHAR2,
P_PPM_INFORMATION19 VARCHAR2,
P_PPM_INFORMATION20 VARCHAR2,
P_PPM_INFORMATION21 VARCHAR2,
P_PPM_INFORMATION22 VARCHAR2,
P_PPM_INFORMATION23 VARCHAR2,
P_PPM_INFORMATION24 VARCHAR2,
P_PPM_INFORMATION25 VARCHAR2,
P_PPM_INFORMATION26 VARCHAR2,
P_PPM_INFORMATION27 VARCHAR2,
P_PPM_INFORMATION28 VARCHAR2,
P_PPM_INFORMATION29 VARCHAR2,
P_PPM_INFORMATION30 VARCHAR2
) IS
BEGIN
UPDATE PAY_PERSONAL_PAYMENT_METHODS_F
SET PERSONAL_PAYMENT_METHOD_ID = P_PERSONAL_PAYMENT_METHOD_ID,
EFFECTIVE_START_DATE = P_EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE = P_EFFECTIVE_END_DATE,
BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID,
EXTERNAL_ACCOUNT_ID = P_EXTERNAL_ACCOUNT_ID,
ASSIGNMENT_ID = P_ASSIGNMENT_ID,
PERSON_ID = P_PERSON_ID,
RUN_TYPE_ID = P_RUN_TYPE_ID,
ORG_PAYMENT_METHOD_ID = P_ORG_PAYMENT_METHOD_ID,
AMOUNT = P_AMOUNT,
COMMENT_ID = P_COMMENT_ID,
PERCENTAGE = P_PERCENTAGE,
PRIORITY = P_PRIORITY,
PAYEE_TYPE = P_PAYEE_TYPE,
PAYEE_ID = P_PAYEE_ID,
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,
ATTRIBUTE16 = P_ATTRIBUTE16,
ATTRIBUTE17 = P_ATTRIBUTE17,
ATTRIBUTE18 = P_ATTRIBUTE18,
ATTRIBUTE19 = P_ATTRIBUTE19,
ATTRIBUTE20 = P_ATTRIBUTE20,
PPM_INFORMATION_CATEGORY = P_PPM_INFORMATION_CATEGORY,
PPM_INFORMATION1 = P_PPM_INFORMATION1,
PPM_INFORMATION2 = P_PPM_INFORMATION2,
PPM_INFORMATION3 = P_PPM_INFORMATION3,
PPM_INFORMATION4 = P_PPM_INFORMATION4,
PPM_INFORMATION5 = P_PPM_INFORMATION5,
PPM_INFORMATION6 = P_PPM_INFORMATION6,
PPM_INFORMATION7 = P_PPM_INFORMATION7,
PPM_INFORMATION8 = P_PPM_INFORMATION8,
PPM_INFORMATION9 = P_PPM_INFORMATION9,
PPM_INFORMATION10 = P_PPM_INFORMATION10,
PPM_INFORMATION11 = P_PPM_INFORMATION11,
PPM_INFORMATION12 = P_PPM_INFORMATION12,
PPM_INFORMATION13 = P_PPM_INFORMATION13,
PPM_INFORMATION14 = P_PPM_INFORMATION14,
PPM_INFORMATION15 = P_PPM_INFORMATION15,
PPM_INFORMATION16 = P_PPM_INFORMATION16,
PPM_INFORMATION17 = P_PPM_INFORMATION17,
PPM_INFORMATION18 = P_PPM_INFORMATION18,
PPM_INFORMATION19 = P_PPM_INFORMATION19,
PPM_INFORMATION20 = P_PPM_INFORMATION20,
PPM_INFORMATION21 = P_PPM_INFORMATION21,
PPM_INFORMATION22 = P_PPM_INFORMATION22,
PPM_INFORMATION23 = P_PPM_INFORMATION23,
PPM_INFORMATION24 = P_PPM_INFORMATION24,
PPM_INFORMATION25 = P_PPM_INFORMATION25,
PPM_INFORMATION26 = P_PPM_INFORMATION26,
PPM_INFORMATION27 = P_PPM_INFORMATION27,
PPM_INFORMATION28 = P_PPM_INFORMATION28,
PPM_INFORMATION29 = P_PPM_INFORMATION29,
PPM_INFORMATION30 = P_PPM_INFORMATION30
WHERE ROWID = P_ROWID;
UPDATE PAY_EXTERNAL_ACCOUNTS
SET PRENOTE_DATE = P_PRENOTE_DATE
WHERE EXTERNAL_ACCOUNT_ID = P_EXTERNAL_ACCOUNT_ID;
UPDATE PAY_EXTERNAL_ACCOUNTS
SET TERRITORY_CODE = P_TERRITORY_CODE
WHERE EXTERNAL_ACCOUNT_ID = P_EXTERNAL_ACCOUNT_ID;
END UPDATE_ROW;
PROCEDURE DELETE_ROW(P_ROWID VARCHAR2,
P_PPM_ID NUMBER,
P_AFTER_THIS_DATE DATE,
P_PAYEE_TYPE VARCHAR2) IS
--
CURSOR el_ent_check IS
SELECT 'el_ents_exist'
FROM pay_element_entries_f
WHERE personal_payment_method_id = p_ppm_id
AND effective_end_date > p_after_this_date;
DELETE FROM PAY_PERSONAL_PAYMENT_METHODS_F
WHERE ROWID = P_ROWID;
END DELETE_ROW;
CURSOR C IS SELECT *
FROM PAY_PERSONAL_PAYMENT_METHODS_F
WHERE ROWID = P_ROWID
FOR UPDATE OF PERSONAL_PAYMENT_METHOD_ID NOWAIT;
CURSOR PRENOTE IS SELECT *
FROM PAY_EXTERNAL_ACCOUNTS
WHERE EXTERNAL_ACCOUNT_ID = P_EXTERNAL_ACCOUNT_ID
FOR UPDATE OF PRENOTE_DATE NOWAIT;
select payroll_id
from per_all_assignments_f
where assignment_id = to_number (p_asg_id)
and fnd_date.canonical_to_date(p_new_date) between effective_start_date
and effective_end_date;