DBA Data[Home] [Help]

APPS.HR_SIT_BE1 dependencies on FND_NUMBER

Line 105: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);

101: l_text:='';
102: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
103: --
104: l_text:='';
105: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
106: l_text:=l_text||'
';
107: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
108: l_text:='';
109: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);

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

105: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
106: l_text:=l_text||'';
107: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
108: l_text:='';
109: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);
110: l_text:=l_text||'
';
111: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
112: l_text:='';
113: l_text:=l_text||fnd_number.number_to_canonical(p_id_flex_num);

Line 113: l_text:=l_text||fnd_number.number_to_canonical(p_id_flex_num);

109: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);
110: l_text:=l_text||'';
111: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
112: l_text:='';
113: l_text:=l_text||fnd_number.number_to_canonical(p_id_flex_num);
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_date.date_to_canonical(p_effective_date);

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

129: l_text:=l_text||fnd_date.date_to_canonical(p_date_to);
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_request_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_program_application_id);

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

133: l_text:=l_text||fnd_number.number_to_canonical(p_request_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_program_application_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_program_id);

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

137: l_text:=l_text||fnd_number.number_to_canonical(p_program_application_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_program_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_date.date_to_canonical(p_program_update_date);

Line 357: l_text:=l_text||fnd_number.number_to_canonical(p_analysis_criteria_id);

353: l_text:=l_text||irc_utilities_pkg.removeTags(p_concat_segments);
354: l_text:=l_text||'';
355: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
356: l_text:='';
357: l_text:=l_text||fnd_number.number_to_canonical(p_analysis_criteria_id);
358: l_text:=l_text||'
';
359: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
360: l_text:='';
361: l_text:=l_text||fnd_number.number_to_canonical(p_person_analysis_id);

Line 361: l_text:=l_text||fnd_number.number_to_canonical(p_person_analysis_id);

357: l_text:=l_text||fnd_number.number_to_canonical(p_analysis_criteria_id);
358: l_text:=l_text||'';
359: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
360: l_text:='';
361: l_text:=l_text||fnd_number.number_to_canonical(p_person_analysis_id);
362: l_text:=l_text||'
';
363: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
364: l_text:='';
365: l_text:=l_text||fnd_number.number_to_canonical(p_pea_object_version_number);

Line 365: l_text:=l_text||fnd_number.number_to_canonical(p_pea_object_version_number);

361: l_text:=l_text||fnd_number.number_to_canonical(p_person_analysis_id);
362: l_text:=l_text||'';
363: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
364: l_text:='';
365: l_text:=l_text||fnd_number.number_to_canonical(p_pea_object_version_number);
366: l_text:=l_text||'
';
367: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
368: l_text:='';
369: --