APPS.CLN_UPDTDLVY_PKG dependencies on CLN_UPDTDLVY_S

Line 156: SELECT CLN_UPDTDLVY_S.nextval into l_updtdlvy_seq from dual;

152:
153: l_ref_num := l_receipt_id || '-' || sys_guid();
154:
155: -- create unique key
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);

Line 297: SELECT CLN_UPDTDLVY_S.nextval into l_updtdlvy_seq from dual;

293: cln_debug_pub.Add('Failure point ' || x_progress, 1);
294: end if;
295:
296: -- create unique key
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);