eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_STS_RKU SQL Statements

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

Line: 5


procedure AFTER_UPDATE
(P_EFFECTIVE_DATE in DATE
,P_STATUTORY_SITUATION_ID in NUMBER
,P_BUSINESS_GROUP_ID in NUMBER
,P_SITUATION_NAME in VARCHAR2
,P_TYPE_OF_PS in VARCHAR2
,P_SITUATION_TYPE in VARCHAR2
,P_SUB_TYPE in VARCHAR2
,P_SOURCE in VARCHAR2
,P_LOCATION in VARCHAR2
,P_REASON in VARCHAR2
,P_IS_DEFAULT in VARCHAR2
,P_DATE_FROM in DATE
,P_DATE_TO in DATE
,P_REQUEST_TYPE in VARCHAR2
,P_EMPLOYEE_AGREEMENT_NEEDED in VARCHAR2
,P_MANAGER_AGREEMENT_NEEDED in VARCHAR2
,P_PRINT_ARRETTE in VARCHAR2
,P_RESERVE_POSITION in VARCHAR2
,P_ALLOW_PROGRESSIONS in VARCHAR2
,P_EXTEND_PROBATION_PERIOD in VARCHAR2
,P_REMUNERATION_PAID in VARCHAR2
,P_PAY_SHARE in NUMBER
,P_PAY_PERIODS in NUMBER
,P_FREQUENCY in VARCHAR2
,P_FIRST_PERIOD_MAX_DURATION in NUMBER
,P_MIN_DURATION_PER_REQUEST in NUMBER
,P_MAX_DURATION_PER_REQUEST in NUMBER
,P_MAX_DURATION_WHOLE_CAREER in NUMBER
,P_RENEWABLE_ALLOWED in VARCHAR2
,P_MAX_NO_OF_RENEWALS in NUMBER
,P_MAX_DURATION_PER_RENEWAL in NUMBER
,P_MAX_TOT_CONTINUOUS_DURATION in NUMBER
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_REMUNERATE_ASSIGN_STATUS_ID in NUMBER
,P_BUSINESS_GROUP_ID_O in NUMBER
,P_SITUATION_NAME_O in VARCHAR2
,P_TYPE_OF_PS_O in VARCHAR2
,P_SITUATION_TYPE_O in VARCHAR2
,P_SUB_TYPE_O in VARCHAR2
,P_SOURCE_O in VARCHAR2
,P_LOCATION_O in VARCHAR2
,P_REASON_O in VARCHAR2
,P_IS_DEFAULT_O in VARCHAR2
,P_DATE_FROM_O in DATE
,P_DATE_TO_O in DATE
,P_REQUEST_TYPE_O in VARCHAR2
,P_EMPLOYEE_AGREEMENT_NEEDED_O in VARCHAR2
,P_MANAGER_AGREEMENT_NEEDED_O in VARCHAR2
,P_PRINT_ARRETTE_O in VARCHAR2
,P_RESERVE_POSITION_O in VARCHAR2
,P_ALLOW_PROGRESSIONS_O in VARCHAR2
,P_EXTEND_PROBATION_PERIOD_O in VARCHAR2
,P_REMUNERATION_PAID_O in VARCHAR2
,P_PAY_SHARE_O in NUMBER
,P_PAY_PERIODS_O in NUMBER
,P_FREQUENCY_O in VARCHAR2
,P_FIRST_PERIOD_MAX_DURATION_O in NUMBER
,P_MIN_DURATION_PER_REQUEST_O in NUMBER
,P_MAX_DURATION_PER_REQUEST_O in NUMBER
,P_MAX_DURATION_WHOLE_CAREER_O in NUMBER
,P_RENEWABLE_ALLOWED_O in VARCHAR2
,P_MAX_NO_OF_RENEWALS_O in NUMBER
,P_MAX_DURATION_PER_RENEWAL_O in NUMBER
,P_MAX_TOT_CONTINUOUS_DURATIO_O in NUMBER
,P_OBJECT_VERSION_NUMBER_O in NUMBER
,P_REMUNERATE_ASSIGN_STAT_ID_O in NUMBER
)is
begin
hr_utility.set_location('Entering: PQH_STS_RKU.AFTER_UPDATE', 10);

Line: 75


hr_utility.set_location(' Leaving: PQH_STS_RKU.AFTER_UPDATE', 20);

Line: 76


end AFTER_UPDATE;