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