1 Package ben_online_activity_api AUTHID CURRENT_USER as
2 /* $Header: beolaapi.pkh 120.0 2005/05/28 09:50:53 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_online_activity >------------------------|
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_ordr_num No number
18 -- p_function_name No varchar2
19 -- p_user_function_name No varchar2
20 -- p_function_type No varchar2
21 -- p_business_group_id No number Business Group of Record
22 -- p_start_date No date
23 -- p_end_date No date
24 --
25 -- Post Success:
26 --
27 -- Out Parameters:
28 -- Name Type Description
29 -- p_csr_activities_id Yes number PK of record
30 -- p_object_version_number No number OVN of record
31 --
32 -- Post Failure:
33 --
34 -- Access Status:
35 -- Public.
36 --
37 -- {End Of Comments}
38 --
39 procedure create_online_activity
40 (
41 p_validate in boolean default false
42 ,p_csr_activities_id out nocopy number
43 ,p_ordr_num in number default null
44 ,p_function_name in varchar2 default null
45 ,p_user_function_name in varchar2 default null
46 ,p_function_type in varchar2 default null
47 ,p_business_group_id in number default null
48 ,p_object_version_number out nocopy number
49 ,p_start_date in date default null
50 ,p_end_date in date default null
51 );
52 -- ----------------------------------------------------------------------------
53 -- |------------------------< update_online_activity >------------------------|
54 -- ----------------------------------------------------------------------------
55 -- {Start Of Comments}
56 --
57 -- Description:
58 --
59 -- Prerequisites:
60 --
61 --
62 -- In Parameters:
63 -- Name Reqd Type Description
64 -- p_validate Yes boolean Commit or Rollback.
65 -- p_csr_activities_id Yes number PK of record
66 -- p_ordr_num No number
67 -- p_function_name No varchar2
68 -- p_user_function_name No varchar2
69 -- p_function_type No varchar2
70 -- p_business_group_id No number Business Group of Record
71 -- p_start_date No date
72 -- p_end_date No date
73 --
74 -- Post Success:
75 --
76 -- Name Type Description
77 -- p_object_version_number No number OVN of record
78 --
79 -- Post Failure:
80 --
81 -- Access Status:
82 -- Public.
83 --
84 -- {End Of Comments}
85 --
86 procedure update_online_activity
87 (
88 p_validate in boolean default false
89 ,p_csr_activities_id in number
90 ,p_ordr_num in number default hr_api.g_number
91 ,p_function_name in varchar2 default hr_api.g_varchar2
92 ,p_user_function_name in varchar2 default hr_api.g_varchar2
93 ,p_function_type in varchar2 default hr_api.g_varchar2
94 ,p_business_group_id in number default hr_api.g_number
95 ,p_object_version_number in out nocopy number
96 ,p_start_date in date default hr_api.g_date
97 ,p_end_date in date default hr_api.g_date
98 );
99 --
100 -- ----------------------------------------------------------------------------
101 -- |------------------------< delete_online_activity >------------------------|
102 -- ----------------------------------------------------------------------------
103 -- {Start Of Comments}
104 --
105 -- Description:
106 --
107 -- Prerequisites:
108 --
109 --
110 -- In Parameters:
111 -- Name Reqd Type Description
112 -- p_validate Yes boolean Commit or Rollback.
113 -- p_csr_activities_id Yes number PK of record
114 --
115 -- Post Success:
116 --
117 -- Name Type Description
118 -- p_object_version_number No number OVN of record
119 --
120 -- Post Failure:
121 --
122 -- Access Status:
123 -- Public.
124 --
125 -- {End Of Comments}
126 --
127 procedure delete_online_activity
128 (
129 p_validate in boolean default false
130 ,p_csr_activities_id in number
131 ,p_object_version_number in out nocopy number
132 );
133 --
134 -- ----------------------------------------------------------------------------
135 -- |----------------------------------< lck >---------------------------------|
136 -- ----------------------------------------------------------------------------
137 -- {Start Of Comments}
138 --
139 -- Description:
140 --
141 -- Prerequisites:
142 --
143 --
144 -- In Parameters:
145 -- Name Reqd Type Description
146 -- p_csr_activities_id Yes number PK of record
147 -- p_object_version_number Yes number OVN of record
148 --
149 -- Post Success:
150 --
151 -- Name Type Description
152 --
153 -- Post Failure:
154 --
155 -- Access Status:
156 -- Public.
157 --
158 -- {End Of Comments}
159 --
160 procedure lck
161 (
162 p_csr_activities_id in number
163 ,p_object_version_number in number
164 );
165 --
166 end ben_online_activity_api;
[Home] [Help]