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_FR_STAT_SITUATIONS_BK2 SQL Statements

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

Line: 5


procedure UPDATE_STATUTORY_SITUATION_A
(P_EFFECTIVE_DATE in DATE
,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_STATUTORY_SITUATION_ID in NUMBER
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_REMUNERATE_ASSIGN_STATUS_ID in NUMBER
)is
begin
hr_utility.set_location('Entering: PQH_FR_STAT_SITUATIONS_BK2.UPDATE_STATUTORY_SITUATION_A', 10);

Line: 43


hr_utility.set_location(' Leaving: PQH_FR_STAT_SITUATIONS_BK2.UPDATE_STATUTORY_SITUATION_A', 20);

Line: 44


end UPDATE_STATUTORY_SITUATION_A;

Line: 45


procedure UPDATE_STATUTORY_SITUATION_B
(P_EFFECTIVE_DATE in DATE
,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_STATUTORY_SITUATION_ID in NUMBER
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_REMUNERATE_ASSIGN_STATUS_ID in NUMBER
)is
begin
hr_utility.set_location('Entering: PQH_FR_STAT_SITUATIONS_BK2.UPDATE_STATUTORY_SITUATION_B', 10);

Line: 83


hr_utility.set_location(' Leaving: PQH_FR_STAT_SITUATIONS_BK2.UPDATE_STATUTORY_SITUATION_B', 20);

Line: 84


end UPDATE_STATUTORY_SITUATION_B;