DBA Data[Home] [Help]

APPS.HZ_GEOCODE_PKG dependencies on FND_GLOBAL

Line 210: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(13)),

206: FUNCTION remove_whitespace (p_str IN VARCHAR2) RETURN VARCHAR2 IS
207: l_str VARCHAR2(32767);
208: BEGIN
209: l_str := p_str;
210: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(13)),
211: fnd_global.local_chr(13));
212: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(8)),
213: fnd_global.local_chr(8));
214: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(10)),

Line 211: fnd_global.local_chr(13));

207: l_str VARCHAR2(32767);
208: BEGIN
209: l_str := p_str;
210: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(13)),
211: fnd_global.local_chr(13));
212: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(8)),
213: fnd_global.local_chr(8));
214: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(10)),
215: fnd_global.local_chr(10));

Line 212: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(8)),

208: BEGIN
209: l_str := p_str;
210: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(13)),
211: fnd_global.local_chr(13));
212: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(8)),
213: fnd_global.local_chr(8));
214: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(10)),
215: fnd_global.local_chr(10));
216: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(0)),

Line 213: fnd_global.local_chr(8));

209: l_str := p_str;
210: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(13)),
211: fnd_global.local_chr(13));
212: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(8)),
213: fnd_global.local_chr(8));
214: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(10)),
215: fnd_global.local_chr(10));
216: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(0)),
217: fnd_global.local_chr(0));

Line 214: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(10)),

210: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(13)),
211: fnd_global.local_chr(13));
212: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(8)),
213: fnd_global.local_chr(8));
214: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(10)),
215: fnd_global.local_chr(10));
216: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(0)),
217: fnd_global.local_chr(0));
218: l_str := RTRIM(LTRIM(l_str));

Line 215: fnd_global.local_chr(10));

211: fnd_global.local_chr(13));
212: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(8)),
213: fnd_global.local_chr(8));
214: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(10)),
215: fnd_global.local_chr(10));
216: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(0)),
217: fnd_global.local_chr(0));
218: l_str := RTRIM(LTRIM(l_str));
219: RETURN l_str;

Line 216: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(0)),

212: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(8)),
213: fnd_global.local_chr(8));
214: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(10)),
215: fnd_global.local_chr(10));
216: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(0)),
217: fnd_global.local_chr(0));
218: l_str := RTRIM(LTRIM(l_str));
219: RETURN l_str;
220: END remove_whitespace;

Line 217: fnd_global.local_chr(0));

213: fnd_global.local_chr(8));
214: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(10)),
215: fnd_global.local_chr(10));
216: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(0)),
217: fnd_global.local_chr(0));
218: l_str := RTRIM(LTRIM(l_str));
219: RETURN l_str;
220: END remove_whitespace;
221:

Line 246: l_str := REPLACE(l_str, fnd_global.local_chr(38)); -- get rid of ampersands

242: l_str := p_str;
243:
244: -- clean the string of reserved characters before returning
245: -- l_str := REPLACE(l_str, '&'); -- get rid of ampersands
246: l_str := REPLACE(l_str, fnd_global.local_chr(38)); -- get rid of ampersands
247: l_str := REPLACE(l_str, '<'); -- get rid of open brackets
248: l_str := REPLACE(l_str, '>'); -- get rid of close brackets
249: l_str := REPLACE(l_str, '"'); -- get rid of double quotes
250: l_str := REPLACE(l_str, ''''); -- get rid of double quotes

Line 911: ''||FND_GLOBAL.local_chr(10);

907: At_least_one:= 'N';
908: xml_request := '';
909: xml_request := 'xml_request=' ||
910: '' ||
911: ''||FND_GLOBAL.local_chr(10);
912: FOR i IN 1..l_count LOOP
913: l_return_status := fnd_api.g_ret_sts_success;
914: l_loc_rec := p_loc_array(i);
915: l_form_us :=

Line 951: '' || FND_GLOBAL.local_chr(10);

947: -- '' ||
948: '' ||
949: l_form_us ||
950: '
' ||
951: '' || FND_GLOBAL.local_chr(10);
952: END IF;
953: END LOOP;
954: END IF;
955: