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_SFLUTIL_SS dependencies on WF_NOTIFICATION

Line 127: wf_notifications ntf

123:
124: cursor sflNotificationsCursor is
125: select ias.notification_id notification_id
126: from wf_item_activity_statuses ias,
127: wf_notifications ntf
128: where ias.item_type = itemtype
129: and ias.item_key =itemkey
130: and ias.notification_id is not null
131: and ntf.notification_id = ias.notification_id

Line 136: wf_notifications ntf

132: and ntf.status='OPEN'
133: union
134: select ias.notification_id notification_id
135: from wf_item_activity_statuses_h ias,
136: wf_notifications ntf
137: where ias.notification_id is not null
138: and ias.item_type = itemtype
139: and ias.item_key =itemkey
140: and ntf.notification_id = ias.notification_id

Line 161: wf_notification.close(ntfrow.notification_id,'SYSADMIN');

157:
158: begin
159: -- close all notifications pertaining to this transaction
160: for ntfrow in sflNotificationsCursor loop
161: wf_notification.close(ntfrow.notification_id,'SYSADMIN');
162: end loop;
163: exception
164: when others then
165: -- close the cursor

Line 193: from wf_notifications

189: select 1
190: into dummy
191: from sys.dual
192: where exists ( select null
193: from wf_notifications
194: where notification_id = nid
195: and status = 'OPEN'
196: );
197: --

Line 241: comments wf_notifications .user_comment%type;

237:
238: colon pls_integer;
239: avalue varchar2(240);
240: notid pls_integer;
241: comments wf_notifications .user_comment%type;
242: document varchar2(240);
243: document_type varchar2(240);
244: ln_notification_id number;
245: begin

Line 255: wf_notification.close(ln_notification_id,'SYSADMIN');

251:
252: -- close the existing ntf id if any for this transaction
253: ln_notification_id :=wf_engine.getitemattrnumber(itemtype,itemkey,'HR_LAST_SFL_NTF_ID_ATTR',true);
254: if(ln_notification_id is not null and OpenNotificationsExist(ln_notification_id))then
255: wf_notification.close(ln_notification_id,'SYSADMIN');
256: end if;
257:
258:
259: --PERFORMER

Line 341: --ln_transaction_id := wf_notification.GetAttrNumber(document_id,'HR_SFL_TRANSACTION_REF_ID_ATTR');

337: if g_debug then
338: hr_utility.set_location('Calling hr_workflow_ss.get_item_type_and_key for NtfId:'||document_id, 11);
339: end if;
340: -- get the transaction id corresponding to this SFL notification, HR_SFL_TRANSACTION_REF_ID_ATTR
341: --ln_transaction_id := wf_notification.GetAttrNumber(document_id,'HR_SFL_TRANSACTION_REF_ID_ATTR');
342: ln_transaction_id := wf_notification.GetAttrNumber(document_id,'HR_TRANSACTION_REF_ID_ATTR');
343:
344: --document := getSubject(ln_transaction_id,null);
345: -- set the document type

Line 342: ln_transaction_id := wf_notification.GetAttrNumber(document_id,'HR_TRANSACTION_REF_ID_ATTR');

338: hr_utility.set_location('Calling hr_workflow_ss.get_item_type_and_key for NtfId:'||document_id, 11);
339: end if;
340: -- get the transaction id corresponding to this SFL notification, HR_SFL_TRANSACTION_REF_ID_ATTR
341: --ln_transaction_id := wf_notification.GetAttrNumber(document_id,'HR_SFL_TRANSACTION_REF_ID_ATTR');
342: ln_transaction_id := wf_notification.GetAttrNumber(document_id,'HR_TRANSACTION_REF_ID_ATTR');
343:
344: --document := getSubject(ln_transaction_id,null);
345: -- set the document type
346: document_type := wf_notification.doc_html;

Line 346: document_type := wf_notification.doc_html;

342: ln_transaction_id := wf_notification.GetAttrNumber(document_id,'HR_TRANSACTION_REF_ID_ATTR');
343:
344: --document := getSubject(ln_transaction_id,null);
345: -- set the document type
346: document_type := wf_notification.doc_html;
347: -- default ouptut
348: document :=ln_transaction_id;
349:
350: if (ln_transaction_id is not null) then

Line 607: return wf_notification.getsubject(p_notification_id,'text/plain');

603:
604: lv_subject := p_transaction_id;
605: if(p_notification_id is not null) then
606: -- Fix for bug 13800538
607: return wf_notification.getsubject(p_notification_id,'text/plain');
608: else
609: return getActionSubject(p_transaction_id);
610: end if;
611:

Line 739: ln_notification_id wf_notifications.notification_id%type;

735: --
736: c_proc constant varchar2(30) := 'getSFLTransactionDetails';
737: lv_item_type wf_items.item_type%type;
738: lv_item_key wf_items.item_type%type;
739: ln_notification_id wf_notifications.notification_id%type;
740: lv_process_name wf_items.root_activity%type;
741: ln_sfl_block_activity_id number;
742: lv_relaunchSFLLink varchar2(2000);
743: begin

Line 1115: ln_notification_id wf_notifications.notification_id%type;

1111: c_proc constant varchar2(40) := 'closeOpenSFLNotification';
1112: lv_sfl_item_type wf_items.item_type%type;
1113: lv_sfl_item_key wf_items.item_key%type;
1114: ln_sfl_block_activity_id number;
1115: ln_notification_id wf_notifications.notification_id%type;
1116:
1117: begin
1118: g_debug := hr_utility.debug_enabled;
1119: if g_debug then

Line 1149: hr_utility.set_location(' calling wf_notification.close for:'||ln_notification_id, 4);

1145: true);
1146: hr_utility.set_location('sfl ln_notification_id:'||ln_notification_id, 4);
1147: if(ln_notification_id is not null and OpenNotificationsExist(ln_notification_id)) then
1148: -- close the FYI notification
1149: hr_utility.set_location(' calling wf_notification.close for:'||ln_notification_id, 4);
1150: wf_notification.close(ln_notification_id,null);
1151: end if;
1152:
1153: end if;

Line 1150: wf_notification.close(ln_notification_id,null);

1146: hr_utility.set_location('sfl ln_notification_id:'||ln_notification_id, 4);
1147: if(ln_notification_id is not null and OpenNotificationsExist(ln_notification_id)) then
1148: -- close the FYI notification
1149: hr_utility.set_location(' calling wf_notification.close for:'||ln_notification_id, 4);
1150: wf_notification.close(ln_notification_id,null);
1151: end if;
1152:
1153: end if;
1154: