DBA Data[Home] [Help]

APPS.PA_WORKFLOW_HISTORY dependencies on WF_NOTIFICATION

Line 256: if (display_type = wf_notification.doc_html) then

252: FOR rec IN get_history_info LOOP
253: /* Added for Bug 7538477 Start */
254: if (FND_RELEASE.MAJOR_VERSION = 12 and FND_RELEASE.minor_version >= 1 and FND_RELEASE.POINT_VERSION >= 1 )
255: or (FND_RELEASE.MAJOR_VERSION > 12) then
256: if (display_type = wf_notification.doc_html) then
257: l_action_date := '' ||
258: to_char(rec.action_date ,
259: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', G_user_id),
260: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', G_user_id),'GREGORIAN') || '''') /* Modified for Bug 8974192 */

Line 389: if (display_type = wf_notification.doc_html) then

385: FOR rec IN get_history_info LOOP
386: /* Added for Bug 7538477 Start */
387: if (FND_RELEASE.MAJOR_VERSION = 12 and FND_RELEASE.minor_version >= 1 and FND_RELEASE.POINT_VERSION >= 1 )
388: or (FND_RELEASE.MAJOR_VERSION > 12) then
389: if (display_type = wf_notification.doc_html) then
390: l_action_date := '' ||
391: to_char(rec.action_date ,
392: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', G_user_id),
393: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', G_user_id),'GREGORIAN') || '''') /* Modified for Bug 8974192 */

Line 427: if (display_type = wf_notification.doc_html) then

423: FOR rec IN get_approver_info LOOP
424: /* Added for Bug 7538477 Start */
425: if (FND_RELEASE.MAJOR_VERSION = 12 and FND_RELEASE.minor_version >= 1 and FND_RELEASE.POINT_VERSION >= 1 )
426: or (FND_RELEASE.MAJOR_VERSION > 12) then
427: if (display_type = wf_notification.doc_html) then
428: l_action_date := '' ||
429: to_char(rec.action_date ,
430: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', G_user_id),
431: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', G_user_id),'GREGORIAN') || '''') /* Modified for Bug 8974192 */