APPS.GHR_PAR_RKD SQL Statements

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

Line: 5

procedure AFTER_DELETE
(P_PA_REQUEST_ID in NUMBER
,P_PA_NOTIFICATION_ID_O in NUMBER
,P_NOA_FAMILY_CODE_O in VARCHAR2
,P_ROUTING_GROUP_ID_O in NUMBER
,P_PROPOSED_EFFECTIVE_ASAP_FL_O in VARCHAR2
,P_ACADEMIC_DISCIPLINE_O in VARCHAR2
,P_ADDITIONAL_INFO_PERSON_ID_O in NUMBER
,P_ADDITIONAL_INFO_TEL_NUMBER_O in VARCHAR2
,P_AGENCY_CODE_O in VARCHAR2
,P_ALTERED_PA_REQUEST_ID_O in NUMBER
,P_ANNUITANT_INDICATOR_O in VARCHAR2
,P_ANNUITANT_INDICATOR_DESC_O in VARCHAR2
,P_APPROPRIATION_CODE1_O in VARCHAR2
,P_APPROPRIATION_CODE2_O in VARCHAR2
,P_APPROVAL_DATE_O in DATE
,P_APPROVING_OFFICIAL_FULL_NA_O in VARCHAR2
,P_APPROVING_OFFICIAL_WORK_TI_O in VARCHAR2
,P_AUTHORIZED_BY_PERSON_ID_O in NUMBER
,P_AUTHORIZED_BY_TITLE_O in VARCHAR2
,P_SF50_APPROVAL_DATE_O in DATE
,P_SF50_APPROVING_OFCL_FULL_N_O in VARCHAR2
,P_SF50_APPROVING_OFCL_WORK_T_O in VARCHAR2
,P_AWARD_AMOUNT_O in NUMBER
,P_AWARD_UOM_O in VARCHAR2
,P_BARGAINING_UNIT_STATUS_O in VARCHAR2
,P_CITIZENSHIP_O in VARCHAR2
,P_CONCURRENCE_DATE_O in DATE
,P_CUSTOM_PAY_CALC_FLAG_O in VARCHAR2
,P_DUTY_STATION_CODE_O in VARCHAR2
,P_DUTY_STATION_DESC_O in VARCHAR2
,P_DUTY_STATION_ID_O in NUMBER
,P_DUTY_STATION_LOCATION_ID_O in NUMBER
,P_EDUCATION_LEVEL_O in VARCHAR2
,P_EFFECTIVE_DATE_O in DATE
,P_EMPLOYEE_ASSIGNMENT_ID_O in NUMBER
,P_EMPLOYEE_DATE_OF_BIRTH_O in DATE
,P_EMPLOYEE_DEPT_OR_AGENCY_O in VARCHAR2
,P_EMPLOYEE_FIRST_NAME_O in VARCHAR2
,P_EMPLOYEE_LAST_NAME_O in VARCHAR2
,P_EMPLOYEE_MIDDLE_NAMES_O in VARCHAR2
,P_EMPLOYEE_NATIONAL_IDENTIFI_O in VARCHAR2
,P_FEGLI_O in VARCHAR2
,P_FEGLI_DESC_O in VARCHAR2
,P_FIRST_ACTION_LA_CODE1_O in VARCHAR2
,P_FIRST_ACTION_LA_CODE2_O in VARCHAR2
,P_FIRST_ACTION_LA_DESC1_O in VARCHAR2
,P_FIRST_ACTION_LA_DESC2_O in VARCHAR2
,P_FIRST_NOA_CANCEL_OR_CORREC_O in VARCHAR2
,P_FIRST_NOA_CODE_O in VARCHAR2
,P_FIRST_NOA_DESC_O in VARCHAR2
,P_FIRST_NOA_ID_O in NUMBER
,P_FIRST_NOA_PA_REQUEST_ID_O in NUMBER
,P_FLSA_CATEGORY_O in VARCHAR2
,P_FORWARDING_ADDRESS_LINE1_O in VARCHAR2
,P_FORWARDING_ADDRESS_LINE2_O in VARCHAR2
,P_FORWARDING_ADDRESS_LINE3_O in VARCHAR2
,P_FORWARDING_COUNTRY_O in VARCHAR2
,P_FORWARDING_COUNTRY_SHORT_N_O in VARCHAR2
,P_FORWARDING_POSTAL_CODE_O in VARCHAR2
,P_FORWARDING_REGION_2_O in VARCHAR2
,P_FORWARDING_TOWN_OR_CITY_O in VARCHAR2
,P_FROM_ADJ_BASIC_PAY_O in NUMBER
,P_FROM_AGENCY_CODE_O in VARCHAR2
,P_FROM_AGENCY_DESC_O in VARCHAR2
,P_FROM_BASIC_PAY_O in NUMBER
,P_FROM_GRADE_OR_LEVEL_O in VARCHAR2
,P_FROM_LOCALITY_ADJ_O in NUMBER
,P_FROM_OCC_CODE_O in VARCHAR2
,P_FROM_OFFICE_SYMBOL_O in VARCHAR2
,P_FROM_OTHER_PAY_AMOUNT_O in NUMBER
,P_FROM_PAY_BASIS_O in VARCHAR2
,P_FROM_PAY_PLAN_O in VARCHAR2
,P_FROM_POSITION_ID_O in NUMBER
,P_FROM_POSITION_ORG_LINE1_O in VARCHAR2
,P_FROM_POSITION_ORG_LINE2_O in VARCHAR2
,P_FROM_POSITION_ORG_LINE3_O in VARCHAR2
,P_FROM_POSITION_ORG_LINE4_O in VARCHAR2
,P_FROM_POSITION_ORG_LINE5_O in VARCHAR2
,P_FROM_POSITION_ORG_LINE6_O in VARCHAR2
,P_FROM_POSITION_NUMBER_O in VARCHAR2
,P_FROM_POSITION_SEQ_NO_O in NUMBER
,P_FROM_POSITION_TITLE_O in VARCHAR2
,P_FROM_STEP_OR_RATE_O in VARCHAR2
,P_FROM_TOTAL_SALARY_O in NUMBER
,P_FUNCTIONAL_CLASS_O in VARCHAR2
,P_NOTEPAD_O in VARCHAR2
,P_PART_TIME_HOURS_O in NUMBER
,P_PAY_RATE_DETERMINANT_O in VARCHAR2
,P_PERSONNEL_OFFICE_ID_O in VARCHAR2
,P_PERSON_ID_O in NUMBER
,P_POSITION_OCCUPIED_O in VARCHAR2
,P_PROPOSED_EFFECTIVE_DATE_O in DATE
,P_REQUESTED_BY_PERSON_ID_O in NUMBER
,P_REQUESTED_BY_TITLE_O in VARCHAR2
,P_REQUESTED_DATE_O in DATE
,P_REQUESTING_OFFICE_REMARK_D_O in VARCHAR2
,P_REQUESTING_OFFICE_REMARK_F_O in VARCHAR2
,P_REQUEST_NUMBER_O in VARCHAR2
,P_RESIGN_AND_RETIRE_REASON_D_O in VARCHAR2
,P_RETIREMENT_PLAN_O in VARCHAR2
,P_RETIREMENT_PLAN_DESC_O in VARCHAR2
,P_SECOND_ACTION_LA_CODE1_O in VARCHAR2
,P_SECOND_ACTION_LA_CODE2_O in VARCHAR2
,P_SECOND_ACTION_LA_DESC1_O in VARCHAR2
,P_SECOND_ACTION_LA_DESC2_O in VARCHAR2
,P_SECOND_NOA_CANCEL_OR_CORRE_O in VARCHAR2
,P_SECOND_NOA_CODE_O in VARCHAR2
,P_SECOND_NOA_DESC_O in VARCHAR2
,P_SECOND_NOA_ID_O in NUMBER
,P_SECOND_NOA_PA_REQUEST_ID_O in NUMBER
,P_SERVICE_COMP_DATE_O in DATE
,P_STATUS_O in VARCHAR2
,P_SUPERVISORY_STATUS_O in VARCHAR2
,P_TENURE_O in VARCHAR2
,P_TO_ADJ_BASIC_PAY_O in NUMBER
,P_TO_BASIC_PAY_O in NUMBER
,P_TO_GRADE_ID_O in NUMBER
,P_TO_GRADE_OR_LEVEL_O in VARCHAR2
,P_TO_JOB_ID_O in NUMBER
,P_TO_LOCALITY_ADJ_O in NUMBER
,P_TO_OCC_CODE_O in VARCHAR2
,P_TO_OFFICE_SYMBOL_O in VARCHAR2
,P_TO_ORGANIZATION_ID_O in NUMBER
,P_TO_OTHER_PAY_AMOUNT_O in NUMBER
,P_TO_AU_OVERTIME_O in NUMBER
,P_TO_AUO_PREMIUM_PAY_INDICAT_O in VARCHAR2
,P_TO_AVAILABILITY_PAY_O in NUMBER
,P_TO_AP_PREMIUM_PAY_INDICATO_O in VARCHAR2
,P_TO_RETENTION_ALLOWANCE_O in NUMBER
,P_TO_SUPERVISORY_DIFFERENTIA_O in NUMBER
,P_TO_STAFFING_DIFFERENTIAL_O in NUMBER
,P_TO_PAY_BASIS_O in VARCHAR2
,P_TO_PAY_PLAN_O in VARCHAR2
,P_TO_POSITION_ID_O in NUMBER
,P_TO_POSITION_ORG_LINE1_O in VARCHAR2
,P_TO_POSITION_ORG_LINE2_O in VARCHAR2
,P_TO_POSITION_ORG_LINE3_O in VARCHAR2
,P_TO_POSITION_ORG_LINE4_O in VARCHAR2
,P_TO_POSITION_ORG_LINE5_O in VARCHAR2
,P_TO_POSITION_ORG_LINE6_O in VARCHAR2
,P_TO_POSITION_NUMBER_O in VARCHAR2
,P_TO_POSITION_SEQ_NO_O in NUMBER
,P_TO_POSITION_TITLE_O in VARCHAR2
,P_TO_STEP_OR_RATE_O in VARCHAR2
,P_TO_TOTAL_SALARY_O in NUMBER
,P_VETERANS_PREFERENCE_O in VARCHAR2
,P_VETERANS_PREF_FOR_RIF_O in VARCHAR2
,P_VETERANS_STATUS_O in VARCHAR2
,P_WORK_SCHEDULE_O in VARCHAR2
,P_WORK_SCHEDULE_DESC_O in VARCHAR2
,P_YEAR_DEGREE_ATTAINED_O in NUMBER
,P_FIRST_NOA_INFORMATION1_O in VARCHAR2
,P_FIRST_NOA_INFORMATION2_O in VARCHAR2
,P_FIRST_NOA_INFORMATION3_O in VARCHAR2
,P_FIRST_NOA_INFORMATION4_O in VARCHAR2
,P_FIRST_NOA_INFORMATION5_O in VARCHAR2
,P_SECOND_LAC1_INFORMATION1_O in VARCHAR2
,P_SECOND_LAC1_INFORMATION2_O in VARCHAR2
,P_SECOND_LAC1_INFORMATION3_O in VARCHAR2
,P_SECOND_LAC1_INFORMATION4_O in VARCHAR2
,P_SECOND_LAC1_INFORMATION5_O in VARCHAR2
,P_SECOND_LAC2_INFORMATION1_O in VARCHAR2
,P_SECOND_LAC2_INFORMATION2_O in VARCHAR2
,P_SECOND_LAC2_INFORMATION3_O in VARCHAR2
,P_SECOND_LAC2_INFORMATION4_O in VARCHAR2
,P_SECOND_LAC2_INFORMATION5_O in VARCHAR2
,P_SECOND_NOA_INFORMATION1_O in VARCHAR2
,P_SECOND_NOA_INFORMATION2_O in VARCHAR2
,P_SECOND_NOA_INFORMATION3_O in VARCHAR2
,P_SECOND_NOA_INFORMATION4_O in VARCHAR2
,P_SECOND_NOA_INFORMATION5_O in VARCHAR2
,P_FIRST_LAC1_INFORMATION1_O in VARCHAR2
,P_FIRST_LAC1_INFORMATION2_O in VARCHAR2
,P_FIRST_LAC1_INFORMATION3_O in VARCHAR2
,P_FIRST_LAC1_INFORMATION4_O in VARCHAR2
,P_FIRST_LAC1_INFORMATION5_O in VARCHAR2
,P_FIRST_LAC2_INFORMATION1_O in VARCHAR2
,P_FIRST_LAC2_INFORMATION2_O in VARCHAR2
,P_FIRST_LAC2_INFORMATION3_O in VARCHAR2
,P_FIRST_LAC2_INFORMATION4_O in VARCHAR2
,P_FIRST_LAC2_INFORMATION5_O in VARCHAR2
,P_ATTRIBUTE_CATEGORY_O in VARCHAR2
,P_ATTRIBUTE1_O in VARCHAR2
,P_ATTRIBUTE2_O in VARCHAR2
,P_ATTRIBUTE3_O in VARCHAR2
,P_ATTRIBUTE4_O in VARCHAR2
,P_ATTRIBUTE5_O in VARCHAR2
,P_ATTRIBUTE6_O in VARCHAR2
,P_ATTRIBUTE7_O in VARCHAR2
,P_ATTRIBUTE8_O in VARCHAR2
,P_ATTRIBUTE9_O in VARCHAR2
,P_ATTRIBUTE10_O in VARCHAR2
,P_ATTRIBUTE11_O in VARCHAR2
,P_ATTRIBUTE12_O in VARCHAR2
,P_ATTRIBUTE13_O in VARCHAR2
,P_ATTRIBUTE14_O in VARCHAR2
,P_ATTRIBUTE15_O in VARCHAR2
,P_ATTRIBUTE16_O in VARCHAR2
,P_ATTRIBUTE17_O in VARCHAR2
,P_ATTRIBUTE18_O in VARCHAR2
,P_ATTRIBUTE19_O in VARCHAR2
,P_ATTRIBUTE20_O in VARCHAR2
,P_FIRST_NOA_CANC_PA_REQUEST_O in NUMBER
,P_SECOND_NOA_CANC_PA_REQUEST_O in NUMBER
,P_TO_RETENTION_ALLOW_PERCENT_O in NUMBER
,P_TO_SUPERVISORY_DIFF_PERCEN_O in NUMBER
,P_TO_STAFFING_DIFF_PERCENTAG_O in NUMBER
,P_AWARD_PERCENTAGE_O in NUMBER
,P_RPA_TYPE_O in VARCHAR2
,P_MASS_ACTION_ID_O in NUMBER
,P_MASS_ACTION_ELIGIBLE_FLAG_O in VARCHAR2
,P_MASS_ACTION_SELECT_FLAG_O in VARCHAR2
,P_MASS_ACTION_COMMENTS_O in VARCHAR2
)is
begin
hr_utility.set_location('Entering: GHR_PAR_RKD.AFTER_DELETE', 10);

Line: 222

hr_utility.set_location(' Leaving: GHR_PAR_RKD.AFTER_DELETE', 20);

Line: 223

end AFTER_DELETE;