eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XDPCORE_BUNDLE dependencies on DUAL

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

571: -- dbms_output.put_line('Got Ind bundle id: ' || l_BundleID);
572:
573: l_Counter := l_Counter + 1;
574:
575: select to_char(XDP_WF_ITEMKEY_S.NEXTVAL) into l_tempKey from dual;
576: l_tempKey := to_char(l_OrderID) || '-BUNDLE-IND-' || l_tempKey;
577:
578: t_ChildTypes(l_Counter) := 'XDPPROV';
579: t_ChildKeys(l_Counter) := l_tempKey;

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

644: l_Counter := l_Counter + 1;
645:
646: t_ChildTypes(l_Counter) := 'XDPPROV';
647:
648: select to_char(XDP_WF_ITEMKEY_S.NEXTVAL) into l_tempKey from dual;
649: l_tempKey := to_char(l_OrderID) || '-BUNDLE-' || to_char(l_BundleID) || '-' || l_tempKey;
650:
651: t_ChildKeys(l_Counter) := l_tempKey;
652:

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

857: EXIT when c_GetIndLinesNullBundle%NOTFOUND;
858:
859: l_Counter := l_Counter + 1;
860:
861: select to_char(XDP_WF_ITEMKEY_S.NEXTVAL) into l_tempKey from dual;
862: l_tempKey := to_char(l_OrderID) || '-BUNDLE_LINE-' || to_char(l_LineItemID) || l_tempKey;
863:
864: t_ChildTypes(l_Counter) := 'XDPPROV';
865: t_ChildKeys(l_Counter) := l_tempKey;

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

936: ** and Create an instance if the dependent line item process
937: **/
938: l_Counter := l_Counter + 1;
939:
940: select to_char(XDP_WF_ITEMKEY_S.NEXTVAL) into l_tempKey from dual;
941: l_tempKey := to_char(l_OrderID) || '-BUNDLE_LINE-' || to_char(l_LineItemID) || l_tempKey;
942:
943: t_ChildTypes(l_Counter) := 'XDPPROV';
944: t_ChildKeys(l_Counter) := l_tempKey;

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

1034: EXIT when c_GetIndLinesForBundle%NOTFOUND;
1035:
1036: l_Counter := l_Counter + 1;
1037:
1038: select to_char(XDP_WF_ITEMKEY_S.NEXTVAL) into l_tempKey from dual;
1039: l_tempKey := to_char(l_OrderID) || '-BUNDLE- ' || to_char(l_BundleID) || '-LINE-' || to_char(l_LineItemID) || l_tempKey;
1040:
1041: t_ChildTypes(l_Counter) := 'XDPPROV';
1042: t_ChildKeys(l_Counter) := l_tempKey;

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

1114: ** and Create an instance if the dependent line item process
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) || '-BUNDLE_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:
1309: -- dbms_output.put_line('Bundle: ' || l_BundleID || ' Line: ' || l_LineItemID);
1310: l_Counter := l_Counter + 1;
1311:
1312: select to_char(XDP_WF_ITEMKEY_S.NEXTVAL) into l_tempKey from dual;
1313: l_tempKey := to_char(l_OrderID) || '-BUNDLE- ' || to_char(l_BundleID) || '-LINE-' || to_char(l_LineItemID) || l_tempKey;
1314:
1315: t_ChildTypes(l_Counter) := 'XDPPROV';
1316: t_ChildKeys(l_Counter) := l_tempKey;

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

1389: l_Counter := l_Counter + 1;
1390:
1391: -- dbms_output.put_line('Bundle: ' || l_BundleID || ' Line: ' || l_LineItemID);
1392:
1393: select to_char(XDP_WF_ITEMKEY_S.NEXTVAL) into l_tempKey from dual;
1394: l_tempKey := to_char(l_OrderID) || '-BUNDLE_LINE-' || to_char(l_LineItemID) || l_tempKey;
1395:
1396: t_ChildTypes(l_Counter) := 'XDPPROV';
1397: t_ChildKeys(l_Counter) := l_tempKey;

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

1647: l_result := 'Y';
1648: l_Counter := l_Counter + 1;
1649:
1650: l_BundleID := lv_BundleRec.BUNDLE_ID;
1651: select to_char(XDP_WF_ITEMKEY_S.NEXTVAL) into l_tempKey from dual;
1652: l_tempKey := to_char(l_OrderID) || '-BUNDLE-' || l_tempKey;
1653:
1654: t_ChildKeys(l_Counter) := l_tempKey;
1655:

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

1779: FOR lv_BundelRec in c_BundleSeq( l_OrderID, l_PrevBundleSeq ) LOOP
1780: l_BundleID := lv_BundelRec.BUNDLE_ID;
1781: l_CurrentBundleSeq := lv_BundelRec.BUNDLE_SEQUENCE;
1782:
1783: select to_char(XDP_WF_ITEMKEY_S.NEXTVAL) into l_tempKey from dual;
1784: l_tempKey := to_char(l_OrderID) || '-BUNDLE-' || to_char(l_LineItemID) || l_tempKey;
1785:
1786: wf_engine.CreateProcess(itemtype => 'XDPPROV',
1787: itemkey => l_tempKey,