APPS.PO_CHG_REQUEST_PVT dependencies on WF_ENGINE

Line 285: wf_engine.completeActivity(l_po_item_type,

281: END IF;
282: ELSE
283: Notif_Ack_Status := FND_MESSAGE.GET_STRING('POS','POS_PO_PARTIALLY_ACKED');
284: END IF;
285: wf_engine.completeActivity(l_po_item_type,
286: l_po_item_key,
287: l_activity_name,
288: --'NOTIFY_WEB_SUPPLIER_RESP',
289: Notif_Ack_Status);

Line 367: n_varname Wf_Engine.NameTabTyp;

363: l_nid NUMBER;
364: l_api_name CONSTANT VARCHAR2(30) := 'startSignatureWF';
365: x_return_status VARCHAR2(10);
366: l_supplier_username fnd_user.user_name%type;
367: n_varname Wf_Engine.NameTabTyp;
368: n_varval Wf_Engine.NumTabTyp;
369: t_varname Wf_Engine.NameTabTyp;
370: t_varval Wf_Engine.TextTabTyp;
371: l_supplier_displayname VARCHAR2(240);

Line 368: n_varval Wf_Engine.NumTabTyp;

364: l_api_name CONSTANT VARCHAR2(30) := 'startSignatureWF';
365: x_return_status VARCHAR2(10);
366: l_supplier_username fnd_user.user_name%type;
367: n_varname Wf_Engine.NameTabTyp;
368: n_varval Wf_Engine.NumTabTyp;
369: t_varname Wf_Engine.NameTabTyp;
370: t_varval Wf_Engine.TextTabTyp;
371: l_supplier_displayname VARCHAR2(240);
372:

Line 369: t_varname Wf_Engine.NameTabTyp;

365: x_return_status VARCHAR2(10);
366: l_supplier_username fnd_user.user_name%type;
367: n_varname Wf_Engine.NameTabTyp;
368: n_varval Wf_Engine.NumTabTyp;
369: t_varname Wf_Engine.NameTabTyp;
370: t_varval Wf_Engine.TextTabTyp;
371: l_supplier_displayname VARCHAR2(240);
372:
373: BEGIN

Line 370: t_varval Wf_Engine.TextTabTyp;

366: l_supplier_username fnd_user.user_name%type;
367: n_varname Wf_Engine.NameTabTyp;
368: n_varval Wf_Engine.NumTabTyp;
369: t_varname Wf_Engine.NameTabTyp;
370: t_varval Wf_Engine.TextTabTyp;
371: l_supplier_displayname VARCHAR2(240);
372:
373: BEGIN
374: -- initialize return status

Line 381: wf_engine.createProcess ( ItemType => p_item_type,

377: x_return_status := FND_API.g_ret_sts_unexp_error;
378: return x_return_status;
379: else
380:
381: wf_engine.createProcess ( ItemType => p_item_type,
382: ItemKey => p_item_key,
383: Process => 'DOCUMENT_SIGNATURE_PROCESS');
384:
385: -- Get Supplier User Name

Line 413: Wf_Engine.SetItemAttrNumberArray(p_item_type, p_item_key,n_varname,n_varval);

409: t_varval(3) := p_document_number;
410: t_varname(4) := 'SUPPLIER_USER_NAME';
411: t_varval(4) := l_supplier_username;
412:
413: Wf_Engine.SetItemAttrNumberArray(p_item_type, p_item_key,n_varname,n_varval);
414: Wf_Engine.SetItemAttrTextArray(p_item_type, p_item_key,t_varname,t_varval);
415:
416: wf_engine.StartProcess(ItemType => p_item_type,
417: ItemKey => p_item_key);

Line 414: Wf_Engine.SetItemAttrTextArray(p_item_type, p_item_key,t_varname,t_varval);

410: t_varname(4) := 'SUPPLIER_USER_NAME';
411: t_varval(4) := l_supplier_username;
412:
413: Wf_Engine.SetItemAttrNumberArray(p_item_type, p_item_key,n_varname,n_varval);
414: Wf_Engine.SetItemAttrTextArray(p_item_type, p_item_key,t_varname,t_varval);
415:
416: wf_engine.StartProcess(ItemType => p_item_type,
417: ItemKey => p_item_key);
418: -- DO explicit commit

Line 416: wf_engine.StartProcess(ItemType => p_item_type,

412:
413: Wf_Engine.SetItemAttrNumberArray(p_item_type, p_item_key,n_varname,n_varval);
414: Wf_Engine.SetItemAttrTextArray(p_item_type, p_item_key,t_varname,t_varval);
415:
416: wf_engine.StartProcess(ItemType => p_item_type,
417: ItemKey => p_item_key);
418: -- DO explicit commit
419: commit;
420: return x_return_status;

Line 2871: x_sup_user_id := wf_engine.GetItemAttrNumber (itemtype => l_item_type,

2867: ELSE
2868:
2869: -- Find the Notification generated for the given Item Key
2870: -- Compare the User Id with the Workflow Invoker's User Id
2871: x_sup_user_id := wf_engine.GetItemAttrNumber (itemtype => l_item_type,
2872: itemkey => l_item_key,
2873: aname => 'SUPPLIER_USER_ID');
2874:
2875: if (x_sup_user_id = p_supplier_user_id) then