PACKAGE BODY: APPS.PQH_FR_STAT_SITUATIONS_BK2

Source

1 package body PQH_FR_STAT_SITUATIONS_BK2 as
2 /* $Header: pqstsapi.pkb 120.0 2005/05/29 02:43:03 generated noship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2007/01/03 22:53:34 (YYYY/MM/DD HH24:MI:SS)
5 procedure UPDATE_STATUTORY_SITUATION_A
6 (P_EFFECTIVE_DATE in DATE
7 ,P_BUSINESS_GROUP_ID in NUMBER
8 ,P_SITUATION_NAME in VARCHAR2
9 ,P_TYPE_OF_PS in VARCHAR2
10 ,P_SITUATION_TYPE in VARCHAR2
11 ,P_SUB_TYPE in VARCHAR2
12 ,P_SOURCE in VARCHAR2
13 ,P_LOCATION in VARCHAR2
14 ,P_REASON in VARCHAR2
15 ,P_IS_DEFAULT in VARCHAR2
16 ,P_DATE_FROM in DATE
17 ,P_DATE_TO in DATE
18 ,P_REQUEST_TYPE in VARCHAR2
19 ,P_EMPLOYEE_AGREEMENT_NEEDED in VARCHAR2
20 ,P_MANAGER_AGREEMENT_NEEDED in VARCHAR2
21 ,P_PRINT_ARRETTE in VARCHAR2
22 ,P_RESERVE_POSITION in VARCHAR2
23 ,P_ALLOW_PROGRESSIONS in VARCHAR2
24 ,P_EXTEND_PROBATION_PERIOD in VARCHAR2
25 ,P_REMUNERATION_PAID in VARCHAR2
26 ,P_PAY_SHARE in NUMBER
27 ,P_PAY_PERIODS in NUMBER
28 ,P_FREQUENCY in VARCHAR2
29 ,P_FIRST_PERIOD_MAX_DURATION in NUMBER
30 ,P_MIN_DURATION_PER_REQUEST in NUMBER
31 ,P_MAX_DURATION_PER_REQUEST in NUMBER
32 ,P_MAX_DURATION_WHOLE_CAREER in NUMBER
33 ,P_RENEWABLE_ALLOWED in VARCHAR2
34 ,P_MAX_NO_OF_RENEWALS in NUMBER
35 ,P_MAX_DURATION_PER_RENEWAL in NUMBER
36 ,P_MAX_TOT_CONTINUOUS_DURATION in NUMBER
37 ,P_STATUTORY_SITUATION_ID in NUMBER
38 ,P_OBJECT_VERSION_NUMBER in NUMBER
39 ,P_REMUNERATE_ASSIGN_STATUS_ID in NUMBER
40 )is
41 begin
42 hr_utility.set_location('Entering: PQH_FR_STAT_SITUATIONS_BK2.UPDATE_STATUTORY_SITUATION_A', 10);
43 hr_utility.set_location(' Leaving: PQH_FR_STAT_SITUATIONS_BK2.UPDATE_STATUTORY_SITUATION_A', 20);
44 end UPDATE_STATUTORY_SITUATION_A;
45 procedure UPDATE_STATUTORY_SITUATION_B
46 (P_EFFECTIVE_DATE in DATE
47 ,P_BUSINESS_GROUP_ID in NUMBER
48 ,P_SITUATION_NAME in VARCHAR2
49 ,P_TYPE_OF_PS in VARCHAR2
50 ,P_SITUATION_TYPE in VARCHAR2
51 ,P_SUB_TYPE in VARCHAR2
52 ,P_SOURCE in VARCHAR2
53 ,P_LOCATION in VARCHAR2
54 ,P_REASON in VARCHAR2
55 ,P_IS_DEFAULT in VARCHAR2
56 ,P_DATE_FROM in DATE
57 ,P_DATE_TO in DATE
58 ,P_REQUEST_TYPE in VARCHAR2
59 ,P_EMPLOYEE_AGREEMENT_NEEDED in VARCHAR2
60 ,P_MANAGER_AGREEMENT_NEEDED in VARCHAR2
61 ,P_PRINT_ARRETTE in VARCHAR2
62 ,P_RESERVE_POSITION in VARCHAR2
63 ,P_ALLOW_PROGRESSIONS in VARCHAR2
64 ,P_EXTEND_PROBATION_PERIOD in VARCHAR2
65 ,P_REMUNERATION_PAID in VARCHAR2
66 ,P_PAY_SHARE in NUMBER
67 ,P_PAY_PERIODS in NUMBER
68 ,P_FREQUENCY in VARCHAR2
69 ,P_FIRST_PERIOD_MAX_DURATION in NUMBER
70 ,P_MIN_DURATION_PER_REQUEST in NUMBER
71 ,P_MAX_DURATION_PER_REQUEST in NUMBER
72 ,P_MAX_DURATION_WHOLE_CAREER in NUMBER
73 ,P_RENEWABLE_ALLOWED in VARCHAR2
74 ,P_MAX_NO_OF_RENEWALS in NUMBER
75 ,P_MAX_DURATION_PER_RENEWAL in NUMBER
76 ,P_MAX_TOT_CONTINUOUS_DURATION in NUMBER
77 ,P_STATUTORY_SITUATION_ID in NUMBER
78 ,P_OBJECT_VERSION_NUMBER in NUMBER
79 ,P_REMUNERATE_ASSIGN_STATUS_ID in NUMBER
80 )is
81 begin
82 hr_utility.set_location('Entering: PQH_FR_STAT_SITUATIONS_BK2.UPDATE_STATUTORY_SITUATION_B', 10);
83 hr_utility.set_location(' Leaving: PQH_FR_STAT_SITUATIONS_BK2.UPDATE_STATUTORY_SITUATION_B', 20);
84 end UPDATE_STATUTORY_SITUATION_B;
85 end PQH_FR_STAT_SITUATIONS_BK2;