APPS.AP_WEB_EXPENSE_WF dependencies on WF_NOTIFICATIONS

Line 10895: l_payable_admin wf_notifications.recipient_role%TYPE;

10891: l_doc_cctr VARCHAR2(2000);
10892: l_preparer_name VARCHAR2(2000);
10893: l_employee_name VARCHAR2(2000);
10894: l_purpose VARCHAR2(2400);
10895: l_payable_admin wf_notifications.recipient_role%TYPE;
10896: l_currency VARCHAR2(50);
10897: l_total VARCHAR2(200);
10898: l_payment_due VARCHAR2(100);
10899: l_debug_info VARCHAR2(200);

Line 14421: FROM wf_notifications

14417: IF ( l_ame_enabled <> 'Y' ) THEN
14418:
14419: BEGIN
14420: SELECT recipient_role INTO l_user_name
14421: FROM wf_notifications
14422: WHERE message_type = 'APEXP'
14423: AND message_name = 'OIE_REQ_EXPENSE_REPORT_APPRVL'
14424: AND ( item_key = p_item_key
14425: OR p_item_key = SubStr(context,7,length(p_item_key)) )

Line 15066: l_user_name wf_notifications.recipient_role%type;

15062:
15063: l_item_type wf_items.item_type%type;
15064: l_item_key wf_items.item_key%type;
15065: l_access_granted varchar2(1) := 'N';
15066: l_user_name wf_notifications.recipient_role%type;
15067:
15068: BEGIN
15069:
15070: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start CheckAccess');

Line 15075: from wf_notifications

15071:
15072: -- get the item type for the notif
15073: select message_type
15074: into l_item_type
15075: from wf_notifications
15076: where notification_id = p_ntf_id
15077: and rownum = 1;
15078:
15079: -- check the following:

Line 15162: from wf_notifications wfn ,

15158: /*
15159: -- 2. User has access to the NtfId
15160: select 'Y'
15161: into l_access_granted
15162: from wf_notifications wfn ,
15163: WF_USER_ROLES wur
15164: where wur.user_name = p_user_name
15165: and wfn.notification_id = p_ntf_id
15166: and ( wfn.recipient_role = wur.role_name

Line 16143: l_context wf_notifications.context%type;

16139: RETURN l_ExpAccountsUpdated;
16140: END IsExpAccountsUpdated;
16141:
16142: FUNCTION getItemKey(p_notification_id IN NUMBER) RETURN VARCHAR2 IS
16143: l_context wf_notifications.context%type;
16144: l_temp_context wf_notifications.context%type;
16145: l_item_key wf_notifications.context%type;
16146: l_debug_info varchar2(200);
16147: BEGIN

Line 16144: l_temp_context wf_notifications.context%type;

16140: END IsExpAccountsUpdated;
16141:
16142: FUNCTION getItemKey(p_notification_id IN NUMBER) RETURN VARCHAR2 IS
16143: l_context wf_notifications.context%type;
16144: l_temp_context wf_notifications.context%type;
16145: l_item_key wf_notifications.context%type;
16146: l_debug_info varchar2(200);
16147: BEGIN
16148: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start getItemKey');

Line 16145: l_item_key wf_notifications.context%type;

16141:
16142: FUNCTION getItemKey(p_notification_id IN NUMBER) RETURN VARCHAR2 IS
16143: l_context wf_notifications.context%type;
16144: l_temp_context wf_notifications.context%type;
16145: l_item_key wf_notifications.context%type;
16146: l_debug_info varchar2(200);
16147: BEGIN
16148: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start getItemKey');
16149:

Line 16151: from wf_notifications

16147: BEGIN
16148: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start getItemKey');
16149:
16150: select context into l_context
16151: from wf_notifications
16152: where notification_id = p_notification_id;
16153:
16154: --l_context would have something like 'APEXP:22591-2:579934'
16155: