DBA Data[Home] [Help]

APPS.POS_SUPPLIER_NOTIFY_PKG dependencies on WF_ENGINE

Line 19: l_threshold NUMBER := WF_ENGINE.threshold;

15:
16: l_itemtype wf_items.item_type%TYPE;
17: l_itemkey wf_items.item_key%TYPE;
18:
19: l_threshold NUMBER := WF_ENGINE.threshold;
20:
21: BEGIN
22:
23: IF (p_defer) THEN

Line 24: WF_ENGINE.threshold := -1;

20:
21: BEGIN
22:
23: IF (p_defer) THEN
24: WF_ENGINE.threshold := -1;
25: END IF;
26:
27: l_itemtype := 'POSNOTIF';
28:

Line 33: WF_ENGINE.CreateProcess(itemtype => l_itemtype,

29: l_itemkey := 'POSNOTIF' || p_process || '_KEY_' ||
30: TO_CHAR(SYSDATE, 'MMDDYYYY_HH24MISS') || '_' ||
31: fnd_crypto.smallrandomnumber;
32:
33: WF_ENGINE.CreateProcess(itemtype => l_itemtype,
34: itemkey => l_itemkey,
35: process => p_process);
36:
37: WF_ENGINE.SetItemAttrText(itemtype => l_itemtype,

Line 37: WF_ENGINE.SetItemAttrText(itemtype => l_itemtype,

33: WF_ENGINE.CreateProcess(itemtype => l_itemtype,
34: itemkey => l_itemkey,
35: process => p_process);
36:
37: WF_ENGINE.SetItemAttrText(itemtype => l_itemtype,
38: itemkey => l_itemkey,
39: aname => '#FROM_ROLE',
40: avalue => fnd_global.user_name);
41:

Line 42: WF_ENGINE.SetItemAttrText(itemtype => l_itemtype,

38: itemkey => l_itemkey,
39: aname => '#FROM_ROLE',
40: avalue => fnd_global.user_name);
41:
42: WF_ENGINE.SetItemAttrText(itemtype => l_itemtype,
43: itemkey => l_itemkey,
44: aname => 'NOTIF_RECEIVER_ROLE',
45: avalue => p_role);
46:

Line 47: WF_ENGINE.SetItemAttrText(itemtype => l_itemtype,

43: itemkey => l_itemkey,
44: aname => 'NOTIF_RECEIVER_ROLE',
45: avalue => p_role);
46:
47: WF_ENGINE.SetItemAttrText(itemtype => l_itemtype,
48: itemkey => l_itemkey,
49: aname => 'SUPPMSGSUB',
50: avalue => p_msg_subject);
51:

Line 52: WF_ENGINE.SetItemAttrText(itemtype => l_itemtype,

48: itemkey => l_itemkey,
49: aname => 'SUPPMSGSUB',
50: avalue => p_msg_subject);
51:
52: WF_ENGINE.SetItemAttrText(itemtype => l_itemtype,
53: itemkey => l_itemkey,
54: aname => 'SUPPMSGBD',
55: avalue => p_msg_body);
56:

Line 57: WF_ENGINE.SetItemAttrText(itemtype => l_itemtype,

53: itemkey => l_itemkey,
54: aname => 'SUPPMSGBD',
55: avalue => p_msg_body);
56:
57: WF_ENGINE.SetItemAttrText(itemtype => l_itemtype,
58: itemkey => l_itemkey,
59: aname => 'SUPPADTMSG',
60: avalue => p_osn_message);
61:

Line 62: WF_ENGINE.StartProcess(itemtype => l_itemtype,

58: itemkey => l_itemkey,
59: aname => 'SUPPADTMSG',
60: avalue => p_osn_message);
61:
62: WF_ENGINE.StartProcess(itemtype => l_itemtype,
63: itemkey => l_itemkey);
64:
65: WF_ENGINE.threshold := l_threshold;
66:

Line 65: WF_ENGINE.threshold := l_threshold;

61:
62: WF_ENGINE.StartProcess(itemtype => l_itemtype,
63: itemkey => l_itemkey);
64:
65: WF_ENGINE.threshold := l_threshold;
66:
67: EXCEPTION
68: WHEN OTHERS THEN
69: WF_ENGINE.threshold := l_threshold;

Line 69: WF_ENGINE.threshold := l_threshold;

65: WF_ENGINE.threshold := l_threshold;
66:
67: EXCEPTION
68: WHEN OTHERS THEN
69: WF_ENGINE.threshold := l_threshold;
70: RAISE;
71:
72: END wf_process;
73: