APPS.CLN_UPDTDLVY_PKG dependencies on DUAL

Line 105: from dual;

101: WHERE h.shipment_header_id = p_shipment_header_id;
102:
103: select FND_PROFILE.VALUE('ORG_ID')
104: into l_organization_id
105: from dual;
106:
107: if (l_debug_level <= 1) then
108: cln_debug_pub.Add('CLN_UPDTDLVY_PKG.Raise_Updatedelivery_Event: Parameter Lookups Completed', 1);
109: cln_debug_pub.Add('With the following parameters:', 1);

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 159: SELECT sysdate into l_date from dual;

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

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

Line 300: SELECT sysdate into l_date from dual;

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);
302:
303: x_progress := 'CLN_SYNCCTLG_PKG.Showship_Raise_Event : 02';
304: if (l_debug_level <= 1) then