eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_JP_REPORT_PKG dependencies on FND_NUMBER

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

132: l_concatenated_numbers:=NULL;
133:
134: if p_number1 is not NULL then
135: if l_concatenated_numbers is NULL then
136: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number1);
137: else
138: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number1);
139: end if;
140: end if;

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

134: if p_number1 is not NULL then
135: if l_concatenated_numbers is NULL then
136: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number1);
137: else
138: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number1);
139: end if;
140: end if;
141: if p_number2 is not NULL then
142: if l_concatenated_numbers is NULL then

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

139: end if;
140: end if;
141: if p_number2 is not NULL then
142: if l_concatenated_numbers is NULL then
143: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number2);
144: else
145: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number2);
146: end if;
147: end if;

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

141: if p_number2 is not NULL then
142: if l_concatenated_numbers is NULL then
143: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number2);
144: else
145: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number2);
146: end if;
147: end if;
148: if p_number3 is not NULL then
149: if l_concatenated_numbers is NULL then

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

146: end if;
147: end if;
148: if p_number3 is not NULL then
149: if l_concatenated_numbers is NULL then
150: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number3);
151: else
152: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number3);
153: end if;
154: end if;

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

148: if p_number3 is not NULL then
149: if l_concatenated_numbers is NULL then
150: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number3);
151: else
152: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number3);
153: end if;
154: end if;
155: if p_number4 is not NULL then
156: if l_concatenated_numbers is NULL then

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

153: end if;
154: end if;
155: if p_number4 is not NULL then
156: if l_concatenated_numbers is NULL then
157: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number4);
158: else
159: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number4);
160: end if;
161: end if;

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

155: if p_number4 is not NULL then
156: if l_concatenated_numbers is NULL then
157: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number4);
158: else
159: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number4);
160: end if;
161: end if;
162: if p_number5 is not NULL then
163: if l_concatenated_numbers is NULL then

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

160: end if;
161: end if;
162: if p_number5 is not NULL then
163: if l_concatenated_numbers is NULL then
164: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number5);
165: else
166: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number5);
167: end if;
168: end if;

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

162: if p_number5 is not NULL then
163: if l_concatenated_numbers is NULL then
164: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number5);
165: else
166: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number5);
167: end if;
168: end if;
169: if p_number6 is not NULL then
170: if l_concatenated_numbers is NULL then

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

167: end if;
168: end if;
169: if p_number6 is not NULL then
170: if l_concatenated_numbers is NULL then
171: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number6);
172: else
173: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number6);
174: end if;
175: end if;

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

169: if p_number6 is not NULL then
170: if l_concatenated_numbers is NULL then
171: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number6);
172: else
173: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number6);
174: end if;
175: end if;
176: if p_number7 is not NULL then
177: if l_concatenated_numbers is NULL then

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

174: end if;
175: end if;
176: if p_number7 is not NULL then
177: if l_concatenated_numbers is NULL then
178: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number7);
179: else
180: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number7);
181: end if;
182: end if;

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

176: if p_number7 is not NULL then
177: if l_concatenated_numbers is NULL then
178: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number7);
179: else
180: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number7);
181: end if;
182: end if;
183: if p_number8 is not NULL then
184: if l_concatenated_numbers is NULL then

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

181: end if;
182: end if;
183: if p_number8 is not NULL then
184: if l_concatenated_numbers is NULL then
185: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number8);
186: else
187: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number8);
188: end if;
189: end if;

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

183: if p_number8 is not NULL then
184: if l_concatenated_numbers is NULL then
185: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number8);
186: else
187: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number8);
188: end if;
189: end if;
190: if p_number9 is not NULL then
191: if l_concatenated_numbers is NULL then

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

188: end if;
189: end if;
190: if p_number9 is not NULL then
191: if l_concatenated_numbers is NULL then
192: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number9);
193: else
194: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number9);
195: end if;
196: end if;

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

190: if p_number9 is not NULL then
191: if l_concatenated_numbers is NULL then
192: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number9);
193: else
194: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number9);
195: end if;
196: end if;
197: if p_number10 is not NULL then
198: if l_concatenated_numbers is NULL then

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

195: end if;
196: end if;
197: if p_number10 is not NULL then
198: if l_concatenated_numbers is NULL then
199: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number10);
200: else
201: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number10);
202: end if;
203: end if;

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

197: if p_number10 is not NULL then
198: if l_concatenated_numbers is NULL then
199: l_concatenated_numbers:=fnd_number.number_to_canonical(p_number10);
200: else
201: l_concatenated_numbers:=l_concatenated_numbers || ',' || fnd_number.number_to_canonical(p_number10);
202: end if;
203: end if;
204:
205: return l_concatenated_numbers;

Line 3145: -- not use fnd_number.number_to_canonical

3141: return varchar2
3142: is
3143: begin
3144: --
3145: -- not use fnd_number.number_to_canonical
3146: return cnv_txt(to_char(p_text),p_char_set);
3147: --
3148: end cnv_txt;
3149: --

Line 3243: return add_tag(p_tag,fnd_number.number_to_canonical(p_text));

3239: return varchar2
3240: is
3241: begin
3242: --
3243: return add_tag(p_tag,fnd_number.number_to_canonical(p_text));
3244: --
3245: end add_tag;
3246: --
3247: -- -------------------------------------------------------------------------

Line 3462: and fnd_number.canonical_to_number(p_row)

3458: and nvl(puc.legislation_code,c_legislation_code) = c_legislation_code
3459: and pur.user_table_id = l_table_id
3460: and p_effective_date
3461: between pur.effective_start_date and pur.effective_end_date
3462: and fnd_number.canonical_to_number(p_row)
3463: between fnd_number.canonical_to_number(pur.row_low_range_or_name) and fnd_number.canonical_to_number(pur.row_high_range)
3464: and nvl(pur.business_group_id,p_business_group_id) = p_business_group_id
3465: and nvl(pur.legislation_code,c_legislation_code) = c_legislation_code
3466: and puci.user_column_id = puc.user_column_id

Line 3463: between fnd_number.canonical_to_number(pur.row_low_range_or_name) and fnd_number.canonical_to_number(pur.row_high_range)

3459: and pur.user_table_id = l_table_id
3460: and p_effective_date
3461: between pur.effective_start_date and pur.effective_end_date
3462: and fnd_number.canonical_to_number(p_row)
3463: between fnd_number.canonical_to_number(pur.row_low_range_or_name) and fnd_number.canonical_to_number(pur.row_high_range)
3464: and nvl(pur.business_group_id,p_business_group_id) = p_business_group_id
3465: and nvl(pur.legislation_code,c_legislation_code) = c_legislation_code
3466: and puci.user_column_id = puc.user_column_id
3467: and puci.user_row_id = pur.user_row_id