DBA Data[Home] [Help]

APPS.HR_PREVIOUS_EMPLOYMENT_BE7 dependencies on FND_NUMBER

Line 91: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);

87: l_text:='';
88: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
89: --
90: l_text:='';
91: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
92: l_text:=l_text||'
';
93: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
94: l_text:='';
95: l_text:=l_text||fnd_number.number_to_canonical(p_previous_employer_id);

Line 95: l_text:=l_text||fnd_number.number_to_canonical(p_previous_employer_id);

91: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
92: l_text:=l_text||'';
93: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
94: l_text:='';
95: l_text:=l_text||fnd_number.number_to_canonical(p_previous_employer_id);
96: l_text:=l_text||'
';
97: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
98: l_text:='';
99: l_text:=l_text||fnd_number.number_to_canonical(p_previous_job_id);

Line 99: l_text:=l_text||fnd_number.number_to_canonical(p_previous_job_id);

95: l_text:=l_text||fnd_number.number_to_canonical(p_previous_employer_id);
96: l_text:=l_text||'';
97: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
98: l_text:='';
99: l_text:=l_text||fnd_number.number_to_canonical(p_previous_job_id);
100: l_text:=l_text||'
';
101: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
102: l_text:='';
103: l_text:=l_text||fnd_date.date_to_canonical(p_start_date);

Line 111: l_text:=l_text||fnd_number.number_to_canonical(p_period_years);

107: l_text:=l_text||fnd_date.date_to_canonical(p_end_date);
108: l_text:=l_text||'';
109: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
110: l_text:='';
111: l_text:=l_text||fnd_number.number_to_canonical(p_period_years);
112: l_text:=l_text||'
';
113: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
114: l_text:='';
115: l_text:=l_text||fnd_number.number_to_canonical(p_period_months);

Line 115: l_text:=l_text||fnd_number.number_to_canonical(p_period_months);

111: l_text:=l_text||fnd_number.number_to_canonical(p_period_years);
112: l_text:=l_text||'';
113: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
114: l_text:='';
115: l_text:=l_text||fnd_number.number_to_canonical(p_period_months);
116: l_text:=l_text||'
';
117: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
118: l_text:='';
119: l_text:=l_text||fnd_number.number_to_canonical(p_period_days);

Line 119: l_text:=l_text||fnd_number.number_to_canonical(p_period_days);

115: l_text:=l_text||fnd_number.number_to_canonical(p_period_months);
116: l_text:=l_text||'';
117: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
118: l_text:='';
119: l_text:=l_text||fnd_number.number_to_canonical(p_period_days);
120: l_text:=l_text||'
';
121: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
122: l_text:='';
123: l_text:=l_text||irc_utilities_pkg.removeTags(p_pju_attribute_category);

Line 291: l_text:=l_text||fnd_number.number_to_canonical(p_previous_job_usage_id);

287: l_text:=l_text||irc_utilities_pkg.removeTags(p_pju_information20);
288: l_text:=l_text||'';
289: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
290: l_text:='';
291: l_text:=l_text||fnd_number.number_to_canonical(p_previous_job_usage_id);
292: l_text:=l_text||'
';
293: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
294: l_text:='';
295: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);

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

291: l_text:=l_text||fnd_number.number_to_canonical(p_previous_job_usage_id);
292: l_text:=l_text||'';
293: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
294: l_text:='';
295: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
296: l_text:=l_text||'
';
297: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
298: l_text:='';
299: --