APPS.AP_PAYMENT_EVENT_WF_PKG dependencies on FND_DATE

Line 38: --Introduced calendar_aware parameter in fnd_date.date_to_chardate

34: l_calendar_aware_alt NUMBER :=2;
35: l_calendar_aware NUMBER := 1;
36: l_calendar_unaware NUMBER := 0;
37:
38: --Introduced calendar_aware parameter in fnd_date.date_to_chardate
39: --procedure for bug#11774150
40: CURSOR c_message_lines IS
41: SELECT ''||invoice_num||
42: ''||fnd_date.date_to_chardate(dateval=>ai.invoice_date,

Line 42: ''||fnd_date.date_to_chardate(dateval=>ai.invoice_date,

38: --Introduced calendar_aware parameter in fnd_date.date_to_chardate
39: --procedure for bug#11774150
40: CURSOR c_message_lines IS
41: SELECT ''||invoice_num||
42: ''||fnd_date.date_to_chardate(dateval=>ai.invoice_date,
43: calendar_aware=>l_calendar_unaware)||
44: ''||to_char(aip.discount_taken)||
45: ''||to_char(aip.amount)||''
46: FROM ap_invoice_payments aip, ap_invoices ai

Line 76: --Introduced calendar_aware parameter in fnd_date.date_to_chardate

72: end if;
73:
74: /* Get Basic Check Info */
75:
76: --Introduced calendar_aware parameter in fnd_date.date_to_chardate
77: --procedure for bug#11774150
78: SELECT check_number,
79: fnd_date.date_to_chardate(dateval=>check_date,calendar_aware=>l_calendar_unaware),
80: currency_code,

Line 79: fnd_date.date_to_chardate(dateval=>check_date,calendar_aware=>l_calendar_unaware),

75:
76: --Introduced calendar_aware parameter in fnd_date.date_to_chardate
77: --procedure for bug#11774150
78: SELECT check_number,
79: fnd_date.date_to_chardate(dateval=>check_date,calendar_aware=>l_calendar_unaware),
80: currency_code,
81: amount
82: INTO l_check_number,
83: l_check_date,