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 296: FND_CURRENCY.Get_Format_Mask(p_reimb_curr,22));

292: from ap_expense_report_headers_all
293: where report_header_id = p_report_header_id;
294:
295: l_total_dsp := to_char(l_total,
296: FND_CURRENCY.Get_Format_Mask(p_reimb_curr,22));
297: l_new_total_dsp := to_char(p_new_total,
298: FND_CURRENCY.Get_Format_Mask(p_reimb_curr,22));
299: l_credit_total := p_total - p_new_total;
300: l_credit_total_dsp := to_char(l_credit_total,

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

294:
295: l_total_dsp := to_char(l_total,
296: FND_CURRENCY.Get_Format_Mask(p_reimb_curr,22));
297: l_new_total_dsp := to_char(p_new_total,
298: FND_CURRENCY.Get_Format_Mask(p_reimb_curr,22));
299: l_credit_total := p_total - p_new_total;
300: l_credit_total_dsp := to_char(l_credit_total,
301: FND_CURRENCY.Get_Format_Mask(p_reimb_curr,22));
302: AP_WEB_PROJECT_PKG.IsSessionProjectEnabled(

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

297: l_new_total_dsp := to_char(p_new_total,
298: FND_CURRENCY.Get_Format_Mask(p_reimb_curr,22));
299: l_credit_total := p_total - p_new_total;
300: l_credit_total_dsp := to_char(l_credit_total,
301: FND_CURRENCY.Get_Format_Mask(p_reimb_curr,22));
302: AP_WEB_PROJECT_PKG.IsSessionProjectEnabled(
303: p_employee_id,
304: FND_PROFILE.VALUE('USER_ID'),
305: l_employee_project_enabled);

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

1116: l_table_row := tr_start;
1117: l_table_row := l_table_row || td_select || to_char(l_line_num) || td_end;
1118: l_table_row := l_table_row || td_text || V_StartExpenseDate || td_end;
1119: l_table_row := l_table_row || td_text || V_ExpenseType || td_end;
1120: l_table_row := l_table_row || td_number || to_char(V_Amount, FND_CURRENCY.Get_Format_Mask(l_currency,22)) || td_end;
1121:
1122: ---------------------------------------------------------
1123: l_debug_info := 'Add the Reason column to the Sys Admin table';
1124: ---------------------------------------------------------

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

2950: IF (nvl(l_sum_violations, 0) > 0) THEN
2951: WF_ENGINE.SetItemAttrText(p_item_type,
2952: p_item_key,
2953: 'VIOLATIONS_TOTAL',
2954: to_char(l_sum_violations + nvl(l_sum_missing_receipts,0), FND_CURRENCY.Get_Format_Mask(l_currency,22)) || ' ' || l_currency);
2955: END IF;
2956:
2957: -- 9412210: if report is in a currency other than USD then convert to USD
2958: -- and compare

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

2987: IF (nvl(l_converted_amount,0) <= nvl(l_sum_limit,0)) THEN
2988:
2989: p_result := 'COMPLETE:N';
2990: ELSE
2991: l_sum_missing_display_total := to_char(l_sum_missing_receipts, FND_CURRENCY.Get_Format_Mask(l_currency,22)) || ' ' || l_currency;
2992:
2993: WF_ENGINE.SetItemAttrText(p_item_type,
2994: p_item_key,
2995: 'MISSING_RECEIPT_TOTAL',

Line 3640: 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;

3636: -----------------------------------------
3637: l_debug_info := 'Format Adjustment Line';
3638: -----------------------------------------
3639: -- jrautiai ADJ Fix, taking the results from a record instead of variable.
3640: 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;
3641:
3642: -----------------------------------------------------
3643: l_debug_info := 'Set Adjustment Line Item Attribute';
3644: -----------------------------------------------------

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

3713: -----------------------------------------------------------------
3714: WF_ENGINE.SetItemAttrText(p_item_type,
3715: p_item_key,
3716: 'DISPLAY_TOTAL',
3717: to_char(l_total,FND_CURRENCY.Get_Format_Mask(l_currency,22)) || ' ' || l_currency);
3718:
3719: /* jrautiai ADJ Fix end */
3720:
3721: IF (C_WF_Version >= C_CreditLineVersion) THEN

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

3732: -----------------------------------------------------------------
3733: WF_ENGINE.SetItemAttrText(p_item_type,
3734: p_item_key,
3735: 'NEG_CREDIT_DISPLAY_TOTAL',
3736: to_char(0,FND_CURRENCY.Get_Format_Mask(l_currency,22)));
3737:
3738:
3739: -----------------------------------------------------
3740: l_debug_info := 'Set New New_Expense_Total Item Attribute';

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

3749: -----------------------------------------------------------------
3750: WF_ENGINE.SetItemAttrText(p_item_type,
3751: p_item_key,
3752: 'POS_NEW_EXPENSE_DISPLAY_TOTAL',
3753: to_char(0,FND_CURRENCY.Get_Format_Mask(l_currency,22)));
3754:
3755:
3756: END IF;
3757:

Line 4082: 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;

4078:
4079: -----------------------------------------
4080: l_debug_info := 'Format ShortPay Line';
4081: -----------------------------------------
4082: 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;
4083:
4084: -----------------------------------------------------
4085: l_debug_info := 'Reuse Adjustment Line Item Attribute';
4086: -----------------------------------------------------

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

5881: -----------------------------------------------------------------
5882: WF_ENGINE.SetItemAttrText(p_item_type,
5883: l_item_key,
5884: 'DISPLAY_TOTAL',
5885: to_char(l_total,FND_CURRENCY.Get_Format_Mask(l_currency,22)) || ' ' || l_currency);
5886:
5887: ----------------------------------------------
5888: l_debug_info := 'Set Currency Item Attribute';
5889: -----------------------------------------------

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

6879: -----------------------------------------------------------------
6880: WF_ENGINE.SetItemAttrText(p_item_type,
6881: l_item_key,
6882: 'DISPLAY_TOTAL',
6883: to_char(l_total,FND_CURRENCY.Get_Format_Mask(l_currency,22)) || ' ' || l_currency);
6884:
6885:
6886:
6887:

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

6897: l_new_exp_total);
6898: WF_ENGINE.SetItemAttrText(p_item_type,
6899: l_item_key,
6900: 'POS_NEW_EXPENSE_DISPLAY_TOTAL',
6901: to_char(l_new_exp_total, FND_CURRENCY.Get_Format_Mask(l_currency,22)));
6902:
6903: WF_ENGINE.SetItemAttrNumber(p_item_type,
6904: l_item_key,
6905: 'NEG_CREDIT_TOTAL',

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

6906: l_credit_total);
6907: WF_ENGINE.SetItemAttrText(p_item_type,
6908: l_item_key,
6909: 'NEG_CREDIT_DISPLAY_TOTAL',
6910: to_char(l_credit_total, FND_CURRENCY.Get_Format_Mask(l_currency,22)));
6911:
6912:
6913:
6914: END IF;

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

7536: -----------------------------------------------------------------
7537: WF_ENGINE.SetItemAttrText(p_item_type,
7538: l_item_key,
7539: 'DISPLAY_TOTAL',
7540: to_char(l_total,FND_CURRENCY.Get_Format_Mask(l_currency,22)) || ' ' || l_currency);
7541:
7542: --------------------------------------------------------------
7543: l_debug_info := 'Set CC Payment Due From Item Attribute';
7544: --------------------------------------------------------------

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

7559: l_new_exp_total);
7560: WF_ENGINE.SetItemAttrText(p_item_type,
7561: l_item_key,
7562: 'POS_NEW_EXPENSE_DISPLAY_TOTAL',
7563: to_char(l_new_exp_total, FND_CURRENCY.Get_Format_Mask(l_currency,22)));
7564:
7565: WF_ENGINE.SetItemAttrNumber(p_item_type,
7566: l_item_key,
7567: 'NEG_CREDIT_TOTAL',

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

7568: l_credit_total);
7569: WF_ENGINE.SetItemAttrText(p_item_type,
7570: l_item_key,
7571: 'NEG_CREDIT_DISPLAY_TOTAL',
7572: to_char(l_credit_total, FND_CURRENCY.Get_Format_Mask(l_currency,22)));
7573:
7574: END IF;
7575:
7576: ---------------------------------------------------------------------------

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

7970: -----------------------------------------------------------------
7971: WF_ENGINE.SetItemAttrText(p_item_type,
7972: l_item_key,
7973: 'DISPLAY_TOTAL',
7974: to_char(l_total,FND_CURRENCY.Get_Format_Mask(l_currency,22)) || ' ' || l_currency);
7975:
7976: ----------------------------------------------
7977: l_debug_info := 'Set Currency Item Attribute';
7978: -----------------------------------------------

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

9583: -- 'Expense Type'
9584: p_adjustment_line := p_adjustment_line || td_text || adjustment_rec.expense_type_disp || td_end;
9585: -- 'Original Amount'
9586: p_adjustment_line := p_adjustment_line || td_number ||
9587: NVL(to_char(adjustment_rec.submitted_amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)), '&' || 'nbsp;') || td_end;
9588: -- 'Adjustment'
9589: p_adjustment_line := p_adjustment_line || td_number ||
9590: NVL(to_char(adjustment_rec.adjusted_amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)), '&' || 'nbsp;') || td_end;
9591: -- 'New Amount'

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

9586: p_adjustment_line := p_adjustment_line || td_number ||
9587: NVL(to_char(adjustment_rec.submitted_amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)), '&' || 'nbsp;') || td_end;
9588: -- 'Adjustment'
9589: p_adjustment_line := p_adjustment_line || td_number ||
9590: NVL(to_char(adjustment_rec.adjusted_amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)), '&' || 'nbsp;') || td_end;
9591: -- 'New Amount'
9592: p_adjustment_line := p_adjustment_line || td_number || to_char(adjustment_rec.amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)) || td_end;
9593: -- 'Credit Card Expense'
9594: p_adjustment_line := p_adjustment_line || td_text || NVL(adjustment_rec.credit_card_expense_disp, '&' || 'nbsp;') || td_end;

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

9588: -- 'Adjustment'
9589: p_adjustment_line := p_adjustment_line || td_number ||
9590: NVL(to_char(adjustment_rec.adjusted_amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)), '&' || 'nbsp;') || td_end;
9591: -- 'New Amount'
9592: p_adjustment_line := p_adjustment_line || td_number || to_char(adjustment_rec.amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)) || td_end;
9593: -- 'Credit Card Expense'
9594: p_adjustment_line := p_adjustment_line || td_text || NVL(adjustment_rec.credit_card_expense_disp, '&' || 'nbsp;') || td_end;
9595: -- 'Justification'
9596: p_adjustment_line := p_adjustment_line || td_text || nvl(WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.justification), '&' || 'nbsp;') || td_end;

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

9626: -- 'Expense Type'
9627: p_adjustment_line := p_adjustment_line || td_text || adjustment_rec.expense_type_disp || td_end;
9628: -- 'Amount'
9629: p_adjustment_line := p_adjustment_line || td_number ||
9630: NVL(to_char(adjustment_rec.amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)), '&' || 'nbsp;') || td_end;
9631: -- 'Justification'
9632: p_adjustment_line := p_adjustment_line || td_text || nvl(WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.justification), '&' || 'nbsp;') || td_end;
9633: -- 'Instructions'
9634: p_adjustment_line := p_adjustment_line || td_text;

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

9662: -- 'Expense Type'
9663: p_adjustment_line := p_adjustment_line || td_text || adjustment_rec.expense_type_disp || td_end;
9664: -- 'Amount'
9665: p_adjustment_line := p_adjustment_line || td_number ||
9666: NVL(to_char(adjustment_rec.amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)), '&' || 'nbsp;') || td_end;
9667: -- 'Itemized Expense'
9668: p_adjustment_line := p_adjustment_line || td_text || NVL(adjustment_rec.itemized_expense_disp, '&' || 'nbsp;') || td_end;
9669: -- 'Justification'
9670: p_adjustment_line := p_adjustment_line || td_text || nvl(WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.justification), '&' || 'nbsp;') || td_end;

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

9988:
9989: IF l_adj_code = 'ADJUSTMENT' THEN
9990: -- display Total
9991: l_document := l_document || '' || l_prompts(12) || '';
9992: l_document := l_document || ''|| LPAD(to_char(l_total_adjustment, FND_CURRENCY.Get_Format_Mask(l_currency,22)),14) || '';
9993: l_document := l_document || '';
9994: ELSE
9995: l_document := l_document || '' || l_prompts(12) || '';
9996: l_document := l_document || ''|| LPAD(to_char(l_total_amount, FND_CURRENCY.Get_Format_Mask(l_currency,22)),14) || '';

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

9992: l_document := l_document || ''|| LPAD(to_char(l_total_adjustment, FND_CURRENCY.Get_Format_Mask(l_currency,22)),14) || '';
9993: l_document := l_document || '';
9994: ELSE
9995: l_document := l_document || '' || l_prompts(12) || '';
9996: l_document := l_document || ''|| LPAD(to_char(l_total_amount, FND_CURRENCY.Get_Format_Mask(l_currency,22)),14) || '';
9997: l_document := l_document || '';
9998: END IF;
9999:
10000: l_document := l_document || '';

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

12297: end if;
12298: END IF;
12299: l_line_info := '(' || to_char(l_num_lines) || ')' || l_line_info || ' '|| l_start_date
12300: || l_expense_type || ' ' || l_project_string
12301: || ' ' || LPAD(to_char(l_total_amt, FND_CURRENCY.Get_Format_Mask(l_currency,22)),14);
12302: -- set a new line
12303: l_document := l_document || '
12304: ';
12305: l_document := l_document || l_line_info;

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

12569: end if;
12570: end if;
12571:
12572: -- display Amount
12573: l_document := l_document || td_number || LPAD(to_char(l_total_amt, FND_CURRENCY.Get_Format_Mask(l_currency,22)),14) || td_end;
12574:
12575: -- display Justification
12576: l_document := l_document || td_text || nvl(WF_NOTIFICATION.SubstituteSpecialChars(l_justification), '&' || 'nbsp;') || td_end;
12577:

Line 12694: 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;

12690: l_document := l_document || '' ||
12692: l_prompts(12) || td_end;
12693:
12694: 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;
12695: l_document := l_document || th_number || '&' || 'nbsp;' || td_end;
12696:
12697: if (l_line_accounting_enabled = 'Y') then
12698: l_document := l_document || th_number || '&' || 'nbsp;' || td_end;

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

12799: -- display Merchant
12800: --Bug 2942773: Add Merchant name value to personal expense table.
12801: l_document := l_document || td_text || WF_NOTIFICATION.SubstituteSpecialChars(l_merchant_name) || td_end;
12802: -- display Amount
12803: l_document := l_document || td_number || LPAD(to_char(l_total_amt, FND_CURRENCY.Get_Format_Mask(l_currency,22)),14) || td_end;
12804: l_document := l_document || tr_end;
12805:
12806: l_cc_personal_total_amt := l_cc_personal_total_amt + l_total_amt;
12807:

Line 12824: 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;

12820:
12821: -- display Total
12822: l_document := l_document || '' || l_prompts(12) || td_end;
12823:
12824: 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;
12825: l_document := l_document || tr_end;
12826: l_document := l_document || table_end || indent_end;
12827:
12828: end if; -- l_num_personal_lines > 0

Line 12903: 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;

12899: l_document := l_document || td_text || l_cc_trxn_date || td_end;
12900: -- display Merchant
12901: l_document := l_document || td_text || WF_NOTIFICATION.SubstituteSpecialChars(l_cc_merchant_name) || td_end;
12902: -- display Amount
12903: 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;
12904: l_document := l_document || tr_end;
12905:
12906: l_cc_personal_total_amt := l_cc_personal_total_amt + to_number(l_cc_expensed_amt);
12907:

Line 12922: 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;

12918: --------------------------------------------
12919: l_document := l_document || tr_start;
12920: -- display Total
12921: l_document := l_document || '' || l_prompts(12) || td_end;
12922: 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;
12923: l_document := l_document || tr_end;
12924: l_document := l_document || table_end || indent_end;
12925:
12926: end if; -- l_num_personal_lines > 0

Line 14026: FND_CURRENCY.GET_INFO(

14022: l_rate := round(l_schedule_line_array(1).rate * MILES_TO_SWMILES, 6);
14023: END IF;
14024: END IF;*/
14025:
14026: FND_CURRENCY.GET_INFO(
14027: l_mileage_line_array(i).reimbursement_currency_code,
14028: l_base_precision ,
14029: l_ext_precision ,
14030: l_base_min_acct_unit);

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

14195: NULL;
14196: END IF;
14197:
14198: l_total_dsp := to_char(l_total,
14199: FND_CURRENCY.Get_Format_Mask(l_reimb_curr,22));
14200:
14201: WF_ENGINE.SetItemAttrText('APEXP',
14202: to_char(l_report_header_id),
14203: 'DISPLAY_TOTAL',