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