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

Line 4765: if (funcmode <> wf_engine.eng_run) then

4761:
4762:
4763: -- Do nothing in cancel or timeout mode
4764: --
4765: if (funcmode <> wf_engine.eng_run) then
4766:
4767: resultout := wf_engine.eng_null;
4768: return;
4769:

Line 4767: resultout := wf_engine.eng_null;

4763: -- Do nothing in cancel or timeout mode
4764: --
4765: if (funcmode <> wf_engine.eng_run) then
4766:
4767: resultout := wf_engine.eng_null;
4768: return;
4769:
4770: end if;
4771:

Line 4772: l_draftid := wf_engine.GetItemAttrNumber (itemtype => itemtype,

4768: return;
4769:
4770: end if;
4771:
4772: l_draftid := wf_engine.GetItemAttrNumber (itemtype => itemtype,
4773: itemkey => itemkey,
4774: aname => 'DRAFT_ID');
4775:
4776: l_document_type := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,

Line 4972: l_draft_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'DRAFT_ID');

4968: IF (g_po_wf_debug = 'Y') THEN
4969: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
4970: END IF;
4971:
4972: l_draft_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'DRAFT_ID');
4973:
4974: SELECT document_id
4975: INTO l_po_header_id
4976: FROM po_drafts

Line 5069: resultout := wf_engine.eng_completed || ':' || l_is_lock_available;

5065: IF (g_po_wf_debug = 'Y') THEN
5066: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.IS_LOCK_FOR_SGD_GEN_AVAILABLE value is : '|| l_is_lock_available;
5067: END IF;
5068:
5069: resultout := wf_engine.eng_completed || ':' || l_is_lock_available;
5070:
5071: EXCEPTION
5072: WHEN OTHERS THEN
5073: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.IS_LOCK_FOR_SGD_GEN_AVAILABLE: Exception';

Line 5125: resultout := wf_engine.eng_completed || ':' || l_is_sgd_generation_req;

5121: THEN
5122: l_is_sgd_generation_req := 'Y';
5123: END IF;
5124:
5125: resultout := wf_engine.eng_completed || ':' || l_is_sgd_generation_req;
5126: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.IS_SGD_GENERATION_REQUIRED value is '|| l_is_sgd_generation_req ;
5127: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
5128:
5129: EXCEPTION

Line 5172: l_draft_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'DRAFT_ID');

5168: IF (g_po_wf_debug = 'Y') THEN
5169: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
5170: END IF;
5171:
5172: l_draft_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'DRAFT_ID');
5173:
5174: SELECT document_id
5175: INTO l_po_header_id
5176: FROM po_drafts

Line 5179: l_doc_sub_type := wf_engine.GetItemAttrText ( itemtype => itemtype,

5175: INTO l_po_header_id
5176: FROM po_drafts
5177: WHERE draft_id = l_draft_id;
5178:
5179: l_doc_sub_type := wf_engine.GetItemAttrText ( itemtype => itemtype,
5180: itemkey => itemkey,
5181: aname => 'DOCUMENT_SUBTYPE');
5182: l_doc_type := wf_engine.GetItemAttrText ( itemtype => itemtype,
5183: itemkey => itemkey,

Line 5182: l_doc_type := wf_engine.GetItemAttrText ( itemtype => itemtype,

5178:
5179: l_doc_sub_type := wf_engine.GetItemAttrText ( itemtype => itemtype,
5180: itemkey => itemkey,
5181: aname => 'DOCUMENT_SUBTYPE');
5182: l_doc_type := wf_engine.GetItemAttrText ( itemtype => itemtype,
5183: itemkey => itemkey,
5184: aname => 'DOCUMENT_TYPE');
5185: l_org_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
5186: itemkey => itemkey,

Line 5185: l_org_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,

5181: aname => 'DOCUMENT_SUBTYPE');
5182: l_doc_type := wf_engine.GetItemAttrText ( itemtype => itemtype,
5183: itemkey => itemkey,
5184: aname => 'DOCUMENT_TYPE');
5185: l_org_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
5186: itemkey => itemkey,
5187: aname => 'ORG_ID');
5188:
5189: SELECT revision_num into l_revision_number FROM po_headers_all WHERE po_header_id = l_po_header_id;

Line 5239: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

5235: itemkey => itemkey,
5236: aname => 'REQUEST_ID',
5237: avalue => l_request_id);
5238:
5239: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
5240:
5241: EXCEPTION
5242: WHEN OTHERS THEN
5243: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.LAUNCH_SGD_CONCURRENT_PROGRAM: Error: '||sqlerrm;

Line 5247: resultout := wf_engine.eng_completed || ':' || '';

5243: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.LAUNCH_SGD_CONCURRENT_PROGRAM: Error: '||sqlerrm;
5244: IF (g_po_wf_debug = 'Y') THEN
5245: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
5246: END IF;
5247: resultout := wf_engine.eng_completed || ':' || '';
5248:
5249: END LAUNCH_SGD_CONCURRENT_PROGRAM;
5250:
5251: -------------------------------------------------------------------------------

Line 5313: wf_engine.CompleteActivity(x_itemtype,item_key.item_key,'WAIT_FOR_LOCK_TO_BE_RELEASED','ACTIVITY_PERFORMED');

5309: FOR item_key IN waiting_process_wf_keys(l_draft_id) LOOP
5310: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.RELEASE_SYNC_SGD_LOCK: Item keys of waiting process : ' || item_key.item_key;
5311: po_wf_debug_pkg.Insert_debug(itemtype, itemkey, x_progress);
5312: --Execute complete activity on these process to resume
5313: wf_engine.CompleteActivity(x_itemtype,item_key.item_key,'WAIT_FOR_LOCK_TO_BE_RELEASED','ACTIVITY_PERFORMED');
5314: END LOOP;
5315:
5316: COMMIT;
5317: