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 DUAL

Line 1877: l_payment_due VARCHAR2(10) := C_IndividualPay;

1873: l_base_currency_code AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode;
1874: l_sys_base_currency_code AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode;
1875: exchange_rate_exception EXCEPTION;
1876: l_available_prepays NUMBER;
1877: l_payment_due VARCHAR2(10) := C_IndividualPay;
1878:
1879: l_debug_info VARCHAR2(1000);
1880:
1881: V_PADefaultDistCCID AP_WEB_DB_EXPLINE_PKG.expLines_codeCombID;

Line 3426: l_payment_due VARCHAR2(10) := C_IndividualPay;

3422: l_debug_info VARCHAR2(200);
3423: l_num_lines INTEGER := 0;
3424: i INTEGER;
3425: j INTEGER;
3426: l_payment_due VARCHAR2(10) := C_IndividualPay;
3427: l_total NUMBER := 0;
3428: l_ccard_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCCardCompany;
3429: l_emp_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueEmployee;
3430: C_CreditLineVersion CONSTANT NUMBER := 1;

Line 3855: l_payment_due VARCHAR2(10) := C_IndividualPay;

3851: p_funmode IN VARCHAR2,
3852: p_result OUT NOCOPY VARCHAR2) IS
3853: ----------------------------------------------------------------------
3854: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
3855: l_payment_due VARCHAR2(10) := C_IndividualPay;
3856: l_debug_info VARCHAR2(200);
3857: C_WF_Version NUMBER := 0;
3858: BEGIN
3859:

Line 4390: l_payment_due VARCHAR2(10) := C_IndividualPay;

4386: l_no_receipts_shortpay_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
4387: l_policy_shortpay_doc_num AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;
4388: l_no_receipts_shortpay_doc_num AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;
4389: l_document_number AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;
4390: l_payment_due VARCHAR2(10) := C_IndividualPay;
4391: l_count NUMBER;
4392: l_personal_total NUMBER := 0;
4393: l_policy_ccard_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCcardCompany;
4394: l_no_receipts_ccard_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCcardCompany;

Line 4678: l_payment_due VARCHAR2(10) := C_IndividualPay;

4674:
4675:
4676: PROCEDURE DeleteExpReportFromAPTables(p_report_header_id IN AP_WEB_DB_EXPRPT_PKG.expHdr_headerID) IS
4677: l_debug_info VARCHAR2(200);
4678: l_payment_due VARCHAR2(10) := C_IndividualPay;
4679: l_item_type VARCHAR2(100) := 'APEXP';
4680: l_item_key VARCHAR2(100) := to_char(p_report_header_id);
4681:
4682: BEGIN

Line 4997: l_payment_due VARCHAR2(50) := C_IndividualPay;

4993: p_report_header_id IN AP_WEB_DB_EXPLINE_PKG.expLines_headerID,
4994: p_item_type IN VARCHAR2,
4995: p_item_key IN VARCHAR2)
4996: IS
4997: l_payment_due VARCHAR2(50) := C_IndividualPay;
4998: l_debug_info VARCHAR2(200);
4999: BEGIN
5000:
5001: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF',

Line 5144: l_payment_due VARCHAR2(10) := C_IndividualPay;

5140: p_result OUT NOCOPY VARCHAR2) IS
5141: ----------------------------------------------------------------------
5142: l_debug_info VARCHAR2(200);
5143: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
5144: l_payment_due VARCHAR2(10) := C_IndividualPay;
5145: l_AMEEnabled VARCHAR2(1);
5146: l_No VARCHAR2(1) := 'N';
5147: C_WF_Version NUMBER := 0;
5148: l_n_resp_id NUMBER;

Line 5361: l_payment_due VARCHAR2(10) := C_IndividualPay;

5357: l_document_number VARCHAR2(50);
5358: l_emp_cost_center VARCHAR2(240);
5359: l_doc_cost_center VARCHAR2(240);
5360: l_total NUMBER;
5361: l_payment_due VARCHAR2(10) := C_IndividualPay;
5362: l_currency VARCHAR2(25);
5363: l_debug_info VARCHAR2(200);
5364: BEGIN
5365:

Line 6144: l_payment_due VARCHAR2(10) := C_IndividualPay;

6140: l_new_exp_total NUMBER;
6141: l_currency VARCHAR2(25);
6142: l_url VARCHAR2(1000);
6143: l_debug_info VARCHAR2(200);
6144: l_payment_due VARCHAR2(10) := C_IndividualPay;
6145:
6146: l_purpose VARCHAR2(2400);
6147: l_approver_id NUMBER;
6148: l_approver_name wf_users.name%type;

Line 6720: l_payment_due VARCHAR2(10) := C_IndividualPay;

6716: l_currency VARCHAR2(25);
6717: l_url VARCHAR2(1000);
6718: l_debug_info VARCHAR2(200);
6719: V_IsSessionProjectEnabled VARCHAR2(1);
6720: l_payment_due VARCHAR2(10) := C_IndividualPay;
6721:
6722: l_purpose VARCHAR2(2400);
6723: l_approver_id NUMBER;
6724: l_submit_from_oie VARCHAR2(1);

Line 7334: l_payment_due VARCHAR2(10) := C_IndividualPay;

7330: l_doc_cost_center VARCHAR2(240);
7331: l_currency VARCHAR2(50);
7332: l_week_end_date DATE;
7333: l_debug_info VARCHAR2(200);
7334: l_payment_due VARCHAR2(10) := C_IndividualPay;
7335:
7336: C_WF_VERSION NUMBER;
7337:
7338: BEGIN

Line 10324: l_payment_due VARCHAR2(10) := C_IndividualPay;

10320: p_result OUT NOCOPY VARCHAR2) IS
10321: ----------------------------------------------------------------------
10322: l_debug_info VARCHAR2(200);
10323: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
10324: l_payment_due VARCHAR2(10) := C_IndividualPay;
10325: l_No VARCHAR2(1) := 'N';
10326: l_AMEEnabled VARCHAR2(1);
10327: C_WF_Version NUMBER := 0;
10328: l_n_resp_id NUMBER;

Line 11277: l_payment_due_from VARCHAR2(10) := 'INDIVIDUAL';

11273: l_cc_trxn_date VARCHAR2(50);--Bug 2944363
11274: l_cc_expensed_amt AP_WEB_DB_EXPLINE_PKG.expLines_amount;--Bug 2944363
11275: l_cc_curr_code VARCHAR2(20); --Bug 2944363
11276: l_cc_merchant_name AP_CREDIT_CARD_TRXNS_ALL.merchant_name1%TYPE;--Bug 2944363
11277: l_payment_due_from VARCHAR2(10) := 'INDIVIDUAL';
11278:
11279: BEGIN
11280:
11281: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start GenerateExpClobLines');

Line 15121: from dual

15117: END;
15118:
15119: select 'Y'
15120: into l_access_granted
15121: from dual
15122: where
15123: (p_item_key = WF_ENGINE.GetItemAttrNumber(l_item_type, l_item_key, 'EXPENSE_REPORT_ID')
15124: or
15125: p_item_key = WF_ENGINE.GetItemAttrNumber(l_item_type, l_item_key, 'HOLDING_EXPENSE_REPORT_ID'))