DBA Data[Home] [Help]

APPS.PA_WORKFLOW_HISTORY dependencies on FND_PROFILE

Line 259: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', G_user_id),

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 */
261: || '
';
262: else
263: l_action_date := to_char(rec.action_date ,

Line 260: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', G_user_id),'GREGORIAN') || '''') /* Modified for Bug 8974192 */

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 */
261: || '
';
262: else
263: l_action_date := to_char(rec.action_date ,
264: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', G_user_id),

Line 264: 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 */
261: || '';
262: else
263: l_action_date := to_char(rec.action_date ,
264: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', G_user_id),
265: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', G_user_id),'GREGORIAN') || ''''); /* Modified for Bug 8974192 */
266: end if;
267: else
268: l_action_date := to_char(rec.action_date);

Line 265: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', G_user_id),'GREGORIAN') || ''''); /* Modified for Bug 8974192 */

261: || '';
262: else
263: l_action_date := to_char(rec.action_date ,
264: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', G_user_id),
265: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', G_user_id),'GREGORIAN') || ''''); /* Modified for Bug 8974192 */
266: end if;
267: else
268: l_action_date := to_char(rec.action_date);
269: end if;

Line 392: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', G_user_id),

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 */
394: || '
';
395: else
396: l_action_date := to_char(rec.action_date ,

Line 393: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', G_user_id),'GREGORIAN') || '''') /* Modified for Bug 8974192 */

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 */
394: || '
';
395: else
396: l_action_date := to_char(rec.action_date ,
397: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', G_user_id),

Line 397: 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 */
394: || '';
395: else
396: l_action_date := to_char(rec.action_date ,
397: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', G_user_id),
398: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', G_user_id),'GREGORIAN') || ''''); /* Modified for Bug 8974192 */
399: end if;
400: else
401: l_action_date := to_char(rec.action_date);

Line 398: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', G_user_id),'GREGORIAN') || ''''); /* Modified for Bug 8974192 */

394: || '';
395: else
396: l_action_date := to_char(rec.action_date ,
397: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', G_user_id),
398: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', G_user_id),'GREGORIAN') || ''''); /* Modified for Bug 8974192 */
399: end if;
400: else
401: l_action_date := to_char(rec.action_date);
402: end if;

Line 430: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', G_user_id),

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 */
432: || '
';
433: else
434: l_action_date := to_char(rec.action_date ,

Line 431: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', G_user_id),'GREGORIAN') || '''') /* Modified for Bug 8974192 */

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 */
432: || '
';
433: else
434: l_action_date := to_char(rec.action_date ,
435: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', G_user_id),

Line 435: 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 */
432: || '';
433: else
434: l_action_date := to_char(rec.action_date ,
435: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', G_user_id),
436: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', G_user_id),'GREGORIAN') || ''''); /* Modified for Bug 8974192 */
437: end if;
438: else
439: l_action_date := to_char(rec.action_date);

Line 436: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', G_user_id),'GREGORIAN') || ''''); /* Modified for Bug 8974192 */

432: || '';
433: else
434: l_action_date := to_char(rec.action_date ,
435: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', G_user_id),
436: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', G_user_id),'GREGORIAN') || ''''); /* Modified for Bug 8974192 */
437: end if;
438: else
439: l_action_date := to_char(rec.action_date);
440: end if;