DBA Data[Home] [Help]

APPS.AP_WEB_CREDIT_CARD_WF dependencies on FND_CURRENCY

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

185: ----------------------------------------------------------
186: WF_ENGINE.SetItemAttrText(l_itemType,
187: l_itemKey,
188: 'AMOUNT',
189: to_char(p_paidAmount, FND_CURRENCY.Get_Format_Mask(p_paymentCurrency,22)) || ' ' || p_paymentCurrency);
190:
191: ----------------------------------------------------------
192: l_debugInfo := 'Set CURRENCY Item Attribute';
193: ----------------------------------------------------------

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

376: ----------------------------------------------------------
377: l_debugInfo := 'Set WF Amount Item Attribute';
378: ----------------------------------------------------------
379: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'AMOUNT',
380: to_char(p_Amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)) || ' ' || p_currency);
381:
382: ----------------------------------------------------------
383: l_debugInfo := 'Set CURRENCY Item Attribute';
384: ----------------------------------------------------------

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

896: NULL;
897: END IF;
898:
899: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'TOTAL_OUTSTANDING',
900: to_char(l_total_amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)) || ' ' || p_currency);
901:
902:
903: WF_ENGINE.setItemAttrText(l_itemType, l_itemKey, 'SEND_NOTIFICATIONS_PARAM',p_send_notifications);
904: WF_ENGINE.setItemAttrText(l_itemType, l_itemKey, 'AGING_GRACE_DAYS',nvl(p_grace_days,0));

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

984: ------------------------------------------------------
985: l_debugInfo := 'Set Amount Item Attribute';
986: ------------------------------------------------------
987: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'AMOUNT',
988: to_char(p_Amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)) || ' ' || p_currency);
989:
990:
991: ------------------------------------------------------
992: l_debugInfo := 'Set WF BUCKET1..2 Item Attribute';

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

1074: ------------------------------------------------------
1075: l_debugInfo := 'Set Amount Item Attribute';
1076: ------------------------------------------------------
1077: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_ESC_AMOUNT',
1078: to_char(l_mgr_esc_amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)) || ' ' || p_currency);
1079:
1080: WF_ENGINE.SetItemAttrText(l_itemType,
1081: l_itemKey,
1082: 'LIST_ESC',

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

1100: ------------------------------------------------------
1101: l_debugInfo := 'Set Amount Item Attribute';
1102: ------------------------------------------------------
1103: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_NEXT_ESC_AMOUNT',
1104: to_char(l_next_mgr_esc_amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)) || ' ' || p_currency);
1105:
1106:
1107: WF_ENGINE.SetItemAttrText(l_itemType,
1108: l_itemKey,

Line 1227: 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);

1223: ----------------------------------------------------------
1224: l_debugInfo := 'Set WF Amount Item Attribute';
1225: ----------------------------------------------------------
1226: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'AMOUNT',
1227: 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);
1228:
1229: ----------------------------------------------------------
1230: l_debugInfo := 'Set the Owner of Workflow Process.';
1231: ----------------------------------------------------------

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

1559: --------------------------------------------
1560: l_debugInfo := 'Format Expense Line Info';
1561: --------------------------------------------
1562: l_lineInfo := to_char(l_transaction_date,l_dateFormat) || ' ' ||
1563: l_merchant_name1 || ' ' || to_char(l_billed_amount, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22));
1564: -- set a new line
1565: document := document || ' ' || l_lineInfo;
1566: l_lineInfo := '';
1567: ELSE -- HTML type

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

1567: ELSE -- HTML type
1568: document := document || tr_start|| td_text||
1569: to_char(l_transaction_date,l_dateFormat) || td_end;
1570: document := document || td_text|| WF_NOTIFICATION.SubstituteSpecialChars(l_merchant_name1) || td_end;
1571: document := document || td_number|| to_char(l_billed_amount, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)) || td_end||tr_end;
1572: END IF;
1573: END LOOP;
1574:
1575: close l_DisputedCharges_cursor;

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

1793: --------------------------------------------
1794: l_debugInfo := 'Format Expense Line Info';
1795: --------------------------------------------
1796: l_lineInfo := to_char(l_transaction_date,l_dateFormat) || ' ' ||
1797: to_char(l_billed_amount, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)) || ' ' ||
1798: l_merchant_name1 || ' ' ||
1799: l_expense_report_number || ' ' ||
1800: l_expense_report_status;
1801:

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

1804: l_lineInfo := '';
1805: ELSE -- HTML type
1806: l_document := l_document || tr_start;
1807: l_document := l_document || td_text ||to_char(l_transaction_date,l_dateFormat)|| td_end;
1808: l_document := l_document || td_number||to_char(l_billed_amount, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)) || td_end;
1809: l_document := l_document || td_text|| WF_NOTIFICATION.SubstituteSpecialChars(l_merchant_name1) || td_end;
1810: l_document := l_document || td_text|| l_expense_report_number ||td_end;
1811: l_document := l_document || td_text|| l_displayed_status ||td_end;
1812: l_document := l_document || tr_end;

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

2073: l_debugInfo := 'Format Expense Line Info';
2074: --------------------------------------------
2075: --Bug 3339380 : Added posted currency code to Transaction Amount
2076: l_lineInfo := to_char(l_transaction_date,l_dateFormat) || ' ' || to_char(l_posted_date,l_dateFormat) || ' ' ||
2077: to_char(l_transaction_amount, FND_CURRENCY.Get_Format_Mask(l_posted_currency_code,22)) || ' ' || l_posted_currency_code|| ' ' ||
2078: to_char(l_billed_amount, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)) || ' ' ||
2079: l_merchant_name1 || ' ' || l_location || ' ' ||
2080: l_expense_report_number || ' ' ||
2081: l_displayed_status;

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

2074: --------------------------------------------
2075: --Bug 3339380 : Added posted currency code to Transaction Amount
2076: l_lineInfo := to_char(l_transaction_date,l_dateFormat) || ' ' || to_char(l_posted_date,l_dateFormat) || ' ' ||
2077: to_char(l_transaction_amount, FND_CURRENCY.Get_Format_Mask(l_posted_currency_code,22)) || ' ' || l_posted_currency_code|| ' ' ||
2078: to_char(l_billed_amount, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)) || ' ' ||
2079: l_merchant_name1 || ' ' || l_location || ' ' ||
2080: l_expense_report_number || ' ' ||
2081: l_displayed_status;
2082:

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

2092:
2093: l_document := l_document ||td_text || to_char(l_transaction_date,l_dateFormat) ||td_end;
2094: l_document := l_document ||td_text || to_char(l_posted_date,l_dateFormat) ||td_end;
2095: --Bug 3339380 : Added posted currency code to Transaction Amount
2096: l_document := l_document || td_number || to_char(l_transaction_amount, FND_CURRENCY.Get_Format_Mask(l_posted_currency_code,22));
2097:
2098: l_document := l_document || ' ' || l_posted_currency_code || td_end;
2099:
2100:

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

2097:
2098: l_document := l_document || ' ' || l_posted_currency_code || td_end;
2099:
2100:
2101: l_document := l_document || td_number || to_char(l_billed_amount, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)) || td_end;
2102: l_document := l_document || td_text || WF_NOTIFICATION.SubstituteSpecialChars(l_merchant_name1) || td_end;
2103: l_document := l_document || td_text || l_location ||td_end;
2104: l_document := l_document || td_text || l_expense_report_number || td_end;
2105: l_document := l_document || td_text || l_displayed_status || td_end;

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

2194: l_debugInfo := 'Format Expense Line Info';
2195: --------------------------------------------
2196: --Bug 3339380 : Added posted currency code to Transaction Amount
2197: l_lineInfo := to_char(l_transaction_date,l_dateFormat) || ' ' || to_char(l_posted_date,l_dateFormat) || ' ' ||
2198: to_char(l_transaction_amount, FND_CURRENCY.Get_Format_Mask(l_posted_currency_code,22)) || ' ' || l_posted_currency_code || ' ' ||
2199: to_char(l_billed_amount, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)) || ' ' ||
2200: l_merchant_name1 || ' ' || l_location;
2201:
2202: -- set a new line

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

2195: --------------------------------------------
2196: --Bug 3339380 : Added posted currency code to Transaction Amount
2197: l_lineInfo := to_char(l_transaction_date,l_dateFormat) || ' ' || to_char(l_posted_date,l_dateFormat) || ' ' ||
2198: to_char(l_transaction_amount, FND_CURRENCY.Get_Format_Mask(l_posted_currency_code,22)) || ' ' || l_posted_currency_code || ' ' ||
2199: to_char(l_billed_amount, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)) || ' ' ||
2200: l_merchant_name1 || ' ' || l_location;
2201:
2202: -- set a new line
2203:

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

2213: l_document := l_document || tr_start;
2214: l_document := l_document || td_text|| to_char(l_transaction_date,l_dateFormat) ||td_end;
2215: l_document := l_document || td_text|| to_char(l_posted_date,l_dateFormat) ||td_end;
2216: --Bug 3339380 : Added posted currency code to Transaction Amount
2217: l_document := l_document || td_number|| to_char(l_transaction_amount, FND_CURRENCY.Get_Format_Mask(l_posted_currency_code,22));
2218:
2219: l_document := l_document || ' ' || l_posted_currency_code ||td_end;
2220:
2221: l_document := l_document || td_number|| to_char(l_billed_amount, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)) || td_end;

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

2217: l_document := l_document || td_number|| to_char(l_transaction_amount, FND_CURRENCY.Get_Format_Mask(l_posted_currency_code,22));
2218:
2219: l_document := l_document || ' ' || l_posted_currency_code ||td_end;
2220:
2221: l_document := l_document || td_number|| to_char(l_billed_amount, FND_CURRENCY.Get_Format_Mask(l_billed_currency_code,22)) || td_end;
2222: l_document := l_document || td_text || WF_NOTIFICATION.SubstituteSpecialChars(l_merchant_name1) || td_end;
2223: l_document := l_document || td_text|| l_location ||td_end;
2224: l_document := l_document || tr_end;
2225:

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

2693:
2694: l_document := l_document || td_text|| l_employee_name ||td_end;
2695: l_document := l_document || td_number|| l_total_num_outstanding ||td_end;
2696: l_document := l_document || td_number ||l_total_dispute||td_end;
2697: 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;
2698: 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;
2699:
2700: l_document := l_document || tr_end;
2701:

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

2694: l_document := l_document || td_text|| l_employee_name ||td_end;
2695: l_document := l_document || td_number|| l_total_num_outstanding ||td_end;
2696: l_document := l_document || td_number ||l_total_dispute||td_end;
2697: 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;
2698: 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;
2699:
2700: l_document := l_document || tr_end;
2701:
2702: END IF;

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

2722:
2723: l_document := l_document || tr_start;
2724: l_document := l_document || '' || l_prompts(17) || td_end;
2725:
2726: 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;
2727: 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;
2728:
2729: l_document := l_document || tr_end;
2730:

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

2723: l_document := l_document || tr_start;
2724: l_document := l_document || '' || l_prompts(17) || td_end;
2725:
2726: 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;
2727: 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;
2728:
2729: l_document := l_document || tr_end;
2730:
2731: if (display_type = 'text/html') then

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

2972: l_document := l_document || td_text||l_supervisor_display_name ||td_end;
2973: l_document := l_document || td_text ||l_direct_report_name ||td_end; --Direct Report
2974: l_document := l_document || td_number|| l_total_num_outstanding ||td_end;
2975: l_document := l_document || td_number|| l_total_dispute ||td_end;
2976: 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;
2977: 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;
2978:
2979: END IF;
2980:

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

2973: l_document := l_document || td_text ||l_direct_report_name ||td_end; --Direct Report
2974: l_document := l_document || td_number|| l_total_num_outstanding ||td_end;
2975: l_document := l_document || td_number|| l_total_dispute ||td_end;
2976: 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;
2977: 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;
2978:
2979: END IF;
2980:
2981: l_count := l_count + 1; --Direct Report

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

3006: l_document := l_document ||
3007: '' ||l_prompts(17) ||
3008: td_end; --Direct Report changed colspan to 5.
3009:
3010: 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;
3011: 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;
3012:
3013: l_document := l_document || tr_end;
3014:

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

3007: '' ||l_prompts(17) ||
3008: td_end; --Direct Report changed colspan to 5.
3009:
3010: 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;
3011: 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;
3012:
3013: l_document := l_document || tr_end;
3014:
3015: if (display_type = 'text/html') then