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.M4R_7B5_OSFM_PKG dependencies on WF_ENGINE

Line 61: l_po_doc_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'DOCUMENT_ID');

57: cln_debug_pub.Add('funcmode:' || p_funcmode, 2);
58: cln_debug_pub.Add('resultout:' || x_resultout, 2);
59: END IF;
60:
61: l_po_doc_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'DOCUMENT_ID');
62: IF (g_debug_level <= 1) THEN
63: cln_debug_pub.Add('PO Document ID ' || l_po_doc_id, 1);
64: END IF;
65:

Line 66: l_po_doc_type := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'DOCUMENT_TYPE');

62: IF (g_debug_level <= 1) THEN
63: cln_debug_pub.Add('PO Document ID ' || l_po_doc_id, 1);
64: END IF;
65:
66: l_po_doc_type := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'DOCUMENT_TYPE');
67: IF (g_debug_level <= 1) THEN
68: cln_debug_pub.Add('PO Document Type ' || l_po_doc_type, 1);
69: END IF;
70:

Line 71: l_po_rev_num := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'PO_REVISION_NUM');

67: IF (g_debug_level <= 1) THEN
68: cln_debug_pub.Add('PO Document Type ' || l_po_doc_type, 1);
69: END IF;
70:
71: l_po_rev_num := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'PO_REVISION_NUM');
72: IF (g_debug_level <= 1) THEN
73: cln_debug_pub.Add('PO Document Revision Number ' || l_po_rev_num, 1);
74: END IF;
75:

Line 166: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_TRANSACTION_TYPE', 'M4R');

162: cln_debug_pub.Add('PO_RELEASE_NUM = '|| l_po_rel_num , 1);
163: cln_debug_pub.Add('PO_REL_REV_NUM = '|| l_po_rel_rev_num , 1);
164: END IF;
165:
166: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_TRANSACTION_TYPE', 'M4R');
167: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_TRANSACTION_SUBTYPE', '7B5_OSFM_WO');
168: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_ID', l_party_id);
169: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_SITE_ID', l_party_site_id);
170: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_TYPE', 'S');

Line 167: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_TRANSACTION_SUBTYPE', '7B5_OSFM_WO');

163: cln_debug_pub.Add('PO_REL_REV_NUM = '|| l_po_rel_rev_num , 1);
164: END IF;
165:
166: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_TRANSACTION_TYPE', 'M4R');
167: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_TRANSACTION_SUBTYPE', '7B5_OSFM_WO');
168: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_ID', l_party_id);
169: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_SITE_ID', l_party_site_id);
170: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_TYPE', 'S');
171: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ORG_ID', l_org_id);

Line 168: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_ID', l_party_id);

164: END IF;
165:
166: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_TRANSACTION_TYPE', 'M4R');
167: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_TRANSACTION_SUBTYPE', '7B5_OSFM_WO');
168: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_ID', l_party_id);
169: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_SITE_ID', l_party_site_id);
170: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_TYPE', 'S');
171: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ORG_ID', l_org_id);
172: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_RELEASE_ID', l_po_rel_id);

Line 169: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_SITE_ID', l_party_site_id);

165:
166: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_TRANSACTION_TYPE', 'M4R');
167: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_TRANSACTION_SUBTYPE', '7B5_OSFM_WO');
168: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_ID', l_party_id);
169: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_SITE_ID', l_party_site_id);
170: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_TYPE', 'S');
171: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ORG_ID', l_org_id);
172: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_RELEASE_ID', l_po_rel_id);
173: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_HEADER_ID', l_po_header_id);

Line 170: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_TYPE', 'S');

166: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_TRANSACTION_TYPE', 'M4R');
167: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_TRANSACTION_SUBTYPE', '7B5_OSFM_WO');
168: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_ID', l_party_id);
169: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_SITE_ID', l_party_site_id);
170: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_TYPE', 'S');
171: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ORG_ID', l_org_id);
172: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_RELEASE_ID', l_po_rel_id);
173: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_HEADER_ID', l_po_header_id);
174: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_RELEASE_NUM', l_po_rel_num);

Line 171: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ORG_ID', l_org_id);

167: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_TRANSACTION_SUBTYPE', '7B5_OSFM_WO');
168: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_ID', l_party_id);
169: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_SITE_ID', l_party_site_id);
170: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_TYPE', 'S');
171: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ORG_ID', l_org_id);
172: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_RELEASE_ID', l_po_rel_id);
173: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_HEADER_ID', l_po_header_id);
174: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_RELEASE_NUM', l_po_rel_num);
175: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_REVISION_NUM', l_po_rev_num);

Line 172: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_RELEASE_ID', l_po_rel_id);

168: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_ID', l_party_id);
169: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_SITE_ID', l_party_site_id);
170: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_TYPE', 'S');
171: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ORG_ID', l_org_id);
172: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_RELEASE_ID', l_po_rel_id);
173: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_HEADER_ID', l_po_header_id);
174: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_RELEASE_NUM', l_po_rel_num);
175: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_REVISION_NUM', l_po_rev_num);
176: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_REL_REV_NUM', l_po_rel_rev_num);

Line 173: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_HEADER_ID', l_po_header_id);

169: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_SITE_ID', l_party_site_id);
170: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_TYPE', 'S');
171: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ORG_ID', l_org_id);
172: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_RELEASE_ID', l_po_rel_id);
173: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_HEADER_ID', l_po_header_id);
174: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_RELEASE_NUM', l_po_rel_num);
175: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_REVISION_NUM', l_po_rev_num);
176: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_REL_REV_NUM', l_po_rel_rev_num);
177:

Line 174: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_RELEASE_NUM', l_po_rel_num);

170: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_TYPE', 'S');
171: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ORG_ID', l_org_id);
172: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_RELEASE_ID', l_po_rel_id);
173: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_HEADER_ID', l_po_header_id);
174: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_RELEASE_NUM', l_po_rel_num);
175: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_REVISION_NUM', l_po_rev_num);
176: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_REL_REV_NUM', l_po_rel_rev_num);
177:
178: IF (g_debug_level <= 1) THEN

Line 175: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_REVISION_NUM', l_po_rev_num);

171: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ORG_ID', l_org_id);
172: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_RELEASE_ID', l_po_rel_id);
173: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_HEADER_ID', l_po_header_id);
174: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_RELEASE_NUM', l_po_rel_num);
175: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_REVISION_NUM', l_po_rev_num);
176: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_REL_REV_NUM', l_po_rel_rev_num);
177:
178: IF (g_debug_level <= 1) THEN
179: cln_debug_pub.Add('Workflow Attributes set', 1);

Line 176: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_REL_REV_NUM', l_po_rel_rev_num);

172: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_RELEASE_ID', l_po_rel_id);
173: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_HEADER_ID', l_po_header_id);
174: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_RELEASE_NUM', l_po_rel_num);
175: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_REVISION_NUM', l_po_rev_num);
176: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_REL_REV_NUM', l_po_rel_rev_num);
177:
178: IF (g_debug_level <= 1) THEN
179: cln_debug_pub.Add('Workflow Attributes set', 1);
180: END IF;

Line 312: l_po_header_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'PO_HEADER_ID');

308: END IF;
309:
310:
311: -- read wf item attributes into local variable, begins
312: l_po_header_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'PO_HEADER_ID');
313: IF (g_debug_level <= 1) THEN
314: cln_debug_pub.Add('PO Header ID ' || l_po_header_id, 1);
315: END IF;
316:

Line 317: l_po_rel_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'PO_RELEASE_ID');

313: IF (g_debug_level <= 1) THEN
314: cln_debug_pub.Add('PO Header ID ' || l_po_header_id, 1);
315: END IF;
316:
317: l_po_rel_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'PO_RELEASE_ID');
318: IF (g_debug_level <= 1) THEN
319: cln_debug_pub.Add('PO Release ID ' || l_po_rel_id, 1);
320: END IF;
321:

Line 322: l_po_doc_type := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'DOCUMENT_TYPE');

318: IF (g_debug_level <= 1) THEN
319: cln_debug_pub.Add('PO Release ID ' || l_po_rel_id, 1);
320: END IF;
321:
322: l_po_doc_type := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'DOCUMENT_TYPE');
323: IF (g_debug_level <= 1) THEN
324: cln_debug_pub.Add('PO Document Type ' || l_po_doc_type, 1);
325: END IF;
326:

Line 327: l_po_rev_num := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'PO_REVISION_NUM');

323: IF (g_debug_level <= 1) THEN
324: cln_debug_pub.Add('PO Document Type ' || l_po_doc_type, 1);
325: END IF;
326:
327: l_po_rev_num := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'PO_REVISION_NUM');
328: IF (g_debug_level <= 1) THEN
329: cln_debug_pub.Add('PO Revision Number ' || l_po_rev_num, 1);
330: END IF;
331:

Line 332: l_po_rel_num := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'PO_RELEASE_NUM');

328: IF (g_debug_level <= 1) THEN
329: cln_debug_pub.Add('PO Revision Number ' || l_po_rev_num, 1);
330: END IF;
331:
332: l_po_rel_num := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'PO_RELEASE_NUM');
333: IF (g_debug_level <= 1) THEN
334: cln_debug_pub.Add('PO Release Number ' || l_po_rel_num, 1);
335: END IF;
336:

Line 337: l_po_rel_rev_num := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'PO_REL_REV_NUM');

333: IF (g_debug_level <= 1) THEN
334: cln_debug_pub.Add('PO Release Number ' || l_po_rel_num, 1);
335: END IF;
336:
337: l_po_rel_rev_num := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'PO_REL_REV_NUM');
338: IF (g_debug_level <= 1) THEN
339: cln_debug_pub.Add('PO Release Revision Number ' || l_po_rel_rev_num, 1);
340: END IF;
341:

Line 342: l_org_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'ORG_ID');

338: IF (g_debug_level <= 1) THEN
339: cln_debug_pub.Add('PO Release Revision Number ' || l_po_rel_rev_num, 1);
340: END IF;
341:
342: l_org_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'ORG_ID');
343: IF (g_debug_level <= 1) THEN
344: cln_debug_pub.Add('Org ID ' || l_org_id, 1);
345: END IF;
346:

Line 347: l_party_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'ECX_PARTY_ID');

343: IF (g_debug_level <= 1) THEN
344: cln_debug_pub.Add('Org ID ' || l_org_id, 1);
345: END IF;
346:
347: l_party_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'ECX_PARTY_ID');
348: IF (g_debug_level <= 1) THEN
349: cln_debug_pub.Add('Party ID ' || l_party_id, 1);
350: END IF;
351:

Line 352: l_party_site_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'ECX_PARTY_SITE_ID');

348: IF (g_debug_level <= 1) THEN
349: cln_debug_pub.Add('Party ID ' || l_party_id, 1);
350: END IF;
351:
352: l_party_site_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'ECX_PARTY_SITE_ID');
353: IF (g_debug_level <= 1) THEN
354: cln_debug_pub.Add('Party Site ID ' || l_party_site_id, 1);
355: END IF;
356: -- read wf item attributes into local variable, ends

Line 818: x_resultout := wf_engine.eng_completed;

814: l_raise_flag := 'N';
815:
816: END LOOP;
817:
818: x_resultout := wf_engine.eng_completed;
819:
820: IF (g_debug_level <= 2) THEN
821: cln_debug_pub.Add('Exiting the M4R_7B5_OSFM_PKG.PROCESS_WO procedure', 2);
822: END IF;