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