DBA Data[Home] [Help]

APPS.XDPCORE_WI dependencies on XDP_WF_ITEMKEY_S

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;