eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_APPROVAL_SS dependencies on WF_NOTIFICATION

Line 220: from wf_notification_attributes

216:
217: if ( funmode = 'RESPOND' ) then
218: select text_value
219: into lv_result_code
220: from wf_notification_attributes
221: where notification_id=wf_engine.context_nid
222: and name='RESULT';
223:
224: begin

Line 237: from wf_notification_attributes

233: -- WF_NOTE
234: begin
235: select text_value
236: into lv_comments
237: from wf_notification_attributes
238: where notification_id=wf_engine.context_nid
239: and name='WF_NOTE';
240: exception
241: when others then

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 2279: from wf_notification_attributes

2275: --sturlapa coding starts for bug 3866581
2276: begin
2277: select text_value
2278: into lv_result_code
2279: from wf_notification_attributes
2280: where notification_id=wf_engine.context_nid
2281: and name='RESULT';
2282:
2283: if(funmode='RESPOND' and lv_result_code='RESUBMIT') Then

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 3298: wf_notification.setattrtext(p_approval_notification_id,

3294:
3295:
3296: -- code logic to complete the approval notification with
3297: -- RETURNEDFORCORRECTION result
3298: wf_notification.setattrtext(p_approval_notification_id,
3299: 'RESULT',
3300: 'RETURNEDFORCORRECTION');
3301: BEGIN
3302: wf_notification.setattrtext(

Line 3302: wf_notification.setattrtext(

3298: wf_notification.setattrtext(p_approval_notification_id,
3299: 'RESULT',
3300: 'RETURNEDFORCORRECTION');
3301: BEGIN
3302: wf_notification.setattrtext(
3303: p_approval_notification_id
3304: ,'WF_NOTE'
3305: ,p_rfc_comments);
3306: EXCEPTION WHEN OTHERS THEN

Line 3308: wf_notification.propagatehistory(

3304: ,'WF_NOTE'
3305: ,p_rfc_comments);
3306: EXCEPTION WHEN OTHERS THEN
3307: -- RFC from SFL Other
3308: wf_notification.propagatehistory(
3309: p_item_type
3310: ,p_item_key
3311: ,'APPROVAL_NOTIFICATION'
3312: ,fnd_global.user_name

Line 3320: wf_notification.respond(p_approval_notification_id

3316: ,p_rfc_comments);
3317: END;
3318:
3319: -- now respond to the approval notification
3320: wf_notification.respond(p_approval_notification_id
3321: ,null
3322: ,fnd_global.user_name
3323: ,null);
3324:

Line 3351: wf_notification.setAttrText(

3347: null;
3348: end;
3349:
3350: -- Set the from attribute for RFC notification.
3351: wf_notification.setAttrText(
3352: nid => ln_rfc_notification_id
3353: ,aname => '#FROM_ROLE'
3354: ,avalue => fnd_global.user_name );
3355: -- processing logic for non AME

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 4458: from wf_notification_attributes wna

4454: p_approval_comments in varchar2)
4455: is
4456: cursor csr_wf_note_exists is
4457: select 1
4458: from wf_notification_attributes wna
4459: where notification_id = p_ntf_id
4460: and NAME = 'WF_NOTE';
4461: l_dummy number(1);
4462: begin

Line 4473: wf_notification.setattrtext( p_ntf_id,'WF_NOTE',p_approval_comments);

4469: open csr_wf_note_exists;
4470: fetch csr_wf_note_exists into l_dummy;
4471: if csr_wf_note_exists%found then
4472: -- Attribute exists so write into it
4473: wf_notification.setattrtext( p_ntf_id,'WF_NOTE',p_approval_comments);
4474: else
4475: -- Do we need to create the attribute ?
4476: -- Current implementation is a no-op
4477: null;

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:

Line 4541: wf_notification.setattrtext(

4537: null,
4538: fnd_global.user_name,
4539: p_approval_comments);
4540: -- complete the notification
4541: wf_notification.setattrtext(
4542: ln_notification_id
4543: ,'RESULT'
4544: ,'RESUBMIT');
4545:

Line 4550: wf_notification.respond(

4546: -- Fix for bug 4998216 starts
4547: update_comments(ln_notification_id,lr_hr_api_transaction_rec.status,p_approval_comments);
4548: -- Fix for bug 4998216 ends
4549:
4550: wf_notification.respond(
4551: ln_notification_id
4552: ,p_approval_comments
4553: ,fnd_global.user_name
4554: ,null);

Line 4558: wf_notification.propagatehistory(

4554: ,null);
4555: -- Fix for 5070814
4556: if(lr_hr_api_transaction_rec.status in ('RI','RIS','RO','RIS')) then
4557: -- propagate during RFC only
4558: wf_notification.propagatehistory(
4559: lr_hr_api_transaction_rec.item_type
4560: ,lr_hr_api_transaction_rec.item_key
4561: ,'APPROVAL_NOTIFICATION'
4562: ,fnd_global.user_name