APPS.PO_NEGOTIATION_REQ_NOTIF dependencies on FND_GLOBAL

Line 333: NL VARCHAR2(1) := fnd_global.newline;

329: rql.destination_organization_id;
330:
331: l_status varchar2(60) :=null;
332: l_line line_record;
333: NL VARCHAR2(1) := fnd_global.newline;
334: l_document varchar2(32000) := '';
335: l_document_id number;
336: l_item_type wf_items.item_type%TYPE;
337: l_item_key wf_items.item_key%TYPE;

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 606: NL VARCHAR2(1) := fnd_global.newline;

602: ORDER BY rql.auction_line_number;
603:
604: l_status varchar2(60) :=null;
605: l_line line_record;
606: NL VARCHAR2(1) := fnd_global.newline;
607: l_document varchar2(32000) := '';
608: l_document_id number;
609: l_item_type wf_items.item_type%TYPE;
610: l_item_key wf_items.item_key%TYPE;

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

Line 853: NL VARCHAR2(1) := fnd_global.newline;

849: display_type in Varchar2,
850: document in out NOCOPY clob,
851: document_type in out NOCOPY varchar2) IS
852:
853: NL VARCHAR2(1) := fnd_global.newline;
854: l_document varchar2(32000) := '';
855: l_item_type wf_items.item_type%TYPE;
856: l_item_key wf_items.item_key%TYPE;
857: l_message_text varchar2(30000) := null;