APPS.XDPCORE_WI dependencies on DUAL

Line 1480: from dual

1476: x_Progress VARCHAR2(2000);
1477:
1478: CURSOR c_ContinueWI(p_OrderID number) is
1479: select 'Y' yahoo
1480: from dual
1481: where exists (select WORKITEM_INSTANCE_ID
1482: from XDP_FULFILL_WORKLIST
1483: where ORDER_ID = p_OrderID
1484: and status_code in ('READY','IN PROGRESS') );

Line 1496: select 'Y' into l_Continue from dual

1492: exit;
1493: end loop;
1494: /*
1495: begin
1496: select 'Y' into l_Continue from dual
1497: where exists (select WORKITEM_INSTANCE_ID
1498: from XDP_FULFILL_WORKLIST
1499: where ORDER_ID = l_OrderID
1500: and status_code = 'READY' );

Line 1576: SELECT to_char(XDP_WF_ITEMKEY_S.NEXTVAL) into l_tempKey from dual;

1572: x_Progress VARCHAR2(2000);
1573:
1574: begin
1575:
1576: SELECT to_char(XDP_WF_ITEMKEY_S.NEXTVAL) into l_tempKey from dual;
1577:
1578: if itemkeyPrefix is null then
1579: itemkey := to_char(OrderID) || '-WI-' || l_tempKey;
1580: else

Line 1732: select to_char(XDP_WF_ITEMKEY_S.NEXTVAL) into l_tempKey from dual;

1728: EXIT when c_GetIndWIList%NOTFOUND;
1729:
1730: l_Counter := l_Counter + 1;
1731:
1732: select to_char(XDP_WF_ITEMKEY_S.NEXTVAL) into l_tempKey from dual;
1733: l_tempKey := to_char(l_OrderID) || '-WI-' || to_char(l_WIInstanceID) || l_tempKey;
1734:
1735: t_ChildTypes(l_Counter) := 'XDPPROV';
1736: t_ChildKeys(l_Counter) := l_tempKey;

Line 1793: select to_char(XDP_WF_ITEMKEY_S.NEXTVAL) into l_tempKey from dual;

1789: if c_GetDepWIList%FOUND then
1790:
1791: l_Counter := l_Counter + 1;
1792:
1793: select to_char(XDP_WF_ITEMKEY_S.NEXTVAL) into l_tempKey from dual;
1794: l_tempKey := to_char(l_OrderID) || '-WI-' || to_char(l_WIInstanceID) || l_tempKey;
1795:
1796: t_ChildTypes(l_Counter) := 'XDPPROV';
1797: t_ChildKeys(l_Counter) := l_tempKey;