DBA Data[Home] [Help]

APPS.AP_WEB_CREDIT_CARD_WF dependencies on WF_NOTIFICATION

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

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

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

1526:
1527: BEGIN
1528: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'start GenerateUnsubmittedList');
1529:
1530: WF_NOTIFICATION.NewClob(l_temp_clob,document);
1531: GenUnsubmittedClobList(document_id,
1532: display_type,
1533: l_temp_clob,
1534: document_type);

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

1699: EXIT WHEN l_UnsubmittedCharges_cursor%NOTFOUND;
1700:
1701: IF lengthb(l_document) >= l_document_max THEN
1702: -- Appends document to end of document (CLOB object)
1703: WF_NOTIFICATION.WriteToClob(document,l_document);
1704: l_document := '';
1705: END IF;
1706:
1707: BEGIN

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

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

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

1744: if (display_type = 'text/html') then
1745: l_document := l_document || table_end||indent_end;
1746: end if;
1747:
1748: WF_NOTIFICATION.WriteToClob(document,l_document);
1749:
1750: document_type := display_type;
1751:
1752: EXCEPTION

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

1774: BEGIN
1775:
1776: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start GenerateDunningList');
1777:
1778: WF_NOTIFICATION.NewClob(l_temp_clob,document);
1779: GenerateDunningClobList(document_id,
1780: display_type,
1781: l_temp_clob,
1782: document_type);

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

1978: EXIT WHEN l_Dunning_cursor%NOTFOUND;
1979: --Notification Esc
1980: IF lengthb(l_document) >= l_document_max THEN
1981: -- Appends document to end of document (CLOB object)
1982: WF_NOTIFICATION.WriteToClob(document,l_document);
1983: l_document := '';
1984: END IF;
1985: --Notification Esc
1986:

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

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

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

2042: if (display_type = 'text/html') then
2043: l_document := l_document||table_end|| indent_end;
2044: l_document := l_document || '
';
2045: end if;
2046: WF_NOTIFICATION.WriteToClob(document,l_document); --Notification Esc
2047:
2048: l_document := '';
2049:
2050:

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

2109: --Amulya Mishra : Notification Esc Project
2110:
2111: IF lengthb(l_document) >= l_document_max THEN
2112: -- Appends document to end of document (CLOB object)
2113: WF_NOTIFICATION.WriteToClob(document,l_document);
2114: l_document := '';
2115: END IF;
2116: --Amulya Mishra : Notification Esc Project
2117:

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

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

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

2157: END IF; --End of IF l_total_dispute > 0 - bug 3326035
2158: if (display_type = 'text/html') then
2159: l_document := l_document || table_end||indent_end;
2160: end if;
2161: WF_NOTIFICATION.WriteToClob(document,l_document); --Notification Esc
2162: document_type := display_type;
2163:
2164: --Amulya Mishra : Notification esc project :
2165:

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

2590:
2591:
2592: IF lengthb(l_document) >= l_document_max THEN
2593: -- Appends document to end of document (CLOB object)
2594: WF_NOTIFICATION.WriteToClob(document,l_document);
2595: l_document := '';
2596: END IF;
2597:
2598: IF ((nvl(l_total_outstanding,0) <> 0 OR nvl(l_total_dispute,0) <> 0) AND l_count <= 100) THEN --Direct Report

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

2657: if (display_type = 'text/html') then
2658: l_document := l_document||table_end|| indent_end;
2659: l_document := l_document || '
';
2660: end if;
2661: WF_NOTIFICATION.WriteToClob(document,l_document); --Notification Esc
2662: document_type := display_type;
2663:
2664:
2665: EXCEPTION

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

2860:
2861:
2862: IF lengthb(l_document) >= l_document_max THEN
2863: -- Appends document to end of document (CLOB object)
2864: WF_NOTIFICATION.WriteToClob(document,l_document);
2865: l_document := '';
2866: END IF;
2867:
2868: --Bug 3337388: If l_level is not as dunning number then dont disply thoese employee's records.

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

2941: if (display_type = 'text/html') then
2942: l_document := l_document||table_end|| indent_end;
2943: l_document := l_document || '
';
2944: end if;
2945: WF_NOTIFICATION.WriteToClob(document,l_document); --Notification Esc
2946: document_type := display_type;
2947:
2948:
2949: EXCEPTION