96: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
97: l_text:=l_text||'';
98: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
99: l_text:='
100: l_text:=l_text||fnd_number.number_to_canonical(p_vacancy_id);
101: l_text:=l_text||'
102: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
103: l_text:='
104: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
100: l_text:=l_text||fnd_number.number_to_canonical(p_vacancy_id);
101: l_text:=l_text||'';
102: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
103: l_text:='
104: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
105: l_text:=l_text||'
106: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
107: l_text:='
108: l_text:=l_text||fnd_date.date_to_canonical(p_date_from);
108: l_text:=l_text||fnd_date.date_to_canonical(p_date_from);
109: l_text:=l_text||'';
110: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
111: l_text:='
112: l_text:=l_text||fnd_number.number_to_canonical(p_position_id);
113: l_text:=l_text||'
114: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
115: l_text:='
116: l_text:=l_text||fnd_number.number_to_canonical(p_job_id);
112: l_text:=l_text||fnd_number.number_to_canonical(p_position_id);
113: l_text:=l_text||'';
114: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
115: l_text:='
116: l_text:=l_text||fnd_number.number_to_canonical(p_job_id);
117: l_text:=l_text||'
118: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
119: l_text:='
120: l_text:=l_text||fnd_number.number_to_canonical(p_grade_id);
116: l_text:=l_text||fnd_number.number_to_canonical(p_job_id);
117: l_text:=l_text||'';
118: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
119: l_text:='
120: l_text:=l_text||fnd_number.number_to_canonical(p_grade_id);
121: l_text:=l_text||'
122: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
123: l_text:='
124: l_text:=l_text||fnd_number.number_to_canonical(p_organization_id);
120: l_text:=l_text||fnd_number.number_to_canonical(p_grade_id);
121: l_text:=l_text||'';
122: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
123: l_text:='
124: l_text:=l_text||fnd_number.number_to_canonical(p_organization_id);
125: l_text:=l_text||'
126: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
127: l_text:='
128: l_text:=l_text||fnd_number.number_to_canonical(p_people_group_id);
124: l_text:=l_text||fnd_number.number_to_canonical(p_organization_id);
125: l_text:=l_text||'';
126: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
127: l_text:='
128: l_text:=l_text||fnd_number.number_to_canonical(p_people_group_id);
129: l_text:=l_text||'
130: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
131: l_text:='
132: l_text:=l_text||fnd_number.number_to_canonical(p_location_id);
128: l_text:=l_text||fnd_number.number_to_canonical(p_people_group_id);
129: l_text:=l_text||'';
130: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
131: l_text:='
132: l_text:=l_text||fnd_number.number_to_canonical(p_location_id);
133: l_text:=l_text||'
134: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
135: l_text:='
136: l_text:=l_text||fnd_number.number_to_canonical(p_recruiter_id);
132: l_text:=l_text||fnd_number.number_to_canonical(p_location_id);
133: l_text:=l_text||'';
134: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
135: l_text:='
136: l_text:=l_text||fnd_number.number_to_canonical(p_recruiter_id);
137: l_text:=l_text||'
138: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
139: l_text:='
140: l_text:=l_text||fnd_date.date_to_canonical(p_date_to);
148: l_text:=l_text||irc_utilities_pkg.removeTags(p_description);
149: l_text:=l_text||'';
150: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
151: l_text:='
152: l_text:=l_text||fnd_number.number_to_canonical(p_number_of_openings);
153: l_text:=l_text||'
154: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
155: l_text:='
156: l_text:=l_text||irc_utilities_pkg.removeTags(p_status);
160: l_text:=l_text||irc_utilities_pkg.removeTags(p_budget_measurement_type);
161: l_text:=l_text||'';
162: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
163: l_text:='
164: l_text:=l_text||fnd_number.number_to_canonical(p_budget_measurement_value);
165: l_text:=l_text||'
166: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
167: l_text:='
168: l_text:=l_text||irc_utilities_pkg.removeTags(p_vacancy_category);
168: l_text:=l_text||irc_utilities_pkg.removeTags(p_vacancy_category);
169: l_text:=l_text||'';
170: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
171: l_text:='
172: l_text:=l_text||fnd_number.number_to_canonical(p_manager_id);
173: l_text:=l_text||'
174: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
175: l_text:='
176: l_text:=l_text||fnd_number.number_to_canonical(p_primary_posting_id);
172: l_text:=l_text||fnd_number.number_to_canonical(p_manager_id);
173: l_text:=l_text||'';
174: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
175: l_text:='
176: l_text:=l_text||fnd_number.number_to_canonical(p_primary_posting_id);
177: l_text:=l_text||'
178: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
179: l_text:='
180: l_text:=l_text||fnd_number.number_to_canonical(p_assessment_id);
176: l_text:=l_text||fnd_number.number_to_canonical(p_primary_posting_id);
177: l_text:=l_text||'';
178: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
179: l_text:='
180: l_text:=l_text||fnd_number.number_to_canonical(p_assessment_id);
181: l_text:=l_text||'
182: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
183: l_text:='
184: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute_category);