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 2264: select ORIGINAL_RECIPIENT into original_forward_to_user from wf_notifications where notification_id = notification_rec.notification_id;

2260: end if;
2261:
2262: if(notification_rec.notification_id is not null) then
2263:
2264: select ORIGINAL_RECIPIENT into original_forward_to_user from wf_notifications where notification_id = notification_rec.notification_id;
2265:
2266: prll_ntf := wf_engine.getitemattrtext(p_item_type,
2267: p_item_key,
2268: 'PRLL_TRNSFR_DET',true);

Line 4121: from wf_notifications

4117: else
4118: -- get the original recipient role name
4119: select original_recipient
4120: into lv_user_name
4121: from wf_notifications
4122: where notification_id =p_notification_id;
4123:
4124: wf_directory.getroleorigsysinfo(lv_user_name,lv_orig_system,lv_orig_system_id);
4125: end if;

Line 4155: from wf_notifications

4151: else
4152: -- get the original recipient role name
4153: select original_recipient
4154: into lv_user_name
4155: from wf_notifications
4156: where notification_id =p_notification_id;
4157:
4158: wf_directory.getroleorigsysinfo(lv_user_name,lv_orig_system,lv_orig_system_id);
4159: end if;

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

4168:
4169: end getUserOrigSystemId;
4170:
4171:
4172: procedure handleRFCAction(p_approval_notification_id in wf_notifications.notification_id%type,
4173: p_transaction_id in hr_api_transactions.transaction_id%type,
4174: p_item_type in wf_items.item_type%type,
4175: p_item_key in wf_items.item_key%type,
4176: p_rfcRoleName in wf_roles.name%type,

Line 4184: ln_rfc_notification_id wf_notifications.notification_id%type;

4180: p_approverIndex in number
4181: ) is
4182: -- local variables
4183: c_proc constant varchar2(30) := 'handleRFCAction';
4184: ln_rfc_notification_id wf_notifications.notification_id%type;
4185: l_lastDefaultApprover NUMBER;
4186: lv_dummy varchar2(10);
4187: lv_role_name wf_roles.name%type;
4188: lv_role_disp_name wf_roles.name%type;

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

4447: end if;
4448:
4449: end handleRFCAction;
4450:
4451: procedure handleRFCAction(p_approval_notification_id in wf_notifications.notification_id%type
4452: ) is
4453: lv_item_type wf_items.item_type%type;
4454: lv_item_key wf_items.item_key%type;
4455: lv_creator_role wf_roles.name%type;

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

4755:
4756: end appraisalRolesReInit;
4757:
4758:
4759: procedure reInitPerformerRoles(p_notification_id in wf_notifications.notification_id%type,
4760: p_transaction_id in hr_api_transactions.transaction_id%type,
4761: p_item_type in wf_items.item_type%type,
4762: p_item_key in wf_items.item_key%type) is
4763: c_proc constant varchar2(30) := 'reInitPerformerRoles';

Line 4780: from wf_notifications

4776: select substr(context,1,instr(context,':',1)-1) itemtype
4777: ,substr(context,instr(context,':')+1, (
4778: instr(context,':',instr(context,':')+1 ) - instr(context,':')-1) ) itemkey
4779: into lv_item_type,lv_item_key
4780: from wf_notifications
4781: where notification_id = p_notification_id;
4782: exception
4783: when others then
4784: null;

Line 5390: ln_notification_id wf_notifications.notification_id%type;

5386: function getApproverNtfId(p_transaction_id in number) return number
5387: is
5388: c_proc constant varchar2(30) := 'getApproverNtfId';
5389: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
5390: ln_notification_id wf_notifications.notification_id%type;
5391: begin
5392: if(p_transaction_id is not null) then
5393: select * into lr_hr_api_transaction_rec
5394: from hr_api_transactions

Line 5534: ln_notification_id wf_notifications.notification_id%type;

5530: -- local variables
5531: c_proc constant varchar2(30) := 'processNonPageNavWFSubmit';
5532: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
5533: ln_activity_id wf_item_activity_statuses.process_activity%type;
5534: ln_notification_id wf_notifications.notification_id%type;
5535: lv_loginPersonDispName per_all_people_f.full_name%type;
5536: lv_loginPersonUserName fnd_user.user_name%type;
5537: ln_loginPersonId fnd_user.employee_id%type;
5538:

Line 6074: select ORIGINAL_RECIPIENT into original_forward_to_user from wf_notifications where notification_id = notification_rec.notification_id;

6070: hr_utility.set_location('Approval mode is parallel', 1);
6071: end if;
6072: if(notification_rec.notification_id is not null) then
6073:
6074: select ORIGINAL_RECIPIENT into original_forward_to_user from wf_notifications where notification_id = notification_rec.notification_id;
6075:
6076: prll_ntf := wf_engine.getitemattrtext(p_item_type,
6077: p_item_key,
6078: 'PRLL_TRNSFR_DET',true);