DBA Data[Home] [Help]

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 466: n_varname Wf_Engine.NameTabTyp;

462: l_nid NUMBER;
463: l_api_name CONSTANT VARCHAR2(30) := 'startSignatureWF';
464: x_return_status VARCHAR2(10);
465: l_supplier_username fnd_user.user_name%type;
466: n_varname Wf_Engine.NameTabTyp;
467: n_varval Wf_Engine.NumTabTyp;
468: t_varname Wf_Engine.NameTabTyp;
469: t_varval Wf_Engine.TextTabTyp;
470: l_supplier_displayname VARCHAR2(240);

Line 467: n_varval Wf_Engine.NumTabTyp;

463: l_api_name CONSTANT VARCHAR2(30) := 'startSignatureWF';
464: x_return_status VARCHAR2(10);
465: l_supplier_username fnd_user.user_name%type;
466: n_varname Wf_Engine.NameTabTyp;
467: n_varval Wf_Engine.NumTabTyp;
468: t_varname Wf_Engine.NameTabTyp;
469: t_varval Wf_Engine.TextTabTyp;
470: l_supplier_displayname VARCHAR2(240);
471:

Line 468: t_varname Wf_Engine.NameTabTyp;

464: x_return_status VARCHAR2(10);
465: l_supplier_username fnd_user.user_name%type;
466: n_varname Wf_Engine.NameTabTyp;
467: n_varval Wf_Engine.NumTabTyp;
468: t_varname Wf_Engine.NameTabTyp;
469: t_varval Wf_Engine.TextTabTyp;
470: l_supplier_displayname VARCHAR2(240);
471:
472: BEGIN

Line 469: t_varval Wf_Engine.TextTabTyp;

465: l_supplier_username fnd_user.user_name%type;
466: n_varname Wf_Engine.NameTabTyp;
467: n_varval Wf_Engine.NumTabTyp;
468: t_varname Wf_Engine.NameTabTyp;
469: t_varval Wf_Engine.TextTabTyp;
470: l_supplier_displayname VARCHAR2(240);
471:
472: BEGIN
473: -- initialize return status

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

476: x_return_status := FND_API.g_ret_sts_unexp_error;
477: return x_return_status;
478: else
479:
480: wf_engine.createProcess ( ItemType => p_item_type,
481: ItemKey => p_item_key,
482: Process => 'DOCUMENT_SIGNATURE_PROCESS');
483:
484: -- Get Supplier User Name

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

511: t_varval(3) := p_document_number;
512: t_varname(4) := 'SUPPLIER_USER_NAME';
513: t_varval(4) := l_supplier_username;
514:
515: Wf_Engine.SetItemAttrNumberArray(p_item_type, p_item_key,n_varname,n_varval);
516: Wf_Engine.SetItemAttrTextArray(p_item_type, p_item_key,t_varname,t_varval);
517:
518: wf_engine.StartProcess(ItemType => p_item_type,
519: ItemKey => p_item_key);

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

512: t_varname(4) := 'SUPPLIER_USER_NAME';
513: t_varval(4) := l_supplier_username;
514:
515: Wf_Engine.SetItemAttrNumberArray(p_item_type, p_item_key,n_varname,n_varval);
516: Wf_Engine.SetItemAttrTextArray(p_item_type, p_item_key,t_varname,t_varval);
517:
518: wf_engine.StartProcess(ItemType => p_item_type,
519: ItemKey => p_item_key);
520: -- DO explicit commit

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

514:
515: Wf_Engine.SetItemAttrNumberArray(p_item_type, p_item_key,n_varname,n_varval);
516: Wf_Engine.SetItemAttrTextArray(p_item_type, p_item_key,t_varname,t_varval);
517:
518: wf_engine.StartProcess(ItemType => p_item_type,
519: ItemKey => p_item_key);
520: -- DO explicit commit
521: commit;
522: return x_return_status;

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

3014: ELSE
3015:
3016: -- Find the Notification generated for the given Item Key
3017: -- Compare the User Id with the Workflow Invoker's User Id
3018: x_sup_user_id := wf_engine.GetItemAttrNumber (itemtype => l_item_type,
3019: itemkey => l_item_key,
3020: aname => 'SUPPLIER_USER_ID');
3021:
3022: if (x_sup_user_id = p_supplier_user_id) then

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

3239: ELSE
3240:
3241: -- Find the Notification generated for the given Item Key
3242: -- Compare the User Id with the Workflow Invoker's User Id
3243: x_sup_user_id := wf_engine.GetItemAttrNumber (itemtype => l_item_type,
3244: itemkey => l_item_key,
3245: aname => 'SUPPLIER_USER_ID');
3246:
3247: if (x_sup_user_id = p_supplier_user_id) then