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 1894: l_payment_due VARCHAR2(10) := C_IndividualPay;

1890: l_base_currency_code AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode;
1891: l_sys_base_currency_code AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode;
1892: exchange_rate_exception EXCEPTION;
1893: l_available_prepays NUMBER;
1894: l_payment_due VARCHAR2(10) := C_IndividualPay;
1895:
1896: l_debug_info VARCHAR2(1000);
1897:
1898: V_PADefaultDistCCID AP_WEB_DB_EXPLINE_PKG.expLines_codeCombID;

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

3471: l_debug_info VARCHAR2(200);
3472: l_num_lines INTEGER := 0;
3473: i INTEGER;
3474: j INTEGER;
3475: l_payment_due VARCHAR2(10) := C_IndividualPay;
3476: l_total NUMBER := 0;
3477: l_ccard_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCCardCompany;
3478: l_emp_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueEmployee;
3479: C_CreditLineVersion CONSTANT NUMBER := 1;

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

3900: p_funmode IN VARCHAR2,
3901: p_result OUT NOCOPY VARCHAR2) IS
3902: ----------------------------------------------------------------------
3903: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
3904: l_payment_due VARCHAR2(10) := C_IndividualPay;
3905: l_debug_info VARCHAR2(200);
3906: C_WF_Version NUMBER := 0;
3907: BEGIN
3908:

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

4528: l_no_both_receipts_shortpay_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
4529: l_policy_shortpay_doc_num AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;
4530: l_no_receipts_shortpay_doc_num AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;
4531: l_document_number AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;
4532: l_payment_due VARCHAR2(10) := C_IndividualPay;
4533: l_count NUMBER;
4534: l_personal_total NUMBER := 0;
4535: l_policy_ccard_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCcardCompany;
4536: l_no_receipts_ccard_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCcardCompany;

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

4980:
4981:
4982: PROCEDURE DeleteExpReportFromAPTables(p_report_header_id IN AP_WEB_DB_EXPRPT_PKG.expHdr_headerID) IS
4983: l_debug_info VARCHAR2(200);
4984: l_payment_due VARCHAR2(10) := C_IndividualPay;
4985: l_item_type VARCHAR2(100) := 'APEXP';
4986: l_item_key VARCHAR2(100) := to_char(p_report_header_id);
4987:
4988: BEGIN

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

5312: p_report_header_id IN AP_WEB_DB_EXPLINE_PKG.expLines_headerID,
5313: p_item_type IN VARCHAR2,
5314: p_item_key IN VARCHAR2)
5315: IS
5316: l_payment_due VARCHAR2(50) := C_IndividualPay;
5317: l_debug_info VARCHAR2(200);
5318: BEGIN
5319:
5320: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF',

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

5498: p_result OUT NOCOPY VARCHAR2) IS
5499: ----------------------------------------------------------------------
5500: l_debug_info VARCHAR2(200);
5501: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
5502: l_payment_due VARCHAR2(10) := C_IndividualPay;
5503: l_AMEEnabled VARCHAR2(1);
5504: l_No VARCHAR2(1) := 'N';
5505: C_WF_Version NUMBER := 0;
5506: l_n_resp_id NUMBER;

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

5715: l_document_number VARCHAR2(50);
5716: l_emp_cost_center VARCHAR2(240);
5717: l_doc_cost_center VARCHAR2(240);
5718: l_total NUMBER;
5719: l_payment_due VARCHAR2(10) := C_IndividualPay;
5720: l_currency VARCHAR2(25);
5721: l_debug_info VARCHAR2(200);
5722: BEGIN
5723:

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

6521: l_new_exp_total NUMBER;
6522: l_currency VARCHAR2(25);
6523: l_url VARCHAR2(1000);
6524: l_debug_info VARCHAR2(200);
6525: l_payment_due VARCHAR2(10) := C_IndividualPay;
6526:
6527: l_purpose VARCHAR2(2400);
6528: l_approver_id NUMBER;
6529: l_approver_name wf_users.name%type;

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

7097: l_currency VARCHAR2(25);
7098: l_url VARCHAR2(1000);
7099: l_debug_info VARCHAR2(200);
7100: V_IsSessionProjectEnabled VARCHAR2(1);
7101: l_payment_due VARCHAR2(10) := C_IndividualPay;
7102:
7103: l_purpose VARCHAR2(2400);
7104: l_approver_id NUMBER;
7105: l_submit_from_oie VARCHAR2(1);

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

7775: l_doc_cost_center VARCHAR2(240);
7776: l_currency VARCHAR2(50);
7777: l_week_end_date DATE;
7778: l_debug_info VARCHAR2(200);
7779: l_payment_due VARCHAR2(10) := C_IndividualPay;
7780:
7781: C_WF_VERSION NUMBER;
7782:
7783: BEGIN

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

11047: p_result OUT NOCOPY VARCHAR2) IS
11048: ----------------------------------------------------------------------
11049: l_debug_info VARCHAR2(200);
11050: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
11051: l_payment_due VARCHAR2(10) := C_IndividualPay;
11052: l_No VARCHAR2(1) := 'N';
11053: l_AMEEnabled VARCHAR2(1);
11054: C_WF_Version NUMBER := 0;
11055: l_n_resp_id NUMBER;

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

12036: l_cc_trxn_date VARCHAR2(50);--Bug 2944363
12037: l_cc_expensed_amt AP_WEB_DB_EXPLINE_PKG.expLines_amount;--Bug 2944363
12038: l_cc_curr_code VARCHAR2(20); --Bug 2944363
12039: l_cc_merchant_name AP_CREDIT_CARD_TRXNS_ALL.merchant_name1%TYPE;--Bug 2944363
12040: l_payment_due_from VARCHAR2(10) := 'INDIVIDUAL';
12041:
12042: BEGIN
12043:
12044: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start GenerateExpClobLines');

Line 16087: from dual

16083: END;
16084:
16085: select 'Y'
16086: into l_access_granted
16087: from dual
16088: where
16089: (p_item_key = WF_ENGINE.GetItemAttrNumber(l_item_type, l_item_key, 'EXPENSE_REPORT_ID')
16090: or
16091: p_item_key = WF_ENGINE.GetItemAttrNumber(l_item_type, l_item_key, 'HOLDING_EXPENSE_REPORT_ID'))