DBA Data[Home] [Help]

PACKAGE: APPS.PQP_GB_SS_ABSENCE_TEMPLATE

Source


1 PACKAGE pqp_gb_ss_absence_template 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;