DBA Data[Home] [Help]

APPS.POS_WF_PO_ACKNOWLEDGE dependencies on WF_ENGINE

Line 34: x_acceptance_due_date := wf_engine.GetItemAttrDate ( itemtype => itemtype,

30: x_progress varchar2(3) := '000';
31: begin
32: x_progress := '001';
33:
34: x_acceptance_due_date := wf_engine.GetItemAttrDate ( itemtype => itemtype,
35: itemkey => itemkey,
36: aname => 'ACCEPTANCE_DUE_DATE');
37:
38: x_acceptance_flag := wf_engine.GetItemAttrText ( itemtype => itemtype,

Line 38: x_acceptance_flag := wf_engine.GetItemAttrText ( itemtype => itemtype,

34: x_acceptance_due_date := wf_engine.GetItemAttrDate ( itemtype => itemtype,
35: itemkey => itemkey,
36: aname => 'ACCEPTANCE_DUE_DATE');
37:
38: x_acceptance_flag := wf_engine.GetItemAttrText ( itemtype => itemtype,
39: itemkey => itemkey,
40: aname => 'ACCEPTANCE_REQUIRED');
41:
42: if (x_acceptance_due_date is NULL or nvl(x_acceptance_flag, 'N') <> 'Y') then

Line 44: wf_engine.SetItemAttrText ( itemtype => itemtype,

40: aname => 'ACCEPTANCE_REQUIRED');
41:
42: if (x_acceptance_due_date is NULL or nvl(x_acceptance_flag, 'N') <> 'Y') then
43:
44: wf_engine.SetItemAttrText ( itemtype => itemtype,
45: itemkey => itemkey,
46: aname => 'BY',
47: avalue => '');
48: end if;

Line 72: x_org_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,

68: x_org_id number;
69: begin
70:
71: -- set the org context
72: x_org_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
73: itemkey => itemkey,
74: aname => 'ORG_ID');
75:
76: fnd_client_info.set_org_context(to_char(x_org_id));

Line 81: wf_engine.SetItemAttrText ( itemtype => itemtype,

77:
78: fnd_message.set_name ('ICX','POS_PO_WF_ACCEPTED_VALUE');
79: x_acceptance_result := fnd_message.get;
80:
81: wf_engine.SetItemAttrText ( itemtype => itemtype,
82: itemkey => itemkey,
83: aname => 'ACCEPTANCE_RESULT',
84: avalue => nvl(x_acceptance_result, 'Accepted'));
85:

Line 110: x_org_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,

106: x_org_id number;
107: begin
108:
109: -- set the org context
110: x_org_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
111: itemkey => itemkey,
112: aname => 'ORG_ID');
113:
114: fnd_client_info.set_org_context(to_char(x_org_id));

Line 119: wf_engine.SetItemAttrText ( itemtype => itemtype,

115:
116: fnd_message.set_name ('ICX','POS_PO_WF_REJECTED_VALUE');
117: x_acceptance_result := fnd_message.get;
118:
119: wf_engine.SetItemAttrText ( itemtype => itemtype,
120: itemkey => itemkey,
121: aname => 'ACCEPTANCE_RESULT',
122: avalue => nvl(x_acceptance_result, 'Rejected'));
123:

Line 155: x_document_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,

151: x_org_id number;
152: p_rowid VARCHAR2(2000);
153: l_param VARCHAR2(2000);
154: begin
155: x_document_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
156: itemkey => itemkey,
157: aname => 'DOCUMENT_ID');
158:
159: x_document_type_code := wf_engine.GetItemAttrText ( itemtype => itemtype,

Line 159: x_document_type_code := wf_engine.GetItemAttrText ( itemtype => itemtype,

155: x_document_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
156: itemkey => itemkey,
157: aname => 'DOCUMENT_ID');
158:
159: x_document_type_code := wf_engine.GetItemAttrText ( itemtype => itemtype,
160: itemkey => itemkey,
161: aname => 'DOCUMENT_TYPE_CODE');
162: --dbms_output.put_line('Document Code is ' || x_document_type_code );
163: if x_document_type_code <> 'RELEASE' then

Line 175: wf_engine.SetItemAttrText ( itemtype => itemtype,

171: where poh.po_header_id = x_document_id
172: and poh.type_lookup_code = polc.lookup_code
173: and polc.lookup_type = 'PO TYPE';
174:
175: wf_engine.SetItemAttrText ( itemtype => itemtype,
176: itemkey => itemkey,
177: aname => 'FOR',
178: avalue => '');
179:

Line 196: wf_engine.SetItemAttrText ( itemtype => itemtype,

192: end if;
193:
194: -- Set Item Attributes.
195:
196: wf_engine.SetItemAttrText ( itemtype => itemtype,
197: itemkey => itemkey,
198: aname => 'DOCUMENT_NUM',
199: avalue => x_document_num);
200:

Line 201: wf_engine.SetItemAttrText ( itemtype => itemtype,

197: itemkey => itemkey,
198: aname => 'DOCUMENT_NUM',
199: avalue => x_document_num);
200:
201: wf_engine.SetItemAttrText ( itemtype => itemtype,
202: itemkey => itemkey,
203: aname => 'DOCUMENT_TYPE',
204: avalue => x_document_type);
205:

Line 206: wf_engine.SetItemAttrText ( itemtype => itemtype,

202: itemkey => itemkey,
203: aname => 'DOCUMENT_TYPE',
204: avalue => x_document_type);
205:
206: wf_engine.SetItemAttrText ( itemtype => itemtype,
207: itemkey => itemkey,
208: aname => 'ACCEPTANCE_REQUIRED',
209: avalue => x_acceptance_required_flag);
210:

Line 211: wf_engine.SetItemAttrDate ( itemtype => itemtype,

207: itemkey => itemkey,
208: aname => 'ACCEPTANCE_REQUIRED',
209: avalue => x_acceptance_required_flag);
210:
211: wf_engine.SetItemAttrDate ( itemtype => itemtype,
212: itemkey => itemkey,
213: aname => 'ACCEPTANCE_DUE_DATE',
214: avalue => x_acceptance_due_date);
215:

Line 216: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

212: itemkey => itemkey,
213: aname => 'ACCEPTANCE_DUE_DATE',
214: avalue => x_acceptance_due_date);
215:
216: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
217: itemkey => itemkey,
218: aname => 'RELEASE_NUM',
219: avalue => x_release_num);
220:

Line 221: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

217: itemkey => itemkey,
218: aname => 'RELEASE_NUM',
219: avalue => x_release_num);
220:
221: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
222: itemkey => itemkey,
223: aname => 'BUYER_USER_ID',
224: avalue => x_agent_id);
225:

Line 226: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

222: itemkey => itemkey,
223: aname => 'BUYER_USER_ID',
224: avalue => x_agent_id);
225:
226: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
227: itemkey => itemkey,
228: aname => 'ORG_ID',
229: avalue => x_org_id);
230:

Line 231: wf_engine.SetItemAttrText( itemtype => itemtype,

227: itemkey => itemkey,
228: aname => 'ORG_ID',
229: avalue => x_org_id);
230:
231: wf_engine.SetItemAttrText( itemtype => itemtype,
232: itemkey => itemkey,
233: aname => 'PO_DETAILS_URL',
234: avalue => 'PLSQL:POS_WF_PO_COMMON_APIS.GET_PO_DETAILS_URL/' ||
235: itemtype || ':' || itemkey);

Line 301: x_document_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,

297: else
298: x_Acceptance_Lookup_Code := 'REJECTED';
299: end if;
300:
301: x_document_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
302: itemkey => itemkey,
303: aname => 'DOCUMENT_ID');
304:
305: x_document_type_code := wf_engine.GetItemAttrText ( itemtype => itemtype,

Line 305: x_document_type_code := wf_engine.GetItemAttrText ( itemtype => itemtype,

301: x_document_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
302: itemkey => itemkey,
303: aname => 'DOCUMENT_ID');
304:
305: x_document_type_code := wf_engine.GetItemAttrText ( itemtype => itemtype,
306: itemkey => itemkey,
307: aname => 'DOCUMENT_TYPE_CODE');
308:
309: -- abort any outstanding acceptance notifications for any previous revision of the document.

Line 384: x_org_id := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,

380: l_item_key := 'POS_ACK_' || to_char (document_id) || '_' || to_char(nvl(document_rev, 0));
381:
382: -- set the org context
383: begin
384: x_org_id := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,
385: itemkey => l_item_key,
386: aname => 'ORG_ID');
387:
388: fnd_client_info.set_org_context(to_char(x_org_id));

Line 410: wf_engine.completeActivity ( l_item_type, l_item_key, 'NOTIFY_SUPPLIER', 'Abort' );

406: if x_acceptance_required = 'Y' then
407: begin
408: -- Abort the notification - workflow will take the default transition.
409:
410: wf_engine.completeActivity ( l_item_type, l_item_key, 'NOTIFY_SUPPLIER', 'Abort' );
411:
412: exception
413: when others then
414: null;