APPS.BEN_EXT_WHERE_CLAUSE_API dependencies on HR_API

Line 105: ,p_seq_num in number default hr_api.g_number

101: procedure update_ext_where_clause
102: (
103: p_validate in boolean default false
104: ,p_ext_where_clause_id in number
105: ,p_seq_num in number default hr_api.g_number
106: ,p_oper_cd in varchar2 default hr_api.g_varchar2
107: ,p_val in varchar2 default hr_api.g_varchar2
108: ,p_and_or_cd in varchar2 default hr_api.g_varchar2
109: ,p_ext_data_elmt_id in number default hr_api.g_number

Line 106: ,p_oper_cd in varchar2 default hr_api.g_varchar2

102: (
103: p_validate in boolean default false
104: ,p_ext_where_clause_id in number
105: ,p_seq_num in number default hr_api.g_number
106: ,p_oper_cd in varchar2 default hr_api.g_varchar2
107: ,p_val in varchar2 default hr_api.g_varchar2
108: ,p_and_or_cd in varchar2 default hr_api.g_varchar2
109: ,p_ext_data_elmt_id in number default hr_api.g_number
110: ,p_cond_ext_data_elmt_id in number default hr_api.g_number

Line 107: ,p_val in varchar2 default hr_api.g_varchar2

103: p_validate in boolean default false
104: ,p_ext_where_clause_id in number
105: ,p_seq_num in number default hr_api.g_number
106: ,p_oper_cd in varchar2 default hr_api.g_varchar2
107: ,p_val in varchar2 default hr_api.g_varchar2
108: ,p_and_or_cd in varchar2 default hr_api.g_varchar2
109: ,p_ext_data_elmt_id in number default hr_api.g_number
110: ,p_cond_ext_data_elmt_id in number default hr_api.g_number
111: ,p_ext_rcd_in_file_id in number default hr_api.g_number

Line 108: ,p_and_or_cd in varchar2 default hr_api.g_varchar2

104: ,p_ext_where_clause_id in number
105: ,p_seq_num in number default hr_api.g_number
106: ,p_oper_cd in varchar2 default hr_api.g_varchar2
107: ,p_val in varchar2 default hr_api.g_varchar2
108: ,p_and_or_cd in varchar2 default hr_api.g_varchar2
109: ,p_ext_data_elmt_id in number default hr_api.g_number
110: ,p_cond_ext_data_elmt_id in number default hr_api.g_number
111: ,p_ext_rcd_in_file_id in number default hr_api.g_number
112: ,p_ext_data_elmt_in_rcd_id in number default hr_api.g_number

Line 109: ,p_ext_data_elmt_id in number default hr_api.g_number

105: ,p_seq_num in number default hr_api.g_number
106: ,p_oper_cd in varchar2 default hr_api.g_varchar2
107: ,p_val in varchar2 default hr_api.g_varchar2
108: ,p_and_or_cd in varchar2 default hr_api.g_varchar2
109: ,p_ext_data_elmt_id in number default hr_api.g_number
110: ,p_cond_ext_data_elmt_id in number default hr_api.g_number
111: ,p_ext_rcd_in_file_id in number default hr_api.g_number
112: ,p_ext_data_elmt_in_rcd_id in number default hr_api.g_number
113: ,p_business_group_id in number default hr_api.g_number

Line 110: ,p_cond_ext_data_elmt_id in number default hr_api.g_number

106: ,p_oper_cd in varchar2 default hr_api.g_varchar2
107: ,p_val in varchar2 default hr_api.g_varchar2
108: ,p_and_or_cd in varchar2 default hr_api.g_varchar2
109: ,p_ext_data_elmt_id in number default hr_api.g_number
110: ,p_cond_ext_data_elmt_id in number default hr_api.g_number
111: ,p_ext_rcd_in_file_id in number default hr_api.g_number
112: ,p_ext_data_elmt_in_rcd_id in number default hr_api.g_number
113: ,p_business_group_id in number default hr_api.g_number
114: ,p_legislation_code in varchar2 default hr_api.g_varchar2

Line 111: ,p_ext_rcd_in_file_id in number default hr_api.g_number

107: ,p_val in varchar2 default hr_api.g_varchar2
108: ,p_and_or_cd in varchar2 default hr_api.g_varchar2
109: ,p_ext_data_elmt_id in number default hr_api.g_number
110: ,p_cond_ext_data_elmt_id in number default hr_api.g_number
111: ,p_ext_rcd_in_file_id in number default hr_api.g_number
112: ,p_ext_data_elmt_in_rcd_id in number default hr_api.g_number
113: ,p_business_group_id in number default hr_api.g_number
114: ,p_legislation_code in varchar2 default hr_api.g_varchar2
115: ,p_object_version_number in out nocopy number

Line 112: ,p_ext_data_elmt_in_rcd_id in number default hr_api.g_number

108: ,p_and_or_cd in varchar2 default hr_api.g_varchar2
109: ,p_ext_data_elmt_id in number default hr_api.g_number
110: ,p_cond_ext_data_elmt_id in number default hr_api.g_number
111: ,p_ext_rcd_in_file_id in number default hr_api.g_number
112: ,p_ext_data_elmt_in_rcd_id in number default hr_api.g_number
113: ,p_business_group_id in number default hr_api.g_number
114: ,p_legislation_code in varchar2 default hr_api.g_varchar2
115: ,p_object_version_number in out nocopy number
116: ,p_cond_ext_data_elmt_in_rcd_id in number default hr_api.g_number

Line 113: ,p_business_group_id in number default hr_api.g_number

109: ,p_ext_data_elmt_id in number default hr_api.g_number
110: ,p_cond_ext_data_elmt_id in number default hr_api.g_number
111: ,p_ext_rcd_in_file_id in number default hr_api.g_number
112: ,p_ext_data_elmt_in_rcd_id in number default hr_api.g_number
113: ,p_business_group_id in number default hr_api.g_number
114: ,p_legislation_code in varchar2 default hr_api.g_varchar2
115: ,p_object_version_number in out nocopy number
116: ,p_cond_ext_data_elmt_in_rcd_id in number default hr_api.g_number
117: ,p_effective_date in date

Line 114: ,p_legislation_code in varchar2 default hr_api.g_varchar2

110: ,p_cond_ext_data_elmt_id in number default hr_api.g_number
111: ,p_ext_rcd_in_file_id in number default hr_api.g_number
112: ,p_ext_data_elmt_in_rcd_id in number default hr_api.g_number
113: ,p_business_group_id in number default hr_api.g_number
114: ,p_legislation_code in varchar2 default hr_api.g_varchar2
115: ,p_object_version_number in out nocopy number
116: ,p_cond_ext_data_elmt_in_rcd_id in number default hr_api.g_number
117: ,p_effective_date in date
118: );

Line 116: ,p_cond_ext_data_elmt_in_rcd_id in number default hr_api.g_number

112: ,p_ext_data_elmt_in_rcd_id in number default hr_api.g_number
113: ,p_business_group_id in number default hr_api.g_number
114: ,p_legislation_code in varchar2 default hr_api.g_varchar2
115: ,p_object_version_number in out nocopy number
116: ,p_cond_ext_data_elmt_in_rcd_id in number default hr_api.g_number
117: ,p_effective_date in date
118: );
119: --
120: -- ----------------------------------------------------------------------------