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_CREDIT_CARD_WF dependencies on FND_CURRENCY

Line 181: to_char(p_paidAmount, FND_CURRENCY.Get_Format_Mask(p_paymentCurrency,22)) || ' ' || p_paymentCurrency);

177: ----------------------------------------------------------
178: WF_ENGINE.SetItemAttrText(l_itemType,
179: l_itemKey,
180: 'AMOUNT',
181: to_char(p_paidAmount, FND_CURRENCY.Get_Format_Mask(p_paymentCurrency,22)) || ' ' || p_paymentCurrency);
182:
183: ----------------------------------------------------------
184: l_debugInfo := 'Set CURRENCY Item Attribute';
185: ----------------------------------------------------------

Line 370: to_char(p_Amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)) || ' ' || p_currency);

366: ----------------------------------------------------------
367: l_debugInfo := 'Set WF Amount Item Attribute';
368: ----------------------------------------------------------
369: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'AMOUNT',
370: to_char(p_Amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)) || ' ' || p_currency);
371:
372: ----------------------------------------------------------
373: l_debugInfo := 'Set CURRENCY Item Attribute';
374: ----------------------------------------------------------

Line 849: to_char(l_total_amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)) || ' ' || p_currency);

845: NULL;
846: END IF;
847:
848: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'TOTAL_OUTSTANDING',
849: to_char(l_total_amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)) || ' ' || p_currency);
850:
851:
852: WF_ENGINE.setItemAttrText(l_itemType, l_itemKey, 'SEND_NOTIFICATIONS_PARAM',p_send_notifications);
853: WF_ENGINE.setItemAttrText(l_itemType, l_itemKey, 'AGING_GRACE_DAYS',nvl(p_grace_days,0));

Line 926: to_char(p_Amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)) || ' ' || p_currency);

922: ------------------------------------------------------
923: l_debugInfo := 'Set Amount Item Attribute';
924: ------------------------------------------------------
925: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'AMOUNT',
926: to_char(p_Amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)) || ' ' || p_currency);
927:
928:
929: ------------------------------------------------------
930: l_debugInfo := 'Set WF BUCKET1..2 Item Attribute';

Line 1010: to_char(l_mgr_esc_amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)) || ' ' || p_currency);

1006: ------------------------------------------------------
1007: l_debugInfo := 'Set Amount Item Attribute';
1008: ------------------------------------------------------
1009: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_ESC_AMOUNT',
1010: to_char(l_mgr_esc_amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)) || ' ' || p_currency);
1011:
1012: WF_ENGINE.SetItemAttrText(l_itemType,
1013: l_itemKey,
1014: 'LIST_ESC',

Line 1036: to_char(l_next_mgr_esc_amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)) || ' ' || p_currency);

1032: ------------------------------------------------------
1033: l_debugInfo := 'Set Amount Item Attribute';
1034: ------------------------------------------------------
1035: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_NEXT_ESC_AMOUNT',
1036: to_char(l_next_mgr_esc_amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)) || ' ' || p_currency);
1037:
1038:
1039: WF_ENGINE.SetItemAttrText(l_itemType,
1040: l_itemKey,

Line 1159: to_char(l_exp_info_rec.total, FND_CURRENCY.Get_Format_Mask(l_exp_info_rec.default_curr_code,22)) || ' ' || l_exp_info_rec.default_curr_code);

1155: ----------------------------------------------------------
1156: l_debugInfo := 'Set WF Amount Item Attribute';
1157: ----------------------------------------------------------
1158: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'AMOUNT',
1159: to_char(l_exp_info_rec.total, FND_CURRENCY.Get_Format_Mask(l_exp_info_rec.default_curr_code,22)) || ' ' || l_exp_info_rec.default_curr_code);
1160:
1161: ----------------------------------------------------------
1162: l_debugInfo := 'Set the Owner of Workflow Process.';
1163: ----------------------------------------------------------

Line 1489: l_merchant_name1 || ' ' || to_char(l_billed_amount, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22));

1485: --------------------------------------------
1486: l_debugInfo := 'Format Expense Line Info';
1487: --------------------------------------------
1488: l_lineInfo := to_char(l_transaction_date,l_dateFormat) || ' ' ||
1489: l_merchant_name1 || ' ' || to_char(l_billed_amount, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22));
1490: -- set a new line
1491: document := document || ' ' || l_lineInfo;
1492: l_lineInfo := '';
1493: ELSE -- HTML type

Line 1497: document := document || td_number|| to_char(l_billed_amount, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)) || td_end||tr_end;

1493: ELSE -- HTML type
1494: document := document || tr_start|| td_text||
1495: to_char(l_transaction_date,l_dateFormat) || td_end;
1496: document := document || td_text|| WF_NOTIFICATION.SubstituteSpecialChars(l_merchant_name1) || td_end;
1497: document := document || td_number|| to_char(l_billed_amount, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)) || td_end||tr_end;
1498: END IF;
1499: END LOOP;
1500:
1501: close l_DisputedCharges_cursor;

Line 1723: to_char(l_billed_amount, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)) || ' ' ||

1719: --------------------------------------------
1720: l_debugInfo := 'Format Expense Line Info';
1721: --------------------------------------------
1722: l_lineInfo := to_char(l_transaction_date,l_dateFormat) || ' ' ||
1723: to_char(l_billed_amount, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)) || ' ' ||
1724: l_merchant_name1 || ' ' ||
1725: l_expense_report_number || ' ' ||
1726: l_expense_report_status;
1727:

Line 1734: l_document := l_document || td_number||to_char(l_billed_amount, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)) || td_end;

1730: l_lineInfo := '';
1731: ELSE -- HTML type
1732: l_document := l_document || tr_start;
1733: l_document := l_document || td_text ||to_char(l_transaction_date,l_dateFormat)|| td_end;
1734: l_document := l_document || td_number||to_char(l_billed_amount, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)) || td_end;
1735: l_document := l_document || td_text|| WF_NOTIFICATION.SubstituteSpecialChars(l_merchant_name1) || td_end;
1736: l_document := l_document || td_text|| l_expense_report_number ||td_end;
1737: l_document := l_document || td_text|| l_displayed_status ||td_end;
1738: l_document := l_document || tr_end;

Line 2003: to_char(l_transaction_amount, FND_CURRENCY.Get_Format_Mask(l_posted_currency_code,22)) || ' ' || l_posted_currency_code|| ' ' ||

1999: l_debugInfo := 'Format Expense Line Info';
2000: --------------------------------------------
2001: --Bug 3339380 : Added posted currency code to Transaction Amount
2002: l_lineInfo := to_char(l_transaction_date,l_dateFormat) || ' ' || to_char(l_posted_date,l_dateFormat) || ' ' ||
2003: to_char(l_transaction_amount, FND_CURRENCY.Get_Format_Mask(l_posted_currency_code,22)) || ' ' || l_posted_currency_code|| ' ' ||
2004: to_char(l_billed_amount, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)) || ' ' ||
2005: l_merchant_name1 || ' ' || l_location || ' ' ||
2006: l_expense_report_number || ' ' ||
2007: l_displayed_status;

Line 2004: to_char(l_billed_amount, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)) || ' ' ||

2000: --------------------------------------------
2001: --Bug 3339380 : Added posted currency code to Transaction Amount
2002: l_lineInfo := to_char(l_transaction_date,l_dateFormat) || ' ' || to_char(l_posted_date,l_dateFormat) || ' ' ||
2003: to_char(l_transaction_amount, FND_CURRENCY.Get_Format_Mask(l_posted_currency_code,22)) || ' ' || l_posted_currency_code|| ' ' ||
2004: to_char(l_billed_amount, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)) || ' ' ||
2005: l_merchant_name1 || ' ' || l_location || ' ' ||
2006: l_expense_report_number || ' ' ||
2007: l_displayed_status;
2008:

Line 2022: l_document := l_document || td_number || to_char(l_transaction_amount, FND_CURRENCY.Get_Format_Mask(l_posted_currency_code,22));

2018:
2019: l_document := l_document ||td_text || to_char(l_transaction_date,l_dateFormat) ||td_end;
2020: l_document := l_document ||td_text || to_char(l_posted_date,l_dateFormat) ||td_end;
2021: --Bug 3339380 : Added posted currency code to Transaction Amount
2022: l_document := l_document || td_number || to_char(l_transaction_amount, FND_CURRENCY.Get_Format_Mask(l_posted_currency_code,22));
2023:
2024: l_document := l_document || ' ' || l_posted_currency_code || td_end;
2025:
2026:

Line 2027: l_document := l_document || td_number || to_char(l_billed_amount, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)) || td_end;

2023:
2024: l_document := l_document || ' ' || l_posted_currency_code || td_end;
2025:
2026:
2027: l_document := l_document || td_number || to_char(l_billed_amount, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)) || td_end;
2028: l_document := l_document || td_text || WF_NOTIFICATION.SubstituteSpecialChars(l_merchant_name1) || td_end;
2029: l_document := l_document || td_text || l_location ||td_end;
2030: l_document := l_document || td_text || l_expense_report_number || td_end;
2031: l_document := l_document || td_text || l_displayed_status || td_end;

Line 2124: to_char(l_transaction_amount, FND_CURRENCY.Get_Format_Mask(l_posted_currency_code,22)) || ' ' || l_posted_currency_code || ' ' ||

2120: l_debugInfo := 'Format Expense Line Info';
2121: --------------------------------------------
2122: --Bug 3339380 : Added posted currency code to Transaction Amount
2123: l_lineInfo := to_char(l_transaction_date,l_dateFormat) || ' ' || to_char(l_posted_date,l_dateFormat) || ' ' ||
2124: to_char(l_transaction_amount, FND_CURRENCY.Get_Format_Mask(l_posted_currency_code,22)) || ' ' || l_posted_currency_code || ' ' ||
2125: to_char(l_billed_amount, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)) || ' ' ||
2126: l_merchant_name1 || ' ' || l_location;
2127:
2128: -- set a new line

Line 2125: to_char(l_billed_amount, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)) || ' ' ||

2121: --------------------------------------------
2122: --Bug 3339380 : Added posted currency code to Transaction Amount
2123: l_lineInfo := to_char(l_transaction_date,l_dateFormat) || ' ' || to_char(l_posted_date,l_dateFormat) || ' ' ||
2124: to_char(l_transaction_amount, FND_CURRENCY.Get_Format_Mask(l_posted_currency_code,22)) || ' ' || l_posted_currency_code || ' ' ||
2125: to_char(l_billed_amount, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)) || ' ' ||
2126: l_merchant_name1 || ' ' || l_location;
2127:
2128: -- set a new line
2129:

Line 2143: l_document := l_document || td_number|| to_char(l_transaction_amount, FND_CURRENCY.Get_Format_Mask(l_posted_currency_code,22));

2139: l_document := l_document || tr_start;
2140: l_document := l_document || td_text|| to_char(l_transaction_date,l_dateFormat) ||td_end;
2141: l_document := l_document || td_text|| to_char(l_posted_date,l_dateFormat) ||td_end;
2142: --Bug 3339380 : Added posted currency code to Transaction Amount
2143: l_document := l_document || td_number|| to_char(l_transaction_amount, FND_CURRENCY.Get_Format_Mask(l_posted_currency_code,22));
2144:
2145: l_document := l_document || ' ' || l_posted_currency_code ||td_end;
2146:
2147: l_document := l_document || td_number|| to_char(l_billed_amount, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)) || td_end;

Line 2147: l_document := l_document || td_number|| to_char(l_billed_amount, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)) || td_end;

2143: l_document := l_document || td_number|| to_char(l_transaction_amount, FND_CURRENCY.Get_Format_Mask(l_posted_currency_code,22));
2144:
2145: l_document := l_document || ' ' || l_posted_currency_code ||td_end;
2146:
2147: l_document := l_document || td_number|| to_char(l_billed_amount, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)) || td_end;
2148: l_document := l_document || td_text || WF_NOTIFICATION.SubstituteSpecialChars(l_merchant_name1) || td_end;
2149: l_document := l_document || td_text|| l_location ||td_end;
2150: l_document := l_document || tr_end;
2151:

Line 2623: l_document := l_document || td_number|| LPAD(to_char(l_total_amt_outstanding, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)),14) || td_end;

2619:
2620: l_document := l_document || td_text|| l_employee_name ||td_end;
2621: l_document := l_document || td_number|| l_total_num_outstanding ||td_end;
2622: l_document := l_document || td_number ||l_total_dispute||td_end;
2623: l_document := l_document || td_number|| LPAD(to_char(l_total_amt_outstanding, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)),14) || td_end;
2624: l_document := l_document || td_number || LPAD(to_char(l_total_amount, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)),14) || td_end;
2625:
2626: l_document := l_document || tr_end;
2627:

Line 2624: l_document := l_document || td_number || LPAD(to_char(l_total_amount, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)),14) || td_end;

2620: l_document := l_document || td_text|| l_employee_name ||td_end;
2621: l_document := l_document || td_number|| l_total_num_outstanding ||td_end;
2622: l_document := l_document || td_number ||l_total_dispute||td_end;
2623: l_document := l_document || td_number|| LPAD(to_char(l_total_amt_outstanding, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)),14) || td_end;
2624: l_document := l_document || td_number || LPAD(to_char(l_total_amount, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)),14) || td_end;
2625:
2626: l_document := l_document || tr_end;
2627:
2628: END IF;

Line 2652: l_document := l_document || td_number|| LPAD(to_char(l_gross_outstanding, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)),14) || td_end;

2648:
2649: l_document := l_document || tr_start;
2650: l_document := l_document || '' || l_prompts(17) || td_end;
2651:
2652: l_document := l_document || td_number|| LPAD(to_char(l_gross_outstanding, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)),14) || td_end;
2653: l_document := l_document || td_number || LPAD(to_char(l_gross_amount, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)),14) || td_end;
2654:
2655: l_document := l_document || tr_end;
2656:

Line 2653: l_document := l_document || td_number || LPAD(to_char(l_gross_amount, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)),14) || td_end;

2649: l_document := l_document || tr_start;
2650: l_document := l_document || '' || l_prompts(17) || td_end;
2651:
2652: l_document := l_document || td_number|| LPAD(to_char(l_gross_outstanding, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)),14) || td_end;
2653: l_document := l_document || td_number || LPAD(to_char(l_gross_amount, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)),14) || td_end;
2654:
2655: l_document := l_document || tr_end;
2656:
2657: if (display_type = 'text/html') then

Line 2902: l_document := l_document || td_number|| LPAD(to_char(l_total_amt_outstanding, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)),14) || td_end;

2898: l_document := l_document || td_text||l_supervisor_display_name ||td_end;
2899: l_document := l_document || td_text ||l_direct_report_name ||td_end; --Direct Report
2900: l_document := l_document || td_number|| l_total_num_outstanding ||td_end;
2901: l_document := l_document || td_number|| l_total_dispute ||td_end;
2902: l_document := l_document || td_number|| LPAD(to_char(l_total_amt_outstanding, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)),14) || td_end;
2903: l_document := l_document || td_number|| LPAD(to_char(l_total_amount, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)),14) || td_end;
2904:
2905: END IF;
2906:

Line 2903: l_document := l_document || td_number|| LPAD(to_char(l_total_amount, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)),14) || td_end;

2899: l_document := l_document || td_text ||l_direct_report_name ||td_end; --Direct Report
2900: l_document := l_document || td_number|| l_total_num_outstanding ||td_end;
2901: l_document := l_document || td_number|| l_total_dispute ||td_end;
2902: l_document := l_document || td_number|| LPAD(to_char(l_total_amt_outstanding, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)),14) || td_end;
2903: l_document := l_document || td_number|| LPAD(to_char(l_total_amount, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)),14) || td_end;
2904:
2905: END IF;
2906:
2907: l_count := l_count + 1; --Direct Report

Line 2936: l_document := l_document || td_number|| LPAD(to_char(l_gross_outstanding, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)),14) || td_end;

2932: l_document := l_document ||
2933: '' ||l_prompts(17) ||
2934: td_end; --Direct Report changed colspan to 5.
2935:
2936: l_document := l_document || td_number|| LPAD(to_char(l_gross_outstanding, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)),14) || td_end;
2937: l_document := l_document || td_number|| LPAD(to_char(l_gross_amount, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)),14) || td_end;
2938:
2939: l_document := l_document || tr_end;
2940:

Line 2937: l_document := l_document || td_number|| LPAD(to_char(l_gross_amount, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)),14) || td_end;

2933: '' ||l_prompts(17) ||
2934: td_end; --Direct Report changed colspan to 5.
2935:
2936: l_document := l_document || td_number|| LPAD(to_char(l_gross_outstanding, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)),14) || td_end;
2937: l_document := l_document || td_number|| LPAD(to_char(l_gross_amount, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)),14) || td_end;
2938:
2939: l_document := l_document || tr_end;
2940:
2941: if (display_type = 'text/html') then