DBA Data[Home] [Help]

APPS.PON_CLO_RENUMBER_PKG dependencies on FND_GLOBAL

Line 163: l_nextChar := fnd_global.local_chr(l_asciiValue);

159: l_carryOver := TRUE;
160: END IF;
161:
162: -- Step 5 : nextChar = char(asciiValue) => Char corresponding to the next ascii value
163: l_nextChar := fnd_global.local_chr(l_asciiValue);
164:
165: -- Step 6 : replace the last char of SlinNum with the nextChar.
166:
167: ret_SlinNum := SubStr(SlinNum, 1, Length(SlinNum) - 1) || l_nextChar;

Line 180: l_next_second_last_char := fnd_global.local_chr( Ascii(l_second_last_char) + 1 );

176: l_second_last_char := SubStr(SlinNum, Length(SlinNum) - 1 , 1);
177: IF (l_second_last_char = '9') THEN
178: RAISE INFO_SLIN_NUM_EXHAUSTED;
179: END IF;
180: l_next_second_last_char := fnd_global.local_chr( Ascii(l_second_last_char) + 1 );
181: ret_SlinNum := SubStr(SlinNum, 1, Length(SlinNum) - 2) || l_next_second_last_Char || SubStr(ret_SlinNum, Length(ret_SlinNum) , 1);
182: END IF;
183:
184: RETURN ret_SlinNum;

Line 248: l_nextChar := fnd_global.local_chr(l_asciiValue) ;

244:
245:
246:
247: -- Step 5 : nextChar = char(asciiValue) => Char corresponding to the next ascii value
248: l_nextChar := fnd_global.local_chr(l_asciiValue) ;
249:
250: -- Step 6 : replace the last char of SlinNum with the nextChar.
251:
252: ret_SlinNum := SubStr(SlinNum, 1, Length(SlinNum) - 1) || l_nextChar;

Line 270: l_next_second_last_char := fnd_global.local_chr(l_asciiValue);

266: IF (l_asciiValue = 73 OR l_asciiValue = 79) THEN
267: l_asciiValue := l_asciiValue + 1;
268: END IF;
269:
270: l_next_second_last_char := fnd_global.local_chr(l_asciiValue);
271: ret_SlinNum := SubStr(SlinNum, 1, Length(SlinNum) - 2) || l_next_second_last_Char || SubStr(ret_SlinNum, Length(ret_SlinNum) , 1);
272: END IF;
273:
274: RETURN ret_SlinNum;