APPS.PQP_AAT_API_BK2 SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 5

procedure UPDATE_ASSIGNMENT_ATTRIBUTE_A
(P_EFFECTIVE_DATE in DATE
,P_DATETRACK_MODE in VARCHAR2
,P_BUSINESS_GROUP_ID in NUMBER
,P_ASSIGNMENT_ATTRIBUTE_ID in NUMBER
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_EFFECTIVE_START_DATE in DATE
,P_EFFECTIVE_END_DATE in DATE
,P_ASSIGNMENT_ID in NUMBER
,P_CONTRACT_TYPE in VARCHAR2
,P_WORK_PATTERN in VARCHAR2
,P_START_DAY in VARCHAR2
,P_PRIMARY_COMPANY_CAR in NUMBER
,P_PRIMARY_CAR_FUEL_BENEFIT in VARCHAR2
,P_PRIMARY_CAPITAL_CONTRIBUTION in NUMBER
,P_PRIMARY_CLASS_1A in VARCHAR2
,P_SECONDARY_COMPANY_CAR in NUMBER
,P_SECONDARY_CAR_FUEL_BENEFIT in VARCHAR2
,P_SECONDARY_CAPITAL_CONTRIBUTI in NUMBER
,P_SECONDARY_CLASS_1A in VARCHAR2
,P_COMPANY_CAR_CALC_METHOD in VARCHAR2
,P_COMPANY_CAR_RATES_TABLE_ID in NUMBER
,P_COMPANY_CAR_SECONDARY_TABLE in NUMBER
,P_PRIVATE_CAR in NUMBER
,P_PRIVATE_CAR_CALC_METHOD in VARCHAR2
,P_PRIVATE_CAR_RATES_TABLE_ID in NUMBER
,P_PRIVATE_CAR_ESSENTIAL_TABLE in NUMBER
,P_PRIMARY_PRIVATE_CONTRIBUTION in NUMBER
,P_SECONDARY_PRIVATE_CONTRIBUTI in NUMBER
,P_TP_IS_TEACHER in VARCHAR2
,P_TP_HEADTEACHER_GRP_CODE in NUMBER
,P_TP_SAFEGUARDED_GRADE in VARCHAR2
,P_TP_SAFEGUARDED_GRADE_ID in NUMBER
,P_TP_SAFEGUARDED_RATE_TYPE in VARCHAR2
,P_TP_SAFEGUARDED_RATE_ID in NUMBER
,P_TP_SPINAL_POINT_ID in NUMBER
,P_TP_ELECTED_PENSION in VARCHAR2
,P_TP_FAST_TRACK in VARCHAR2
,P_AAT_ATTRIBUTE_CATEGORY in VARCHAR2
,P_AAT_ATTRIBUTE1 in VARCHAR2
,P_AAT_ATTRIBUTE2 in VARCHAR2
,P_AAT_ATTRIBUTE3 in VARCHAR2
,P_AAT_ATTRIBUTE4 in VARCHAR2
,P_AAT_ATTRIBUTE5 in VARCHAR2
,P_AAT_ATTRIBUTE6 in VARCHAR2
,P_AAT_ATTRIBUTE7 in VARCHAR2
,P_AAT_ATTRIBUTE8 in VARCHAR2
,P_AAT_ATTRIBUTE9 in VARCHAR2
,P_AAT_ATTRIBUTE10 in VARCHAR2
,P_AAT_ATTRIBUTE11 in VARCHAR2
,P_AAT_ATTRIBUTE12 in VARCHAR2
,P_AAT_ATTRIBUTE13 in VARCHAR2
,P_AAT_ATTRIBUTE14 in VARCHAR2
,P_AAT_ATTRIBUTE15 in VARCHAR2
,P_AAT_ATTRIBUTE16 in VARCHAR2
,P_AAT_ATTRIBUTE17 in VARCHAR2
,P_AAT_ATTRIBUTE18 in VARCHAR2
,P_AAT_ATTRIBUTE19 in VARCHAR2
,P_AAT_ATTRIBUTE20 in VARCHAR2
,P_AAT_INFORMATION_CATEGORY in VARCHAR2
,P_AAT_INFORMATION1 in VARCHAR2
,P_AAT_INFORMATION2 in VARCHAR2
,P_AAT_INFORMATION3 in VARCHAR2
,P_AAT_INFORMATION4 in VARCHAR2
,P_AAT_INFORMATION5 in VARCHAR2
,P_AAT_INFORMATION6 in VARCHAR2
,P_AAT_INFORMATION7 in VARCHAR2
,P_AAT_INFORMATION8 in VARCHAR2
,P_AAT_INFORMATION9 in VARCHAR2
,P_AAT_INFORMATION10 in VARCHAR2
,P_AAT_INFORMATION11 in VARCHAR2
,P_AAT_INFORMATION12 in VARCHAR2
,P_AAT_INFORMATION13 in VARCHAR2
,P_AAT_INFORMATION14 in VARCHAR2
,P_AAT_INFORMATION15 in VARCHAR2
,P_AAT_INFORMATION16 in VARCHAR2
,P_AAT_INFORMATION17 in VARCHAR2
,P_AAT_INFORMATION18 in VARCHAR2
,P_AAT_INFORMATION19 in VARCHAR2
,P_AAT_INFORMATION20 in VARCHAR2
,P_LGPS_PROCESS_FLAG in VARCHAR2
,P_LGPS_EXCLUSION_TYPE in VARCHAR2
,P_LGPS_PENSIONABLE_PAY in VARCHAR2
,P_LGPS_TRANS_ARRANG_FLAG in VARCHAR2
,P_LGPS_MEMBERSHIP_NUMBER in VARCHAR2
)is
begin
hr_utility.set_location('Entering: PQP_AAT_API_BK2.UPDATE_ASSIGNMENT_ATTRIBUTE_A', 10);

Line: 93

hr_utility.set_location(' Leaving: PQP_AAT_API_BK2.UPDATE_ASSIGNMENT_ATTRIBUTE_A', 20);

Line: 94

end UPDATE_ASSIGNMENT_ATTRIBUTE_A;

Line: 95

procedure UPDATE_ASSIGNMENT_ATTRIBUTE_B
(P_EFFECTIVE_DATE in DATE
,P_DATETRACK_MODE in VARCHAR2
,P_BUSINESS_GROUP_ID in NUMBER
,P_ASSIGNMENT_ATTRIBUTE_ID in NUMBER
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_EFFECTIVE_START_DATE in DATE
,P_EFFECTIVE_END_DATE in DATE
,P_ASSIGNMENT_ID in NUMBER
,P_CONTRACT_TYPE in VARCHAR2
,P_WORK_PATTERN in VARCHAR2
,P_START_DAY in VARCHAR2
,P_PRIMARY_COMPANY_CAR in NUMBER
,P_PRIMARY_CAR_FUEL_BENEFIT in VARCHAR2
,P_PRIMARY_CAPITAL_CONTRIBUTION in NUMBER
,P_PRIMARY_CLASS_1A in VARCHAR2
,P_SECONDARY_COMPANY_CAR in NUMBER
,P_SECONDARY_CAR_FUEL_BENEFIT in VARCHAR2
,P_SECONDARY_CAPITAL_CONTRIBUTI in NUMBER
,P_SECONDARY_CLASS_1A in VARCHAR2
,P_COMPANY_CAR_CALC_METHOD in VARCHAR2
,P_COMPANY_CAR_RATES_TABLE_ID in NUMBER
,P_COMPANY_CAR_SECONDARY_TABLE in NUMBER
,P_PRIVATE_CAR in NUMBER
,P_PRIVATE_CAR_CALC_METHOD in VARCHAR2
,P_PRIVATE_CAR_RATES_TABLE_ID in NUMBER
,P_PRIVATE_CAR_ESSENTIAL_TABLE in NUMBER
,P_PRIMARY_PRIVATE_CONTRIBUTION in NUMBER
,P_SECONDARY_PRIVATE_CONTRIBUTI in NUMBER
,P_TP_IS_TEACHER in VARCHAR2
,P_TP_HEADTEACHER_GRP_CODE in NUMBER
,P_TP_SAFEGUARDED_GRADE in VARCHAR2
,P_TP_SAFEGUARDED_GRADE_ID in NUMBER
,P_TP_SAFEGUARDED_RATE_TYPE in VARCHAR2
,P_TP_SAFEGUARDED_RATE_ID in NUMBER
,P_TP_SPINAL_POINT_ID in NUMBER
,P_TP_ELECTED_PENSION in VARCHAR2
,P_TP_FAST_TRACK in VARCHAR2
,P_AAT_ATTRIBUTE_CATEGORY in VARCHAR2
,P_AAT_ATTRIBUTE1 in VARCHAR2
,P_AAT_ATTRIBUTE2 in VARCHAR2
,P_AAT_ATTRIBUTE3 in VARCHAR2
,P_AAT_ATTRIBUTE4 in VARCHAR2
,P_AAT_ATTRIBUTE5 in VARCHAR2
,P_AAT_ATTRIBUTE6 in VARCHAR2
,P_AAT_ATTRIBUTE7 in VARCHAR2
,P_AAT_ATTRIBUTE8 in VARCHAR2
,P_AAT_ATTRIBUTE9 in VARCHAR2
,P_AAT_ATTRIBUTE10 in VARCHAR2
,P_AAT_ATTRIBUTE11 in VARCHAR2
,P_AAT_ATTRIBUTE12 in VARCHAR2
,P_AAT_ATTRIBUTE13 in VARCHAR2
,P_AAT_ATTRIBUTE14 in VARCHAR2
,P_AAT_ATTRIBUTE15 in VARCHAR2
,P_AAT_ATTRIBUTE16 in VARCHAR2
,P_AAT_ATTRIBUTE17 in VARCHAR2
,P_AAT_ATTRIBUTE18 in VARCHAR2
,P_AAT_ATTRIBUTE19 in VARCHAR2
,P_AAT_ATTRIBUTE20 in VARCHAR2
,P_AAT_INFORMATION_CATEGORY in VARCHAR2
,P_AAT_INFORMATION1 in VARCHAR2
,P_AAT_INFORMATION2 in VARCHAR2
,P_AAT_INFORMATION3 in VARCHAR2
,P_AAT_INFORMATION4 in VARCHAR2
,P_AAT_INFORMATION5 in VARCHAR2
,P_AAT_INFORMATION6 in VARCHAR2
,P_AAT_INFORMATION7 in VARCHAR2
,P_AAT_INFORMATION8 in VARCHAR2
,P_AAT_INFORMATION9 in VARCHAR2
,P_AAT_INFORMATION10 in VARCHAR2
,P_AAT_INFORMATION11 in VARCHAR2
,P_AAT_INFORMATION12 in VARCHAR2
,P_AAT_INFORMATION13 in VARCHAR2
,P_AAT_INFORMATION14 in VARCHAR2
,P_AAT_INFORMATION15 in VARCHAR2
,P_AAT_INFORMATION16 in VARCHAR2
,P_AAT_INFORMATION17 in VARCHAR2
,P_AAT_INFORMATION18 in VARCHAR2
,P_AAT_INFORMATION19 in VARCHAR2
,P_AAT_INFORMATION20 in VARCHAR2
,P_LGPS_PROCESS_FLAG in VARCHAR2
,P_LGPS_EXCLUSION_TYPE in VARCHAR2
,P_LGPS_PENSIONABLE_PAY in VARCHAR2
,P_LGPS_TRANS_ARRANG_FLAG in VARCHAR2
,P_LGPS_MEMBERSHIP_NUMBER in VARCHAR2
)is
begin
hr_utility.set_location('Entering: PQP_AAT_API_BK2.UPDATE_ASSIGNMENT_ATTRIBUTE_B', 10);

Line: 183

hr_utility.set_location(' Leaving: PQP_AAT_API_BK2.UPDATE_ASSIGNMENT_ATTRIBUTE_B', 20);

Line: 184

end UPDATE_ASSIGNMENT_ATTRIBUTE_B;