1 PACKAGE pqp_gb_ss_absence_template AUTHID CURRENT_USER AS
2 -- $Header: pqpgbabd.pkh 120.0 2005/05/29 01:58:16 appldev noship $
3 --
4
5 Procedure Create_omp_template
6 (P_PLAN_ID IN NUMBER
7 ,P_PLAN_DESCRIPTION IN VARCHAR2
8 ,P_ABSE_DAYS_DEF IN VARCHAR2
9 ,P_MATERNITY_ABSE_ENT_UDT IN NUMBER
10 ,P_HOLIDAYS_UDT IN NUMBER
11 ,P_DAILY_RATE_CALC_METHOD IN VARCHAR2
12 ,P_DAILY_RATE_CALC_PERIOD IN VARCHAR2
13 ,P_DAILY_RATE_CALC_DIVISOR IN NUMBER
14 ,P_WORKING_PATTERN IN VARCHAR2
15 ,P_LOS_CALC IN VARCHAR2
16 ,P_LOS_CALC_UOM IN VARCHAR2
17 ,P_LOS_CALC_DURATION IN VARCHAR2
18 ,P_AVG_EARNINGS_DURATION IN VARCHAR2
19 ,P_AVG_EARNINGS_UOM IN VARCHAR2
20 ,P_AVG_EARNINGS_BALANCE IN VARCHAR2
21 ,P_PRI_ELE_NAME IN VARCHAR2
22 ,P_PRI_ELE_REPORTING_NAME IN VARCHAR2
23 ,P_PRI_ELE_DESCRIPTION IN VARCHAR2
24 ,P_PRI_ELE_PROCESSING_PRIORITY IN NUMBER
25 ,P_ABSE_PRIMARY_YN IN VARCHAR2
26 ,P_PAY_ELE_REPORTING_NAME IN VARCHAR2
27 ,P_PAY_ELE_DESCRIPTION IN VARCHAR2
28 ,P_PAY_ELE_PROCESSING_PRIORITY IN NUMBER
29 ,P_PAY_SRC_PAY_COMPONENT IN VARCHAR2
30 ,P_BAND1_ELE_BASE_NAME IN VARCHAR2
31 ,P_BAND2_ELE_BASE_NAME IN VARCHAR2
32 ,P_BAND3_ELE_BASE_NAME IN VARCHAR2
33 ,P_BAND4_ELE_BASE_NAME IN VARCHAR2
34 ,P_EFFECTIVE_START_DATE IN DATE
35 ,P_EFFECTIVE_END_DATE IN DATE
36 ,P_ABSE_TYPE_LOOKUP_TYPE IN VARCHAR2
37 ,P_ABSE_TYPE_LOOKUP_VALUE IN pqp_gb_osp_template.t_abs_types
38 ,P_ELEMENT_TYPE_ID OUT NOCOPY NUMBER
39 ,P_REQUEST_ID OUT NOCOPY NUMBER
40 ,P_SECURITY_GROUP_ID IN NUMBER
41 ,P_BG_ID IN NUMBER
42 );
43
44 Procedure Create_osp_template(
45 P_PLAN_ID IN NUMBER ,
46 P_PLAN_DESCRIPTION IN VARCHAR2 ,
47 P_SCH_CAL_TYPE IN VARCHAR2 ,
48 P_SCH_CAL_DURATION IN NUMBER ,
49 P_SCH_CAL_UOM IN VARCHAR2 ,
50 --P_SCH_CAL_START_DATE IN VARCHAR2 ,
51 P_SCH_CAL_START_DATE IN DATE ,
52 --P_SCH_CAL_END_DATE IN VARCHAR2 ,
53 P_SCH_CAL_END_DATE IN DATE ,
54 P_ABS_DAYS IN VARCHAR2 ,
55 P_ABS_ENT_SICK_LEAVES IN NUMBER ,
56 P_ABS_ENT_HOLIDAYS IN NUMBER ,
57 P_ABS_DAILY_RATE_CALC_METHOD IN VARCHAR2 ,
58 P_ABS_DAILY_RATE_CALC_PERIOD IN VARCHAR2 ,
59 P_ABS_DAILY_RATE_CALC_DIVISOR IN NUMBER ,
60 P_ABS_WORKING_PATTERN IN VARCHAR2 ,
61 P_ABS_OVERLAP_RULE IN VARCHAR2 ,
62 P_ABS_ELE_NAME IN VARCHAR2 ,
63 P_ABS_ELE_REPORTING_NAME IN VARCHAR2 ,
64 P_ABS_ELE_DESCRIPTION IN VARCHAR2 ,
65 P_ABS_ELE_PROCESSING_PRIORITY IN NUMBER ,
66 P_ABS_PRIMARY_YN IN VARCHAR2 ,
67 P_PAY_ELE_REPORTING_NAME IN VARCHAR2 ,
68 P_PAY_ELE_DESCRIPTION IN VARCHAR2 ,
69 P_PAY_ELE_PROCESSING_PRIORITY IN NUMBER ,
70 P_PAY_SRC_PAY_COMPONENT IN VARCHAR2 ,
71 P_BND1_ELE_SUB_NAME IN VARCHAR2 ,
72 P_BND2_ELE_SUB_NAME IN VARCHAR2 ,
73 P_BND3_ELE_SUB_NAME IN VARCHAR2 ,
74 P_BND4_ELE_SUB_NAME IN VARCHAR2 ,
75 --P_ELE_EFF_START_DATE IN VARCHAR2 ,
76 P_ELE_EFF_START_DATE IN DATE ,
77 --P_ELE_EFF_END_DATE IN VARCHAR2 ,
78 P_ELE_EFF_END_DATE IN DATE ,
79 P_ABS_TYPE_LOOKUP_TYPE IN VARCHAR2 default null ,
80 P_ABS_TYPE_LOOKUP_VALUE IN pqp_gb_osp_template.t_abs_types,
81 P_ELEMENT_TYPE_ID OUT NOCOPY NUMBER ,
82 P_REQUEST_ID OUT NOCOPY NUMBER ,
83 P_SECURITY_GROUP_ID IN NUMBER ,
84 P_BG_ID IN NUMBER ,
85 P_PLAN_TYPE_LOOKUP_TYPE IN VARCHAR2 default null, --LG
86 P_PLAN_TYPE_LOOKUP_VALUE IN pqp_gb_osp_template.t_plan_types, --LG
87 P_ENABLE_ENT_PRORATION IN VARCHAR2 DEFAULT NULL, --LG
88 P_SCHEME_TYPE IN VARCHAR2 DEFAULT NULL, -- LG
89 P_ABS_SCHEDULE_WP IN VARCHAR2 DEFAULT NULL, -- LG
90 P_DUAL_ROLLING_DURATION IN NUMBER DEFAULT NULL, -- LG
91 P_DUAL_ROLLING_UOM IN VARCHAR2 DEFAULT NULL , -- LG
92 P_FT_ROUND_CONFIG IN VARCHAR2 DEFAULT NULL ,
93 P_PT_ROUND_CONFIG IN VARCHAR2 DEFAULT NULL
94 );
95
96
97 Procedure Create_unp_template
98 (P_PLAN_ID IN NUMBER
99 ,P_PLAN_DESCRIPTION IN VARCHAR2
100 ,P_ABS_DAYS IN VARCHAR2
101 ,P_ABS_ENT_SICK_LEAVES IN NUMBER
102 ,P_ABS_ENT_HOLIDAYS IN NUMBER
103 ,P_ABS_DAILY_RATE_CALC_METHOD IN VARCHAR2
104 ,P_ABS_DAILY_RATE_CALC_PERIOD IN VARCHAR2
105 ,P_ABS_DAILY_RATE_CALC_DIVISOR IN NUMBER
106 ,P_ABS_WORKING_PATTERN IN VARCHAR2
107 ,P_ABS_ELE_NAME IN VARCHAR2
108 ,P_ABS_ELE_REPORTING_NAME IN VARCHAR2
109 ,P_ABS_ELE_DESCRIPTION IN VARCHAR2
110 ,P_ABS_ELE_PROCESSING_PRIORITY IN NUMBER
111 ,P_ABS_PRIMARY_YN IN VARCHAR2
112 ,P_PAY_ELE_REPORTING_NAME IN VARCHAR2
113 ,P_PAY_ELE_DESCRIPTION IN VARCHAR2
114 ,P_PAY_ELE_PROCESSING_PRIORITY IN NUMBER
115 ,P_PAY_SRC_PAY_COMPONENT IN VARCHAR2
116 ,P_ELE_EFF_START_DATE IN DATE
117 ,P_ELE_EFF_END_DATE IN DATE
118 ,P_ABS_TYPE_LOOKUP_TYPE IN VARCHAR2
119 ,P_ABS_TYPE_LOOKUP_VALUE IN pqp_gb_osp_template.t_abs_types
120 ,P_ELEMENT_TYPE_ID OUT NOCOPY NUMBER
121 ,P_REQUEST_ID OUT NOCOPY NUMBER
122 ,P_SECURITY_GROUP_ID IN NUMBER
123 ,P_BG_ID IN NUMBER
124 ,P_ABS_SCHEDULE_WP IN VARCHAR2 DEFAULT NULL -- LG
125 ) ;
126
127
128
129 end;