DBA Data[Home] [Help]

APPS.PO_EMAIL_GENERATE dependencies on FND_GLOBAL

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

72: document in out NOCOPY clob,
73: document_type in out NOCOPY varchar2) IS
74:
75: l_document VARCHAR2(32000) := '';
76: NL VARCHAR2(1) := fnd_global.newline;
77:
78: shipmentNum NUMBER := 1;
79:
80: l_document_id VARCHAR2(30) := document_id;

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

2356: document in out NOCOPY varchar2,
2357: document_type in out NOCOPY varchar2) IS
2358:
2359:
2360: NL VARCHAR2(1) := fnd_global.newline;
2361:
2362: l_document VARCHAR2(32000) := '';
2363: x_display_type varchar2(60);
2364:

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

4108: v_filehandle UTL_FILE.FILE_TYPE;
4109: l_filedir varchar2(2000) := null;
4110: l_filename varchar2(2000) := null;
4111: v_terms varchar2(4000) := null;
4112: NL VARCHAR2(1) := fnd_global.newline;
4113: l_document varchar2(32000);
4114: x_progress varchar2(3);
4115: x_display_type varchar2(60);
4116:

Line 4207: -- bug 3128426: removed call to fnd_global.apps_initialize

4203: END;
4204: --EMAILPO FPH END--
4205:
4206:
4207: -- bug 3128426: removed call to fnd_global.apps_initialize
4208: -- instead, use fnd_profile.value_specific to get
4209: -- profile values w/o resetting the app context
4210: l_filedir := FND_PROFILE.VALUE_SPECIFIC(
4211: name => 'PO_EMAIL_TERMS_DIR_NAME'

Line 4245: l_filename_lang := l_filename || '_' || fnd_global.base_language;

4241: /* open the file */
4242: v_filehandle := UTL_FILE.FOPEN(l_filedir,l_filename_lang,'r');
4243: EXCEPTION WHEN OTHERS THEN
4244: BEGIN
4245: l_filename_lang := l_filename || '_' || fnd_global.base_language;
4246: v_filehandle := UTL_FILE.FOPEN(l_filedir,l_filename_lang, 'r');
4247: EXCEPTION WHEN OTHERS THEN
4248: v_filehandle := UTL_FILE.FOPEN(l_filedir,l_filename, 'r');
4249: END;