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:
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:
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:
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: