DBA Data[Home] [Help]

APPS.PAY_JP_DBI_PKG dependencies on FF_DBI_UTILS_PKG

Line 128: l_new_tl_user_name := ff_dbi_utils_pkg.str2dbiname(p_tl_user_name);

124: and language = 'JA';
125: --
126: -- Update only when the user_name is different.
127: --
128: l_new_tl_user_name := ff_dbi_utils_pkg.str2dbiname(p_tl_user_name);
129: if l_tl_user_name <> l_new_tl_user_name then
130: --
131: -- Following procedure will be changed to delete compiled info
132: -- if the translated DBI is used in fastformulas,

Line 231: if ja_installed and ff_dbi_utils_pkg.translations_supported('JP') then

227: -- Note this only updates FF_DATABASE_ITEMS_TL with JA language.
228: -- It is not necessary to check whether the db charset is JA compliant,
229: -- because JA installation means that the DB is JA charset compliant.
230: --
231: if ja_installed and ff_dbi_utils_pkg.translations_supported('JP') then
232: l_upper_limit := decode_lookup('NAME_TRANSLATIONS', 'UPPER_LIMIT');
233: l_lower_limit := decode_lookup('NAME_TRANSLATIONS', 'LOWER_LIMIT');
234: l_max := decode_lookup('NAME_TRANSLATIONS', 'MAX');
235: l_min := decode_lookup('NAME_TRANSLATIONS', 'MIN');

Line 240: l_user_name := ff_dbi_utils_pkg.str2dbiname(

236: --
237: -- UDT DBIs for route "PAY_JP_UDT_RANGE_ROUTE1".
238: --
239: for l_tab in csr_tab('R') loop
240: l_user_name := ff_dbi_utils_pkg.str2dbiname(
241: l_tab.user_table_name || '_' ||
242: l_tab.user_row_title ||
243: '_UPPER_LIMIT');
244: l_tl_user_name := ff_dbi_utils_pkg.str2dbiname(

Line 244: l_tl_user_name := ff_dbi_utils_pkg.str2dbiname(

240: l_user_name := ff_dbi_utils_pkg.str2dbiname(
241: l_tab.user_table_name || '_' ||
242: l_tab.user_row_title ||
243: '_UPPER_LIMIT');
244: l_tl_user_name := ff_dbi_utils_pkg.str2dbiname(
245: l_tab.tl_user_table_name || '_' ||
246: l_tab.tl_user_row_title || '_' ||
247: l_upper_limit);
248: update_tl_row(l_user_name, l_tl_user_name);

Line 250: l_user_name := ff_dbi_utils_pkg.str2dbiname(

246: l_tab.tl_user_row_title || '_' ||
247: l_upper_limit);
248: update_tl_row(l_user_name, l_tl_user_name);
249: --
250: l_user_name := ff_dbi_utils_pkg.str2dbiname(
251: l_tab.user_table_name || '_' ||
252: l_tab.user_row_title ||
253: '_LOWER_LIMIT');
254: l_tl_user_name := ff_dbi_utils_pkg.str2dbiname(

Line 254: l_tl_user_name := ff_dbi_utils_pkg.str2dbiname(

250: l_user_name := ff_dbi_utils_pkg.str2dbiname(
251: l_tab.user_table_name || '_' ||
252: l_tab.user_row_title ||
253: '_LOWER_LIMIT');
254: l_tl_user_name := ff_dbi_utils_pkg.str2dbiname(
255: l_tab.tl_user_table_name || '_' ||
256: l_tab.tl_user_row_title || '_' ||
257: l_lower_limit);
258: update_tl_row(l_user_name, l_tl_user_name);

Line 265: l_user_name := ff_dbi_utils_pkg.str2dbiname(

261: -- UDT DBIs for route "PAY_JP_UDT_RANGE_ROUTE2".
262: --
263: for l_tab in csr_tab('R') loop
264: for l_col in csr_col(l_tab.user_table_id) loop
265: l_user_name := ff_dbi_utils_pkg.str2dbiname(
266: l_tab.user_table_name || '_' ||
267: l_col.user_column_name ||
268: '_MAX');
269: l_tl_user_name := ff_dbi_utils_pkg.str2dbiname(

Line 269: l_tl_user_name := ff_dbi_utils_pkg.str2dbiname(

265: l_user_name := ff_dbi_utils_pkg.str2dbiname(
266: l_tab.user_table_name || '_' ||
267: l_col.user_column_name ||
268: '_MAX');
269: l_tl_user_name := ff_dbi_utils_pkg.str2dbiname(
270: l_tab.tl_user_table_name || '_' ||
271: l_col.tl_user_column_name || '_' ||
272: l_max);
273: update_tl_row(l_user_name, l_tl_user_name);

Line 275: l_user_name := ff_dbi_utils_pkg.str2dbiname(

271: l_col.tl_user_column_name || '_' ||
272: l_max);
273: update_tl_row(l_user_name, l_tl_user_name);
274: --
275: l_user_name := ff_dbi_utils_pkg.str2dbiname(
276: l_tab.user_table_name || '_' ||
277: l_col.user_column_name ||
278: '_MIN');
279: l_tl_user_name := ff_dbi_utils_pkg.str2dbiname(

Line 279: l_tl_user_name := ff_dbi_utils_pkg.str2dbiname(

275: l_user_name := ff_dbi_utils_pkg.str2dbiname(
276: l_tab.user_table_name || '_' ||
277: l_col.user_column_name ||
278: '_MIN');
279: l_tl_user_name := ff_dbi_utils_pkg.str2dbiname(
280: l_tab.tl_user_table_name || '_' ||
281: l_col.tl_user_column_name || '_' ||
282: l_min);
283: update_tl_row(l_user_name, l_tl_user_name);

Line 292: l_user_name := ff_dbi_utils_pkg.str2dbiname(

288: --
289: for l_tab in csr_tab('M') loop
290: for l_row in csr_row(l_tab.user_table_id) loop
291: for l_col in csr_col(l_tab.user_table_id) loop
292: l_user_name := ff_dbi_utils_pkg.str2dbiname(
293: l_tab.user_table_name || '_' ||
294: l_row.row_low_range_or_name || '_' ||
295: l_col.user_column_name);
296: l_tl_user_name := ff_dbi_utils_pkg.str2dbiname(

Line 296: l_tl_user_name := ff_dbi_utils_pkg.str2dbiname(

292: l_user_name := ff_dbi_utils_pkg.str2dbiname(
293: l_tab.user_table_name || '_' ||
294: l_row.row_low_range_or_name || '_' ||
295: l_col.user_column_name);
296: l_tl_user_name := ff_dbi_utils_pkg.str2dbiname(
297: l_tab.tl_user_table_name || '_' ||
298: l_row.tl_row_low_range_or_name || '_' ||
299: l_col.tl_user_column_name);
300: update_tl_row(l_user_name, l_tl_user_name);