1 Package ben_popup_message_api as
2 /* $Header: bepumapi.pkh 120.0 2005/05/28 11:26:29 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_popup_message >------------------------|
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_pop_name No varchar2
18 -- p_formula_id No number
19 -- p_function_name No varchar2
20 -- p_block_name No varchar2
21 -- p_field_name No varchar2
22 -- p_event_name No varchar2
23 -- p_message No varchar2
24 -- p_message_type No varchar2
25 -- p_business_group_id No number Business Group of Record
26 -- p_start_date No date
27 -- p_end_date No date
28 -- p_no_formula_flag No varchar2
29 -- p_effective_date Yes date Session Date.
30 --
31 -- Post Success:
32 --
33 -- Out Parameters:
34 -- Name Type Description
35 -- p_pop_up_messages_id Yes number PK of record
36 -- p_object_version_number No number OVN of record
37 --
38 -- Post Failure:
39 --
40 -- Access Status:
41 -- Public.
42 --
43 -- {End Of Comments}
44 --
45 procedure create_popup_message
46 (
47 p_validate in boolean default false
48 ,p_pop_up_messages_id out nocopy number
49 ,p_pop_name in varchar2 default null
50 ,p_formula_id in number default null
51 ,p_function_name in varchar2 default null
52 ,p_block_name in varchar2 default null
53 ,p_field_name in varchar2 default null
54 ,p_event_name in varchar2 default null
55 ,p_message in varchar2 default null
56 ,p_message_type in varchar2 default null
57 ,p_business_group_id in number default null
58 ,p_object_version_number out nocopy number
59 ,p_start_date in date default null
60 ,p_end_date in date default null
61 ,p_no_formula_flag in varchar2 default null
62 ,p_effective_date in date
63 );
64 -- ----------------------------------------------------------------------------
65 -- |------------------------< update_popup_message >------------------------|
66 -- ----------------------------------------------------------------------------
67 -- {Start Of Comments}
68 --
69 -- Description:
70 --
71 -- Prerequisites:
72 --
73 --
74 -- In Parameters:
75 -- Name Reqd Type Description
76 -- p_validate Yes boolean Commit or Rollback.
77 -- p_pop_up_messages_id Yes number PK of record
78 -- p_pop_name No varchar2
79 -- p_formula_id No number
80 -- p_function_name No varchar2
81 -- p_block_name No varchar2
82 -- p_field_name No varchar2
83 -- p_event_name No varchar2
84 -- p_message No varchar2
85 -- p_message_type No varchar2
86 -- p_business_group_id No number Business Group of Record
87 -- p_start_date No date
88 -- p_end_date No date
89 -- p_no_formula_flag No varchar2
90 -- p_effective_date Yes date Session Date.
91 --
92 -- Post Success:
93 --
94 -- Name Type Description
95 -- p_object_version_number No number OVN of record
96 --
97 -- Post Failure:
98 --
99 -- Access Status:
100 -- Public.
101 --
102 -- {End Of Comments}
103 --
104 procedure update_popup_message
105 (
106 p_validate in boolean default false
107 ,p_pop_up_messages_id in number
108 ,p_pop_name in varchar2 default hr_api.g_varchar2
109 ,p_formula_id in number default hr_api.g_number
110 ,p_function_name in varchar2 default hr_api.g_varchar2
111 ,p_block_name in varchar2 default hr_api.g_varchar2
112 ,p_field_name in varchar2 default hr_api.g_varchar2
113 ,p_event_name in varchar2 default hr_api.g_varchar2
114 ,p_message in varchar2 default hr_api.g_varchar2
115 ,p_message_type in varchar2 default hr_api.g_varchar2
116 ,p_business_group_id in number default hr_api.g_number
117 ,p_object_version_number in out nocopy number
118 ,p_start_date in date default hr_api.g_date
119 ,p_end_date in date default hr_api.g_date
120 ,p_no_formula_flag in varchar2 default hr_api.g_varchar2
121 ,p_effective_date in date
122 );
123 --
124 -- ----------------------------------------------------------------------------
125 -- |------------------------< delete_popup_message >------------------------|
126 -- ----------------------------------------------------------------------------
127 -- {Start Of Comments}
128 --
129 -- Description:
130 --
131 -- Prerequisites:
132 --
133 --
134 -- In Parameters:
135 -- Name Reqd Type Description
136 -- p_validate Yes boolean Commit or Rollback.
137 -- p_pop_up_messages_id Yes number PK of record
138 -- p_effective_date Yes date Session Date.
139 --
140 -- Post Success:
141 --
142 -- Name Type Description
143 -- p_object_version_number No number OVN of record
144 --
145 -- Post Failure:
146 --
147 -- Access Status:
148 -- Public.
149 --
150 -- {End Of Comments}
151 --
152 procedure delete_popup_message
153 (
154 p_validate in boolean default false
155 ,p_pop_up_messages_id in number
156 ,p_object_version_number in out nocopy number
157 ,p_effective_date in date
158 );
159 --
160 -- ----------------------------------------------------------------------------
161 -- |----------------------------------< lck >---------------------------------|
162 -- ----------------------------------------------------------------------------
163 -- {Start Of Comments}
164 --
165 -- Description:
166 --
167 -- Prerequisites:
168 --
169 --
170 -- In Parameters:
171 -- Name Reqd Type Description
172 -- p_pop_up_messages_id Yes number PK of record
173 -- p_object_version_number Yes number OVN of record
174 --
175 -- Post Success:
176 --
177 -- Name Type Description
178 --
179 -- Post Failure:
180 --
181 -- Access Status:
182 -- Public.
183 --
184 -- {End Of Comments}
185 --
186 procedure lck
187 (
188 p_pop_up_messages_id in number
189 ,p_object_version_number in number
190 );
191 --
192 end ben_popup_message_api;