1 Package ben_reporting_api AUTHID CURRENT_USER as
2 /* $Header: bebmnapi.pkh 115.5 2002/12/11 10:34:04 lakrish ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_reporting >------------------------------|
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_benefit_action_id Yes number
18 -- p_thread_id Yes number
19 -- p_sequence Yes number
20 -- p_text No varchar2
21 --
22 -- Post Success:
23 --
24 -- Out Parameters:
25 -- Name Type Description
26 -- p_reporting_id Yes number PK of record
27 -- p_object_version_number No number OVN of record
28 --
29 -- Post Failure:
30 --
31 -- Access Status:
32 -- Public.
33 --
34 -- {End Of Comments}
35 --
36 procedure create_reporting
37 (p_validate in boolean default false
38 ,p_reporting_id out nocopy number
39 ,p_benefit_action_id in number default null
40 ,p_thread_id in number default null
41 ,p_sequence in number default null
42 ,p_text in varchar2 default null
43 ,p_rep_typ_cd in varchar2 default null
44 ,p_error_message_code in varchar2 default null
45 ,p_national_identifier in varchar2 default null
46 ,p_related_person_ler_id in number default null
47 ,p_temporal_ler_id in number default null
48 ,p_ler_id in number default null
49 ,p_person_id in number default null
50 ,p_pgm_id in number default null
51 ,p_pl_id in number default null
52 ,p_related_person_id in number default null
53 ,p_oipl_id in number default null
54 ,p_pl_typ_id in number default null
55 ,p_actl_prem_id in number default null
56 ,p_val in number default null
57 ,p_mo_num in number default null
58 ,p_yr_num in number default null
59 ,p_object_version_number out nocopy number);
60 -- ----------------------------------------------------------------------------
61 -- |------------------------< update_reporting >------------------------------|
62 -- ----------------------------------------------------------------------------
63 -- {Start Of Comments}
64 --
65 -- Description:
66 --
67 -- Prerequisites:
68 --
69 --
70 -- In Parameters:
71 -- Name Reqd Type Description
72 -- p_validate Yes boolean Commit or Rollback.
73 -- p_reporting_id Yes number PK of record
74 -- p_benefit_action_id Yes number
75 -- p_thread_id Yes number
76 -- p_sequence Yes number
77 -- p_text No varchar2
78 --
79 -- Post Success:
80 --
81 -- Name Type Description
82 -- p_object_version_number No number OVN of record
83 --
84 -- Post Failure:
85 --
86 -- Access Status:
87 -- Public.
88 --
89 -- {End Of Comments}
90 --
91 procedure update_reporting
92 (p_validate in boolean default false
93 ,p_reporting_id in number
94 ,p_benefit_action_id in number default hr_api.g_number
95 ,p_thread_id in number default hr_api.g_number
96 ,p_sequence in number default hr_api.g_number
97 ,p_text in varchar2 default hr_api.g_varchar2
98 ,p_rep_typ_cd in varchar2 default hr_api.g_varchar2
99 ,p_error_message_code in varchar2 default hr_api.g_varchar2
100 ,p_national_identifier in varchar2 default hr_api.g_varchar2
101 ,p_related_person_ler_id in number default hr_api.g_number
102 ,p_temporal_ler_id in number default hr_api.g_number
106 ,p_pl_id in number default hr_api.g_number
103 ,p_ler_id in number default hr_api.g_number
104 ,p_person_id in number default hr_api.g_number
105 ,p_pgm_id in number default hr_api.g_number
107 ,p_related_person_id in number default hr_api.g_number
108 ,p_oipl_id in number default hr_api.g_number
109 ,p_pl_typ_id in number default hr_api.g_number
110 ,p_actl_prem_id in number default hr_api.g_number
111 ,p_val in number default hr_api.g_number
112 ,p_mo_num in number default hr_api.g_number
113 ,p_yr_num in number default hr_api.g_number
114 ,p_object_version_number in out nocopy number);
115 --
116 -- ----------------------------------------------------------------------------
117 -- |------------------------< delete_reporting >------------------------------|
118 -- ----------------------------------------------------------------------------
119 -- {Start Of Comments}
120 --
121 -- Description:
122 --
123 -- Prerequisites:
124 --
125 --
126 -- In Parameters:
127 -- Name Reqd Type Description
128 -- p_validate Yes boolean Commit or Rollback.
129 -- p_reporting_id Yes number PK of record
130 --
131 -- Post Success:
132 --
133 -- Name Type Description
134 -- p_object_version_number No number OVN of record
135 --
136 -- Post Failure:
137 --
138 -- Access Status:
139 -- Public.
140 --
141 -- {End Of Comments}
142 --
143 procedure delete_reporting
144 (p_validate in boolean default false
145 ,p_reporting_id in number
146 ,p_object_version_number in out nocopy number);
147 --
148 -- ----------------------------------------------------------------------------
149 -- |----------------------------------< lck >---------------------------------|
150 -- ----------------------------------------------------------------------------
151 -- {Start Of Comments}
152 --
153 -- Description:
154 --
155 -- Prerequisites:
156 --
157 --
158 -- In Parameters:
159 -- Name Reqd Type Description
160 -- p_reporting_id Yes number PK of record
161 -- p_object_version_number Yes number OVN of record
162 --
163 -- Post Success:
164 --
165 -- Name Type Description
166 --
167 -- Post Failure:
168 --
169 -- Access Status:
170 -- Public.
171 --
172 -- {End Of Comments}
173 --
174 procedure lck
175 (p_reporting_id in number
176 ,p_object_version_number in number);
177 --
178 end ben_reporting_api;