DBA Data[Home] [Help]

APPS.AMS_GENERIC_NTFY_PVT dependencies on WF_ENGINE

Line 29: l_save_threshold NUMBER := wf_engine.threshold;

25: l_msg_data VARCHAR2(4000);
26: l_error_msg VARCHAR2(4000);
27: x_resource_id NUMBER;
28: l_index NUMBER;
29: l_save_threshold NUMBER := wf_engine.threshold;
30: l_x_data VARCHAR2(4000);
31:
32: BEGIN
33: FND_MSG_PUB.initialize();

Line 38: -- wf_engine.threshold := -1;

34:
35: AMS_Utility_PVT.debug_message('Start :Item Type : '||itemtype
36: ||' Item key : '||itemkey);
37:
38: -- wf_engine.threshold := -1;
39: WF_ENGINE.CreateProcess (itemtype => itemtype,
40: itemkey => itemkey ,
41: process => p_workflowprocess);
42:

Line 39: WF_ENGINE.CreateProcess (itemtype => itemtype,

35: AMS_Utility_PVT.debug_message('Start :Item Type : '||itemtype
36: ||' Item key : '||itemkey);
37:
38: -- wf_engine.threshold := -1;
39: WF_ENGINE.CreateProcess (itemtype => itemtype,
40: itemkey => itemkey ,
41: process => p_workflowprocess);
42:
43: WF_ENGINE.SetItemUserkey(itemtype => itemtype,

Line 43: WF_ENGINE.SetItemUserkey(itemtype => itemtype,

39: WF_ENGINE.CreateProcess (itemtype => itemtype,
40: itemkey => itemkey ,
41: process => p_workflowprocess);
42:
43: WF_ENGINE.SetItemUserkey(itemtype => itemtype,
44: itemkey => itemkey ,
45: userkey => itemuserkey);
46:
47:

Line 51: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

47:
48: /*****************************************************************
49: Initialize Workflow Item Attributes
50: *****************************************************************/
51: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
52: itemkey => itemkey,
53: aname => 'AMS_ACTIVITY_TYPE',
54: avalue => p_activity_type );
55:

Line 57: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype ,

53: aname => 'AMS_ACTIVITY_TYPE',
54: avalue => p_activity_type );
55:
56: -- Activity ID (primary Id of Activity Object)
57: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype ,
58: itemkey => itemkey,
59: aname => 'AMS_ACTIVITY_ID',
60: avalue => p_activity_id );
61:

Line 62: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

58: itemkey => itemkey,
59: aname => 'AMS_ACTIVITY_ID',
60: avalue => p_activity_id );
61:
62: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
63: itemkey => itemkey,
64: aname => 'AMS_SENT_BY',
65: avalue => p_send_by );
66:

Line 67: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

63: itemkey => itemkey,
64: aname => 'AMS_SENT_BY',
65: avalue => p_send_by );
66:
67: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
68: itemkey => itemkey,
69: aname => 'AMS_SEND_TO',
70: avalue => p_sent_to );
71:

Line 72: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

68: itemkey => itemkey,
69: aname => 'AMS_SEND_TO',
70: avalue => p_sent_to );
71:
72: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
73: itemkey => itemkey,
74: aname => 'GEN_SUBJECT',
75: avalue => p_subject );
76:

Line 85: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

81: p_responsibility_id =>21706,
82: p_security_group_id =>NULL,
83: p_session_id =>NULL
84: );
85: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
86: itemkey => itemkey,
87: aname => 'LAUNCH_URL',
88: avalue => l_x_data );
89: */

Line 91: /* WF_ENGINE.SetItemAttrText(itemtype => itemtype,

87: aname => 'LAUNCH_URL',
88: avalue => l_x_data );
89: */
90:
91: /* WF_ENGINE.SetItemAttrText(itemtype => itemtype,
92: itemkey => itemkey,
93: aname => 'AMS_GEN_NTF_APPROVER',
94: avalue => 'CHOANG' );
95: */

Line 97: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

93: aname => 'AMS_GEN_NTF_APPROVER',
94: avalue => 'CHOANG' );
95: */
96:
97: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
98: itemkey => itemkey,
99: aname => 'AMS_DOCUMENT_ID',
100: avalue => ItemType||':'||ItemKey);
101:

Line 103: wf_engine.SetItemAttrText(itemtype => itemtype,

99: aname => 'AMS_DOCUMENT_ID',
100: avalue => ItemType||':'||ItemKey);
101:
102: /*
103: wf_engine.SetItemAttrText(itemtype => itemtype,
104: itemkey => itemkey,
105: aname => 'AMS_GEN_DOCUMENT',
106: avalue => 'PLSQL:AMS_GENERIC_NTFY_PVT.AMS_GENERIC_NOTIFICATION/'||ItemType||':'||ItemKey);
107: */

Line 108: WF_ENGINE.SetItemOwner(itemtype => itemtype,

104: itemkey => itemkey,
105: aname => 'AMS_GEN_DOCUMENT',
106: avalue => 'PLSQL:AMS_GENERIC_NTFY_PVT.AMS_GENERIC_NOTIFICATION/'||ItemType||':'||ItemKey);
107: */
108: WF_ENGINE.SetItemOwner(itemtype => itemtype,
109: itemkey => itemkey,
110: owner => p_send_by);
111:
112:

Line 114: WF_ENGINE.StartProcess (itemtype => itemtype,

110: owner => p_send_by);
111:
112:
113: -- Start the Process
114: WF_ENGINE.StartProcess (itemtype => itemtype,
115: itemkey => itemkey);
116:
117:
118: -- wf_engine.threshold := l_save_threshold ;

Line 118: -- wf_engine.threshold := l_save_threshold ;

114: WF_ENGINE.StartProcess (itemtype => itemtype,
115: itemkey => itemkey);
116:
117:
118: -- wf_engine.threshold := l_save_threshold ;
119: EXCEPTION
120: WHEN OTHERS THEN
121: -- wf_engine.threshold := l_save_threshold ;
122: FND_MSG_PUB.Count_And_Get (

Line 121: -- wf_engine.threshold := l_save_threshold ;

117:
118: -- wf_engine.threshold := l_save_threshold ;
119: EXCEPTION
120: WHEN OTHERS THEN
121: -- wf_engine.threshold := l_save_threshold ;
122: FND_MSG_PUB.Count_And_Get (
123: p_encoded => FND_API.G_FALSE,
124: p_count => l_msg_count,
125: p_data => l_msg_data);

Line 173: l_activity_type := wf_engine.GetItemAttrText(

169: ItemType := nvl(substr(document_id, 1,instr(document_id,':')-1),'AMSGAPP');
170: ItemKey := substr(document_id, instr(document_id,':')+1);
171:
172:
173: l_activity_type := wf_engine.GetItemAttrText(
174: itemtype => itemtype,
175: itemkey => itemkey,
176: aname => 'AMS_ACTIVITY_TYPE' );
177: IF l_activity_type is NULL THEN

Line 206: -- wf_engine.threshold := l_save_threshold ;

202: end if;
203: */
204: EXCEPTION
205: WHEN OTHERS THEN
206: -- wf_engine.threshold := l_save_threshold ;
207: FND_MSG_PUB.Count_And_Get (
208: p_encoded => FND_API.G_FALSE,
209: p_count => l_msg_count,
210: p_data => l_msg_data);

Line 250: l_stat := wf_engine.GetActivityAttrText(

246: l_error_msg VARCHAR2(4000);
247: l_index NUMBER;
248:
249: BEGIN
250: l_stat := wf_engine.GetActivityAttrText(
251: itemtype => itemtype,
252: itemkey => itemkey,
253: actid => actid,
254: aname => 'UPDATE_STATUS' );

Line 259: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

255: IF(l_stat is NULL) THEN
256: l_stat:='Value is NULL';
257: END IF;
258:
259: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
260: itemkey => itemkey,
261: aname => 'UPDATE_GEN_STATUS',
262: avalue => l_stat );
263:

Line 266: -- wf_engine.threshold := l_save_threshold ;

262: avalue => l_stat );
263:
264: EXCEPTION
265: WHEN OTHERS THEN
266: -- wf_engine.threshold := l_save_threshold ;
267: FND_MSG_PUB.Count_And_Get (
268: p_encoded => FND_API.G_FALSE,
269: p_count => l_msg_count,
270: p_data => l_msg_data);