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_ITEMS

Line 319: FROM wf_items

315: END IF;
316:
317: BEGIN
318: SELECT 'Y' INTO l_wf_exists
319: FROM wf_items
320: WHERE item_type = l_item_type
321: AND item_key = l_item_key;
322:
323: l_wf_exists := 'Y';

Line 3232: from WF_PROCESS_ACTIVITIES WPA, WF_ACTIVITIES WA, wf_items wi

3228: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start isOldProcess');
3229:
3230: select wa.result_type
3231: into l_resultType
3232: from WF_PROCESS_ACTIVITIES WPA, WF_ACTIVITIES WA, wf_items wi
3233: where WPA.INSTANCE_ID = p_actid
3234: and WPA.ACTIVITY_ITEM_TYPE = WA.ITEM_TYPE
3235: and WPA.ACTIVITY_NAME = WA.NAME
3236: and wi.begin_date >= WA.BEGIN_DATE

Line 5367: l_end_date wf_items.end_date%TYPE;

5363: IS
5364: l_debug_info VARCHAR2(200);
5365: l_wf_active BOOLEAN := FALSE;
5366: l_wf_exist BOOLEAN := FALSE;
5367: l_end_date wf_items.end_date%TYPE;
5368: l_childItemKeySeq NUMBER;
5369: l_childItemKey varchar2(30);
5370: l_itemkey varchar2(30);
5371: l_itemtype varchar2(30);

Line 5444: from wf_items

5440:
5441: begin
5442: select end_date
5443: into l_end_date
5444: from wf_items
5445: where item_type = l_itemtype
5446: and item_key = l_childItemKey;
5447:
5448: if l_end_date is NULL then

Line 10344: l_itemkey wf_items.item_key%TYPE;

10340: l_new_language fnd_languages.nls_language%type := null;
10341:
10342: C_WF_Version NUMBER := 0;
10343:
10344: l_itemkey wf_items.item_key%TYPE;
10345: l_approvalProcessCompleteYNOut varchar2(1);
10346: l_nextApproversOut ame_util.approversTable2;
10347: l_ApproverAuthority varchar2(10);
10348: l_oldApproversOut ame_util.approversTable2;

Line 10353: l_temp_item_key wf_items.item_key%TYPE := p_item_key;

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);
10357:

Line 11642: l_itemkey wf_items.item_key%TYPE;

11638:
11639: PROCEDURE WithdrawExpenseRep(
11640: p_rep_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE)
11641: IS
11642: l_itemkey wf_items.item_key%TYPE;
11643: l_itemtype wf_items.item_type%TYPE := 'APEXP';
11644: l_document_number AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;
11645: l_doc_cctr VARCHAR2(2000);
11646: l_preparer_name VARCHAR2(2000);

Line 11643: l_itemtype wf_items.item_type%TYPE := 'APEXP';

11639: PROCEDURE WithdrawExpenseRep(
11640: p_rep_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE)
11641: IS
11642: l_itemkey wf_items.item_key%TYPE;
11643: l_itemtype wf_items.item_type%TYPE := 'APEXP';
11644: l_document_number AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;
11645: l_doc_cctr VARCHAR2(2000);
11646: l_preparer_name VARCHAR2(2000);
11647: l_employee_name VARCHAR2(2000);

Line 11656: l_end_date wf_items.end_date%TYPE;

11652: l_payment_due VARCHAR2(100);
11653: l_debug_info VARCHAR2(200);
11654: l_wf_active BOOLEAN := FALSE;
11655: l_wf_exist BOOLEAN := FALSE;
11656: l_end_date wf_items.end_date%TYPE;
11657: l_AMEEnabled VARCHAR2(1);
11658: l_receipts_status VARCHAR2(30);
11659:
11660: l_entered_by NUMBER := fnd_global.user_id;

Line 11681: from wf_items

11677: l_itemkey := to_char(p_rep_header_id);
11678: begin
11679: select end_date
11680: into l_end_date
11681: from wf_items
11682: where item_type = l_itemtype
11683: and item_key = l_itemkey;
11684:
11685: if l_end_date is NULL then

Line 16028: l_item_type wf_items.item_type%type;

16024: p_user_name IN VARCHAR2) RETURN VARCHAR2
16025: ------------------------------------------------------------------------
16026: IS
16027:
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;

Line 16029: l_item_key wf_items.item_key%type;

16025: ------------------------------------------------------------------------
16026: IS
16027:
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:

Line 16030: l_temp_item_key wf_items.item_key%type;

16026: IS
16027:
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

Line 16173: l_childItemKey wf_items.item_key%type;

16169: l_approvalProcessCompleteYNOut varchar2(1);
16170: l_nextApproversOut ame_util.approversTable2;
16171:
16172: l_childItemKeySeq number;
16173: l_childItemKey wf_items.item_key%type;
16174: l_child_item_key wf_items.item_key%type;
16175: l_masterUserKey wf_items.user_key%type;
16176:
16177: l_manager_name wf_users.name%type;

Line 16174: l_child_item_key wf_items.item_key%type;

16170: l_nextApproversOut ame_util.approversTable2;
16171:
16172: l_childItemKeySeq number;
16173: l_childItemKey wf_items.item_key%type;
16174: l_child_item_key wf_items.item_key%type;
16175: l_masterUserKey wf_items.user_key%type;
16176:
16177: l_manager_name wf_users.name%type;
16178: l_manager_display_name wf_users.display_name%type;

Line 16175: l_masterUserKey wf_items.user_key%type;

16171:
16172: l_childItemKeySeq number;
16173: l_childItemKey wf_items.item_key%type;
16174: l_child_item_key wf_items.item_key%type;
16175: l_masterUserKey wf_items.user_key%type;
16176:
16177: l_manager_name wf_users.name%type;
16178: l_manager_display_name wf_users.display_name%type;
16179: