APPS.CLN_SYNCCTLG_PKG dependencies on DUAL

Line 142: from dual;

138: end if;
139:
140: select FND_PROFILE.VALUE('ORG_ID')
141: into l_operating_unit_id
142: from dual;
143:
144: if (l_debug_level <= 1) then
145: cln_debug_pub.Add('l_operating_unit_id:' || l_operating_unit_id, 1);
146: end if;

Line 221: SELECT CLN_SYNCCTLG_S.nextval into l_syncctlg_seq from dual;

217: cln_debug_pub.Add('Failure point ' || x_progress, 1);
218: end if;
219:
220: -- create unique key
221: SELECT CLN_SYNCCTLG_S.nextval into l_syncctlg_seq from dual;
222: if (l_debug_level <= 1) then
223: cln_debug_pub.Add('l_syncctlg_seq:' || l_syncctlg_seq, 1);
224: end if;
225: l_event_key := to_char(p_list_header_id) || '.' || to_char(l_syncctlg_seq);

Line 227: SELECT sysdate into l_date from dual;

223: cln_debug_pub.Add('l_syncctlg_seq:' || l_syncctlg_seq, 1);
224: end if;
225: l_event_key := to_char(p_list_header_id) || '.' || to_char(l_syncctlg_seq);
226:
227: SELECT sysdate into l_date from dual;
228: if (l_debug_level <= 1) then
229: cln_debug_pub.Add('l_date:' || l_date, 1);
230: end if;
231: l_canonical_date := FND_DATE.DATE_TO_CANONICAL(l_date);

Line 552: SELECT CLN_SYNCCTLG_S.nextval into l_syncctlg_seq from dual;

548: cln_debug_pub.Add('Failure point ' || x_progress, 1);
549: end if;
550:
551: -- create unique key
552: SELECT CLN_SYNCCTLG_S.nextval into l_syncctlg_seq from dual;
553: if (l_debug_level <= 1) then
554: cln_debug_pub.Add('l_syncctlg_seq:' || l_syncctlg_seq, 1);
555: end if;
556: l_event_key := to_char(p_list_header_id) || '.' || to_char(l_syncctlg_seq);

Line 558: SELECT sysdate into l_date from dual;

554: cln_debug_pub.Add('l_syncctlg_seq:' || l_syncctlg_seq, 1);
555: end if;
556: l_event_key := to_char(p_list_header_id) || '.' || to_char(l_syncctlg_seq);
557:
558: SELECT sysdate into l_date from dual;
559: if (l_debug_level <= 1) then
560: cln_debug_pub.Add('l_date:' || l_date, 1);
561: end if;
562: l_canonical_date := FND_DATE.DATE_TO_CANONICAL(l_date);