eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POS_WF_PO_ACK 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_COMMON_APIS.GET_PO_DETAILS_URL/' ||
235: itemtype || ':' || itemkey);

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

290: else
291: x_Acceptance_Lookup_Code := 'REJECTED';
292: end if;
293:
294: x_document_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
295: itemkey => itemkey,
296: aname => 'DOCUMENT_ID');
297:
298: x_document_type_code := wf_engine.GetItemAttrText ( itemtype => itemtype,

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

294: x_document_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
295: itemkey => itemkey,
296: aname => 'DOCUMENT_ID');
297:
298: x_document_type_code := wf_engine.GetItemAttrText ( itemtype => itemtype,
299: itemkey => itemkey,
300: aname => 'DOCUMENT_TYPE_CODE');
301:
302: -- abort any outstanding acceptance notifications for any previous revision of the document.

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

398: l_item_key := 'POS_ACK_' || to_char (document_id) || '_' || to_char(nvl(document_rev, 0));
399:
400: -- set the org context
401: begin
402: x_org_id := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,
403: itemkey => l_item_key,
404: aname => 'ORG_ID');
405:
406: fnd_client_info.set_org_context(to_char(x_org_id));

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

424: if x_acceptance_required = 'Y' then
425: begin
426: -- Abort the notification - workflow will take the default transition.
427:
428: wf_engine.completeActivity ( l_item_type, l_item_key, 'NOTIFY_SUPPLIER', 'Abort' );
429:
430: exception
431: when others then
432: null;

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

460: x_org_id number;
461: p_rowid VARCHAR2(2000);
462: l_param VARCHAR2(2000);
463: begin
464: x_document_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
465: itemkey => itemkey,
466: aname => 'DOCUMENT_ID');
467:
468: x_document_type_code := wf_engine.GetItemAttrText ( itemtype => itemtype,

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

464: x_document_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
465: itemkey => itemkey,
466: aname => 'DOCUMENT_ID');
467:
468: x_document_type_code := wf_engine.GetItemAttrText ( itemtype => itemtype,
469: itemkey => itemkey,
470: aname => 'DOCUMENT_TYPE_CODE');
471:
472: --dbms_output.put_line('Org Id is ' || to_char(x_org_id));

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

488: where poh.po_header_id = x_document_id
489: and poh.type_lookup_code = polc.lookup_code
490: and polc.lookup_type = 'PO TYPE';
491:
492: wf_engine.SetItemAttrText ( itemtype => itemtype,
493: itemkey => itemkey,
494: aname => 'FOR',
495: avalue => '');
496:

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

513: --dbms_output.put_line('After Select');
514:
515: -- Set Item Attributes.
516:
517: wf_engine.SetItemAttrText ( itemtype => itemtype,
518: itemkey => itemkey,
519: aname => 'DOCUMENT_NUM',
520: avalue => x_document_num);
521:

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

518: itemkey => itemkey,
519: aname => 'DOCUMENT_NUM',
520: avalue => x_document_num);
521:
522: wf_engine.SetItemAttrText ( itemtype => itemtype,
523: itemkey => itemkey,
524: aname => 'DOCUMENT_TYPE',
525: avalue => x_document_type);
526:

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

523: itemkey => itemkey,
524: aname => 'DOCUMENT_TYPE',
525: avalue => x_document_type);
526:
527: wf_engine.SetItemAttrText ( itemtype => itemtype,
528: itemkey => itemkey,
529: aname => 'ACCEPTANCE_REQUIRED',
530: avalue => x_acceptance_required_flag);
531:

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

528: itemkey => itemkey,
529: aname => 'ACCEPTANCE_REQUIRED',
530: avalue => x_acceptance_required_flag);
531:
532: wf_engine.SetItemAttrDate ( itemtype => itemtype,
533: itemkey => itemkey,
534: aname => 'ACCEPTANCE_DUE_DATE',
535: avalue => x_acceptance_due_date);
536:

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

533: itemkey => itemkey,
534: aname => 'ACCEPTANCE_DUE_DATE',
535: avalue => x_acceptance_due_date);
536:
537: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
538: itemkey => itemkey,
539: aname => 'RELEASE_NUM',
540: avalue => x_release_num);
541:

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

538: itemkey => itemkey,
539: aname => 'RELEASE_NUM',
540: avalue => x_release_num);
541:
542: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
543: itemkey => itemkey,
544: aname => 'BUYER_USER_ID',
545: avalue => x_agent_id);
546:

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

543: itemkey => itemkey,
544: aname => 'BUYER_USER_ID',
545: avalue => x_agent_id);
546:
547: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
548: itemkey => itemkey,
549: aname => 'ORG_ID',
550: avalue => x_org_id);
551: /*

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

548: itemkey => itemkey,
549: aname => 'ORG_ID',
550: avalue => x_org_id);
551: /*
552: wf_engine.SetItemAttrText( itemtype => itemtype,
553: itemkey => itemkey,
554: aname => 'PO_DETAILS_URL',
555: avalue => 'PLSQL:POS_WF_PO_COMMON_APIS.GET_PO_DETAILS_URL/'||
556: itemtype || ':' || itemkey);