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 2247: notification_rec.user_comments := wf_notification.getattrtext(

2243:
2244: notification_rec.notification_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
2245: itemkey => p_item_key,
2246: aname => 'HR_CONTEXT_NID_ATTR');
2247: notification_rec.user_comments := wf_notification.getattrtext(
2248: notification_rec.notification_id
2249: ,'WF_NOTE');
2250:
2251: l_is_parallel := wf_engine.GetItemAttrText(itemtype => p_item_type ,

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

3075: --sturlapa coding starts for bug 3866581
3076: begin
3077: select text_value
3078: into lv_result_code
3079: from wf_notification_attributes
3080: where notification_id=wf_engine.context_nid
3081: and name='RESULT';
3082:
3083: if(funmode='RESPOND' and lv_result_code='RESUBMIT') Then

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

4305:
4306:
4307: -- code logic to complete the approval notification with
4308: -- RETURNEDFORCORRECTION result
4309: wf_notification.setattrtext(p_approval_notification_id,
4310: 'RESULT',
4311: 'RETURNEDFORCORRECTION');
4312: BEGIN
4313: wf_notification.setattrtext(

Line 4313: wf_notification.setattrtext(

4309: wf_notification.setattrtext(p_approval_notification_id,
4310: 'RESULT',
4311: 'RETURNEDFORCORRECTION');
4312: BEGIN
4313: wf_notification.setattrtext(
4314: p_approval_notification_id
4315: ,'WF_NOTE'
4316: ,p_rfc_comments);
4317: EXCEPTION WHEN OTHERS THEN

Line 4319: wf_notification.propagatehistory(

4315: ,'WF_NOTE'
4316: ,p_rfc_comments);
4317: EXCEPTION WHEN OTHERS THEN
4318: -- RFC from SFL Other
4319: wf_notification.propagatehistory(
4320: p_item_type
4321: ,p_item_key
4322: ,'APPROVAL_NOTIFICATION'
4323: ,fnd_global.user_name

Line 4331: wf_notification.respond(p_approval_notification_id

4327: ,p_rfc_comments);
4328: END;
4329:
4330: -- now respond to the approval notification
4331: wf_notification.respond(p_approval_notification_id
4332: ,null
4333: ,fnd_global.user_name
4334: ,null);
4335:

Line 4362: wf_notification.setAttrText(

4358: null;
4359: end;
4360:
4361: -- Set the from attribute for RFC notification.
4362: wf_notification.setAttrText(
4363: nid => ln_rfc_notification_id
4364: ,aname => '#FROM_ROLE'
4365: ,avalue => fnd_global.user_name );
4366: -- processing logic for non AME

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

5495: p_approval_comments in varchar2)
5496: is
5497: cursor csr_wf_note_exists is
5498: select 1
5499: from wf_notification_attributes wna
5500: where notification_id = p_ntf_id
5501: and NAME = 'WF_NOTE';
5502: l_dummy number(1);
5503: begin

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

5510: open csr_wf_note_exists;
5511: fetch csr_wf_note_exists into l_dummy;
5512: if csr_wf_note_exists%found then
5513: -- Attribute exists so write into it
5514: wf_notification.setattrtext( p_ntf_id,'WF_NOTE',p_approval_comments);
5515: else
5516: -- Do we need to create the attribute ?
5517: -- Current implementation is a no-op
5518: null;

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 5586: wf_notification.setattrtext(

5582: null,
5583: fnd_global.user_name,
5584: p_approval_comments);
5585: -- complete the notification
5586: wf_notification.setattrtext(
5587: ln_notification_id
5588: ,'RESULT'
5589: ,'RESUBMIT');
5590:

Line 5595: wf_notification.respond(

5591: -- Fix for bug 4998216 starts
5592: update_comments(ln_notification_id,lr_hr_api_transaction_rec.status,p_approval_comments);
5593: -- Fix for bug 4998216 ends
5594:
5595: wf_notification.respond(
5596: ln_notification_id
5597: ,p_approval_comments
5598: ,fnd_global.user_name
5599: ,null);

Line 5603: wf_notification.propagatehistory(

5599: ,null);
5600: -- Fix for 5070814
5601: if(lr_hr_api_transaction_rec.status in ('RI','RIS','RO','RIS')) then
5602: -- propagate during RFC only
5603: wf_notification.propagatehistory(
5604: lr_hr_api_transaction_rec.item_type
5605: ,lr_hr_api_transaction_rec.item_key
5606: ,'APPROVAL_NOTIFICATION'
5607: ,fnd_global.user_name

Line 6058: notification_rec.user_comments := wf_notification.getattrtext(

6054:
6055: notification_rec.notification_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
6056: itemkey => p_item_key,
6057: aname => 'HR_CONTEXT_NID_ATTR');
6058: notification_rec.user_comments := wf_notification.getattrtext(
6059: notification_rec.notification_id
6060: ,'WF_NOTE');
6061:
6062: l_is_parallel := wf_engine.GetItemAttrText(itemtype => p_item_type ,

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);