APPS.XDPCORE_LINE dependencies on DUAL

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

839: EXIT when c_LineSeqNullBundle%NOTFOUND;
840:
841: l_Counter := l_Counter + 1;
842:
843: select to_char(XDP_WF_ITEMKEY_S.NEXTVAL) into l_tempKey from dual;
844: l_tempkey := to_char(l_OrderID) || '-LINE-' || to_char(l_LineItemID) || l_tempKey;
845:
846: t_ChildTypes(l_Counter) := 'XDPPROV';
847: t_ChildKeys(l_Counter) := l_tempKey;

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

926: EXIT when c_LineSeqForBundle%NOTFOUND;
927:
928: l_Counter := l_Counter + 1;
929:
930: select to_char(XDP_WF_ITEMKEY_S.NEXTVAL) into l_tempKey from dual;
931: l_tempkey := to_char(l_OrderID) || '-LINE-' || to_char(l_LineItemID) || l_tempKey;
932:
933: t_ChildTypes(l_Counter) := 'XDPPROV';
934: t_ChildKeys(l_Counter) := l_tempKey;

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

1114: EXIT when c_LineSeq%NOTFOUND;
1115:
1116: l_Counter := l_Counter + 1;
1117:
1118: select to_char(XDP_WF_ITEMKEY_S.NEXTVAL) into l_tempKey from dual;
1119: l_tempkey := to_char(l_OrderID) || '-LINE-' || to_char(l_LineItemID) || l_tempKey;
1120:
1121: t_ChildTypes(l_Counter) := 'XDPPROV';
1122: t_ChildKeys(l_Counter) := l_tempKey;

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

1308: Fetch c_GetIndLines into l_LineItemID, l_IsPackageFlag, l_Priority,l_ib_source,l_ib_source_id;
1309: EXIT when c_GetIndLines%NOTFOUND;
1310:
1311: l_Counter := l_Counter + 1;
1312: select to_char(XDP_WF_ITEMKEY_S.NEXTVAL) into l_tempKey from dual;
1313: l_tempKey := to_char(l_OrderID) || '-LINE-' || to_char(l_LineItemID) || l_tempKey;
1314:
1315: t_ChildTypes(l_Counter) := 'XDPPROV';
1316: t_ChildKeys(l_Counter) := l_tempKey;

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

1360: ** and Create an instance if the dependent line item process
1361: **/
1362: l_Counter := l_Counter + 1;
1363:
1364: select to_char(XDP_WF_ITEMKEY_S.NEXTVAL) into l_tempKey from dual;
1365: l_tempKey := to_char(l_OrderID) || '-LINE-' || to_char(l_LineItemID) || l_tempKey;
1366:
1367: t_ChildTypes(l_Counter) := 'XDPPROV';
1368: t_ChildKeys(l_Counter) := l_tempKey;

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

1529: l_Priority := lv_LineRec.PRIORITY;
1530: l_ib_source := lv_LineRec.IB_SOURCE;
1531: l_ib_source_id := lv_LineRec.IB_SOURCE_ID;
1532:
1533: select to_char(XDP_WF_ITEMKEY_S.NEXTVAL) into l_tempKey from dual;
1534: l_tempKey := to_char(l_OrderID) || '-LINE-' || to_char(l_LineItemID) || l_tempKey;
1535:
1536: t_ChildKeys(l_Counter) := l_tempKey;
1537:

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

1669: l_Priority := lv_LineRec.PRIORITY;
1670: l_ib_source := lv_LineRec.IB_SOURCE;
1671: l_ib_source_id := lv_LineRec.IB_SOURCE_ID;
1672:
1673: select to_char(XDP_WF_ITEMKEY_S.NEXTVAL) into l_tempKey from dual;
1674: l_tempKey := to_char(l_OrderID) || '-LINE-' || to_char(l_LineItemID) || l_tempKey;
1675:
1676: t_ChildKeys(l_Counter) := l_tempKey;
1677:

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

1720: l_Priority := lv_LineRec.PRIORITY;
1721: l_ib_source := lv_LineRec.IB_SOURCE;
1722: l_ib_source_id := lv_LineRec.IB_SOURCE_ID;
1723:
1724: select to_char(XDP_WF_ITEMKEY_S.NEXTVAL) into l_tempKey from dual;
1725: l_tempKey := to_char(l_OrderID) || '-LINE-' || to_char(l_LineItemID) || l_tempKey;
1726:
1727: t_ChildKeys(l_Counter) := l_tempKey;
1728:

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

1858: itemkey => LaunchServiceProcess.itemkey,
1859: aname => 'LINE_ITEM_ID');
1860:
1861:
1862: select to_char(XDP_WF_ITEMKEY_S.NEXTVAL) into l_tempKey from dual;
1863: l_tempKey := to_char(l_OrderID) || '-SVC-' || to_char(l_LineItemID) || l_tempKey;
1864:
1865: -- Create Process and Bulk Set Item Attribute
1866: XDPCORE.CreateNAddAttrNParentLabel(itemtype => 'XDPPROV',