DBA Data[Home] [Help]

APPS.AP_WEB_CREDIT_CARD_WF dependencies on WF_NOTIFICATION

Line 1570: document := document || td_text|| WF_NOTIFICATION.SubstituteSpecialChars(l_merchant_name1) || td_end;

1566: l_lineInfo := '';
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:

Line 1604: WF_NOTIFICATION.NewClob(l_temp_clob,document);

1600:
1601: BEGIN
1602: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'start GenerateUnsubmittedList');
1603:
1604: WF_NOTIFICATION.NewClob(l_temp_clob,document);
1605: GenUnsubmittedClobList(document_id,
1606: display_type,
1607: l_temp_clob,
1608: document_type);

Line 1777: WF_NOTIFICATION.WriteToClob(document,l_document);

1773: EXIT WHEN l_UnsubmittedCharges_cursor%NOTFOUND;
1774:
1775: IF lengthb(l_document) >= l_document_max THEN
1776: -- Appends document to end of document (CLOB object)
1777: WF_NOTIFICATION.WriteToClob(document,l_document);
1778: l_document := '';
1779: END IF;
1780:
1781: BEGIN

Line 1809: l_document := l_document || td_text|| WF_NOTIFICATION.SubstituteSpecialChars(l_merchant_name1) || td_end;

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;
1813: END IF;

Line 1822: WF_NOTIFICATION.WriteToClob(document,l_document);

1818: if (display_type = 'text/html') then
1819: l_document := l_document || table_end||indent_end;
1820: end if;
1821:
1822: WF_NOTIFICATION.WriteToClob(document,l_document);
1823:
1824: document_type := display_type;
1825:
1826: EXCEPTION

Line 1852: WF_NOTIFICATION.NewClob(l_temp_clob,document);

1848: BEGIN
1849:
1850: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start GenerateDunningList');
1851:
1852: WF_NOTIFICATION.NewClob(l_temp_clob,document);
1853: GenerateDunningClobList(document_id,
1854: display_type,
1855: l_temp_clob,
1856: document_type);

Line 2056: WF_NOTIFICATION.WriteToClob(document,l_document);

2052: EXIT WHEN l_Dunning_cursor%NOTFOUND;
2053: --Notification Esc
2054: IF lengthb(l_document) >= l_document_max THEN
2055: -- Appends document to end of document (CLOB object)
2056: WF_NOTIFICATION.WriteToClob(document,l_document);
2057: l_document := '';
2058: END IF;
2059: --Notification Esc
2060:

Line 2102: l_document := l_document || td_text || WF_NOTIFICATION.SubstituteSpecialChars(l_merchant_name1) || td_end;

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;
2106: l_document := l_document || tr_end;

Line 2120: WF_NOTIFICATION.WriteToClob(document,l_document); --Notification Esc

2116: if (display_type = 'text/html') then
2117: l_document := l_document||table_end|| indent_end;
2118: l_document := l_document || '
';
2119: end if;
2120: WF_NOTIFICATION.WriteToClob(document,l_document); --Notification Esc
2121:
2122: l_document := '';
2123:
2124:

Line 2187: WF_NOTIFICATION.WriteToClob(document,l_document);

2183: --Amulya Mishra : Notification Esc Project
2184:
2185: IF lengthb(l_document) >= l_document_max THEN
2186: -- Appends document to end of document (CLOB object)
2187: WF_NOTIFICATION.WriteToClob(document,l_document);
2188: l_document := '';
2189: END IF;
2190: --Amulya Mishra : Notification Esc Project
2191:

Line 2222: l_document := l_document || td_text || WF_NOTIFICATION.SubstituteSpecialChars(l_merchant_name1) || td_end;

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:
2226:

Line 2235: WF_NOTIFICATION.WriteToClob(document,l_document); --Notification Esc

2231: END IF; --End of IF l_total_dispute > 0 - bug 3326035
2232: if (display_type = 'text/html') then
2233: l_document := l_document || table_end||indent_end;
2234: end if;
2235: WF_NOTIFICATION.WriteToClob(document,l_document); --Notification Esc
2236: document_type := display_type;
2237:
2238: --Amulya Mishra : Notification esc project :
2239:

Line 2668: WF_NOTIFICATION.WriteToClob(document,l_document);

2664:
2665:
2666: IF lengthb(l_document) >= l_document_max THEN
2667: -- Appends document to end of document (CLOB object)
2668: WF_NOTIFICATION.WriteToClob(document,l_document);
2669: l_document := '';
2670: END IF;
2671:
2672: IF ((nvl(l_total_outstanding,0) <> 0 OR nvl(l_total_dispute,0) <> 0) AND l_count <= 100) THEN --Direct Report

Line 2735: WF_NOTIFICATION.WriteToClob(document,l_document); --Notification Esc

2731: if (display_type = 'text/html') then
2732: l_document := l_document||table_end|| indent_end;
2733: l_document := l_document || '
';
2734: end if;
2735: WF_NOTIFICATION.WriteToClob(document,l_document); --Notification Esc
2736: document_type := display_type;
2737:
2738:
2739: EXCEPTION

Line 2938: WF_NOTIFICATION.WriteToClob(document,l_document);

2934:
2935:
2936: IF lengthb(l_document) >= l_document_max THEN
2937: -- Appends document to end of document (CLOB object)
2938: WF_NOTIFICATION.WriteToClob(document,l_document);
2939: l_document := '';
2940: END IF;
2941:
2942: --Bug 3337388: If l_level is not as dunning number then dont disply thoese employee's records.

Line 3019: WF_NOTIFICATION.WriteToClob(document,l_document); --Notification Esc

3015: if (display_type = 'text/html') then
3016: l_document := l_document||table_end|| indent_end;
3017: l_document := l_document || '
';
3018: end if;
3019: WF_NOTIFICATION.WriteToClob(document,l_document); --Notification Esc
3020: document_type := display_type;
3021:
3022:
3023: EXCEPTION