41: prior_len NUMBER := 0;
42: BEGIN
43: l_item_type := substr(document_id, 1, instr(document_id, ':') - 1);
44: l_item_key := substr(document_id, instr(document_id, ':') + 1);
45: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => l_item_type,
46: itemkey => l_item_key,
47: aname => 'DOCUMENT_ID');
48: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => l_item_type,
49: itemkey => l_item_key,
44: l_item_key := substr(document_id, instr(document_id, ':') + 1);
45: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => l_item_type,
46: itemkey => l_item_key,
47: aname => 'DOCUMENT_ID');
48: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => l_item_type,
49: itemkey => l_item_key,
50: aname => 'DRAFT_ID');
51:
52: OPEN car_logs_csr(l_document_id, l_draft_id);
151: resultout := wf_engine.eng_null;
152: RETURN;
153: END IF;
154:
155: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
156: itemkey => itemkey,
157: aname => 'DOCUMENT_ID');
158: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
159: itemkey => itemkey,
154:
155: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
156: itemkey => itemkey,
157: aname => 'DOCUMENT_ID');
158: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
159: itemkey => itemkey,
160: aname => 'DRAFT_ID');
161:
162: IF l_draft_id IS NULL THEN
168: FROM PO_CLM_CARS
169: WHERE PO_HEADER_ID = l_document_id
170: AND PO_DRAFT_ID = l_draft_id;
171:
172: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
173: itemkey => itemkey,
174: aname => 'CAR_ID',
175: avalue => l_car_id);
176: PO_WF_UTIL_PKG.SetItemAttrText(itemtype=>itemtype,
172: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
173: itemkey => itemkey,
174: aname => 'CAR_ID',
175: avalue => l_car_id);
176: PO_WF_UTIL_PKG.SetItemAttrText(itemtype=>itemtype,
177: itemkey => itemkey,
178: aname => 'INVOKER_KEY',
179: avalue => itemkey);
180:
211: resultout := wf_engine.eng_null;
212: RETURN;
213: END IF;
214:
215: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
216: itemkey => itemkey,
217: aname => 'DOCUMENT_ID');
218: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
219: itemkey => itemkey,
214:
215: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
216: itemkey => itemkey,
217: aname => 'DOCUMENT_ID');
218: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
219: itemkey => itemkey,
220: aname => 'DRAFT_ID');
221: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
222: itemkey => itemkey,
217: aname => 'DOCUMENT_ID');
218: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
219: itemkey => itemkey,
220: aname => 'DRAFT_ID');
221: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
222: itemkey => itemkey,
223: aname => 'DOCUMENT_SUBTYPE');
224: l_buyer_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
225: itemkey => itemkey,
220: aname => 'DRAFT_ID');
221: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
222: itemkey => itemkey,
223: aname => 'DOCUMENT_SUBTYPE');
224: l_buyer_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
225: itemkey => itemkey,
226: aname => 'BUYER_USER_NAME');
227: l_approver_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
228: itemkey => itemkey,
223: aname => 'DOCUMENT_SUBTYPE');
224: l_buyer_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
225: itemkey => itemkey,
226: aname => 'BUYER_USER_NAME');
227: l_approver_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
228: itemkey => itemkey,
229: aname => 'APPROVER_USER_NAME');
230:
231: l_update_fpds_info := 'JSP:/OA_HTML/OA.jsp?OAFunc=PO_UPDATE_FPDSNG_INFO&poHeaderId=' || To_Char(l_document_id)
258: ELSE
259: l_performer_user_name := l_approver_user_name;
260: END IF;
261:
262: PO_WF_UTIL_PKG.SetItemAttrText(itemtype=>itemtype,
263: itemkey => itemkey,
264: aname => 'DOCUMENT_TYPE_DISP',
265: avalue => l_doc_type_disp);
266: PO_WF_UTIL_PKG.SetItemAttrText(itemtype=>itemtype,
262: PO_WF_UTIL_PKG.SetItemAttrText(itemtype=>itemtype,
263: itemkey => itemkey,
264: aname => 'DOCUMENT_TYPE_DISP',
265: avalue => l_doc_type_disp);
266: PO_WF_UTIL_PKG.SetItemAttrText(itemtype=>itemtype,
267: itemkey => itemkey,
268: aname => 'PERFORMER_USER_NAME',
269: avalue => l_performer_user_name);
270: PO_WF_UTIL_PKG.SetItemAttrText(itemtype=>itemtype,
266: PO_WF_UTIL_PKG.SetItemAttrText(itemtype=>itemtype,
267: itemkey => itemkey,
268: aname => 'PERFORMER_USER_NAME',
269: avalue => l_performer_user_name);
270: PO_WF_UTIL_PKG.SetItemAttrText(itemtype=>itemtype,
271: itemkey => itemkey,
272: aname => 'CAR_LOGS',
273: avalue => 'PLSQL:PO_CLM_CAR_WF_UTIL.GET_CAR_LOGS/' || itemtype || ':' || itemkey);
274:
271: itemkey => itemkey,
272: aname => 'CAR_LOGS',
273: avalue => 'PLSQL:PO_CLM_CAR_WF_UTIL.GET_CAR_LOGS/' || itemtype || ':' || itemkey);
274:
275: PO_WF_UTIL_PKG.SetItemAttrText(itemtype=>itemtype,
276: itemkey => itemkey,
277: aname => 'UPDATE_FPDS_INFO',
278: avalue => l_update_fpds_info);
279:
326: RETURN;
327: END IF;
328:
329: --CLM Controls Project changes
330: l_org_id := po_wf_util_pkg.GetItemAttrNumber( itemtype =>
331: itemtype,
332: itemkey =>
333: itemkey,
334: aname =>
342: resultout := wf_engine.eng_completed || ':' || 'N';
343: RETURN;
344: END IF;
345:
346: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype =>
347: itemtype,
348: itemkey =>
349: itemkey,
350: aname
349: itemkey,
350: aname
351: =>
352: 'DOCUMENT_ID');
353: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype =>
354: itemtype,
355: itemkey =>
356: itemkey,
357: aname
397: resultout := wf_engine.eng_null;
398: RETURN;
399: END IF;
400:
401: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype =>
402: itemtype,
403: itemkey =>
404: itemkey,
405: aname
404: itemkey,
405: aname
406: =>
407: 'DOCUMENT_ID');
408: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype =>
409: itemtype,
410: itemkey =>
411: itemkey,
412: aname