APPS.HR_APPROVAL_SS dependencies on WF_NOTIFICATIONS

Line 366: from wf_notifications

362: --Collect the username for whom timeout happened
363: begin
364: select RECIPIENT_ROLE
365: into lv_recipient
366: from wf_notifications
367: where notification_id=wf_engine.context_nid;
368: exception
369: when others then
370: null;

Line 3110: from wf_notifications

3106: else
3107: -- get the original recipient role name
3108: select original_recipient
3109: into lv_user_name
3110: from wf_notifications
3111: where notification_id =p_notification_id;
3112:
3113: wf_directory.getroleorigsysinfo(lv_user_name,lv_orig_system,lv_orig_system_id);
3114: end if;

Line 3144: from wf_notifications

3140: else
3141: -- get the original recipient role name
3142: select original_recipient
3143: into lv_user_name
3144: from wf_notifications
3145: where notification_id =p_notification_id;
3146:
3147: wf_directory.getroleorigsysinfo(lv_user_name,lv_orig_system,lv_orig_system_id);
3148: end if;

Line 3161: procedure handleRFCAction(p_approval_notification_id in wf_notifications.notification_id%type,

3157:
3158: end getUserOrigSystemId;
3159:
3160:
3161: procedure handleRFCAction(p_approval_notification_id in wf_notifications.notification_id%type,
3162: p_transaction_id in hr_api_transactions.transaction_id%type,
3163: p_item_type in wf_items.item_type%type,
3164: p_item_key in wf_items.item_key%type,
3165: p_rfcRoleName in wf_roles.name%type,

Line 3173: ln_rfc_notification_id wf_notifications.notification_id%type;

3169: p_approverIndex in number
3170: ) is
3171: -- local variables
3172: c_proc constant varchar2(30) := 'handleRFCAction';
3173: ln_rfc_notification_id wf_notifications.notification_id%type;
3174: l_lastDefaultApprover NUMBER;
3175: lv_dummy varchar2(10);
3176: lv_role_name wf_roles.name%type;
3177: lv_role_disp_name wf_roles.name%type;

Line 3440: procedure handleRFCAction(p_approval_notification_id in wf_notifications.notification_id%type

3436: end if;
3437:
3438: end handleRFCAction;
3439:
3440: procedure handleRFCAction(p_approval_notification_id in wf_notifications.notification_id%type
3441: ) is
3442: lv_item_type wf_items.item_type%type;
3443: lv_item_key wf_items.item_key%type;
3444: lv_creator_role wf_roles.name%type;

Line 3732: procedure reInitPerformerRoles(p_notification_id in wf_notifications.notification_id%type,

3728:
3729: end appraisalRolesReInit;
3730:
3731:
3732: procedure reInitPerformerRoles(p_notification_id in wf_notifications.notification_id%type,
3733: p_transaction_id in hr_api_transactions.transaction_id%type,
3734: p_item_type in wf_items.item_type%type,
3735: p_item_key in wf_items.item_key%type) is
3736: c_proc constant varchar2(30) := 'reInitPerformerRoles';

Line 3753: from wf_notifications

3749: select substr(context,1,instr(context,':',1)-1) itemtype
3750: ,substr(context,instr(context,':')+1, (
3751: instr(context,':',instr(context,':')+1 ) - instr(context,':')-1) ) itemkey
3752: into lv_item_type,lv_item_key
3753: from wf_notifications
3754: where notification_id = p_notification_id;
3755: exception
3756: when others then
3757: null;

Line 4349: ln_notification_id wf_notifications.notification_id%type;

4345: function getApproverNtfId(p_transaction_id in number) return number
4346: is
4347: c_proc constant varchar2(30) := 'getApproverNtfId';
4348: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
4349: ln_notification_id wf_notifications.notification_id%type;
4350: begin
4351: if(p_transaction_id is not null) then
4352: select * into lr_hr_api_transaction_rec
4353: from hr_api_transactions

Line 4493: ln_notification_id wf_notifications.notification_id%type;

4489: -- local variables
4490: c_proc constant varchar2(30) := 'processNonPageNavWFSubmit';
4491: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
4492: ln_activity_id wf_item_activity_statuses.process_activity%type;
4493: ln_notification_id wf_notifications.notification_id%type;
4494: lv_loginPersonDispName per_all_people_f.full_name%type;
4495: lv_loginPersonUserName fnd_user.user_name%type;
4496: ln_loginPersonId fnd_user.employee_id%type;
4497: