[Home] [Help]
9: -- Procedure
10: -- Check_Context
11: --
12: -- Description
13: -- populate the wf_local_roles table with information from workflow
14: -- IN
15: -- itemtype - A valid item type from (WF_ITEM_TYPES table).
16: -- itemkey - A string generated from the application object's primary key.
17: -- actid - The function activity (instance id).
115: -- Procedure
116: -- Notification_process_done
117: --
118: -- Description
119: -- populate the wf_local_roles table with information from workflow
120: -- IN
121: -- itemtype - A valid item type from (WF_ITEM_TYPES table).
122: -- itemkey - A string generated from the application object's primary key.
123: -- actid - The function activity (instance id).
200: -- Procedure
201: -- GetNextApprover
202: --
203: -- Description
204: -- populate the wf_local_roles table with information from workflow
205: -- IN
206: -- itemtype - A valid item type from (WF_ITEM_TYPES table).
207: -- itemkey - A string generated from the application object's primary key.
208: -- actid - The function activity (instance id).
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;
230: l_person_middle_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
231: l_prefix WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
231: l_prefix WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
232: l_suffix WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
233: l_return_status varchar2 (10);
234: l_requester_email_address fnd_user.email_address%type;
235: l_role_display_name wf_local_roles.display_name%type;
236: l_reg_service_type WF_ACTIVITY_ATTRIBUTES.text_default%type;
237:
238: l_msg_count number;
239: l_msg_data varchar2 (280);
911: -- Procedure
912: -- query_role_display_name
913: --
914: -- Description
915: -- query the wf_local_roles table for role_display_name
916: -- also query the username for this request if it was not passed (ART,SMART)
917: -- IN
918: -- itemtype - A valid item type from (WF_ITEM_TYPES table).
919: -- itemkey - A string generated from the application object's primary key.
926: activity_id in number,
927: command in varchar2,
928: resultout out NOCOPY varchar2) is
929:
930: l_role_name wf_local_roles.name%type;
931: l_role_display_name wf_all_roles_vl.display_name%type;
932:
933: BEGIN
934: