DBA Data[Home] [Help]

APPS.XDPCORE dependencies on DUAL

Line 118: FROM dual;

114: if OrderID is NOT NULL then
115:
116: SELECT to_char(XDP_WF_ITEMKEY_S.NEXTVAL)
117: INTO itemkey
118: FROM dual;
119:
120: ItemType := 'XDPPROV';
121: itemkey := to_char(OrderID) || '-INIT-' || itemkey;
122:

Line 177: FROM dual;

173: IF ResubmissionJobID is NOT NULL then
174:
175: SELECT to_char(XDP_WF_ITEMKEY_S.NEXTVAL)
176: INTO itemkey
177: FROM dual;
178:
179: ItemType := 'XDPPROV';
180: itemkey := to_char(ResubmissionJobID) || '-ORU-' || itemkey;
181:

Line 237: FROM dual;

233: if OrderID is NOT NULL then
234:
235: SELECT to_char(XDP_WF_ITEMKEY_S.NEXTVAL)
236: INTO itemkey
237: FROM dual;
238:
239: ItemType := 'XDPPROV';
240: itemkey := to_char(OrderID) || '-OA-' || itemkey;
241:

Line 290: FROM dual;

286: begin
287:
288: SELECT to_char(XDP_WF_ITEMKEY_S.NEXTVAL)
289: INTO itemkey
290: FROM dual;
291:
292: ItemType := 'XDPPROV';
293: itemkey := to_char(OrderID) || '-MAIN-' || itemkey;
294: