DBA Data[Home] [Help]

APPS.PER_VACANCY_BE2 dependencies on FND_NUMBER

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

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);

Line 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);

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

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);

Line 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);

Line 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);

Line 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);

Line 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);

Line 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);

Line 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);

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

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);

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

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);

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

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);

Line 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);

Line 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);