DBA Data[Home] [Help]

APPS.PAY_JP_REPORT_PKG dependencies on FND_NUMBER

Line 127: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number1);

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;

Line 129: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number1);

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

Line 134: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number2);

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;

Line 136: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number2);

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

Line 141: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number3);

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;

Line 143: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number3);

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

Line 148: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number4);

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;

Line 150: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number4);

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

Line 155: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number5);

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;

Line 157: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number5);

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

Line 162: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number6);

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;

Line 164: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number6);

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

Line 169: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number7);

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;

Line 171: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number7);

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

Line 176: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number8);

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;

Line 178: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number8);

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

Line 183: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number9);

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;

Line 185: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number9);

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

Line 190: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number10);

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;

Line 192: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number10);

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;