APPS.XDPCORE_PKG dependencies on DUAL

Line 409: SELECT to_char(XDP_WF_ITEMKEY_S.NEXTVAL) INTO l_tempKey FROM dual;

405: EXIT WHEN c_GetIndServices%NOTFOUND;
406:
407: l_Counter := l_Counter + 1;
408:
409: SELECT to_char(XDP_WF_ITEMKEY_S.NEXTVAL) INTO l_tempKey FROM dual;
410: l_tempKey := to_char(l_OrderID) || '-PKG-' || to_char(l_SrvLineItemID) || '-SVC-' || to_char(l_SrvLineItemID) || '-' || l_tempKey;
411:
412:
413: t_ChildTypes(l_Counter) := 'XDPPROV';

Line 454: SELECT to_char(XDP_WF_ITEMKEY_S.NEXTVAL) INTO l_tempKey FROM dual;

450:
451: IF c_GetDepServices%FOUND THEN
452: l_Counter := l_Counter + 1;
453:
454: SELECT to_char(XDP_WF_ITEMKEY_S.NEXTVAL) INTO l_tempKey FROM dual;
455: l_tempKey := to_char(l_OrderID) || '-PKG-' || to_char(l_SrvLineItemID) || '-SVC-' || to_char(l_SrvLineItemID) || '-' || l_tempKey;
456:
457:
458: t_ChildTypes(l_Counter) := 'XDPPROV';

Line 713: SELECT to_char(XDP_WF_ITEMKEY_S.NEXTVAL) INTO l_tempKey FROM dual;

709: EXIT WHEN c_GetSrcSeq%NOTFOUND;
710:
711: l_Counter := l_Counter + 1;
712:
713: SELECT to_char(XDP_WF_ITEMKEY_S.NEXTVAL) INTO l_tempKey FROM dual;
714: l_tempKey := to_char(l_OrderID) || '-PKG-' || to_char(l_LineItemID) || '-SVC-' || to_char(l_LineItemID) || '-' || l_tempKey;
715:
716: t_ChildTypes(l_Counter) := 'XDPPROV';
717: t_ChildKeys(l_Counter) := l_tempKey;

Line 948: SELECT to_char(XDP_WF_ITEMKEY_S.NEXTVAL) INTO l_tempKey FROM dual;

944: l_result := 'Y';
945: l_SrvLineItemID := c_PkgRec.LINE_ITEM_ID;
946: l_Counter := l_Counter + 1;
947:
948: SELECT to_char(XDP_WF_ITEMKEY_S.NEXTVAL) INTO l_tempKey FROM dual;
949: l_tempKey := to_char(l_OrderID) || '-PKG-' || to_char(l_SrvLineItemID) || '-SVC-' || to_char(l_SrvLineItemID) || '-' || l_tempKey;
950:
951: t_ChildKeys(l_Counter) := l_tempKey;
952: