DBA Data[Home] [Help]

APPS.AME_MIGRATION_REPORT dependencies on FND_GLOBAL

Line 132: l_print_string := rpad(fnd_global.local_chr(32), pStartPos, fnd_global.local_chr(32));

128: end if;
129: widthArray := NumberArray(pWidth1,pWidth2,pWidth3,pWidth4,pWidth5);
130: valueList := ValueArray(pValue1,pValue2,pValue3,pValue4,pValue5);
131: while (print_not_over) loop
132: l_print_string := rpad(fnd_global.local_chr(32), pStartPos, fnd_global.local_chr(32));
133: for i in 1..pTotalPrintColumns loop
134: --
135: l_value_length := lengthb(valueList(i));
136: if l_value_length = 0 then

Line 137: l_temp_string := fnd_global.local_chr(32);

133: for i in 1..pTotalPrintColumns loop
134: --
135: l_value_length := lengthb(valueList(i));
136: if l_value_length = 0 then
137: l_temp_string := fnd_global.local_chr(32);
138: elsif l_value_length <= widthArray(i) then
139: l_temp_string := valueList(i);
140: valueList(i) := '';
141: else

Line 150: l_word_pos := instrb(substrb(valueList(i),1, widthArray(i)), fnd_global.local_chr(32),-1);

146: --try to if we can find a word that is separated by space
147: --if not try to find a word separated by tab
148: --if not it looks like a single word and hence needs doing a substrb at column width
149: --
150: l_word_pos := instrb(substrb(valueList(i),1, widthArray(i)), fnd_global.local_chr(32),-1);
151: if l_word_pos = 0 then
152: --check for tab
153: l_word_pos := instrb(substrb(valueList(i),1,widthArray(i)), fnd_global.local_chr(9),-1);
154: if l_word_pos = 0 then

Line 153: l_word_pos := instrb(substrb(valueList(i),1,widthArray(i)), fnd_global.local_chr(9),-1);

149: --
150: l_word_pos := instrb(substrb(valueList(i),1, widthArray(i)), fnd_global.local_chr(32),-1);
151: if l_word_pos = 0 then
152: --check for tab
153: l_word_pos := instrb(substrb(valueList(i),1,widthArray(i)), fnd_global.local_chr(9),-1);
154: if l_word_pos = 0 then
155: l_word_pos := widthArray(i);
156: end if;
157: end if;

Line 162: l_temp_string := rpad(l_temp_string,widthArray(i)+pSpacer,fnd_global.local_chr(32));

158: l_temp_string := substrb(valueList(i), 1, l_word_pos);
159: valueList(i) := substrb(valueList(i), l_word_pos+1);
160: end if;
161: --
162: l_temp_string := rpad(l_temp_string,widthArray(i)+pSpacer,fnd_global.local_chr(32));
163: l_print_string := l_print_string || l_temp_string;
164: --
165: end loop;
166: fnd_file.put_line(fnd_file.output, l_print_string);