APPS.PAY_JP_DBI_PKG dependencies on FF_DATABASE_ITEMS

Line 11: l_user_name ff_database_items.user_name%type;

7: l_lower_limit hr_lookups.meaning%type;
8: l_max hr_lookups.meaning%type;
9: l_min hr_lookups.meaning%type;
10: --
11: l_user_name ff_database_items.user_name%type;
12: l_tl_user_name ff_database_items_tl.translated_user_name%type;
13: --
14: cursor csr_tab(p_range_or_match in varchar2) is
15: select b.user_table_id,

Line 12: l_tl_user_name ff_database_items_tl.translated_user_name%type;

8: l_max hr_lookups.meaning%type;
9: l_min hr_lookups.meaning%type;
10: --
11: l_user_name ff_database_items.user_name%type;
12: l_tl_user_name ff_database_items_tl.translated_user_name%type;
13: --
14: cursor csr_tab(p_range_or_match in varchar2) is
15: select b.user_table_id,
16: b.user_table_name,

Line 99: l_tl_user_name ff_database_items_tl.translated_user_name%type;

95: p_user_name in varchar2,
96: p_tl_user_name in varchar2)
97: is
98: l_user_entity_id number;
99: l_tl_user_name ff_database_items_tl.translated_user_name%type;
100: l_new_tl_user_name ff_database_items_tl.translated_user_name%type;
101: l_got_error boolean;
102: --
103: cursor csr is

Line 100: l_new_tl_user_name ff_database_items_tl.translated_user_name%type;

96: p_tl_user_name in varchar2)
97: is
98: l_user_entity_id number;
99: l_tl_user_name ff_database_items_tl.translated_user_name%type;
100: l_new_tl_user_name ff_database_items_tl.translated_user_name%type;
101: l_got_error boolean;
102: --
103: cursor csr is
104: select u.user_entity_id

Line 105: from ff_database_items d,

101: l_got_error boolean;
102: --
103: cursor csr is
104: select u.user_entity_id
105: from ff_database_items d,
106: ff_user_entities u
107: where d.user_name = p_user_name
108: and u.user_entity_id = d.user_entity_id
109: and u.legislation_code = 'JP';

Line 116: from ff_database_items_tl

112: fetch csr into l_user_entity_id;
113: if csr%found then
114: select translated_user_name
115: into l_tl_user_name
116: from ff_database_items_tl
117: where user_name = p_user_name
118: and user_entity_id = l_user_entity_id
119: and language = 'JA';
120: --

Line 130: ff_database_items_pkg.update_seeded_tl_rows(

126: -- Following procedure will be changed to delete compiled info
127: -- if the translated DBI is used in fastformulas,
128: -- and log the message to fix those formulas.
129: --
130: ff_database_items_pkg.update_seeded_tl_rows(
131: x_user_name => p_user_name,
132: x_user_entity_id => l_user_entity_id,
133: x_language => 'JA',
134: x_translated_user_name => l_new_tl_user_name,

Line 143: -- Note this only updates FF_DATABASE_ITEMS_TL with JA language.

139: close csr;
140: end update_tl_row;
141: begin
142: --
143: -- Note this only updates FF_DATABASE_ITEMS_TL with JA language.
144: -- It is not necessary to check whether the db charset is JA compliant,
145: -- because JA installation means that the DB is JA charset compliant.
146: --
147: if ja_installed and ff_dbi_utils_pkg.translations_supported('JP') then