1 Package pqh_WORKSHEET_PERIODS_api AUTHID CURRENT_USER as
2 /* $Header: pqwprapi.pkh 120.0 2005/05/29 03:02:15 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_WORKSHEET_PERIOD >------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 --
11 -- Prerequisites:
12 --
13 --
14 -- In Parameters:
15 -- Name Reqd Type Description
16 -- p_validate Yes boolean Commit or Rollback.
17 -- p_end_time_period_id Yes number
18 -- p_worksheet_detail_id Yes number
19 -- p_budget_unit1_percent No number
20 -- p_budget_unit2_percent No number
21 -- p_budget_unit3_percent No number
22 -- p_budget_unit1_value No number
23 -- p_budget_unit2_value No number
24 -- p_budget_unit3_value No number
25 -- p_budget_unit1_value_type_cd No varchar2
26 -- p_budget_unit2_value_type_cd No varchar2
27 -- p_budget_unit3_value_type_cd No varchar2
28 -- p_start_time_period_id Yes number
29 -- p_budget_unit3_available No number
30 -- p_budget_unit2_available No number
31 -- p_budget_unit1_available No number
32 -- p_effective_date Yes date Session Date.
33 --
34 -- Post Success:
35 --
36 -- Out Parameters:
37 -- Name Type Description
38 -- p_worksheet_period_id Yes number PK of record
39 -- p_object_version_number Yes number OVN of record
40 --
41 -- Post Failure:
42 --
43 -- Access Status:
44 -- Public.
45 --
46 -- {End Of Comments}
47 --
48 procedure create_WORKSHEET_PERIOD
49 (
50 p_validate in boolean default false
51 ,p_worksheet_period_id out nocopy number
52 ,p_end_time_period_id in number
53 ,p_worksheet_detail_id in number
54 ,p_budget_unit1_percent in number default null
55 ,p_budget_unit2_percent in number default null
56 ,p_budget_unit3_percent in number default null
57 ,p_budget_unit1_value in number default null
58 ,p_budget_unit2_value in number default null
59 ,p_budget_unit3_value in number default null
60 ,p_object_version_number out nocopy number
61 ,p_budget_unit1_value_type_cd in varchar2 default null
62 ,p_budget_unit2_value_type_cd in varchar2 default null
63 ,p_budget_unit3_value_type_cd in varchar2 default null
64 ,p_start_time_period_id in number
65 ,p_budget_unit3_available in number default null
66 ,p_budget_unit2_available in number default null
67 ,p_budget_unit1_available in number default null
68 ,p_effective_date in date
69 );
70 -- ----------------------------------------------------------------------------
71 -- |------------------------< update_WORKSHEET_PERIOD >------------------------|
72 -- ----------------------------------------------------------------------------
73 -- {Start Of Comments}
74 --
75 -- Description:
76 --
77 -- Prerequisites:
78 --
79 --
80 -- In Parameters:
81 -- Name Reqd Type Description
82 -- p_validate Yes boolean Commit or Rollback.
83 -- p_worksheet_period_id Yes number PK of record
84 -- p_end_time_period_id Yes number
85 -- p_worksheet_detail_id Yes number
86 -- p_budget_unit1_percent No number
87 -- p_budget_unit2_percent No number
88 -- p_budget_unit3_percent No number
89 -- p_budget_unit1_value No number
90 -- p_budget_unit2_value No number
91 -- p_budget_unit3_value No number
92 -- p_budget_unit1_value_type_cd No varchar2
93 -- p_budget_unit2_value_type_cd No varchar2
94 -- p_budget_unit3_value_type_cd No varchar2
95 -- p_start_time_period_id Yes number
96 -- p_budget_unit3_available No number
97 -- p_budget_unit2_available No number
98 -- p_budget_unit1_available No number
99 -- p_effective_date Yes date Session Date.
100 --
101 -- Post Success:
102 --
103 -- Name Type Description
104 -- p_object_version_number Yes number OVN of record
105 --
106 -- Post Failure:
107 --
108 -- Access Status:
109 -- Public.
110 --
111 -- {End Of Comments}
112 --
113 procedure update_WORKSHEET_PERIOD
114 (
115 p_validate in boolean default false
116 ,p_worksheet_period_id in number
117 ,p_end_time_period_id in number default hr_api.g_number
118 ,p_worksheet_detail_id in number default hr_api.g_number
119 ,p_budget_unit1_percent in number default hr_api.g_number
120 ,p_budget_unit2_percent in number default hr_api.g_number
121 ,p_budget_unit3_percent in number default hr_api.g_number
122 ,p_budget_unit1_value in number default hr_api.g_number
123 ,p_budget_unit2_value in number default hr_api.g_number
124 ,p_budget_unit3_value in number default hr_api.g_number
125 ,p_object_version_number in out nocopy number
126 ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
127 ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
128 ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
129 ,p_start_time_period_id in number default hr_api.g_number
130 ,p_budget_unit3_available in number default hr_api.g_number
131 ,p_budget_unit2_available in number default hr_api.g_number
132 ,p_budget_unit1_available in number default hr_api.g_number
133 ,p_effective_date in date
134 );
135 --
136 -- ----------------------------------------------------------------------------
137 -- |------------------------< delete_WORKSHEET_PERIOD >------------------------|
138 -- ----------------------------------------------------------------------------
139 -- {Start Of Comments}
140 --
141 -- Description:
142 --
143 -- Prerequisites:
144 --
145 --
146 -- In Parameters:
147 -- Name Reqd Type Description
148 -- p_validate Yes boolean Commit or Rollback.
149 -- p_worksheet_period_id Yes number PK of record
150 -- p_effective_date Yes date Session Date.
151 --
152 -- Post Success:
153 --
154 -- Name Type Description
155 -- p_object_version_number Yes number OVN of record
156 --
157 -- Post Failure:
158 --
159 -- Access Status:
160 -- Public.
161 --
162 -- {End Of Comments}
163 --
164 procedure delete_WORKSHEET_PERIOD
165 (
166 p_validate in boolean default false
167 ,p_worksheet_period_id in number
168 ,p_object_version_number in number
169 ,p_effective_date in date
170 );
171 --
172 --
173 end pqh_WORKSHEET_PERIODS_api;