APPS.UMX_NOTIFICATION_UTIL dependencies on WF_EVENT

Line 30: l_event wf_event_t;

26:
27: l_context varchar2 (30);
28: i number;
29: l_parameter_list wf_parameter_list_t := null;
30: l_event wf_event_t;
31: l_requested_username fnd_user.user_name%type;
32: l_return_status pls_integer;
33: l_registration_data wf_event_t;
34:

Line 33: l_registration_data wf_event_t;

29: l_parameter_list wf_parameter_list_t := null;
30: l_event wf_event_t;
31: l_requested_username fnd_user.user_name%type;
32: l_return_status pls_integer;
33: l_registration_data wf_event_t;
34:
35: BEGIN
36:
37: if (command = 'RUN') then

Line 90: l_return_status := wf_event.GetValueForParameter (

86: if (l_parameter_list is null) then
87: l_parameter_list := l_registration_data.getParameterList;
88: end if;
89:
90: l_return_status := wf_event.GetValueForParameter (
91: p_name => 'TESTUSERNAME_RET_STATUS',
92: p_parameterlist => l_parameter_list);
93:
94:

Line 133: l_registration_data wf_event_t;

129: activity_id in number,
130: command in varchar2,
131: resultout out NOCOPY varchar2) IS
132:
133: l_registration_data wf_event_t;
134: --l_parameter_list wf_parameter_list_t;
135: l_parameter_list wf_parameter_list_t := wf_parameter_list_t(); --bug# 7110551
136: l_parent_itemkey WF_ITEMS.ITEM_KEY%TYPE;
137: l_approval_result varchar2 (30);

Line 178: wf_event.addParametertoList ('APPROVAL_RESULT',l_approval_result,l_parameter_list);

174: end if;
175: end;
176: end loop;
177:
178: wf_event.addParametertoList ('APPROVAL_RESULT',l_approval_result,l_parameter_list);
179:
180: l_parent_itemkey :=
181: wf_engine.getItemattrtext (item_type,item_key,'UMX_PARENT_ITEM_KEY',false);
182:

Line 183: wf_event.raise ('oracle.apps.fnd.umx.notificationdone', l_parent_itemkey,

179:
180: l_parent_itemkey :=
181: wf_engine.getItemattrtext (item_type,item_key,'UMX_PARENT_ITEM_KEY',false);
182:
183: wf_event.raise ('oracle.apps.fnd.umx.notificationdone', l_parent_itemkey,
184: null,l_parameter_list,sysdate);
185: resultout := 'COMPLETE';
186:
187: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 225: l_registration_data wf_event_t;

221: l_approver_name fnd_user.USER_NAME%TYPE;
222: l_display_name wf_users.display_name%type;
223: l_next_approver ame_util.approverRecord2;
224: l_requested_for_user_id fnd_user.user_id%type;
225: l_registration_data wf_event_t;
226: l_requested_for_party_id hz_parties.party_id%type;
227: l_user_role_name wf_local_roles.name%type;
228: l_person_first_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
229: l_person_last_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;

Line 242: l_event wf_event_t;

238: l_msg_count number;
239: l_msg_data varchar2 (280);
240: l_formatted_lines_cnt number;
241: l_formatted_name_tbl hz_format_pub.string_tbl_type;
242: l_event wf_event_t;
243: l_status varchar2 (15);
244:
245: cursor getusername (l_user_id in fnd_user.user_id%type) is
246: select user_name

Line 319: l_requested_for_party_id := wf_event.GetValueForParameter (

315: -- exists, then we will use the WF role of that person.
316:
317: l_registration_data :=
318: wf_engine.getitemattrevent (item_type, item_key, 'REGISTRATION_DATA');
319: l_requested_for_party_id := wf_event.GetValueForParameter (
320: p_name => 'PERSON_PARTY_ID',
321: p_parameterlist => l_registration_data.getParameterList);
322:
323: if (l_requested_for_party_id is not null) then

Line 489: l_registration_data wf_event_t;

485: l_justification WF_ACTIVITY_ATTRIBUTES.text_default%type;
486: l_reg_service_type WF_ACTIVITY_ATTRIBUTES.text_default%type;
487: l_mins WF_ACTIVITY_ATTRIBUTES.number_default%type;
488: l_days WF_ACTIVITY_ATTRIBUTES.number_default%type;
489: l_registration_data wf_event_t;
490: l_person_party_id hz_parties.party_id%type;
491:
492: x_return_status varchar2 (10);
493: x_msg_count number;

Line 625: l_person_party_id := wf_event.GetValueForParameter (

621: -- Get the formatted name from person party id
622: -- Get the person party id from the event message
623: l_registration_data :=
624: wf_engine.getitemattrevent (item_type, item_key, 'REGISTRATION_DATA');
625: l_person_party_id := wf_event.GetValueForParameter (
626: p_name => 'PERSON_PARTY_ID',
627: p_parameterlist => l_registration_data.getParameterList);
628: if (l_person_party_id is null) then
629: x_formatted_name := l_username;

Line 827: l_event wf_event_t;

823: l_ame_application_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
824: l_reg_request_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
825: l_rejection_reason WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
826: l_current_approver ame_util.approverRecord2;
827: l_event wf_event_t;
828: l_status varchar2 (15);
829:
830: BEGIN
831: