DBA Data[Home] [Help]

APPS.ASO_PA_APR_WF_PVT dependencies on WF_NOTIFICATION

Line 1279: wf_notification.CANCEL (

1275: 1,
1276: 'N'
1277: );
1278: END IF;
1279: wf_notification.CANCEL (
1280: nid => l_notification_id,
1281: cancel_comment => 'TIMEOUT'
1282: );
1283: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 3651: l_notification_id := wf_notification.send(role =>p_role,

3647: where quote_header_id=l_qte_header_id;
3648:
3649: --pp_debug('quote number'||l_qte_number);
3650: --pp_debug('l_quote_name'||l_quote_name);
3651: l_notification_id := wf_notification.send(role =>p_role,
3652: msg_type => p_item_type,
3653: msg_name => p_message_name);
3654:
3655: --pp_debug('Notification id'||l_notification_id);

Line 3657: wf_notification.SetAttrText(nid =>l_notification_id,

3653: msg_name => p_message_name);
3654:
3655: --pp_debug('Notification id'||l_notification_id);
3656:
3657: wf_notification.SetAttrText(nid =>l_notification_id,
3658: aname=>'APPR_OBJ',
3659: avalue=>l_quote_name);
3660:
3661: wf_notification.SetAttrText(nid =>l_notification_id,

Line 3661: wf_notification.SetAttrText(nid =>l_notification_id,

3657: wf_notification.SetAttrText(nid =>l_notification_id,
3658: aname=>'APPR_OBJ',
3659: avalue=>l_quote_name);
3660:
3661: wf_notification.SetAttrText(nid =>l_notification_id,
3662: aname=> 'REQUEST_CANCELLOR_USERNAME',
3663: avalue =>p_cancellor_username);
3664: wf_notification.SetAttrText(nid =>l_notification_id,
3665: aname=> 'REQUEST_CANCELLOR_DISPLAYNAME',

Line 3664: wf_notification.SetAttrText(nid =>l_notification_id,

3660:
3661: wf_notification.SetAttrText(nid =>l_notification_id,
3662: aname=> 'REQUEST_CANCELLOR_USERNAME',
3663: avalue =>p_cancellor_username);
3664: wf_notification.SetAttrText(nid =>l_notification_id,
3665: aname=> 'REQUEST_CANCELLOR_DISPLAYNAME',
3666: avalue =>p_cancellor_displayname);
3667:
3668: wf_notification.SetAttrText (

Line 3668: wf_notification.SetAttrText (

3664: wf_notification.SetAttrText(nid =>l_notification_id,
3665: aname=> 'REQUEST_CANCELLOR_DISPLAYNAME',
3666: avalue =>p_cancellor_displayname);
3667:
3668: wf_notification.SetAttrText (
3669: nid =>l_notification_id,
3670: aname => 'REQUESTOR_DISPLAYNAME',
3671: avalue => p_from_displayname
3672: );

Line 3673: wf_notification.SetAttrText (

3669: nid =>l_notification_id,
3670: aname => 'REQUESTOR_DISPLAYNAME',
3671: avalue => p_from_displayname
3672: );
3673: wf_notification.SetAttrText (
3674: nid =>l_notification_id,
3675: aname => 'REQUESTOR_USERNAME',
3676: avalue => p_from_user_name
3677: );

Line 3679: wf_notification.SetAttrText(nid =>l_notification_id,

3675: aname => 'REQUESTOR_USERNAME',
3676: avalue => p_from_user_name
3677: );
3678:
3679: wf_notification.SetAttrText(nid =>l_notification_id,
3680: aname=> '#FROM_ROLE',
3681: avalue =>p_from_user_name);
3682:
3683: wf_notification.SetAttrText(nid =>l_notification_id,

Line 3683: wf_notification.SetAttrText(nid =>l_notification_id,

3679: wf_notification.SetAttrText(nid =>l_notification_id,
3680: aname=> '#FROM_ROLE',
3681: avalue =>p_from_user_name);
3682:
3683: wf_notification.SetAttrText(nid =>l_notification_id,
3684: aname=> 'OAPAAPPROVALRGN',
3685: avalue =>'JSP:/OA_HTML/OA.jsp?OAFunc=QOT_OAUI_PAPPVL_NOTIF&qotHdrId='||l_qte_header_id||'&qotReqName='||p_from_displayname||'&qotObjApvlId='||l_approval_id);
3686:
3687: select nvl(fnd_profile.value('ASO_QUOTE_APPROVER_RESP'),-1) into l_resp_id from dual;

Line 3706: wf_notification.SetAttrText

3702: END IF;
3703:
3704: --pp_debug('l_url: '||l_url);
3705:
3706: wf_notification.SetAttrText
3707: (nid =>l_notification_id,
3708: aname => 'OAQTEDETAILLNK',
3709: avalue => l_url
3710: );