1 package body PQH_STS_RKU as
2 /* $Header: pqstsrhi.pkb 120.0 2005/05/29 02:43 generated noship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2007/01/03 22:53:35 (YYYY/MM/DD HH24:MI:SS)
5 procedure AFTER_UPDATE
6 (P_EFFECTIVE_DATE in DATE
7 ,P_STATUTORY_SITUATION_ID in NUMBER
8 ,P_BUSINESS_GROUP_ID in NUMBER
9 ,P_SITUATION_NAME in VARCHAR2
10 ,P_TYPE_OF_PS in VARCHAR2
11 ,P_SITUATION_TYPE in VARCHAR2
12 ,P_SUB_TYPE in VARCHAR2
13 ,P_SOURCE in VARCHAR2
14 ,P_LOCATION in VARCHAR2
15 ,P_REASON in VARCHAR2
16 ,P_IS_DEFAULT in VARCHAR2
17 ,P_DATE_FROM in DATE
18 ,P_DATE_TO in DATE
19 ,P_REQUEST_TYPE in VARCHAR2
20 ,P_EMPLOYEE_AGREEMENT_NEEDED in VARCHAR2
21 ,P_MANAGER_AGREEMENT_NEEDED in VARCHAR2
22 ,P_PRINT_ARRETTE in VARCHAR2
23 ,P_RESERVE_POSITION in VARCHAR2
24 ,P_ALLOW_PROGRESSIONS in VARCHAR2
25 ,P_EXTEND_PROBATION_PERIOD in VARCHAR2
26 ,P_REMUNERATION_PAID in VARCHAR2
27 ,P_PAY_SHARE in NUMBER
28 ,P_PAY_PERIODS in NUMBER
29 ,P_FREQUENCY in VARCHAR2
30 ,P_FIRST_PERIOD_MAX_DURATION in NUMBER
31 ,P_MIN_DURATION_PER_REQUEST in NUMBER
32 ,P_MAX_DURATION_PER_REQUEST in NUMBER
33 ,P_MAX_DURATION_WHOLE_CAREER in NUMBER
34 ,P_RENEWABLE_ALLOWED in VARCHAR2
35 ,P_MAX_NO_OF_RENEWALS in NUMBER
36 ,P_MAX_DURATION_PER_RENEWAL in NUMBER
37 ,P_MAX_TOT_CONTINUOUS_DURATION in NUMBER
38 ,P_OBJECT_VERSION_NUMBER in NUMBER
39 ,P_REMUNERATE_ASSIGN_STATUS_ID in NUMBER
40 ,P_BUSINESS_GROUP_ID_O in NUMBER
41 ,P_SITUATION_NAME_O in VARCHAR2
42 ,P_TYPE_OF_PS_O in VARCHAR2
43 ,P_SITUATION_TYPE_O in VARCHAR2
44 ,P_SUB_TYPE_O in VARCHAR2
45 ,P_SOURCE_O in VARCHAR2
46 ,P_LOCATION_O in VARCHAR2
47 ,P_REASON_O in VARCHAR2
48 ,P_IS_DEFAULT_O in VARCHAR2
49 ,P_DATE_FROM_O in DATE
50 ,P_DATE_TO_O in DATE
51 ,P_REQUEST_TYPE_O in VARCHAR2
52 ,P_EMPLOYEE_AGREEMENT_NEEDED_O in VARCHAR2
53 ,P_MANAGER_AGREEMENT_NEEDED_O in VARCHAR2
54 ,P_PRINT_ARRETTE_O in VARCHAR2
55 ,P_RESERVE_POSITION_O in VARCHAR2
56 ,P_ALLOW_PROGRESSIONS_O in VARCHAR2
57 ,P_EXTEND_PROBATION_PERIOD_O in VARCHAR2
58 ,P_REMUNERATION_PAID_O in VARCHAR2
59 ,P_PAY_SHARE_O in NUMBER
60 ,P_PAY_PERIODS_O in NUMBER
61 ,P_FREQUENCY_O in VARCHAR2
62 ,P_FIRST_PERIOD_MAX_DURATION_O in NUMBER
63 ,P_MIN_DURATION_PER_REQUEST_O in NUMBER
64 ,P_MAX_DURATION_PER_REQUEST_O in NUMBER
65 ,P_MAX_DURATION_WHOLE_CAREER_O in NUMBER
66 ,P_RENEWABLE_ALLOWED_O in VARCHAR2
67 ,P_MAX_NO_OF_RENEWALS_O in NUMBER
68 ,P_MAX_DURATION_PER_RENEWAL_O in NUMBER
69 ,P_MAX_TOT_CONTINUOUS_DURATIO_O in NUMBER
70 ,P_OBJECT_VERSION_NUMBER_O in NUMBER
71 ,P_REMUNERATE_ASSIGN_STAT_ID_O in NUMBER
72 )is
73 begin
74 hr_utility.set_location('Entering: PQH_STS_RKU.AFTER_UPDATE', 10);
75 hr_utility.set_location(' Leaving: PQH_STS_RKU.AFTER_UPDATE', 20);
76 end AFTER_UPDATE;
77 end PQH_STS_RKU;
[Home] [Help]