APPS.CLN_SYNCITEM_PKG dependencies on DUAL

Line 308: SELECT 'x' into l_dummy_check FROM dual

304: END IF;
305:
306: -- Modified the query below due to performance hit. Bug #4946778
307:
308: SELECT 'x' into l_dummy_check FROM dual
309: WHERE EXISTS (SELECT 'X' FROM mtl_system_items_b_kfv msib, --mtl_system_items_vl msib,
310: mtl_customer_item_xrefs mcix, -- mtl_item_revisions mir,
311: po_hazard_classes_tl phct,
312: MTL_CUSTOMER_ITEMS MCI,

Line 383: SELECT sysdate into l_date from dual;

379: cln_debug_pub.Add('User input seems valid.....',1);
380: END IF;
381:
382: -- Get the document creation date as canonical date
383: SELECT sysdate into l_date from dual;
384: l_canonical_date := FND_DATE.DATE_TO_CANONICAL(l_date);
385:
386: IF (l_Debug_Level <= 1) THEN
387: cln_debug_pub.Add('Canonical Date set as - '||l_canonical_date,1);

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 734: from dual;

730:
731: -- get organization ID
732: select FND_PROFILE.VALUE('ORG_ID')
733: into l_organization_id
734: from dual;
735:
736: -- Retrieve Activity Attributes
737: p_inventory_item_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'INVENTORY_ITEM_ID');
738: p_org_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ORGANIZATION_ID');

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

Line 793: SELECT sysdate into l_date from dual;

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);
795:
796: x_progress := 'CLN_SYNCITEM_PKG.Send_Syncitem_Delete : Unique key created';
797: if (l_debug_level <= 1) then