DBA Data[Home] [Help]

APPS.CLN_UPDTDLVY_PKG dependencies on FND_DATE

Line 160: l_canonical_date := FND_DATE.DATE_TO_CANONICAL(l_date);

156: SELECT CLN_UPDTDLVY_S.nextval into l_updtdlvy_seq from dual;
157: l_document_id := to_char(l_receipt_id) || '.' || to_char(l_updtdlvy_seq);
158:
159: SELECT sysdate into l_date from dual;
160: l_canonical_date := FND_DATE.DATE_TO_CANONICAL(l_date);
161:
162: x_progress := 'CLN_UPDTDLVY_PKG.Raise_Updatedelivery_Event : Created reference ID, unique key, and canonical date';
163: if (l_debug_level <= 1) then
164: cln_debug_pub.Add('Failure point ' || x_progress, 1);

Line 301: l_canonical_date := FND_DATE.DATE_TO_CANONICAL(l_date);

297: SELECT CLN_UPDTDLVY_S.nextval into l_updtdlvy_seq from dual;
298: l_event_key := p_receipt_id || '.' || to_char(l_updtdlvy_seq);
299:
300: SELECT sysdate into l_date from dual;
301: l_canonical_date := FND_DATE.DATE_TO_CANONICAL(l_date);
302:
303: x_progress := 'CLN_SYNCCTLG_PKG.Showship_Raise_Event : 02';
304: if (l_debug_level <= 1) then
305: cln_debug_pub.Add('Failure point ' || x_progress, 1);