DBA Data[Home] [Help]

APPS.HR_APPLICANT_BE2 dependencies on FND_DATE

Line 52: l_text:=l_text||fnd_date.date_to_canonical(p_hire_date);

48: l_text:='';
49: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
50: --
51: l_text:='';
52: l_text:=l_text||fnd_date.date_to_canonical(p_hire_date);
53: l_text:=l_text||'
';
54: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
55: l_text:='';
56: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);

Line 80: l_text:=l_text||fnd_date.date_to_canonical(p_per_effective_start_date);

76: l_text:=l_text||irc_utilities_pkg.removeTags(p_employee_number);
77: l_text:=l_text||'';
78: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
79: l_text:='';
80: l_text:=l_text||fnd_date.date_to_canonical(p_per_effective_start_date);
81: l_text:=l_text||'
';
82: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
83: l_text:='';
84: l_text:=l_text||fnd_date.date_to_canonical(p_per_effective_end_date);

Line 84: l_text:=l_text||fnd_date.date_to_canonical(p_per_effective_end_date);

80: l_text:=l_text||fnd_date.date_to_canonical(p_per_effective_start_date);
81: l_text:=l_text||'';
82: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
83: l_text:='';
84: l_text:=l_text||fnd_date.date_to_canonical(p_per_effective_end_date);
85: l_text:=l_text||'
';
86: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
87: l_text:='';
88: if(P_UNACCEPTED_ASG_DEL_WARNING) then

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

104: l_text:=l_text||fnd_number.number_to_canonical(p_oversubscribed_vacancy_id);
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_original_date_of_hire);
109: l_text:=l_text||'
';
110: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
111: l_text:='';
112: --