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 FND_CURRENCY

Line 292: FND_CURRENCY.Get_Format_Mask(p_reimb_curr,22));

288: from ap_expense_report_headers_all
289: where report_header_id = p_report_header_id;
290:
291: l_total_dsp := to_char(l_total,
292: FND_CURRENCY.Get_Format_Mask(p_reimb_curr,22));
293: l_new_total_dsp := to_char(p_new_total,
294: FND_CURRENCY.Get_Format_Mask(p_reimb_curr,22));
295: l_credit_total := p_total - p_new_total;
296: l_credit_total_dsp := to_char(l_credit_total,

Line 294: FND_CURRENCY.Get_Format_Mask(p_reimb_curr,22));

290:
291: l_total_dsp := to_char(l_total,
292: FND_CURRENCY.Get_Format_Mask(p_reimb_curr,22));
293: l_new_total_dsp := to_char(p_new_total,
294: FND_CURRENCY.Get_Format_Mask(p_reimb_curr,22));
295: l_credit_total := p_total - p_new_total;
296: l_credit_total_dsp := to_char(l_credit_total,
297: FND_CURRENCY.Get_Format_Mask(p_reimb_curr,22));
298: AP_WEB_PROJECT_PKG.IsSessionProjectEnabled(

Line 297: FND_CURRENCY.Get_Format_Mask(p_reimb_curr,22));

293: l_new_total_dsp := to_char(p_new_total,
294: FND_CURRENCY.Get_Format_Mask(p_reimb_curr,22));
295: l_credit_total := p_total - p_new_total;
296: l_credit_total_dsp := to_char(l_credit_total,
297: FND_CURRENCY.Get_Format_Mask(p_reimb_curr,22));
298: AP_WEB_PROJECT_PKG.IsSessionProjectEnabled(
299: p_employee_id,
300: FND_PROFILE.VALUE('USER_ID'),
301: l_employee_project_enabled);

Line 1103: l_table_row := l_table_row || td_number || to_char(V_Amount, FND_CURRENCY.Get_Format_Mask(l_currency,22)) || td_end;

1099: l_table_row := tr_start;
1100: l_table_row := l_table_row || td_select || to_char(l_line_num) || td_end;
1101: l_table_row := l_table_row || td_text || V_StartExpenseDate || td_end;
1102: l_table_row := l_table_row || td_text || V_ExpenseType || td_end;
1103: l_table_row := l_table_row || td_number || to_char(V_Amount, FND_CURRENCY.Get_Format_Mask(l_currency,22)) || td_end;
1104:
1105: ---------------------------------------------------------
1106: l_debug_info := 'Add the Reason column to the Sys Admin table';
1107: ---------------------------------------------------------

Line 2932: to_char(l_sum_violations + nvl(l_sum_missing_receipts,0), FND_CURRENCY.Get_Format_Mask(l_currency,22)) || ' ' || l_currency);

2928: IF (nvl(l_sum_violations, 0) > 0) THEN
2929: WF_ENGINE.SetItemAttrText(p_item_type,
2930: p_item_key,
2931: 'VIOLATIONS_TOTAL',
2932: to_char(l_sum_violations + nvl(l_sum_missing_receipts,0), FND_CURRENCY.Get_Format_Mask(l_currency,22)) || ' ' || l_currency);
2933: END IF;
2934:
2935:
2936: -----------------------------------------------------------------

Line 2944: l_sum_missing_display_total := to_char(l_sum_missing_receipts, FND_CURRENCY.Get_Format_Mask(l_currency,22)) || ' ' || l_currency;

2940: IF (nvl(l_sum_missing_receipts,0) <= nvl(l_sum_limit,0)) THEN
2941:
2942: p_result := 'COMPLETE:N';
2943: ELSE
2944: l_sum_missing_display_total := to_char(l_sum_missing_receipts, FND_CURRENCY.Get_Format_Mask(l_currency,22)) || ' ' || l_currency;
2945:
2946: WF_ENGINE.SetItemAttrText(p_item_type,
2947: p_item_key,
2948: 'MISSING_RECEIPT_TOTAL',

Line 3591: l_adjustment_line := adjustment_rec.expense_type_disp || ' ' || to_char(adjustment_rec.amount,FND_CURRENCY.Get_Format_Mask(l_currency,22)) || ' ' || adjustment_rec.adjustment_reason;

3587: -----------------------------------------
3588: l_debug_info := 'Format Adjustment Line';
3589: -----------------------------------------
3590: -- jrautiai ADJ Fix, taking the results from a record instead of variable.
3591: l_adjustment_line := adjustment_rec.expense_type_disp || ' ' || to_char(adjustment_rec.amount,FND_CURRENCY.Get_Format_Mask(l_currency,22)) || ' ' || adjustment_rec.adjustment_reason;
3592:
3593: -----------------------------------------------------
3594: l_debug_info := 'Set Adjustment Line Item Attribute';
3595: -----------------------------------------------------

Line 3668: to_char(l_total,FND_CURRENCY.Get_Format_Mask(l_currency,22)) || ' ' || l_currency);

3664: -----------------------------------------------------------------
3665: WF_ENGINE.SetItemAttrText(p_item_type,
3666: p_item_key,
3667: 'DISPLAY_TOTAL',
3668: to_char(l_total,FND_CURRENCY.Get_Format_Mask(l_currency,22)) || ' ' || l_currency);
3669:
3670: /* jrautiai ADJ Fix end */
3671:
3672: IF (C_WF_Version >= C_CreditLineVersion) THEN

Line 3687: to_char(0,FND_CURRENCY.Get_Format_Mask(l_currency,22)));

3683: -----------------------------------------------------------------
3684: WF_ENGINE.SetItemAttrText(p_item_type,
3685: p_item_key,
3686: 'NEG_CREDIT_DISPLAY_TOTAL',
3687: to_char(0,FND_CURRENCY.Get_Format_Mask(l_currency,22)));
3688:
3689:
3690: -----------------------------------------------------
3691: l_debug_info := 'Set New New_Expense_Total Item Attribute';

Line 3704: to_char(0,FND_CURRENCY.Get_Format_Mask(l_currency,22)));

3700: -----------------------------------------------------------------
3701: WF_ENGINE.SetItemAttrText(p_item_type,
3702: p_item_key,
3703: 'POS_NEW_EXPENSE_DISPLAY_TOTAL',
3704: to_char(0,FND_CURRENCY.Get_Format_Mask(l_currency,22)));
3705:
3706:
3707: END IF;
3708:

Line 4031: l_shortpay_line := shortpay_rec.expense_type_disp || ' ' || to_char(shortpay_rec.amount,FND_CURRENCY.Get_Format_Mask(l_currency,22)) || ' ' || l_currency || ' ' || shortpay_rec.adjustment_reason;

4027:
4028: -----------------------------------------
4029: l_debug_info := 'Format ShortPay Line';
4030: -----------------------------------------
4031: l_shortpay_line := shortpay_rec.expense_type_disp || ' ' || to_char(shortpay_rec.amount,FND_CURRENCY.Get_Format_Mask(l_currency,22)) || ' ' || l_currency || ' ' || shortpay_rec.adjustment_reason;
4032:
4033: -----------------------------------------------------
4034: l_debug_info := 'Reuse Adjustment Line Item Attribute';
4035: -----------------------------------------------------

Line 5527: to_char(l_total,FND_CURRENCY.Get_Format_Mask(l_currency,22)) || ' ' || l_currency);

5523: -----------------------------------------------------------------
5524: WF_ENGINE.SetItemAttrText(p_item_type,
5525: l_item_key,
5526: 'DISPLAY_TOTAL',
5527: to_char(l_total,FND_CURRENCY.Get_Format_Mask(l_currency,22)) || ' ' || l_currency);
5528:
5529: ----------------------------------------------
5530: l_debug_info := 'Set Currency Item Attribute';
5531: -----------------------------------------------

Line 6502: to_char(l_total,FND_CURRENCY.Get_Format_Mask(l_currency,22)) || ' ' || l_currency);

6498: -----------------------------------------------------------------
6499: WF_ENGINE.SetItemAttrText(p_item_type,
6500: l_item_key,
6501: 'DISPLAY_TOTAL',
6502: to_char(l_total,FND_CURRENCY.Get_Format_Mask(l_currency,22)) || ' ' || l_currency);
6503:
6504:
6505:
6506:

Line 6520: to_char(l_new_exp_total, FND_CURRENCY.Get_Format_Mask(l_currency,22)));

6516: l_new_exp_total);
6517: WF_ENGINE.SetItemAttrText(p_item_type,
6518: l_item_key,
6519: 'POS_NEW_EXPENSE_DISPLAY_TOTAL',
6520: to_char(l_new_exp_total, FND_CURRENCY.Get_Format_Mask(l_currency,22)));
6521:
6522: WF_ENGINE.SetItemAttrNumber(p_item_type,
6523: l_item_key,
6524: 'NEG_CREDIT_TOTAL',

Line 6529: to_char(l_credit_total, FND_CURRENCY.Get_Format_Mask(l_currency,22)));

6525: l_credit_total);
6526: WF_ENGINE.SetItemAttrText(p_item_type,
6527: l_item_key,
6528: 'NEG_CREDIT_DISPLAY_TOTAL',
6529: to_char(l_credit_total, FND_CURRENCY.Get_Format_Mask(l_currency,22)));
6530:
6531:
6532:
6533: END IF;

Line 7090: to_char(l_total,FND_CURRENCY.Get_Format_Mask(l_currency,22)) || ' ' || l_currency);

7086: -----------------------------------------------------------------
7087: WF_ENGINE.SetItemAttrText(p_item_type,
7088: l_item_key,
7089: 'DISPLAY_TOTAL',
7090: to_char(l_total,FND_CURRENCY.Get_Format_Mask(l_currency,22)) || ' ' || l_currency);
7091:
7092: --------------------------------------------------------------
7093: l_debug_info := 'Set CC Payment Due From Item Attribute';
7094: --------------------------------------------------------------

Line 7113: to_char(l_new_exp_total, FND_CURRENCY.Get_Format_Mask(l_currency,22)));

7109: l_new_exp_total);
7110: WF_ENGINE.SetItemAttrText(p_item_type,
7111: l_item_key,
7112: 'POS_NEW_EXPENSE_DISPLAY_TOTAL',
7113: to_char(l_new_exp_total, FND_CURRENCY.Get_Format_Mask(l_currency,22)));
7114:
7115: WF_ENGINE.SetItemAttrNumber(p_item_type,
7116: l_item_key,
7117: 'NEG_CREDIT_TOTAL',

Line 7122: to_char(l_credit_total, FND_CURRENCY.Get_Format_Mask(l_currency,22)));

7118: l_credit_total);
7119: WF_ENGINE.SetItemAttrText(p_item_type,
7120: l_item_key,
7121: 'NEG_CREDIT_DISPLAY_TOTAL',
7122: to_char(l_credit_total, FND_CURRENCY.Get_Format_Mask(l_currency,22)));
7123:
7124: END IF;
7125:
7126: ---------------------------------------------------------------------------

Line 7529: to_char(l_total,FND_CURRENCY.Get_Format_Mask(l_currency,22)) || ' ' || l_currency);

7525: -----------------------------------------------------------------
7526: WF_ENGINE.SetItemAttrText(p_item_type,
7527: l_item_key,
7528: 'DISPLAY_TOTAL',
7529: to_char(l_total,FND_CURRENCY.Get_Format_Mask(l_currency,22)) || ' ' || l_currency);
7530:
7531: ----------------------------------------------
7532: l_debug_info := 'Set Currency Item Attribute';
7533: -----------------------------------------------

Line 9141: NVL(to_char(adjustment_rec.submitted_amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)), '&' || 'nbsp;') || td_end;

9137: -- 'Expense Type'
9138: p_adjustment_line := p_adjustment_line || td_text || adjustment_rec.expense_type_disp || td_end;
9139: -- 'Original Amount'
9140: p_adjustment_line := p_adjustment_line || td_number ||
9141: NVL(to_char(adjustment_rec.submitted_amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)), '&' || 'nbsp;') || td_end;
9142: -- 'Adjustment'
9143: p_adjustment_line := p_adjustment_line || td_number ||
9144: NVL(to_char(adjustment_rec.adjusted_amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)), '&' || 'nbsp;') || td_end;
9145: -- 'New Amount'

Line 9144: NVL(to_char(adjustment_rec.adjusted_amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)), '&' || 'nbsp;') || td_end;

9140: p_adjustment_line := p_adjustment_line || td_number ||
9141: NVL(to_char(adjustment_rec.submitted_amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)), '&' || 'nbsp;') || td_end;
9142: -- 'Adjustment'
9143: p_adjustment_line := p_adjustment_line || td_number ||
9144: NVL(to_char(adjustment_rec.adjusted_amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)), '&' || 'nbsp;') || td_end;
9145: -- 'New Amount'
9146: p_adjustment_line := p_adjustment_line || td_number || to_char(adjustment_rec.amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)) || td_end;
9147: -- 'Credit Card Expense'
9148: p_adjustment_line := p_adjustment_line || td_text || NVL(adjustment_rec.credit_card_expense_disp, '&' || 'nbsp;') || td_end;

Line 9146: p_adjustment_line := p_adjustment_line || td_number || to_char(adjustment_rec.amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)) || td_end;

9142: -- 'Adjustment'
9143: p_adjustment_line := p_adjustment_line || td_number ||
9144: NVL(to_char(adjustment_rec.adjusted_amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)), '&' || 'nbsp;') || td_end;
9145: -- 'New Amount'
9146: p_adjustment_line := p_adjustment_line || td_number || to_char(adjustment_rec.amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)) || td_end;
9147: -- 'Credit Card Expense'
9148: p_adjustment_line := p_adjustment_line || td_text || NVL(adjustment_rec.credit_card_expense_disp, '&' || 'nbsp;') || td_end;
9149: -- 'Justification'
9150: p_adjustment_line := p_adjustment_line || td_text || nvl(WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.justification), '&' || 'nbsp;') || td_end;

Line 9184: NVL(to_char(adjustment_rec.amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)), '&' || 'nbsp;') || td_end;

9180: -- 'Expense Type'
9181: p_adjustment_line := p_adjustment_line || td_text || adjustment_rec.expense_type_disp || td_end;
9182: -- 'Amount'
9183: p_adjustment_line := p_adjustment_line || td_number ||
9184: NVL(to_char(adjustment_rec.amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)), '&' || 'nbsp;') || td_end;
9185: -- 'Justification'
9186: p_adjustment_line := p_adjustment_line || td_text || nvl(WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.justification), '&' || 'nbsp;') || td_end;
9187: -- 'Instructions'
9188: p_adjustment_line := p_adjustment_line || td_text;

Line 9220: NVL(to_char(adjustment_rec.amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)), '&' || 'nbsp;') || td_end;

9216: -- 'Expense Type'
9217: p_adjustment_line := p_adjustment_line || td_text || adjustment_rec.expense_type_disp || td_end;
9218: -- 'Amount'
9219: p_adjustment_line := p_adjustment_line || td_number ||
9220: NVL(to_char(adjustment_rec.amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)), '&' || 'nbsp;') || td_end;
9221: -- 'Itemized Expense'
9222: p_adjustment_line := p_adjustment_line || td_text || NVL(adjustment_rec.itemized_expense_disp, '&' || 'nbsp;') || td_end;
9223: -- 'Justification'
9224: p_adjustment_line := p_adjustment_line || td_text || nvl(WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.justification), '&' || 'nbsp;') || td_end;

Line 9546: l_document := l_document || ''|| LPAD(to_char(l_total_adjustment, FND_CURRENCY.Get_Format_Mask(l_currency,22)),14) || '';

9542:
9543: IF l_adj_code = 'ADJUSTMENT' THEN
9544: -- display Total
9545: l_document := l_document || '' || l_prompts(12) || '';
9546: l_document := l_document || ''|| LPAD(to_char(l_total_adjustment, FND_CURRENCY.Get_Format_Mask(l_currency,22)),14) || '';
9547: l_document := l_document || '';
9548: ELSE
9549: l_document := l_document || '' || l_prompts(12) || '';
9550: l_document := l_document || ''|| LPAD(to_char(l_total_amount, FND_CURRENCY.Get_Format_Mask(l_currency,22)),14) || '';

Line 9550: l_document := l_document || ''|| LPAD(to_char(l_total_amount, FND_CURRENCY.Get_Format_Mask(l_currency,22)),14) || '';

9546: l_document := l_document || ''|| LPAD(to_char(l_total_adjustment, FND_CURRENCY.Get_Format_Mask(l_currency,22)),14) || '';
9547: l_document := l_document || '';
9548: ELSE
9549: l_document := l_document || '' || l_prompts(12) || '';
9550: l_document := l_document || ''|| LPAD(to_char(l_total_amount, FND_CURRENCY.Get_Format_Mask(l_currency,22)),14) || '';
9551: l_document := l_document || '';
9552: END IF;
9553:
9554: l_document := l_document || '';

Line 11538: || ' ' || LPAD(to_char(l_total_amt, FND_CURRENCY.Get_Format_Mask(l_currency,22)),14);

11534: end if;
11535: END IF;
11536: l_line_info := '(' || to_char(l_num_lines) || ')' || l_line_info || ' '|| l_start_date
11537: || l_expense_type || ' ' || l_project_string
11538: || ' ' || LPAD(to_char(l_total_amt, FND_CURRENCY.Get_Format_Mask(l_currency,22)),14);
11539: -- set a new line
11540: l_document := l_document || '
11541: ';
11542: l_document := l_document || l_line_info;

Line 11810: l_document := l_document || td_number || LPAD(to_char(l_total_amt, FND_CURRENCY.Get_Format_Mask(l_currency,22)),14) || td_end;

11806: end if;
11807: end if;
11808:
11809: -- display Amount
11810: l_document := l_document || td_number || LPAD(to_char(l_total_amt, FND_CURRENCY.Get_Format_Mask(l_currency,22)),14) || td_end;
11811:
11812: -- display Justification
11813: l_document := l_document || td_text || nvl(WF_NOTIFICATION.SubstituteSpecialChars(l_justification), '&' || 'nbsp;') || td_end;
11814:

Line 11931: l_document := l_document || td_number || LPAD(to_char(l_expense_report_total_amt, FND_CURRENCY.Get_Format_Mask(l_currency,22)),14) || td_end;

11927: l_document := l_document || '' ||
11929: l_prompts(12) || td_end;
11930:
11931: l_document := l_document || td_number || LPAD(to_char(l_expense_report_total_amt, FND_CURRENCY.Get_Format_Mask(l_currency,22)),14) || td_end;
11932: l_document := l_document || th_number || '&' || 'nbsp;' || td_end;
11933:
11934: if (l_line_accounting_enabled = 'Y') then
11935: l_document := l_document || th_number || '&' || 'nbsp;' || td_end;

Line 12040: l_document := l_document || td_number || LPAD(to_char(l_total_amt, FND_CURRENCY.Get_Format_Mask(l_currency,22)),14) || td_end;

12036: -- display Merchant
12037: --Bug 2942773: Add Merchant name value to personal expense table.
12038: l_document := l_document || td_text || WF_NOTIFICATION.SubstituteSpecialChars(l_merchant_name) || td_end;
12039: -- display Amount
12040: l_document := l_document || td_number || LPAD(to_char(l_total_amt, FND_CURRENCY.Get_Format_Mask(l_currency,22)),14) || td_end;
12041: l_document := l_document || tr_end;
12042:
12043: l_cc_personal_total_amt := l_cc_personal_total_amt + l_total_amt;
12044:

Line 12061: l_document := l_document || td_number || LPAD(to_char(l_cc_personal_total_amt, FND_CURRENCY.Get_Format_Mask(l_currency,22)),14) || td_end;

12057:
12058: -- display Total
12059: l_document := l_document || '' || l_prompts(12) || td_end;
12060:
12061: l_document := l_document || td_number || LPAD(to_char(l_cc_personal_total_amt, FND_CURRENCY.Get_Format_Mask(l_currency,22)),14) || td_end;
12062: l_document := l_document || tr_end;
12063: l_document := l_document || table_end || indent_end;
12064:
12065: end if; -- l_num_personal_lines > 0

Line 12140: l_document := l_document || td_number || LPAD(to_char(l_cc_expensed_amt, FND_CURRENCY.Get_Format_Mask(l_cc_curr_code,22)),14) || td_end;

12136: l_document := l_document || td_text || l_cc_trxn_date || td_end;
12137: -- display Merchant
12138: l_document := l_document || td_text || WF_NOTIFICATION.SubstituteSpecialChars(l_cc_merchant_name) || td_end;
12139: -- display Amount
12140: l_document := l_document || td_number || LPAD(to_char(l_cc_expensed_amt, FND_CURRENCY.Get_Format_Mask(l_cc_curr_code,22)),14) || td_end;
12141: l_document := l_document || tr_end;
12142:
12143: l_cc_personal_total_amt := l_cc_personal_total_amt + to_number(l_cc_expensed_amt);
12144:

Line 12159: l_document := l_document || td_number || LPAD(to_char(l_cc_personal_total_amt, FND_CURRENCY.Get_Format_Mask(l_cc_curr_code,22)),14) || td_end;

12155: --------------------------------------------
12156: l_document := l_document || tr_start;
12157: -- display Total
12158: l_document := l_document || '' || l_prompts(12) || td_end;
12159: l_document := l_document || td_number || LPAD(to_char(l_cc_personal_total_amt, FND_CURRENCY.Get_Format_Mask(l_cc_curr_code,22)),14) || td_end;
12160: l_document := l_document || tr_end;
12161: l_document := l_document || table_end || indent_end;
12162:
12163: end if; -- l_num_personal_lines > 0

Line 13246: FND_CURRENCY.GET_INFO(

13242: l_mileage_line_array(i).number_people),0)+
13243: getAddonMileageRatesSum(l_mileage_line_array(i).report_header_id,
13244: l_mileage_line_array(i).orig_dist_line_number);
13245:
13246: FND_CURRENCY.GET_INFO(
13247: l_mileage_line_array(i).reimbursement_currency_code,
13248: l_base_precision ,
13249: l_ext_precision ,
13250: l_base_min_acct_unit);

Line 13429: FND_CURRENCY.Get_Format_Mask(l_reimb_curr,22));

13425: NULL;
13426: END IF;
13427:
13428: l_total_dsp := to_char(l_total,
13429: FND_CURRENCY.Get_Format_Mask(l_reimb_curr,22));
13430:
13431: WF_ENGINE.SetItemAttrText('APEXP',
13432: to_char(l_report_header_id),
13433: 'DISPLAY_TOTAL',