[Home] [Help]
29: x_progress varchar2(200) := '000';
30:
31: begin
32:
33: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
34: itemkey => itemkey,
35: aname => 'DOCUMENT_ID');
36: x_progress := 'req_state_check_approve 001';
37:
91: x_progress varchar2(200) := '000';
92:
93: begin
94:
95: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
96: itemkey => itemkey,
97: aname => 'DOCUMENT_ID');
98: x_progress := 'po_state_check_approve 001';
99:
278:
279: x_progress := 'req_complete_check 001';
280:
281:
282: l_user_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
283: itemkey => itemkey,
284: aname => 'USER_ID');
285:
286: x_progress := 'req_complete_check 002' || to_char(l_user_id);
288:
289: l_last_update_login := l_user_id;
290: l_last_user_id := l_user_id;
291:
292: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
293: itemkey => itemkey,
294: aname => 'DOCUMENT_ID');
295:
296: x_progress := 'req_complete_check 003' || to_char(l_document_id);
608:
609: x_progress := 'req_complete_check 012';
610:
611:
612: wf_engine.SetItemAttrNumber ( itemtype => itemType,
613: itemkey => itemkey,
614: aname => 'ONLINE_REPORT_ID',
615: avalue => l_online_report_id);
616:
675: END LOOP;
676:
677: CLOSE C1;
678:
679: wf_engine.SetItemAttrText ( itemtype => itemType,
680: itemkey => itemkey,
681: aname => 'ONLINE_REPORT_TEXT',
682: avalue => l_concat_report_text);
683: