APPS.PER_VACANCY_BE1 dependencies on FND_NUMBER

Line 101: l_text:=l_text||fnd_number.number_to_canonical(p_requisition_id);

97: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
98: l_text:=l_text||'';
99: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
100: l_text:='';
101: l_text:=l_text||fnd_number.number_to_canonical(p_requisition_id);
102: l_text:=l_text||'';
103: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
104: l_text:='';
105: l_text:=l_text||fnd_date.date_to_canonical(p_date_from);

Line 117: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);

113: l_text:=l_text||irc_utilities_pkg.removeTags(p_security_method);
114: l_text:=l_text||'';
115: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
116: l_text:='';
117: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);
118: l_text:=l_text||'';
119: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
120: l_text:='';
121: l_text:=l_text||fnd_number.number_to_canonical(p_position_id);

Line 121: l_text:=l_text||fnd_number.number_to_canonical(p_position_id);

117: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);
118: l_text:=l_text||'';
119: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
120: l_text:='';
121: l_text:=l_text||fnd_number.number_to_canonical(p_position_id);
122: l_text:=l_text||'';
123: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
124: l_text:='';
125: l_text:=l_text||fnd_number.number_to_canonical(p_job_id);

Line 125: l_text:=l_text||fnd_number.number_to_canonical(p_job_id);

121: l_text:=l_text||fnd_number.number_to_canonical(p_position_id);
122: l_text:=l_text||'';
123: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
124: l_text:='';
125: l_text:=l_text||fnd_number.number_to_canonical(p_job_id);
126: l_text:=l_text||'';
127: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
128: l_text:='';
129: l_text:=l_text||fnd_number.number_to_canonical(p_grade_id);

Line 129: l_text:=l_text||fnd_number.number_to_canonical(p_grade_id);

125: l_text:=l_text||fnd_number.number_to_canonical(p_job_id);
126: l_text:=l_text||'';
127: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
128: l_text:='';
129: l_text:=l_text||fnd_number.number_to_canonical(p_grade_id);
130: l_text:=l_text||'';
131: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
132: l_text:='';
133: l_text:=l_text||fnd_number.number_to_canonical(p_organization_id);

Line 133: l_text:=l_text||fnd_number.number_to_canonical(p_organization_id);

129: l_text:=l_text||fnd_number.number_to_canonical(p_grade_id);
130: l_text:=l_text||'';
131: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
132: l_text:='';
133: l_text:=l_text||fnd_number.number_to_canonical(p_organization_id);
134: l_text:=l_text||'';
135: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
136: l_text:='';
137: l_text:=l_text||fnd_number.number_to_canonical(p_people_group_id);

Line 137: l_text:=l_text||fnd_number.number_to_canonical(p_people_group_id);

133: l_text:=l_text||fnd_number.number_to_canonical(p_organization_id);
134: l_text:=l_text||'';
135: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
136: l_text:='';
137: l_text:=l_text||fnd_number.number_to_canonical(p_people_group_id);
138: l_text:=l_text||'';
139: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
140: l_text:='';
141: l_text:=l_text||fnd_number.number_to_canonical(p_location_id);

Line 141: l_text:=l_text||fnd_number.number_to_canonical(p_location_id);

137: l_text:=l_text||fnd_number.number_to_canonical(p_people_group_id);
138: l_text:=l_text||'';
139: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
140: l_text:='';
141: l_text:=l_text||fnd_number.number_to_canonical(p_location_id);
142: l_text:=l_text||'';
143: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
144: l_text:='';
145: l_text:=l_text||fnd_number.number_to_canonical(p_recruiter_id);

Line 145: l_text:=l_text||fnd_number.number_to_canonical(p_recruiter_id);

141: l_text:=l_text||fnd_number.number_to_canonical(p_location_id);
142: l_text:=l_text||'';
143: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
144: l_text:='';
145: l_text:=l_text||fnd_number.number_to_canonical(p_recruiter_id);
146: l_text:=l_text||'';
147: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
148: l_text:='';
149: l_text:=l_text||fnd_date.date_to_canonical(p_date_to);

Line 157: l_text:=l_text||fnd_number.number_to_canonical(p_number_of_openings);

153: l_text:=l_text||irc_utilities_pkg.removeTags(p_description);
154: l_text:=l_text||'';
155: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
156: l_text:='';
157: l_text:=l_text||fnd_number.number_to_canonical(p_number_of_openings);
158: l_text:=l_text||'';
159: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
160: l_text:='';
161: l_text:=l_text||irc_utilities_pkg.removeTags(p_status);

Line 169: l_text:=l_text||fnd_number.number_to_canonical(p_budget_measurement_value);

165: l_text:=l_text||irc_utilities_pkg.removeTags(p_budget_measurement_type);
166: l_text:=l_text||'';
167: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
168: l_text:='';
169: l_text:=l_text||fnd_number.number_to_canonical(p_budget_measurement_value);
170: l_text:=l_text||'';
171: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
172: l_text:='';
173: l_text:=l_text||irc_utilities_pkg.removeTags(p_vacancy_category);

Line 177: l_text:=l_text||fnd_number.number_to_canonical(p_manager_id);

173: l_text:=l_text||irc_utilities_pkg.removeTags(p_vacancy_category);
174: l_text:=l_text||'';
175: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
176: l_text:='';
177: l_text:=l_text||fnd_number.number_to_canonical(p_manager_id);
178: l_text:=l_text||'';
179: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
180: l_text:='';
181: l_text:=l_text||fnd_number.number_to_canonical(p_primary_posting_id);

Line 181: l_text:=l_text||fnd_number.number_to_canonical(p_primary_posting_id);

177: l_text:=l_text||fnd_number.number_to_canonical(p_manager_id);
178: l_text:=l_text||'';
179: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
180: l_text:='';
181: l_text:=l_text||fnd_number.number_to_canonical(p_primary_posting_id);
182: l_text:=l_text||'';
183: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
184: l_text:='';
185: l_text:=l_text||fnd_number.number_to_canonical(p_assessment_id);

Line 185: l_text:=l_text||fnd_number.number_to_canonical(p_assessment_id);

181: l_text:=l_text||fnd_number.number_to_canonical(p_primary_posting_id);
182: l_text:=l_text||'';
183: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
184: l_text:='';
185: l_text:=l_text||fnd_number.number_to_canonical(p_assessment_id);
186: l_text:=l_text||'';
187: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
188: l_text:='';
189: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute_category);

Line 313: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);

309: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute30);
310: l_text:=l_text||'';
311: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
312: l_text:='';
313: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
314: l_text:=l_text||'';
315: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
316: l_text:='';
317: l_text:=l_text||fnd_number.number_to_canonical(p_vacancy_id);

Line 317: l_text:=l_text||fnd_number.number_to_canonical(p_vacancy_id);

313: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
314: l_text:=l_text||'';
315: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
316: l_text:='';
317: l_text:=l_text||fnd_number.number_to_canonical(p_vacancy_id);
318: l_text:=l_text||'';
319: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
320: l_text:='';
321: if(P_INV_POS_GRADE_WARNING) then