DBA Data[Home] [Help]

APPS.PAY_USER_TABLES_PKG dependencies on HR_API

Line 80: p_base_user_table_name in varchar2 default hr_api.g_varchar2,

76: p_range_or_match in varchar2,
77: p_user_key_units in varchar2,
78: p_user_table_name in varchar2,
79: p_user_row_title in varchar2,
80: p_base_user_table_name in varchar2 default hr_api.g_varchar2,
81: p_base_user_row_title in varchar2 default hr_api.g_varchar2) is
82: begin
83: --
84: check_unique ( p_rowid => p_rowid,

Line 81: p_base_user_row_title in varchar2 default hr_api.g_varchar2) is

77: p_user_key_units in varchar2,
78: p_user_table_name in varchar2,
79: p_user_row_title in varchar2,
80: p_base_user_table_name in varchar2 default hr_api.g_varchar2,
81: p_base_user_row_title in varchar2 default hr_api.g_varchar2) is
82: begin
83: --
84: check_unique ( p_rowid => p_rowid,
85: p_user_table_name => p_user_table_name,

Line 142: p_base_user_table_name in varchar2 default hr_api.g_varchar2,

138: p_range_or_match in varchar2,
139: p_user_key_units in varchar2,
140: p_user_table_name in varchar2,
141: p_user_row_title in varchar2,
142: p_base_user_table_name in varchar2 default hr_api.g_varchar2,
143: p_base_user_row_title in varchar2 default hr_api.g_varchar2) is
144:
145: --_TL cursor--
146: cursor T is select *

Line 143: p_base_user_row_title in varchar2 default hr_api.g_varchar2) is

139: p_user_key_units in varchar2,
140: p_user_table_name in varchar2,
141: p_user_row_title in varchar2,
142: p_base_user_table_name in varchar2 default hr_api.g_varchar2,
143: p_base_user_row_title in varchar2 default hr_api.g_varchar2) is
144:
145: --_TL cursor--
146: cursor T is select *
147: from PAY_USER_TABLES_TL

Line 239: p_base_user_table_name in varchar2 default hr_api.g_varchar2) is

235: procedure check_unique ( p_rowid in varchar2,
236: p_user_table_name in varchar2,
237: p_business_group_id in number,
238: p_legislation_code in varchar2,
239: p_base_user_table_name in varchar2 default hr_api.g_varchar2) is
240: cursor c1 is
241: select '1'
242: from pay_user_tables ut
243: where upper(ut.user_table_name) = upper(p_base_user_table_name)