APPS.CLN_SYNCITEM_PKG dependencies on CLN_SYNCITEM_S

Line 484: SELECT CLN_SYNCITEM_S.nextval into l_syncitem_seq from dual;

480: END IF;
481:
482:
483: -- create unique key
484: SELECT CLN_SYNCITEM_S.nextval into l_syncitem_seq from dual;
485: l_event_key := to_char(p_tp_header_id) || '.' || to_char(l_syncitem_seq);
486:
487: IF (l_Debug_Level <= 1) THEN
488: cln_debug_pub.Add('Event Key set as - '||l_event_key,1);

Line 562: SELECT CLN_SYNCITEM_S.nextval INTO l_syncitem_seq FROM dual;

558: cln_debug_pub.Add('end item of the message found as - '||l_to_items,1);
559: END IF;
560:
561: -- create unique key
562: SELECT CLN_SYNCITEM_S.nextval INTO l_syncitem_seq FROM dual;
563: l_event_key := to_char(p_tp_header_id) || '.' || to_char(l_syncitem_seq);
564:
565:
566: IF (l_Debug_Level <= 1) THEN

Line 790: SELECT CLN_SYNCITEM_S.nextval into l_syncitem_seq from dual;

786: cln_debug_pub.Add('Failure point ' || x_progress, 1);
787: end if;
788:
789: -- create unique key
790: SELECT CLN_SYNCITEM_S.nextval into l_syncitem_seq from dual;
791: l_event_key := to_char(l_tp_header_id) || '.' || to_char(l_syncitem_seq);
792:
793: SELECT sysdate into l_date from dual;
794: l_canonical_date := FND_DATE.DATE_TO_CANONICAL(l_date);