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.AP_WEB_EXPENSE_WF dependencies on WF_NOTIFICATIONS

Line 10352: l_message_name wf_notifications.message_name%type;

10348: l_oldApproversOut ame_util.approversTable2;
10349: -- Bug: 7463317
10350: l_approvers ame_util.approversTable2;
10351: l_approvalProcessCompleteYN varchar2(20) := ame_util.booleanFalse;
10352: l_message_name wf_notifications.message_name%type;
10353: l_temp_item_key wf_items.item_key%TYPE := p_item_key;
10354: l_n_org_id Number;
10355: l_temp_entered_by NUMBER;
10356: l_temp_user_name VARCHAR2(200);

Line 10412: from wf_notifications

10408: l_notificationID := wf_engine.context_nid;
10409:
10410: select message_name
10411: into l_message_name
10412: from wf_notifications
10413: where notification_id = l_notificationID;
10414:
10415: if (l_message_name = 'OIE_AME_EXPENSE_REPORT_APPRVL' OR
10416: l_message_name = 'OIE_REQ_EXPENSE_REPORT_APPRVL') then

Line 10522: FROM wf_notifications

10518: l_debug_info := 'Get User info from notif';
10519: ---------------------------------------------------------------------
10520: BEGIN
10521: SELECT NVL(MORE_INFO_ROLE, RECIPIENT_ROLE) INTO l_temp_user_name
10522: FROM wf_notifications
10523: WHERE notification_id = l_notificationID;
10524:
10525: SELECT user_id INTO l_temp_entered_by FROM fnd_user WHERE user_name = l_temp_user_name;
10526: l_entered_by := l_temp_entered_by;

Line 11649: l_payable_admin wf_notifications.recipient_role%TYPE;

11645: l_doc_cctr VARCHAR2(2000);
11646: l_preparer_name VARCHAR2(2000);
11647: l_employee_name VARCHAR2(2000);
11648: l_purpose VARCHAR2(2400);
11649: l_payable_admin wf_notifications.recipient_role%TYPE;
11650: l_currency VARCHAR2(50);
11651: l_total VARCHAR2(200);
11652: l_payment_due VARCHAR2(100);
11653: l_debug_info VARCHAR2(200);

Line 15326: FROM wf_notifications

15322: IF ( l_ame_enabled <> 'Y' ) THEN
15323:
15324: BEGIN
15325: SELECT recipient_role INTO l_user_name
15326: FROM wf_notifications
15327: WHERE message_type = 'APEXP'
15328: AND message_name = 'OIE_REQ_EXPENSE_REPORT_APPRVL'
15329: AND ( item_key = p_item_key
15330: OR p_item_key = SubStr(context,7,length(p_item_key)) )

Line 15366: FROM wf_notifications

15362: -- l_entered_by);
15363:
15364: BEGIN
15365: SELECT recipient_role INTO l_user_name
15366: FROM wf_notifications
15367: WHERE message_type = 'APEXP'
15368: AND message_name = 'OIE_REQUEST_EMPLOYEE_APPROVAL'
15369: AND ( item_key = p_item_key
15370: OR p_item_key = SubStr(context,7,length(p_item_key)) )

Line 16032: l_user_name wf_notifications.recipient_role%type;

16028: l_item_type wf_items.item_type%type;
16029: l_item_key wf_items.item_key%type;
16030: l_temp_item_key wf_items.item_key%type;
16031: l_access_granted varchar2(1) := 'N';
16032: l_user_name wf_notifications.recipient_role%type;
16033:
16034: BEGIN
16035:
16036: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start CheckAccess');

Line 16041: from wf_notifications

16037:
16038: -- get the item type for the notif
16039: select message_type, item_key
16040: into l_item_type, l_temp_item_key
16041: from wf_notifications
16042: where notification_id = p_ntf_id
16043: and rownum = 1;
16044:
16045: -- check the following:

Line 16128: from wf_notifications wfn ,

16124: /*
16125: -- 2. User has access to the NtfId
16126: select 'Y'
16127: into l_access_granted
16128: from wf_notifications wfn ,
16129: WF_USER_ROLES wur
16130: where wur.user_name = p_user_name
16131: and wfn.notification_id = p_ntf_id
16132: and ( wfn.recipient_role = wur.role_name

Line 16194: l_end_date wf_notifications.end_date%TYPE;

16190: l_employee_id NUMBER;
16191: l_continue BOOLEAN := TRUE;
16192: l_wf_active BOOLEAN := FALSE;
16193: l_wf_exist BOOLEAN := FALSE;
16194: l_end_date wf_notifications.end_date%TYPE;
16195: l_approver_exist varchar2(1) := 'N'; -- Bug 15928430
16196:
16197: BEGIN
16198:

Line 16251: from wf_notifications

16247: l_child_item_key := p_item_key || '-' || to_char(i);
16248: begin
16249: select end_date
16250: into l_end_date
16251: from wf_notifications
16252: where message_type = 'APEXP'
16253: and message_name = 'OIE_AME_EXPENSE_REPORT_APPRVL'
16254: and item_key = l_child_item_key;
16255: if l_end_date is NULL then

Line 17242: l_context wf_notifications.context%type;

17238: RETURN l_ExpAccountsUpdated;
17239: END IsExpAccountsUpdated;
17240:
17241: FUNCTION getItemKey(p_notification_id IN NUMBER) RETURN VARCHAR2 IS
17242: l_context wf_notifications.context%type;
17243: l_temp_context wf_notifications.context%type;
17244: l_item_key wf_notifications.context%type;
17245: l_debug_info varchar2(200);
17246: BEGIN

Line 17243: l_temp_context wf_notifications.context%type;

17239: END IsExpAccountsUpdated;
17240:
17241: FUNCTION getItemKey(p_notification_id IN NUMBER) RETURN VARCHAR2 IS
17242: l_context wf_notifications.context%type;
17243: l_temp_context wf_notifications.context%type;
17244: l_item_key wf_notifications.context%type;
17245: l_debug_info varchar2(200);
17246: BEGIN
17247: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start getItemKey');

Line 17244: l_item_key wf_notifications.context%type;

17240:
17241: FUNCTION getItemKey(p_notification_id IN NUMBER) RETURN VARCHAR2 IS
17242: l_context wf_notifications.context%type;
17243: l_temp_context wf_notifications.context%type;
17244: l_item_key wf_notifications.context%type;
17245: l_debug_info varchar2(200);
17246: BEGIN
17247: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start getItemKey');
17248:

Line 17250: from wf_notifications

17246: BEGIN
17247: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start getItemKey');
17248:
17249: select context into l_context
17250: from wf_notifications
17251: where notification_id = p_notification_id;
17252:
17253: --l_context would have something like 'APEXP:22591-2:579934'
17254: