APPS.PO_NEGOTIATION_REQ_NOTIF dependencies on FND_PROFILE

Line 488: nvl(to_char(l_line.need_by_date , FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),

484: l_document := l_document || '' ||
485: nvl(to_char(l_line.quantity), ' ') || '' || NL;
486:
487: l_document := l_document || '' ||
488: nvl(to_char(l_line.need_by_date , FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
489: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''), ' ') || '' || NL;
490:
491:
492: x_progress := '009';

Line 489: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''), ' ') || '' || NL;

485: nvl(to_char(l_line.quantity), ' ') || '' || NL;
486:
487: l_document := l_document || '' ||
488: nvl(to_char(l_line.need_by_date , FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
489: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''), ' ') || '' || NL;
490:
491:
492: x_progress := '009';
493: if l_line.cancel_flag = 'Y' then

Line 785: nvl(to_char(l_line.old_need_by_date , FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),

781: l_document := l_document || '' ||
782: nvl(to_char(l_line.old_qty), ' ') || '' || NL;
783:
784: l_document := l_document || '' ||
785: nvl(to_char(l_line.old_need_by_date , FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
786: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''), ' ') || '' || NL;
787:
788: END IF;
789:

Line 786: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''), ' ') || '' || NL;

782: nvl(to_char(l_line.old_qty), ' ') || '' || NL;
783:
784: l_document := l_document || '' ||
785: nvl(to_char(l_line.old_need_by_date , FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
786: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''), ' ') || '' || NL;
787:
788: END IF;
789:
790: l_document := l_document || '' ||

Line 794: nvl(to_char(l_line.need_by_date , FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),

790: l_document := l_document || '' ||
791: nvl(to_char(l_line.quantity), ' ') || '' || NL;
792:
793: l_document := l_document || '' ||
794: nvl(to_char(l_line.need_by_date , FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
795: 'NLS_CALENDAR = ''' || FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) || ''''), ' ') || '' || NL;
796:
797: x_progress := '009';
798:

Line 795: 'NLS_CALENDAR = ''' || FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) || ''''), ' ') || '' || NL;

791: nvl(to_char(l_line.quantity), ' ') || '' || NL;
792:
793: l_document := l_document || '' ||
794: nvl(to_char(l_line.need_by_date , FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
795: 'NLS_CALENDAR = ''' || FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) || ''''), ' ') || '' || NL;
796:
797: x_progress := '009';
798:
799: IF l_source = 'MRP' THEN