123: l_concatenated_numbers:=NULL;
124:
125: if p_number1 is not NULL then
126: if l_concatenated_numbers is NULL then
127: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number1);
128: else
129: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number1);
130: end if;
131: end if;
125: if p_number1 is not NULL then
126: if l_concatenated_numbers is NULL then
127: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number1);
128: else
129: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number1);
130: end if;
131: end if;
132: if p_number2 is not NULL then
133: if l_concatenated_numbers is NULL then
130: end if;
131: end if;
132: if p_number2 is not NULL then
133: if l_concatenated_numbers is NULL then
134: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number2);
135: else
136: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number2);
137: end if;
138: end if;
132: if p_number2 is not NULL then
133: if l_concatenated_numbers is NULL then
134: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number2);
135: else
136: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number2);
137: end if;
138: end if;
139: if p_number3 is not NULL then
140: if l_concatenated_numbers is NULL then
137: end if;
138: end if;
139: if p_number3 is not NULL then
140: if l_concatenated_numbers is NULL then
141: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number3);
142: else
143: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number3);
144: end if;
145: end if;
139: if p_number3 is not NULL then
140: if l_concatenated_numbers is NULL then
141: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number3);
142: else
143: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number3);
144: end if;
145: end if;
146: if p_number4 is not NULL then
147: if l_concatenated_numbers is NULL then
144: end if;
145: end if;
146: if p_number4 is not NULL then
147: if l_concatenated_numbers is NULL then
148: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number4);
149: else
150: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number4);
151: end if;
152: end if;
146: if p_number4 is not NULL then
147: if l_concatenated_numbers is NULL then
148: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number4);
149: else
150: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number4);
151: end if;
152: end if;
153: if p_number5 is not NULL then
154: if l_concatenated_numbers is NULL then
151: end if;
152: end if;
153: if p_number5 is not NULL then
154: if l_concatenated_numbers is NULL then
155: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number5);
156: else
157: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number5);
158: end if;
159: end if;
153: if p_number5 is not NULL then
154: if l_concatenated_numbers is NULL then
155: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number5);
156: else
157: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number5);
158: end if;
159: end if;
160: if p_number6 is not NULL then
161: if l_concatenated_numbers is NULL then
158: end if;
159: end if;
160: if p_number6 is not NULL then
161: if l_concatenated_numbers is NULL then
162: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number6);
163: else
164: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number6);
165: end if;
166: end if;
160: if p_number6 is not NULL then
161: if l_concatenated_numbers is NULL then
162: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number6);
163: else
164: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number6);
165: end if;
166: end if;
167: if p_number7 is not NULL then
168: if l_concatenated_numbers is NULL then
165: end if;
166: end if;
167: if p_number7 is not NULL then
168: if l_concatenated_numbers is NULL then
169: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number7);
170: else
171: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number7);
172: end if;
173: end if;
167: if p_number7 is not NULL then
168: if l_concatenated_numbers is NULL then
169: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number7);
170: else
171: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number7);
172: end if;
173: end if;
174: if p_number8 is not NULL then
175: if l_concatenated_numbers is NULL then
172: end if;
173: end if;
174: if p_number8 is not NULL then
175: if l_concatenated_numbers is NULL then
176: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number8);
177: else
178: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number8);
179: end if;
180: end if;
174: if p_number8 is not NULL then
175: if l_concatenated_numbers is NULL then
176: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number8);
177: else
178: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number8);
179: end if;
180: end if;
181: if p_number9 is not NULL then
182: if l_concatenated_numbers is NULL then
179: end if;
180: end if;
181: if p_number9 is not NULL then
182: if l_concatenated_numbers is NULL then
183: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number9);
184: else
185: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number9);
186: end if;
187: end if;
181: if p_number9 is not NULL then
182: if l_concatenated_numbers is NULL then
183: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number9);
184: else
185: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number9);
186: end if;
187: end if;
188: if p_number10 is not NULL then
189: if l_concatenated_numbers is NULL then
186: end if;
187: end if;
188: if p_number10 is not NULL then
189: if l_concatenated_numbers is NULL then
190: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number10);
191: else
192: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number10);
193: end if;
194: end if;
188: if p_number10 is not NULL then
189: if l_concatenated_numbers is NULL then
190: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number10);
191: else
192: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number10);
193: end if;
194: end if;
195:
196: return l_concatenated_numbers;