APPS.PAY_JP_DBI_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 15

		select	b.user_table_id,
			b.user_table_name,
			b.user_row_title,
			tl.user_table_name	tl_user_table_name,
			tl.user_row_title	tl_user_row_title
		from	pay_user_tables		b,
			pay_user_tables_tl	tl
		where	b.range_or_match = p_range_or_match
		and	b.legislation_code = 'JP'
		and	b.business_group_id is null
		and	tl.user_table_id = b.user_table_id
		and	tl.language = 'JA';

Line: 29

		select	b.row_low_range_or_name,
			tl.row_low_range_or_name	tl_row_low_range_or_name
		from	pay_user_rows_f		b,
			pay_user_rows_f_tl	tl
		where	b.user_table_id = p_user_table_id
		and	b.legislation_code = 'JP'
		and	b.business_group_id is null
		and	tl.user_row_id = b.user_row_id
		and	tl.language = 'JA'
		group by
			b.user_row_id,
			b.row_low_range_or_name,
			tl.row_low_range_or_name;

Line: 44

		select	b.user_column_name,
			tl.user_column_name	tl_user_column_name
		from	pay_user_columns	b,
			pay_user_columns_tl	tl
		where	b.user_table_id = p_user_table_id
		and	b.legislation_code = 'JP'
		and	b.business_group_id is null
		and	tl.user_column_id = b.user_column_id
		and	tl.language = 'JA';

Line: 60

		select	'Y'
		from	fnd_languages
		where	language_code = 'JA'
		and	installed_flag in ('B', 'I');

Line: 82

		select	meaning
		into	l_meaning
		from	fnd_lookup_values
		where	lookup_type = p_lookup_type
		and	view_application_id = 3
		and	lookup_code = p_lookup_code
		and	security_group_id = 0
		and	language = 'JA';

Line: 94

	procedure update_tl_row(
		p_user_name		in varchar2,
		p_tl_user_name		in varchar2)
	is
		l_user_entity_id	number;

Line: 104

			select	u.user_entity_id
			from	ff_database_items	d,
				ff_user_entities	u
			where	d.user_name = p_user_name
			and	u.user_entity_id = d.user_entity_id
			and	u.legislation_code = 'JP';

Line: 114

			select	translated_user_name
			into	l_tl_user_name
			from	ff_database_items_tl
			where	user_name = p_user_name
			and	user_entity_id = l_user_entity_id
			and	language = 'JA';

Line: 121

			-- Update only when the user_name is different.
			--
			l_new_tl_user_name := ff_dbi_utils_pkg.str2dbiname(p_tl_user_name);

Line: 126

				-- Following procedure will be changed to delete compiled info
				-- if the translated DBI is used in fastformulas,
				-- and log the message to fix those formulas.
				--
				ff_database_items_pkg.update_seeded_tl_rows(
					x_user_name		=> p_user_name,
					x_user_entity_id	=> l_user_entity_id,
					x_language		=> 'JA',
					x_translated_user_name	=> l_new_tl_user_name,
					x_description		=> null,
                                        x_got_error             => l_got_error);

Line: 140

	end update_tl_row;

Line: 143

	-- Note this only updates FF_DATABASE_ITEMS_TL with JA language.
	-- It is not necessary to check whether the db charset is JA compliant,
	-- because JA installation means that the DB is JA charset compliant.
	--
	if ja_installed and ff_dbi_utils_pkg.translations_supported('JP') then
		l_upper_limit	:= decode_lookup('NAME_TRANSLATIONS', 'UPPER_LIMIT');

Line: 164

			update_tl_row(l_user_name, l_tl_user_name);

Line: 174

			update_tl_row(l_user_name, l_tl_user_name);

Line: 189

				update_tl_row(l_user_name, l_tl_user_name);

Line: 199

				update_tl_row(l_user_name, l_tl_user_name);

Line: 216

					update_tl_row(l_user_name, l_tl_user_name);

Line: 225

			update_tl_row('G_COM_PAY_BASE_DAYS_MIN_DE', l_tl_user_name);

Line: 230

			update_tl_row('PAY_JP_EI_LOCATION_BUSINESS_TYPE', l_tl_user_name);