1 Package pay_time_definition_swi As
2 /* $Header: pytdfswi.pkh 120.1 2005/06/14 14:13 tvankayl noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |------------------------< create_time_definition >------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: pay_time_definition_api.create_time_definition
11 --
12 -- Pre-requisites
13 -- All 'IN' parameters to this procedure have been appropriately derived.
14 --
15 -- Post Success:
16 -- p_return_status will return value indicating success.
17 --
18 -- Post Failure:
19 -- p_return_status will return value indication failure.
20 --
21 -- Access Status:
22 -- Internal Development use only.
23 --
24 -- {End of comments}
25 -- ----------------------------------------------------------------------------
26 PROCEDURE create_time_definition
27 (p_validate in number default hr_api.g_false_num
28 ,p_effective_date in date
29 ,p_short_name in varchar2
30 ,p_definition_name in varchar2
31 ,p_period_type in varchar2 default null
32 ,p_period_unit in varchar2 default null
33 ,p_day_adjustment in varchar2 default null
34 ,p_dynamic_code in varchar2 default null
35 ,p_business_group_id in number default null
36 ,p_legislation_code in varchar2 default null
37 ,p_definition_type in varchar2 default null
38 ,p_number_of_years in number default null
39 ,p_start_date in date default null
40 ,p_period_time_definition_id in number default null
41 ,p_creator_id in number default null
42 ,p_creator_type in varchar2 default null
43 ,p_time_definition_id in number
44 ,p_object_version_number out nocopy number
45 ,p_return_status out nocopy varchar2
46 );
47 -- ----------------------------------------------------------------------------
48 -- |------------------------< update_time_definition >------------------------|
49 -- ----------------------------------------------------------------------------
50 -- {Start of comments}
51 --
52 -- Description:
53 -- This procedure is the self-service wrapper procedure to the following
54 -- API: pay_time_definition_api.update_time_definition
55 --
56 -- Pre-requisites
57 -- All 'IN' parameters to this procedure have been appropriately derived.
58 --
59 -- Post Success:
60 -- p_return_status will return value indicating success.
61 --
62 -- Post Failure:
63 -- p_return_status will return value indication failure.
64 --
65 -- Access Status:
66 -- Internal Development use only.
67 --
68 -- {End of comments}
69 -- ----------------------------------------------------------------------------
70 PROCEDURE update_time_definition
71 (p_validate in number default hr_api.g_false_num
72 ,p_effective_date in date
73 ,p_time_definition_id in number
74 ,p_definition_name in varchar2 default hr_api.g_varchar2
75 ,p_period_type in varchar2 default hr_api.g_varchar2
76 ,p_period_unit in varchar2 default hr_api.g_varchar2
77 ,p_day_adjustment in varchar2 default hr_api.g_varchar2
78 ,p_dynamic_code in varchar2 default hr_api.g_varchar2
79 ,p_number_of_years in number default hr_api.g_number
80 ,p_start_date in date default hr_api.g_date
81 ,p_period_time_definition_id in number default hr_api.g_number
82 ,p_creator_id in number default hr_api.g_number
83 ,p_creator_type in varchar2 default hr_api.g_varchar2
84 ,p_object_version_number in out nocopy number
85 ,p_return_status out nocopy varchar2
86 );
87 -- ----------------------------------------------------------------------------
88 -- |------------------------< delete_time_definition >------------------------|
89 -- ----------------------------------------------------------------------------
90 -- {Start of comments}
91 --
92 -- Description:
93 -- This procedure is the self-service wrapper procedure to the following
94 -- API: pay_time_definition_api.delete_time_definition
95 --
96 -- Pre-requisites
97 -- All 'IN' parameters to this procedure have been appropriately derived.
98 --
99 -- Post Success:
100 -- p_return_status will return value indicating success.
101 --
102 -- Post Failure:
103 -- p_return_status will return value indication failure.
104 --
105 -- Access Status:
106 -- Internal Development use only.
107 --
108 -- {End of comments}
109 -- ----------------------------------------------------------------------------
110 PROCEDURE delete_time_definition
111 (p_validate in number default hr_api.g_false_num
112 ,p_effective_date in date
113 ,p_time_definition_id in number
114 ,p_object_version_number in number
115 ,p_return_status out nocopy varchar2
116 );
117 -- ----------------------------------------------------------------------------
118 -- |--------------------------< chk_time_def_usage >--------------------------|
119 -- ----------------------------------------------------------------------------
120 -- {Start of comments}
121 --
122 -- Description:
123 -- This procedure is the self-service wrapper procedure to the following
124 -- API: pay_tdf_bus.chk_time_def_usage
125 --
126 -- Pre-requisites
127 -- All 'IN' parameters to this procedure have been appropriately derived.
128 --
129 -- Post Success:
130 -- Processing continues.
131 --
132 -- Post Failure:
133 -- An error message is raised.
134 --
135 -- Access Status:
136 -- Internal Development use only.
137 --
138 -- {End of comments}
139 -- ----------------------------------------------------------------------------
140 FUNCTION chk_time_def_usage
141 (p_time_definition_id IN number
142 ,p_definition_type IN varchar2
143 ) Return Number;
144
145 end pay_time_definition_swi;