146: l_car_status VARCHAR2(60);
147:
148: BEGIN
149:
150: IF (funcmode <> wf_engine.eng_run) THEN
151: resultout := wf_engine.eng_null;
152: RETURN;
153: END IF;
154:
147:
148: BEGIN
149:
150: IF (funcmode <> wf_engine.eng_run) THEN
151: resultout := wf_engine.eng_null;
152: RETURN;
153: END IF;
154:
155: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
206: l_fnd_org_id NUMBER;
207: l_mo_org_id NUMBER;
208: BEGIN
209:
210: IF (funcmode <> wf_engine.eng_run) THEN
211: resultout := wf_engine.eng_null;
212: RETURN;
213: END IF;
214:
207: l_mo_org_id NUMBER;
208: BEGIN
209:
210: IF (funcmode <> wf_engine.eng_run) THEN
211: resultout := wf_engine.eng_null;
212: RETURN;
213: END IF;
214:
215: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
289: l_evt wf_event_t;
290: l_ret VARCHAR(25);
291: BEGIN
292:
293: if (funcmode <> wf_engine.eng_run) then
294: resultout := wf_engine.eng_null;
295: return;
296: end if;
297:
290: l_ret VARCHAR(25);
291: BEGIN
292:
293: if (funcmode <> wf_engine.eng_run) then
294: resultout := wf_engine.eng_null;
295: return;
296: end if;
297:
298: l_evt := wf_engine.GetItemAttrEvent(itemtype, itemkey, 'RECEIVER_DATA');
294: resultout := wf_engine.eng_null;
295: return;
296: end if;
297:
298: l_evt := wf_engine.GetItemAttrEvent(itemtype, itemkey, 'RECEIVER_DATA');
299: l_ret := l_evt.GetEventData;
300:
301: IF l_ret = 'S' THEN
302: resultout := 'COMPLETE' || ':' || 'SUCCESS';
320: l_org_id NUMBER; --CLM Controls Project Changes
321:
322: BEGIN
323:
324: IF (funcmode <> wf_engine.eng_run) THEN
325: resultout := wf_engine.eng_null;
326: RETURN;
327: END IF;
328:
321:
322: BEGIN
323:
324: IF (funcmode <> wf_engine.eng_run) THEN
325: resultout := wf_engine.eng_null;
326: RETURN;
327: END IF;
328:
329: --CLM Controls Project changes
338: into l_fpds_reporting
339: FROM dual;
340:
341: IF l_fpds_reporting is null OR l_fpds_reporting = 'N' THEN
342: resultout := wf_engine.eng_completed || ':' || 'N';
343: RETURN;
344: END IF;
345:
346: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype =>
369: WHERE PO_HEADER_ID = l_document_id
370: AND PO_DRAFT_ID = l_draft_id;
371: EXCEPTION
372: WHEN no_data_found THEN
373: resultout := wf_engine.eng_completed || ':' || 'Y';
374: RETURN;
375: END;
376:
377: IF (l_reporting_method <> 'EXEMPT' AND nvl(l_approved_without_reporting, '2') <> '1') THEN
374: RETURN;
375: END;
376:
377: IF (l_reporting_method <> 'EXEMPT' AND nvl(l_approved_without_reporting, '2') <> '1') THEN
378: resultout := wf_engine.eng_completed || ':' || 'Y';
379: ELSE
380: resultout := wf_engine.eng_completed || ':' || 'N';
381: END IF;
382:
376:
377: IF (l_reporting_method <> 'EXEMPT' AND nvl(l_approved_without_reporting, '2') <> '1') THEN
378: resultout := wf_engine.eng_completed || ':' || 'Y';
379: ELSE
380: resultout := wf_engine.eng_completed || ':' || 'N';
381: END IF;
382:
383: END;
384:
392: l_car_authenticated VARCHAR2(5);
393:
394: BEGIN
395:
396: IF (funcmode <> wf_engine.eng_run) THEN
397: resultout := wf_engine.eng_null;
398: RETURN;
399: END IF;
400:
393:
394: BEGIN
395:
396: IF (funcmode <> wf_engine.eng_run) THEN
397: resultout := wf_engine.eng_null;
398: RETURN;
399: END IF;
400:
401: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype =>
426: AND CAR_STATUS in ('AUTHENTICATED', 'APPROVED')
427: AND REPORTING_METHOD = 'SINGLE_CAR';
428: EXCEPTION
429: WHEN no_data_found THEN
430: resultout := wf_engine.eng_completed || ':' || 'N';
431: RETURN;
432: END;
433:
434: resultout := wf_engine.eng_completed || ':' || 'Y';
430: resultout := wf_engine.eng_completed || ':' || 'N';
431: RETURN;
432: END;
433:
434: resultout := wf_engine.eng_completed || ':' || 'Y';
435:
436: END;
437:
438: END;