DBA Data[Home] [Help]

APPS.OTA_CERT_ENROLLMENT_BE1 dependencies on FND_NUMBER

Line 77: l_text:=l_text||fnd_number.number_to_canonical(p_cert_enrollment_id);

73: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
74: l_text:=l_text||'';
75: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
76: l_text:='';
77: l_text:=l_text||fnd_number.number_to_canonical(p_cert_enrollment_id);
78: l_text:=l_text||'
';
79: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
80: l_text:='';
81: l_text:=l_text||fnd_number.number_to_canonical(p_certification_id);

Line 81: l_text:=l_text||fnd_number.number_to_canonical(p_certification_id);

77: l_text:=l_text||fnd_number.number_to_canonical(p_cert_enrollment_id);
78: l_text:=l_text||'';
79: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
80: l_text:='';
81: l_text:=l_text||fnd_number.number_to_canonical(p_certification_id);
82: l_text:=l_text||'
';
83: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
84: l_text:='';
85: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);

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

81: l_text:=l_text||fnd_number.number_to_canonical(p_certification_id);
82: l_text:=l_text||'';
83: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
84: l_text:='';
85: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
86: l_text:=l_text||'
';
87: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
88: l_text:='';
89: l_text:=l_text||fnd_number.number_to_canonical(p_contact_id);

Line 89: l_text:=l_text||fnd_number.number_to_canonical(p_contact_id);

85: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
86: l_text:=l_text||'';
87: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
88: l_text:='';
89: l_text:=l_text||fnd_number.number_to_canonical(p_contact_id);
90: l_text:=l_text||'
';
91: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
92: l_text:='';
93: l_text:=l_text||irc_utilities_pkg.removeTags(p_certification_status_code);

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

113: l_text:=l_text||irc_utilities_pkg.removeTags(p_is_history_flag);
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_number.number_to_canonical(p_business_group_id);
118: l_text:=l_text||'
';
119: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
120: l_text:='';
121: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute_category);