APPS.PON_AUCTION_APPROVAL_PKG dependencies on WF_NOTIFICATION

Line 88: FROM wf_notifications

84: SELECT SUBSTR(context,1,INSTR(context,':',1)-1),
85: SUBSTR(context,INSTR(context,':')+1,
86: (INSTR(context,':',1,2) - INSTR(context,':')-1)),
87: message_name
88: FROM wf_notifications
89: WHERE notification_id = pn_notification_id;
90:
91: p_itemtype WF_ITEM_ACTIVITY_STATUSES.item_type%TYPE; -- VARCHAR2(8)
92: p_itemkey WF_ITEM_ACTIVITY_STATUSES.item_key%TYPE; -- VARCHAR2(240)

Line 94: p_message_name wf_notifications.message_name%TYPE;

90:
91: p_itemtype WF_ITEM_ACTIVITY_STATUSES.item_type%TYPE; -- VARCHAR2(8)
92: p_itemkey WF_ITEM_ACTIVITY_STATUSES.item_key%TYPE; -- VARCHAR2(240)
93:
94: p_message_name wf_notifications.message_name%TYPE;
95:
96: BEGIN
97:
98:

Line 106: -- then parse the wf_notifications.context field to

102: FETCH wf_item_cur INTO p_itemtype, p_itemkey;
103: CLOSE wf_item_cur;
104:
105: -- If the wf_item_activity_statuses does not contain an entry,
106: -- then parse the wf_notifications.context field to
107: -- get the item_type and item_key values for a given notification_id.
108: IF ((p_itemtype IS NULL) AND (p_itemkey IS NULL))
109: THEN
110: OPEN wf_notif_context_cur;

Line 270: WF_Notification.cancel(l_nid);

266: where ASSIGNED_USER = p_user_name
267: and ITEM_TYPE = l_itemType
268: and ITEM_KEY = l_itemkey
269: and activity_status ='NOTIFIED';
270: WF_Notification.cancel(l_nid);
271: exception
272: when others then
273: p_resultOut := 1; -- unexpected
274: end;

Line 337: wf_notification.SetAttrText(l_nid, 'RESULT',p_result);

333: User_Decision_Without_WF(l_user_id, p_result, p_note_to_buyer,
334: p_auction_header_id);
335: return;
336: end;
337: wf_notification.SetAttrText(l_nid, 'RESULT',p_result);
338: wf_notification.SetAttrText(l_nid, 'APPROVER_NOTES',p_note_to_buyer);
339: --added by amundhra for federal CLM
340: --added signed date setting the item attribute date.
341:

Line 338: wf_notification.SetAttrText(l_nid, 'APPROVER_NOTES',p_note_to_buyer);

334: p_auction_header_id);
335: return;
336: end;
337: wf_notification.SetAttrText(l_nid, 'RESULT',p_result);
338: wf_notification.SetAttrText(l_nid, 'APPROVER_NOTES',p_note_to_buyer);
339: --added by amundhra for federal CLM
340: --added signed date setting the item attribute date.
341:
342: SELECT wf_approval_item_key

Line 353: WF_Notification.respond(l_nid,p_result,p_user_name);

349: wf_engine.SetItemAttrDate(l_itemType,l_itemKey, 'SIGNED_DATE', p_signed_date);
350:
351: wf_engine.SetItemAttrDate(l_itemType,l_item_key_main_process, 'SIGNED_DATE', p_signed_date);
352:
353: WF_Notification.respond(l_nid,p_result,p_user_name);
354: exception
355: when others then
356: p_resultOut := 1; -- unexpected
357: end;

Line 372: WF_Notification.cancel(r1.notification_id);

368: l_item_type Varchar2(30) := 'PONAPPRV';
369: begin
370: for r1 in List_of_Process(l_item_type,p_parent_item_key) loop
371: begin
372: WF_Notification.cancel(r1.notification_id);
373:
374: --Bug 9386801
375: --Uncommenting the CompleteActivity because of which
376: --workflow was not ending and resulting in unneeded reminder