DBA Data[Home] [Help]

APPS.HR_US_REPORTS dependencies on FND_GLOBAL

Line 149: 115.21 22-JUL-2010 nkjaladi 9912897 replaced chr(10) with fnd_global.newline

145: break_address_line to use chr(10) instead of rpad it to 30
146: characters to display it in next line.
147: 115.20 22-JUL-2010 nkjaladi 9912897 corrected the arcs in msg. As in previuous version it was
148: wrongly entered.
149: 115.21 22-JUL-2010 nkjaladi 9912897 replaced chr(10) with fnd_global.newline
150: ========================================================================================================
151: */
152: -- Global declarations
153: type char_array is table of varchar(81) index by binary_integer;

Line 559: /* 9912897 - Changed from rpad to fnd_global.newline as this same code is used for

555: AS
556: --
557: begin
558: if length(p_addr_line)<=30 then
559: /* 9912897 - Changed from rpad to fnd_global.newline as this same code is used for
560: XML and RDF file generation */
561: /*return rpad(substr(p_addr_line,1,30),31,' ');*/
562: return substr(p_addr_line,1,30)||fnd_global.newline;
563: else

Line 562: return substr(p_addr_line,1,30)||fnd_global.newline;

558: if length(p_addr_line)<=30 then
559: /* 9912897 - Changed from rpad to fnd_global.newline as this same code is used for
560: XML and RDF file generation */
561: /*return rpad(substr(p_addr_line,1,30),31,' ');*/
562: return substr(p_addr_line,1,30)||fnd_global.newline;
563: else
564: /* 9912897 - Changed from rpad to fnd_global.newline as this same code is used for
565: XML and RDF file generation */
566: /*return rpad(substr(p_addr_line,1,30),31,' ') || rpad(substr(p_addr_line,31,40),31,' ');*/

Line 564: /* 9912897 - Changed from rpad to fnd_global.newline as this same code is used for

560: XML and RDF file generation */
561: /*return rpad(substr(p_addr_line,1,30),31,' ');*/
562: return substr(p_addr_line,1,30)||fnd_global.newline;
563: else
564: /* 9912897 - Changed from rpad to fnd_global.newline as this same code is used for
565: XML and RDF file generation */
566: /*return rpad(substr(p_addr_line,1,30),31,' ') || rpad(substr(p_addr_line,31,40),31,' ');*/
567: return substr(p_addr_line,1,30)||fnd_global.newline || substr(p_addr_line,31,40)||fnd_global.newline;
568: end if;

Line 567: return substr(p_addr_line,1,30)||fnd_global.newline || substr(p_addr_line,31,40)||fnd_global.newline;

563: else
564: /* 9912897 - Changed from rpad to fnd_global.newline as this same code is used for
565: XML and RDF file generation */
566: /*return rpad(substr(p_addr_line,1,30),31,' ') || rpad(substr(p_addr_line,31,40),31,' ');*/
567: return substr(p_addr_line,1,30)||fnd_global.newline || substr(p_addr_line,31,40)||fnd_global.newline;
568: end if;
569:
570: end break_address_line;
571:

Line 631: f_address:= f_address || v_town_or_city||fnd_global.newline;

627: then
628: /* 9912897 - Changed from rpad to chr(10) as this same code is used for
629: XML and RDF file generation */
630: /*f_address:= f_address || rpad(v_town_or_city,31,' ');*/
631: f_address:= f_address || v_town_or_city||fnd_global.newline;
632: end if;
633: --
634: if v_region_2 is not null
635: then