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