[Home] [Help]
PACKAGE: APPS.HR_PROCESS_CEI_SS
Source
1 package hr_process_cei_ss authid current_user as
2 /* $Header: hrceiwrs.pkh 120.0 2005/05/30 23:10 appldev noship $ */
3
4 -- ----------------------------------------------------------------------------
5 -- |-----------------------------< get_row_status >----------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- This function returns the row status for contact extra information record
11 -- as follows.
12 -- "DB_ROW" : default
13 -- "FUTURE_CHANGE_ROW" : record which changed in future date
14 -- "FUTURE_DELETE_ROW" : record which deleted in future date
15 --
16 -- Pre-Requisities:
17 -- N/A
18 --
19 -- In Parameters:
20 -- p_contact_extra_info_id number
21 -- p_effective_date date
22 --
23 -- Post Success:
24 -- The row status will be returned.
25 --
26 -- Post Failure:
27 -- The row status will no be returned and an error will be raised.
28 --
29 -- Developer Implementation Notes:
30 -- N/A
31 --
32 -- Access Status:
33 -- Public
34 --
35 -- {End Of Comments}
36 -------------------------------------------------------------------------------
37 function get_row_status
38 (
39 p_contact_extra_info_id in number,
40 p_effective_date in date
41 ) return varchar2;
42
43 -- ----------------------------------------------------------------------------
44 -- |--------------------------< set_transaction_step >-------------------------|
45 -- ----------------------------------------------------------------------------
46 -- {Start Of Comments}
47 --
48 -- Description:
49 -- This procedure creates the transaction step for contact extra information.
50 --
51 -- Pre-Requisities:
52 -- N/A
53 --
54 -- In Parameters:
55 -- p_item_type varchar2
56 -- p_item_key varchar2
57 -- p_activity_id number
58 -- p_login_person_id number
59 -- p_action varchar2
60 -- p_effective_date date default null
61 -- p_date_track_option varchar2 default null
62 -- p_contact_extra_info_id number default null
63 -- p_contact_relationship_id number default null
64 -- p_information_type varchar2 default null
65 -- p_object_version_number number default null
66 -- p_information_category varchar2 default null
67 -- p_information1 - 30 varchar2 default null
68 -- p_attribute_category varchar2 default null
69 -- p_attribute1 - 20 varchar2 default null
70 --
71 -- Post Success:
72 -- The transaction step will be created.
73 --
74 -- Post Failure:
75 -- The transaction step will no be created and an error will be raised.
76 --
77 -- Developer Implementation Notes:
78 -- N/A
79 --
80 -- Access Status:
81 -- Public
82 --
83 -- {End Of Comments}
84 -------------------------------------------------------------------------------
85 procedure set_transaction_step
86 (
87 p_item_type in varchar2,
88 p_item_key in varchar2,
89 p_activity_id in number,
90 p_login_person_id in number,
91 p_action in varchar2, -- 'INSERT' or 'UPDATE' or 'DELETE'
92 p_effective_date in date default null,
93 p_date_track_option in varchar2 default null,
94 p_contact_extra_info_id in number default null,
95 p_contact_relationship_id in number default null,
96 p_information_type in varchar2 default null,
97 p_object_version_number in number default null,
98 p_information_category in varchar2 default null,
99 p_information1 in varchar2 default null,
100 p_information2 in varchar2 default null,
101 p_information3 in varchar2 default null,
102 p_information4 in varchar2 default null,
103 p_information5 in varchar2 default null,
104 p_information6 in varchar2 default null,
105 p_information7 in varchar2 default null,
106 p_information8 in varchar2 default null,
107 p_information9 in varchar2 default null,
108 p_information10 in varchar2 default null,
109 p_information11 in varchar2 default null,
110 p_information12 in varchar2 default null,
111 p_information13 in varchar2 default null,
112 p_information14 in varchar2 default null,
113 p_information15 in varchar2 default null,
114 p_information16 in varchar2 default null,
115 p_information17 in varchar2 default null,
116 p_information18 in varchar2 default null,
117 p_information19 in varchar2 default null,
118 p_information20 in varchar2 default null,
119 p_information21 in varchar2 default null,
120 p_information22 in varchar2 default null,
121 p_information23 in varchar2 default null,
122 p_information24 in varchar2 default null,
123 p_information25 in varchar2 default null,
124 p_information26 in varchar2 default null,
125 p_information27 in varchar2 default null,
126 p_information28 in varchar2 default null,
127 p_information29 in varchar2 default null,
128 p_information30 in varchar2 default null,
129 p_attribute_category in varchar2 default null,
130 p_attribute1 in varchar2 default null,
131 p_attribute2 in varchar2 default null,
132 p_attribute3 in varchar2 default null,
133 p_attribute4 in varchar2 default null,
134 p_attribute5 in varchar2 default null,
135 p_attribute6 in varchar2 default null,
136 p_attribute7 in varchar2 default null,
137 p_attribute8 in varchar2 default null,
138 p_attribute9 in varchar2 default null,
139 p_attribute10 in varchar2 default null,
140 p_attribute11 in varchar2 default null,
141 p_attribute12 in varchar2 default null,
142 p_attribute13 in varchar2 default null,
143 p_attribute14 in varchar2 default null,
144 p_attribute15 in varchar2 default null,
145 p_attribute16 in varchar2 default null,
146 p_attribute17 in varchar2 default null,
147 p_attribute18 in varchar2 default null,
148 p_attribute19 in varchar2 default null,
149 p_attribute20 in varchar2 default null
150 );
151
152 -- ----------------------------------------------------------------------------
153 -- |------------------------------< process_api >-----------------------------|
154 -- ----------------------------------------------------------------------------
155 -- {Start Of Comments}
156 --
157 -- Description:
158 -- This procedure execute create, update or delete contact extra information
159 -- APIs depending on the action type.
160 --
161 -- Pre-Requisities:
162 -- Transaction step exists in the database against transaction_step_id
163 -- parameter.
164 --
165 -- In Parameters:
166 -- p_validate boolean default false
167 -- p_transaction_step_id number default null
168 -- p_effective_date varchar2 default null
169 --
170 -- Post Success:
171 -- One of insert, update or delete API will be executed and the record of
172 -- contact extra information will be created, updated or deleted.
173 --
174 -- Post Failure:
175 -- The record of contact extra information will not be created, updated or
176 -- deleted and an error will be raised.
177 --
178 -- Developer Implementation Notes:
179 -- N/A
180 --
181 -- Access Status:
182 -- Public
183 --
184 -- {End Of Comments}
185 -------------------------------------------------------------------------------
186 procedure process_api
187 (
188 p_validate in boolean default false,
189 p_transaction_step_id in number default null,
190 p_effective_date in varchar2 default null
191 );
192
193 end hr_process_cei_ss;