DBA Data[Home] [Help]

PACKAGE: APPS.BEN_POPUP_MESSAGE_API

Source


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;