DBA Data[Home] [Help]

APPS.PER_VACANCY_BE2 dependencies on FND_DATE

Line 96: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);

92: l_text:='';
93: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
94: --
95: l_text:='';
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);

Line 108: l_text:=l_text||fnd_date.date_to_canonical(p_date_from);

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

Line 140: l_text:=l_text||fnd_date.date_to_canonical(p_date_to);

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);
141: l_text:=l_text||'
';
142: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
143: l_text:='';
144: l_text:=l_text||irc_utilities_pkg.removeTags(p_security_method);