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 3183: from WF_PROCESS_ACTIVITIES WPA, WF_ACTIVITIES WA, wf_items wi

3179: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start isOldProcess');
3180:
3181: select wa.result_type
3182: into l_resultType
3183: from WF_PROCESS_ACTIVITIES WPA, WF_ACTIVITIES WA, wf_items wi
3184: where WPA.INSTANCE_ID = p_actid
3185: and WPA.ACTIVITY_ITEM_TYPE = WA.ITEM_TYPE
3186: and WPA.ACTIVITY_NAME = WA.NAME
3187: and wi.begin_date >= WA.BEGIN_DATE

Line 5046: l_end_date wf_items.end_date%TYPE;

5042: IS
5043: l_debug_info VARCHAR2(200);
5044: l_wf_active BOOLEAN := FALSE;
5045: l_wf_exist BOOLEAN := FALSE;
5046: l_end_date wf_items.end_date%TYPE;
5047: l_childItemKeySeq NUMBER;
5048: l_childItemKey varchar2(30);
5049: l_itemkey varchar2(30);
5050: l_itemtype varchar2(30);

Line 5086: from wf_items

5082:
5083: begin
5084: select end_date
5085: into l_end_date
5086: from wf_items
5087: where item_type = l_itemtype
5088: and item_key = l_childItemKey;
5089:
5090: if l_end_date is NULL then

Line 9893: l_itemkey wf_items.item_key%TYPE;

9889: l_new_language fnd_languages.nls_language%type := null;
9890:
9891: C_WF_Version NUMBER := 0;
9892:
9893: l_itemkey wf_items.item_key%TYPE;
9894: l_approvalProcessCompleteYNOut varchar2(1);
9895: l_nextApproversOut ame_util.approversTable2;
9896: l_ApproverAuthority varchar2(10);
9897: l_oldApproversOut ame_util.approversTable2;

Line 10888: l_itemkey wf_items.item_key%TYPE;

10884:
10885: PROCEDURE WithdrawExpenseRep(
10886: p_rep_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE)
10887: IS
10888: l_itemkey wf_items.item_key%TYPE;
10889: l_itemtype wf_items.item_type%TYPE := 'APEXP';
10890: l_document_number AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;
10891: l_doc_cctr VARCHAR2(2000);
10892: l_preparer_name VARCHAR2(2000);

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

10885: PROCEDURE WithdrawExpenseRep(
10886: p_rep_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE)
10887: IS
10888: l_itemkey wf_items.item_key%TYPE;
10889: l_itemtype wf_items.item_type%TYPE := 'APEXP';
10890: l_document_number AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;
10891: l_doc_cctr VARCHAR2(2000);
10892: l_preparer_name VARCHAR2(2000);
10893: l_employee_name VARCHAR2(2000);

Line 10902: l_end_date wf_items.end_date%TYPE;

10898: l_payment_due VARCHAR2(100);
10899: l_debug_info VARCHAR2(200);
10900: l_wf_active BOOLEAN := FALSE;
10901: l_wf_exist BOOLEAN := FALSE;
10902: l_end_date wf_items.end_date%TYPE;
10903: l_AMEEnabled VARCHAR2(1);
10904: l_receipts_status VARCHAR2(30);
10905:
10906: l_entered_by NUMBER := fnd_global.user_id;

Line 10927: from wf_items

10923: l_itemkey := to_char(p_rep_header_id);
10924: begin
10925: select end_date
10926: into l_end_date
10927: from wf_items
10928: where item_type = l_itemtype
10929: and item_key = l_itemkey;
10930:
10931: if l_end_date is NULL then

Line 15063: l_item_type wf_items.item_type%type;

15059: p_user_name IN VARCHAR2) RETURN VARCHAR2
15060: ------------------------------------------------------------------------
15061: IS
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:

Line 15064: l_item_key wf_items.item_key%type;

15060: ------------------------------------------------------------------------
15061: IS
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

Line 15207: l_childItemKey wf_items.item_key%type;

15203: l_approvalProcessCompleteYNOut varchar2(1);
15204: l_nextApproversOut ame_util.approversTable2;
15205:
15206: l_childItemKeySeq number;
15207: l_childItemKey wf_items.item_key%type;
15208: l_masterUserKey wf_items.user_key%type;
15209:
15210: l_manager_name wf_users.name%type;
15211: l_manager_display_name wf_users.display_name%type;

Line 15208: l_masterUserKey wf_items.user_key%type;

15204: l_nextApproversOut ame_util.approversTable2;
15205:
15206: l_childItemKeySeq number;
15207: l_childItemKey wf_items.item_key%type;
15208: l_masterUserKey wf_items.user_key%type;
15209:
15210: l_manager_name wf_users.name%type;
15211: l_manager_display_name wf_users.display_name%type;
15212: