[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE AFTER_INSERT
(
p_effective_date in DATE
,p_validation_start_date in DATE
,p_validation_end_date in DATE
,P_APPLICANT_RANK in NUMBER
,P_APPLICATION_ID in NUMBER
,P_ASSIGNMENT_CATEGORY in VARCHAR2
,P_ASSIGNMENT_ID in NUMBER
,P_ASSIGNMENT_NUMBER in VARCHAR2
,P_ASSIGNMENT_SEQUENCE in NUMBER
,P_ASSIGNMENT_STATUS_TYPE_ID in NUMBER
,P_ASSIGNMENT_TYPE in VARCHAR2
,P_ASS_ATTRIBUTE1 in VARCHAR2
,P_ASS_ATTRIBUTE10 in VARCHAR2
,P_ASS_ATTRIBUTE11 in VARCHAR2
,P_ASS_ATTRIBUTE12 in VARCHAR2
,P_ASS_ATTRIBUTE13 in VARCHAR2
,P_ASS_ATTRIBUTE14 in VARCHAR2
,P_ASS_ATTRIBUTE15 in VARCHAR2
,P_ASS_ATTRIBUTE16 in VARCHAR2
,P_ASS_ATTRIBUTE17 in VARCHAR2
,P_ASS_ATTRIBUTE18 in VARCHAR2
,P_ASS_ATTRIBUTE19 in VARCHAR2
,P_ASS_ATTRIBUTE2 in VARCHAR2
,P_ASS_ATTRIBUTE20 in VARCHAR2
,P_ASS_ATTRIBUTE21 in VARCHAR2
,P_ASS_ATTRIBUTE22 in VARCHAR2
,P_ASS_ATTRIBUTE23 in VARCHAR2
,P_ASS_ATTRIBUTE24 in VARCHAR2
,P_ASS_ATTRIBUTE25 in VARCHAR2
,P_ASS_ATTRIBUTE26 in VARCHAR2
,P_ASS_ATTRIBUTE27 in VARCHAR2
,P_ASS_ATTRIBUTE28 in VARCHAR2
,P_ASS_ATTRIBUTE29 in VARCHAR2
,P_ASS_ATTRIBUTE3 in VARCHAR2
,P_ASS_ATTRIBUTE30 in VARCHAR2
,P_ASS_ATTRIBUTE4 in VARCHAR2
,P_ASS_ATTRIBUTE5 in VARCHAR2
,P_ASS_ATTRIBUTE6 in VARCHAR2
,P_ASS_ATTRIBUTE7 in VARCHAR2
,P_ASS_ATTRIBUTE8 in VARCHAR2
,P_ASS_ATTRIBUTE9 in VARCHAR2
,P_ASS_ATTRIBUTE_CATEGORY in VARCHAR2
,P_BARGAINING_UNIT_CODE in VARCHAR2
,P_BUSINESS_GROUP_ID in NUMBER
,P_CAGR_GRADE_DEF_ID in NUMBER
,P_CAGR_ID_FLEX_NUM in NUMBER
,P_CHANGE_REASON in VARCHAR2
,P_COLLECTIVE_AGREEMENT_ID in NUMBER
,P_COMMENT_ID in NUMBER
,P_CONTRACT_ID in NUMBER
,P_DATE_PROBATION_END in DATE
,P_DEFAULT_CODE_COMB_ID in NUMBER
,P_EFFECTIVE_END_DATE in DATE
,P_EFFECTIVE_START_DATE in DATE
,P_EMPLOYEE_CATEGORY in VARCHAR2
,P_EMPLOYMENT_CATEGORY in VARCHAR2
,P_ESTABLISHMENT_ID in NUMBER
,P_FREQUENCY in VARCHAR2
,P_GRADE_ID in NUMBER
,P_HOURLY_SALARIED_CODE in VARCHAR2
,P_INTERNAL_ADDRESS_LINE in VARCHAR2
,P_JOB_ID in NUMBER
,P_JOB_POST_SOURCE_NAME in VARCHAR2
,P_LABOUR_UNION_MEMBER_FLAG in VARCHAR2
,P_LOCATION_ID in NUMBER
,P_MANAGER_FLAG in VARCHAR2
,P_NORMAL_HOURS in NUMBER
,P_NOTICE_PERIOD in NUMBER
,P_NOTICE_PERIOD_UOM in VARCHAR2
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_ORGANIZATION_ID in NUMBER
,P_PAYROLL_ID in NUMBER
,P_PAY_BASIS_ID in NUMBER
,P_PEOPLE_GROUP_ID in NUMBER
,P_PERF_REVIEW_PERIOD in NUMBER
,P_PERF_REVIEW_PERIOD_FREQUEN in VARCHAR2
,P_PERIOD_OF_SERVICE_ID in NUMBER
,P_PERSON_ID in NUMBER
,P_PERSON_REFERRED_BY_ID in NUMBER
,P_PLACEMENT_DATE_START in DATE
,P_POSITION_ID in NUMBER
,P_POSTING_CONTENT_ID in NUMBER
,P_PRIMARY_FLAG in VARCHAR2
,P_PROBATION_PERIOD in NUMBER
,P_PROBATION_UNIT in VARCHAR2
,P_PROGRAM_APPLICATION_ID in NUMBER
,P_PROGRAM_ID in NUMBER
,P_PROGRAM_UPDATE_DATE in DATE
,P_PROJECT_TITLE in VARCHAR2
,P_RECRUITER_ID in NUMBER
,P_RECRUITMENT_ACTIVITY_ID in NUMBER
,P_REQUEST_ID in NUMBER
,P_SAL_REVIEW_PERIOD in NUMBER
,P_SAL_REVIEW_PERIOD_FREQUEN in VARCHAR2
,P_SET_OF_BOOKS_ID in NUMBER
,P_SOFT_CODING_KEYFLEX_ID in NUMBER
,P_SOURCE_ORGANIZATION_ID in NUMBER
,P_SOURCE_TYPE in VARCHAR2
,P_SPECIAL_CEILING_STEP_ID in NUMBER
,P_SUPERVISOR_ID in NUMBER
,P_TIME_NORMAL_FINISH in VARCHAR2
,P_TIME_NORMAL_START in VARCHAR2
,P_TITLE in VARCHAR2
,P_VACANCY_ID in NUMBER
,P_VENDOR_ASSIGNMENT_NUMBER in VARCHAR2
,P_VENDOR_EMPLOYEE_NUMBER in VARCHAR2
,P_VENDOR_ID in NUMBER
,P_WORK_AT_HOME in VARCHAR2
,P_GRADE_LADDER_PGM_ID in NUMBER
,P_SUPERVISOR_ASSIGNMENT_ID in NUMBER
,P_VENDOR_SITE_ID in NUMBER
,P_PO_HEADER_ID in NUMBER
,P_PO_LINE_ID in NUMBER
,P_PROJECTED_ASSIGNMENT_END in DATE
) IS
begin
hr_utility.trace('>> PAY_DYT_ALL_ASSIGNMENTS_PKG.after_insert');
end after_insert;
PROCEDURE AFTER_UPDATE
(
p_effective_date in DATE
,p_datetrack_mode in VARCHAR2
,p_validation_start_date in DATE
,p_validation_end_date in DATE
,P_APPLICANT_RANK in NUMBER
,P_APPLICATION_ID in NUMBER
,P_ASSIGNMENT_CATEGORY in VARCHAR2
,P_ASSIGNMENT_ID in NUMBER
,P_ASSIGNMENT_NUMBER in VARCHAR2
,P_ASSIGNMENT_STATUS_TYPE_ID in NUMBER
,P_ASSIGNMENT_TYPE in VARCHAR2
,P_ASS_ATTRIBUTE1 in VARCHAR2
,P_ASS_ATTRIBUTE10 in VARCHAR2
,P_ASS_ATTRIBUTE11 in VARCHAR2
,P_ASS_ATTRIBUTE12 in VARCHAR2
,P_ASS_ATTRIBUTE13 in VARCHAR2
,P_ASS_ATTRIBUTE14 in VARCHAR2
,P_ASS_ATTRIBUTE15 in VARCHAR2
,P_ASS_ATTRIBUTE16 in VARCHAR2
,P_ASS_ATTRIBUTE17 in VARCHAR2
,P_ASS_ATTRIBUTE18 in VARCHAR2
,P_ASS_ATTRIBUTE19 in VARCHAR2
,P_ASS_ATTRIBUTE2 in VARCHAR2
,P_ASS_ATTRIBUTE20 in VARCHAR2
,P_ASS_ATTRIBUTE21 in VARCHAR2
,P_ASS_ATTRIBUTE22 in VARCHAR2
,P_ASS_ATTRIBUTE23 in VARCHAR2
,P_ASS_ATTRIBUTE24 in VARCHAR2
,P_ASS_ATTRIBUTE25 in VARCHAR2
,P_ASS_ATTRIBUTE26 in VARCHAR2
,P_ASS_ATTRIBUTE27 in VARCHAR2
,P_ASS_ATTRIBUTE28 in VARCHAR2
,P_ASS_ATTRIBUTE29 in VARCHAR2
,P_ASS_ATTRIBUTE3 in VARCHAR2
,P_ASS_ATTRIBUTE30 in VARCHAR2
,P_ASS_ATTRIBUTE4 in VARCHAR2
,P_ASS_ATTRIBUTE5 in VARCHAR2
,P_ASS_ATTRIBUTE6 in VARCHAR2
,P_ASS_ATTRIBUTE7 in VARCHAR2
,P_ASS_ATTRIBUTE8 in VARCHAR2
,P_ASS_ATTRIBUTE9 in VARCHAR2
,P_ASS_ATTRIBUTE_CATEGORY in VARCHAR2
,P_BARGAINING_UNIT_CODE in VARCHAR2
,P_CAGR_GRADE_DEF_ID in NUMBER
,P_CAGR_ID_FLEX_NUM in NUMBER
,P_CHANGE_REASON in VARCHAR2
,P_COLLECTIVE_AGREEMENT_ID in NUMBER
,P_COMMENTS in VARCHAR2
,P_COMMENT_ID in NUMBER
,P_CONTRACT_ID in NUMBER
,P_DATE_PROBATION_END in DATE
,P_DEFAULT_CODE_COMB_ID in NUMBER
,P_EFFECTIVE_END_DATE in DATE
,P_EFFECTIVE_START_DATE in DATE
,P_EMPLOYEE_CATEGORY in VARCHAR2
,P_EMPLOYMENT_CATEGORY in VARCHAR2
,P_ESTABLISHMENT_ID in NUMBER
,P_FREQUENCY in VARCHAR2
,P_GRADE_ID in NUMBER
,P_HOURLY_SALARIED_CODE in VARCHAR2
,P_HOURLY_SALARIED_WARNING in BOOLEAN
,P_INTERNAL_ADDRESS_LINE in VARCHAR2
,P_JOB_ID in NUMBER
,P_JOB_POST_SOURCE_NAME in VARCHAR2
,P_LABOUR_UNION_MEMBER_FLAG in VARCHAR2
,P_LOCATION_ID in NUMBER
,P_MANAGER_FLAG in VARCHAR2
,P_NORMAL_HOURS in NUMBER
,P_NOTICE_PERIOD in NUMBER
,P_NOTICE_PERIOD_UOM in VARCHAR2
,P_NO_MANAGERS_WARNING in BOOLEAN
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_ORGANIZATION_ID in NUMBER
,P_ORG_NOW_NO_MANAGER_WARNING in BOOLEAN
,P_OTHER_MANAGER_WARNING in BOOLEAN
,P_PAYROLL_ID in NUMBER
,P_PAYROLL_ID_UPDATED in BOOLEAN
,P_PAY_BASIS_ID in NUMBER
,P_PEOPLE_GROUP_ID in NUMBER
,P_PERF_REVIEW_PERIOD in NUMBER
,P_PERF_REVIEW_PERIOD_FREQUEN in VARCHAR2
,P_PERIOD_OF_SERVICE_ID in NUMBER
,P_PERSON_REFERRED_BY_ID in NUMBER
,P_PLACEMENT_DATE_START in DATE
,P_POSITION_ID in NUMBER
,P_POSTING_CONTENT_ID in NUMBER
,P_PRIMARY_FLAG in VARCHAR2
,P_PROBATION_PERIOD in NUMBER
,P_PROBATION_UNIT in VARCHAR2
,P_PROGRAM_APPLICATION_ID in NUMBER
,P_PROGRAM_ID in NUMBER
,P_PROGRAM_UPDATE_DATE in DATE
,P_PROJECT_TITLE in VARCHAR2
,P_RECRUITER_ID in NUMBER
,P_RECRUITMENT_ACTIVITY_ID in NUMBER
,P_REQUEST_ID in NUMBER
,P_SAL_REVIEW_PERIOD in NUMBER
,P_SAL_REVIEW_PERIOD_FREQUEN in VARCHAR2
,P_SET_OF_BOOKS_ID in NUMBER
,P_SOFT_CODING_KEYFLEX_ID in NUMBER
,P_SOURCE_ORGANIZATION_ID in NUMBER
,P_SOURCE_TYPE in VARCHAR2
,P_SPECIAL_CEILING_STEP_ID in NUMBER
,P_SUPERVISOR_ID in NUMBER
,P_TIME_NORMAL_FINISH in VARCHAR2
,P_TIME_NORMAL_START in VARCHAR2
,P_TITLE in VARCHAR2
,P_VACANCY_ID in NUMBER
,P_VENDOR_ASSIGNMENT_NUMBER in VARCHAR2
,P_VENDOR_EMPLOYEE_NUMBER in VARCHAR2
,P_VENDOR_ID in NUMBER
,P_WORK_AT_HOME in VARCHAR2
,P_GRADE_LADDER_PGM_ID in NUMBER
,P_SUPERVISOR_ASSIGNMENT_ID in NUMBER
,P_VENDOR_SITE_ID in NUMBER
,P_PO_HEADER_ID in NUMBER
,P_PO_LINE_ID in NUMBER
,P_PROJECTED_ASSIGNMENT_END in DATE
,P_APPLICANT_RANK_O in NUMBER
,P_APPLICATION_ID_O in NUMBER
,P_ASSIGNMENT_CATEGORY_O in VARCHAR2
,P_ASSIGNMENT_NUMBER_O in VARCHAR2
,P_ASSIGNMENT_SEQUENCE_O in NUMBER
,P_ASSIGNMENT_STATUS_TYPE_ID_O in NUMBER
,P_ASSIGNMENT_TYPE_O in VARCHAR2
,P_ASS_ATTRIBUTE1_O in VARCHAR2
,P_ASS_ATTRIBUTE10_O in VARCHAR2
,P_ASS_ATTRIBUTE11_O in VARCHAR2
,P_ASS_ATTRIBUTE12_O in VARCHAR2
,P_ASS_ATTRIBUTE13_O in VARCHAR2
,P_ASS_ATTRIBUTE14_O in VARCHAR2
,P_ASS_ATTRIBUTE15_O in VARCHAR2
,P_ASS_ATTRIBUTE16_O in VARCHAR2
,P_ASS_ATTRIBUTE17_O in VARCHAR2
,P_ASS_ATTRIBUTE18_O in VARCHAR2
,P_ASS_ATTRIBUTE19_O in VARCHAR2
,P_ASS_ATTRIBUTE2_O in VARCHAR2
,P_ASS_ATTRIBUTE20_O in VARCHAR2
,P_ASS_ATTRIBUTE21_O in VARCHAR2
,P_ASS_ATTRIBUTE22_O in VARCHAR2
,P_ASS_ATTRIBUTE23_O in VARCHAR2
,P_ASS_ATTRIBUTE24_O in VARCHAR2
,P_ASS_ATTRIBUTE25_O in VARCHAR2
,P_ASS_ATTRIBUTE26_O in VARCHAR2
,P_ASS_ATTRIBUTE27_O in VARCHAR2
,P_ASS_ATTRIBUTE28_O in VARCHAR2
,P_ASS_ATTRIBUTE29_O in VARCHAR2
,P_ASS_ATTRIBUTE3_O in VARCHAR2
,P_ASS_ATTRIBUTE30_O in VARCHAR2
,P_ASS_ATTRIBUTE4_O in VARCHAR2
,P_ASS_ATTRIBUTE5_O in VARCHAR2
,P_ASS_ATTRIBUTE6_O in VARCHAR2
,P_ASS_ATTRIBUTE7_O in VARCHAR2
,P_ASS_ATTRIBUTE8_O in VARCHAR2
,P_ASS_ATTRIBUTE9_O in VARCHAR2
,P_ASS_ATTRIBUTE_CATEGORY_O in VARCHAR2
,P_BARGAINING_UNIT_CODE_O in VARCHAR2
,P_BUSINESS_GROUP_ID_O in NUMBER
,P_CAGR_GRADE_DEF_ID_O in NUMBER
,P_CAGR_ID_FLEX_NUM_O in NUMBER
,P_CHANGE_REASON_O in VARCHAR2
,P_COLLECTIVE_AGREEMENT_ID_O in NUMBER
,P_COMMENT_ID_O in NUMBER
,P_CONTRACT_ID_O in NUMBER
,P_DATE_PROBATION_END_O in DATE
,P_DEFAULT_CODE_COMB_ID_O in NUMBER
,P_EFFECTIVE_END_DATE_O in DATE
,P_EFFECTIVE_START_DATE_O in DATE
,P_EMPLOYEE_CATEGORY_O in VARCHAR2
,P_EMPLOYMENT_CATEGORY_O in VARCHAR2
,P_ESTABLISHMENT_ID_O in NUMBER
,P_FREQUENCY_O in VARCHAR2
,P_GRADE_ID_O in NUMBER
,P_HOURLY_SALARIED_CODE_O in VARCHAR2
,P_INTERNAL_ADDRESS_LINE_O in VARCHAR2
,P_JOB_ID_O in NUMBER
,P_JOB_POST_SOURCE_NAME_O in VARCHAR2
,P_LABOUR_UNION_MEMBER_FLAG_O in VARCHAR2
,P_LOCATION_ID_O in NUMBER
,P_MANAGER_FLAG_O in VARCHAR2
,P_NORMAL_HOURS_O in NUMBER
,P_NOTICE_PERIOD_O in NUMBER
,P_NOTICE_PERIOD_UOM_O in VARCHAR2
,P_OBJECT_VERSION_NUMBER_O in NUMBER
,P_ORGANIZATION_ID_O in NUMBER
,P_PAYROLL_ID_O in NUMBER
,P_PAY_BASIS_ID_O in NUMBER
,P_PEOPLE_GROUP_ID_O in NUMBER
,P_PERF_REVIEW_PERIOD_O in NUMBER
,P_PERF_REVIEW_PERIOD_FREQUEN_O in VARCHAR2
,P_PERIOD_OF_SERVICE_ID_O in NUMBER
,P_PERSON_ID_O in NUMBER
,P_PERSON_REFERRED_BY_ID_O in NUMBER
,P_PLACEMENT_DATE_START_O in DATE
,P_POSITION_ID_O in NUMBER
,P_POSTING_CONTENT_ID_O in NUMBER
,P_PRIMARY_FLAG_O in VARCHAR2
,P_PROBATION_PERIOD_O in NUMBER
,P_PROBATION_UNIT_O in VARCHAR2
,P_PROGRAM_APPLICATION_ID_O in NUMBER
,P_PROGRAM_ID_O in NUMBER
,P_PROGRAM_UPDATE_DATE_O in DATE
,P_PROJECT_TITLE_O in VARCHAR2
,P_RECRUITER_ID_O in NUMBER
,P_RECRUITMENT_ACTIVITY_ID_O in NUMBER
,P_REQUEST_ID_O in NUMBER
,P_SAL_REVIEW_PERIOD_O in NUMBER
,P_SAL_REVIEW_PERIOD_FREQUEN_O in VARCHAR2
,P_SET_OF_BOOKS_ID_O in NUMBER
,P_SOFT_CODING_KEYFLEX_ID_O in NUMBER
,P_SOURCE_ORGANIZATION_ID_O in NUMBER
,P_SOURCE_TYPE_O in VARCHAR2
,P_SPECIAL_CEILING_STEP_ID_O in NUMBER
,P_SUPERVISOR_ID_O in NUMBER
,P_TIME_NORMAL_FINISH_O in VARCHAR2
,P_TIME_NORMAL_START_O in VARCHAR2
,P_TITLE_O in VARCHAR2
,P_VACANCY_ID_O in NUMBER
,P_VENDOR_ASSIGNMENT_NUMBER_O in VARCHAR2
,P_VENDOR_EMPLOYEE_NUMBER_O in VARCHAR2
,P_VENDOR_ID_O in NUMBER
,P_WORK_AT_HOME_O in VARCHAR2
,P_GRADE_LADDER_PGM_ID_O in NUMBER
,P_SUPERVISOR_ASSIGNMENT_ID_O in NUMBER
,P_VENDOR_SITE_ID_O in NUMBER
,P_PO_HEADER_ID_O in NUMBER
,P_PO_LINE_ID_O in NUMBER
,P_PROJECTED_ASSIGNMENT_END_O in DATE
) IS
begin
hr_utility.trace('>> PAY_DYT_ALL_ASSIGNMENTS_PKG.after_update');
end after_update;
PROCEDURE AFTER_DELETE
(
p_effective_date in DATE
,p_datetrack_mode in VARCHAR2
,p_validation_start_date in DATE
,p_validation_end_date in DATE
,P_ASSIGNMENT_ID in NUMBER
,P_EFFECTIVE_END_DATE in DATE
,P_EFFECTIVE_START_DATE in DATE
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_ORG_NOW_NO_MANAGER_WARNING in BOOLEAN
,P_APPLICANT_RANK_O in NUMBER
,P_APPLICATION_ID_O in NUMBER
,P_ASSIGNMENT_CATEGORY_O in VARCHAR2
,P_ASSIGNMENT_NUMBER_O in VARCHAR2
,P_ASSIGNMENT_SEQUENCE_O in NUMBER
,P_ASSIGNMENT_STATUS_TYPE_ID_O in NUMBER
,P_ASSIGNMENT_TYPE_O in VARCHAR2
,P_ASS_ATTRIBUTE1_O in VARCHAR2
,P_ASS_ATTRIBUTE10_O in VARCHAR2
,P_ASS_ATTRIBUTE11_O in VARCHAR2
,P_ASS_ATTRIBUTE12_O in VARCHAR2
,P_ASS_ATTRIBUTE13_O in VARCHAR2
,P_ASS_ATTRIBUTE14_O in VARCHAR2
,P_ASS_ATTRIBUTE15_O in VARCHAR2
,P_ASS_ATTRIBUTE16_O in VARCHAR2
,P_ASS_ATTRIBUTE17_O in VARCHAR2
,P_ASS_ATTRIBUTE18_O in VARCHAR2
,P_ASS_ATTRIBUTE19_O in VARCHAR2
,P_ASS_ATTRIBUTE2_O in VARCHAR2
,P_ASS_ATTRIBUTE20_O in VARCHAR2
,P_ASS_ATTRIBUTE21_O in VARCHAR2
,P_ASS_ATTRIBUTE22_O in VARCHAR2
,P_ASS_ATTRIBUTE23_O in VARCHAR2
,P_ASS_ATTRIBUTE24_O in VARCHAR2
,P_ASS_ATTRIBUTE25_O in VARCHAR2
,P_ASS_ATTRIBUTE26_O in VARCHAR2
,P_ASS_ATTRIBUTE27_O in VARCHAR2
,P_ASS_ATTRIBUTE28_O in VARCHAR2
,P_ASS_ATTRIBUTE29_O in VARCHAR2
,P_ASS_ATTRIBUTE3_O in VARCHAR2
,P_ASS_ATTRIBUTE30_O in VARCHAR2
,P_ASS_ATTRIBUTE4_O in VARCHAR2
,P_ASS_ATTRIBUTE5_O in VARCHAR2
,P_ASS_ATTRIBUTE6_O in VARCHAR2
,P_ASS_ATTRIBUTE7_O in VARCHAR2
,P_ASS_ATTRIBUTE8_O in VARCHAR2
,P_ASS_ATTRIBUTE9_O in VARCHAR2
,P_ASS_ATTRIBUTE_CATEGORY_O in VARCHAR2
,P_BARGAINING_UNIT_CODE_O in VARCHAR2
,P_BUSINESS_GROUP_ID_O in NUMBER
,P_CAGR_GRADE_DEF_ID_O in NUMBER
,P_CAGR_ID_FLEX_NUM_O in NUMBER
,P_CHANGE_REASON_O in VARCHAR2
,P_COLLECTIVE_AGREEMENT_ID_O in NUMBER
,P_COMMENT_ID_O in NUMBER
,P_CONTRACT_ID_O in NUMBER
,P_DATE_PROBATION_END_O in DATE
,P_DEFAULT_CODE_COMB_ID_O in NUMBER
,P_EFFECTIVE_END_DATE_O in DATE
,P_EFFECTIVE_START_DATE_O in DATE
,P_EMPLOYEE_CATEGORY_O in VARCHAR2
,P_EMPLOYMENT_CATEGORY_O in VARCHAR2
,P_ESTABLISHMENT_ID_O in NUMBER
,P_FREQUENCY_O in VARCHAR2
,P_GRADE_ID_O in NUMBER
,P_HOURLY_SALARIED_CODE_O in VARCHAR2
,P_INTERNAL_ADDRESS_LINE_O in VARCHAR2
,P_JOB_ID_O in NUMBER
,P_JOB_POST_SOURCE_NAME_O in VARCHAR2
,P_LABOUR_UNION_MEMBER_FLAG_O in VARCHAR2
,P_LOCATION_ID_O in NUMBER
,P_MANAGER_FLAG_O in VARCHAR2
,P_NORMAL_HOURS_O in NUMBER
,P_NOTICE_PERIOD_O in NUMBER
,P_NOTICE_PERIOD_UOM_O in VARCHAR2
,P_OBJECT_VERSION_NUMBER_O in NUMBER
,P_ORGANIZATION_ID_O in NUMBER
,P_PAYROLL_ID_O in NUMBER
,P_PAY_BASIS_ID_O in NUMBER
,P_PEOPLE_GROUP_ID_O in NUMBER
,P_PERF_REVIEW_PERIOD_O in NUMBER
,P_PERF_REVIEW_PERIOD_FREQUEN_O in VARCHAR2
,P_PERIOD_OF_SERVICE_ID_O in NUMBER
,P_PERSON_ID_O in NUMBER
,P_PERSON_REFERRED_BY_ID_O in NUMBER
,P_PLACEMENT_DATE_START_O in DATE
,P_POSITION_ID_O in NUMBER
,P_POSTING_CONTENT_ID_O in NUMBER
,P_PRIMARY_FLAG_O in VARCHAR2
,P_PROBATION_PERIOD_O in NUMBER
,P_PROBATION_UNIT_O in VARCHAR2
,P_PROGRAM_APPLICATION_ID_O in NUMBER
,P_PROGRAM_ID_O in NUMBER
,P_PROGRAM_UPDATE_DATE_O in DATE
,P_PROJECT_TITLE_O in VARCHAR2
,P_RECRUITER_ID_O in NUMBER
,P_RECRUITMENT_ACTIVITY_ID_O in NUMBER
,P_REQUEST_ID_O in NUMBER
,P_SAL_REVIEW_PERIOD_O in NUMBER
,P_SAL_REVIEW_PERIOD_FREQUEN_O in VARCHAR2
,P_SET_OF_BOOKS_ID_O in NUMBER
,P_SOFT_CODING_KEYFLEX_ID_O in NUMBER
,P_SOURCE_ORGANIZATION_ID_O in NUMBER
,P_SOURCE_TYPE_O in VARCHAR2
,P_SPECIAL_CEILING_STEP_ID_O in NUMBER
,P_SUPERVISOR_ID_O in NUMBER
,P_TIME_NORMAL_FINISH_O in VARCHAR2
,P_TIME_NORMAL_START_O in VARCHAR2
,P_TITLE_O in VARCHAR2
,P_VACANCY_ID_O in NUMBER
,P_VENDOR_ASSIGNMENT_NUMBER_O in VARCHAR2
,P_VENDOR_EMPLOYEE_NUMBER_O in VARCHAR2
,P_VENDOR_ID_O in NUMBER
,P_WORK_AT_HOME_O in VARCHAR2
,P_GRADE_LADDER_PGM_ID_O in NUMBER
,P_SUPERVISOR_ASSIGNMENT_ID_O in NUMBER
,P_VENDOR_SITE_ID_O in NUMBER
,P_PO_HEADER_ID_O in NUMBER
,P_PO_LINE_ID_O in NUMBER
,P_PROJECTED_ASSIGNMENT_END_O in DATE
) IS
begin
hr_utility.trace('>> PAY_DYT_ALL_ASSIGNMENTS_PKG.after_delete');
end after_delete;