DBA Data[Home] [Help]

APPS.PAY_USER_COLUMNS_PKG dependencies on HR_API

Line 73: p_base_user_column_name in varchar2 default hr_api.g_varchar2) is

69: p_legislation_code in varchar2,
70: p_legislation_subgroup in varchar2,
71: p_user_column_name in varchar2,
72: p_formula_id in number,
73: p_base_user_column_name in varchar2 default hr_api.g_varchar2) is
74: begin
75: --
76: update PAY_USER_COLUMNS
77: set USER_COLUMN_ID = p_user_column_id,

Line 126: p_base_user_column_name in varchar2 default hr_api.g_varchar2) is

122: p_legislation_code in varchar2,
123: p_legislation_subgroup in varchar2,
124: p_user_column_name in varchar2,
125: p_formula_id in number,
126: p_base_user_column_name in varchar2 default hr_api.g_varchar2) is
127: --_TL cursor--
128: cursor T is select *
129: from PAY_USER_COLUMNS_TL
130: where user_column_id = p_user_column_id

Line 207: p_base_user_column_name in varchar2 default hr_api.g_varchar2) is

203: procedure check_unique ( p_rowid in varchar2,
204: p_user_column_name in varchar2,
205: p_user_table_id in number,
206: p_business_group_id in number,
207: p_base_user_column_name in varchar2 default hr_api.g_varchar2) is
208:
209: cursor c1 is
210: select '1'
211: from pay_user_columns uc

Line 237: p_base_user_column_name in varchar2 default hr_api.g_varchar2) is

233: p_user_column_name in varchar2,
234: p_user_table_id in number,
235: p_business_group_id in number,
236: p_legislation_code in varchar2,
237: p_base_user_column_name in varchar2 default hr_api.g_varchar2) is
238: cursor c1 is
239: select '1'
240: from pay_user_columns uc
241: where upper(uc.user_column_name) = upper( p_base_user_column_name)