eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_SSB_DEL dependencies on PER_SSB_SHD

Line 52: (p_rec in per_ssb_shd.g_rec_type

48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml
52: (p_rec in per_ssb_shd.g_rec_type
53: ) is
54: --
55: l_proc varchar2(72) := g_package||'delete_dml';
56: --

Line 75: per_ssb_shd.constraint_error

71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: --
75: per_ssb_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: --
79: Raise;

Line 114: Procedure pre_delete(p_rec in per_ssb_shd.g_rec_type) is

110: -- Internal Row Handler Use Only.
111: --
112: -- {End Of Comments}
113: -- ----------------------------------------------------------------------------
114: Procedure pre_delete(p_rec in per_ssb_shd.g_rec_type) is
115: --
116: l_proc varchar2(72) := g_package||'pre_delete';
117: --
118: Begin

Line 156: Procedure post_delete(p_rec in per_ssb_shd.g_rec_type) is

152: -- Internal Row Handler Use Only.
153: --
154: -- {End Of Comments}
155: -- -----------------------------------------------------------------------------
156: Procedure post_delete(p_rec in per_ssb_shd.g_rec_type) is
157: --
158: l_proc varchar2(72) := g_package||'post_delete';
159: --
160: Begin

Line 166: ,p_setup_task_code_o => per_ssb_shd.g_old_rec.setup_task_code

162: begin
163: --
164: per_ssb_rkd.after_delete
165: (p_setup_sub_task_code => p_rec.setup_sub_task_code
166: ,p_setup_task_code_o => per_ssb_shd.g_old_rec.setup_task_code
167: ,p_setup_sub_task_sequence_o => per_ssb_shd.g_old_rec.setup_sub_task_sequence
168: ,p_setup_sub_task_status_o => per_ssb_shd.g_old_rec.setup_sub_task_status
169: ,p_setup_sub_task_type_o => per_ssb_shd.g_old_rec.setup_sub_task_type
170: ,p_setup_sub_task_data_pump_l_o => per_ssb_shd.g_old_rec.setup_sub_task_data_pump_link

Line 167: ,p_setup_sub_task_sequence_o => per_ssb_shd.g_old_rec.setup_sub_task_sequence

163: --
164: per_ssb_rkd.after_delete
165: (p_setup_sub_task_code => p_rec.setup_sub_task_code
166: ,p_setup_task_code_o => per_ssb_shd.g_old_rec.setup_task_code
167: ,p_setup_sub_task_sequence_o => per_ssb_shd.g_old_rec.setup_sub_task_sequence
168: ,p_setup_sub_task_status_o => per_ssb_shd.g_old_rec.setup_sub_task_status
169: ,p_setup_sub_task_type_o => per_ssb_shd.g_old_rec.setup_sub_task_type
170: ,p_setup_sub_task_data_pump_l_o => per_ssb_shd.g_old_rec.setup_sub_task_data_pump_link
171: ,p_setup_sub_task_action_o => per_ssb_shd.g_old_rec.setup_sub_task_action

Line 168: ,p_setup_sub_task_status_o => per_ssb_shd.g_old_rec.setup_sub_task_status

164: per_ssb_rkd.after_delete
165: (p_setup_sub_task_code => p_rec.setup_sub_task_code
166: ,p_setup_task_code_o => per_ssb_shd.g_old_rec.setup_task_code
167: ,p_setup_sub_task_sequence_o => per_ssb_shd.g_old_rec.setup_sub_task_sequence
168: ,p_setup_sub_task_status_o => per_ssb_shd.g_old_rec.setup_sub_task_status
169: ,p_setup_sub_task_type_o => per_ssb_shd.g_old_rec.setup_sub_task_type
170: ,p_setup_sub_task_data_pump_l_o => per_ssb_shd.g_old_rec.setup_sub_task_data_pump_link
171: ,p_setup_sub_task_action_o => per_ssb_shd.g_old_rec.setup_sub_task_action
172: ,p_setup_sub_task_creation_da_o => per_ssb_shd.g_old_rec.setup_sub_task_creation_date

Line 169: ,p_setup_sub_task_type_o => per_ssb_shd.g_old_rec.setup_sub_task_type

165: (p_setup_sub_task_code => p_rec.setup_sub_task_code
166: ,p_setup_task_code_o => per_ssb_shd.g_old_rec.setup_task_code
167: ,p_setup_sub_task_sequence_o => per_ssb_shd.g_old_rec.setup_sub_task_sequence
168: ,p_setup_sub_task_status_o => per_ssb_shd.g_old_rec.setup_sub_task_status
169: ,p_setup_sub_task_type_o => per_ssb_shd.g_old_rec.setup_sub_task_type
170: ,p_setup_sub_task_data_pump_l_o => per_ssb_shd.g_old_rec.setup_sub_task_data_pump_link
171: ,p_setup_sub_task_action_o => per_ssb_shd.g_old_rec.setup_sub_task_action
172: ,p_setup_sub_task_creation_da_o => per_ssb_shd.g_old_rec.setup_sub_task_creation_date
173: ,p_setup_sub_task_last_mod_da_o => per_ssb_shd.g_old_rec.setup_sub_task_last_mod_date

Line 170: ,p_setup_sub_task_data_pump_l_o => per_ssb_shd.g_old_rec.setup_sub_task_data_pump_link

166: ,p_setup_task_code_o => per_ssb_shd.g_old_rec.setup_task_code
167: ,p_setup_sub_task_sequence_o => per_ssb_shd.g_old_rec.setup_sub_task_sequence
168: ,p_setup_sub_task_status_o => per_ssb_shd.g_old_rec.setup_sub_task_status
169: ,p_setup_sub_task_type_o => per_ssb_shd.g_old_rec.setup_sub_task_type
170: ,p_setup_sub_task_data_pump_l_o => per_ssb_shd.g_old_rec.setup_sub_task_data_pump_link
171: ,p_setup_sub_task_action_o => per_ssb_shd.g_old_rec.setup_sub_task_action
172: ,p_setup_sub_task_creation_da_o => per_ssb_shd.g_old_rec.setup_sub_task_creation_date
173: ,p_setup_sub_task_last_mod_da_o => per_ssb_shd.g_old_rec.setup_sub_task_last_mod_date
174: ,p_legislation_code_o => per_ssb_shd.g_old_rec.legislation_code

Line 171: ,p_setup_sub_task_action_o => per_ssb_shd.g_old_rec.setup_sub_task_action

167: ,p_setup_sub_task_sequence_o => per_ssb_shd.g_old_rec.setup_sub_task_sequence
168: ,p_setup_sub_task_status_o => per_ssb_shd.g_old_rec.setup_sub_task_status
169: ,p_setup_sub_task_type_o => per_ssb_shd.g_old_rec.setup_sub_task_type
170: ,p_setup_sub_task_data_pump_l_o => per_ssb_shd.g_old_rec.setup_sub_task_data_pump_link
171: ,p_setup_sub_task_action_o => per_ssb_shd.g_old_rec.setup_sub_task_action
172: ,p_setup_sub_task_creation_da_o => per_ssb_shd.g_old_rec.setup_sub_task_creation_date
173: ,p_setup_sub_task_last_mod_da_o => per_ssb_shd.g_old_rec.setup_sub_task_last_mod_date
174: ,p_legislation_code_o => per_ssb_shd.g_old_rec.legislation_code
175: ,p_object_version_number_o => per_ssb_shd.g_old_rec.object_version_number

Line 172: ,p_setup_sub_task_creation_da_o => per_ssb_shd.g_old_rec.setup_sub_task_creation_date

168: ,p_setup_sub_task_status_o => per_ssb_shd.g_old_rec.setup_sub_task_status
169: ,p_setup_sub_task_type_o => per_ssb_shd.g_old_rec.setup_sub_task_type
170: ,p_setup_sub_task_data_pump_l_o => per_ssb_shd.g_old_rec.setup_sub_task_data_pump_link
171: ,p_setup_sub_task_action_o => per_ssb_shd.g_old_rec.setup_sub_task_action
172: ,p_setup_sub_task_creation_da_o => per_ssb_shd.g_old_rec.setup_sub_task_creation_date
173: ,p_setup_sub_task_last_mod_da_o => per_ssb_shd.g_old_rec.setup_sub_task_last_mod_date
174: ,p_legislation_code_o => per_ssb_shd.g_old_rec.legislation_code
175: ,p_object_version_number_o => per_ssb_shd.g_old_rec.object_version_number
176: );

Line 173: ,p_setup_sub_task_last_mod_da_o => per_ssb_shd.g_old_rec.setup_sub_task_last_mod_date

169: ,p_setup_sub_task_type_o => per_ssb_shd.g_old_rec.setup_sub_task_type
170: ,p_setup_sub_task_data_pump_l_o => per_ssb_shd.g_old_rec.setup_sub_task_data_pump_link
171: ,p_setup_sub_task_action_o => per_ssb_shd.g_old_rec.setup_sub_task_action
172: ,p_setup_sub_task_creation_da_o => per_ssb_shd.g_old_rec.setup_sub_task_creation_date
173: ,p_setup_sub_task_last_mod_da_o => per_ssb_shd.g_old_rec.setup_sub_task_last_mod_date
174: ,p_legislation_code_o => per_ssb_shd.g_old_rec.legislation_code
175: ,p_object_version_number_o => per_ssb_shd.g_old_rec.object_version_number
176: );
177: --

Line 174: ,p_legislation_code_o => per_ssb_shd.g_old_rec.legislation_code

170: ,p_setup_sub_task_data_pump_l_o => per_ssb_shd.g_old_rec.setup_sub_task_data_pump_link
171: ,p_setup_sub_task_action_o => per_ssb_shd.g_old_rec.setup_sub_task_action
172: ,p_setup_sub_task_creation_da_o => per_ssb_shd.g_old_rec.setup_sub_task_creation_date
173: ,p_setup_sub_task_last_mod_da_o => per_ssb_shd.g_old_rec.setup_sub_task_last_mod_date
174: ,p_legislation_code_o => per_ssb_shd.g_old_rec.legislation_code
175: ,p_object_version_number_o => per_ssb_shd.g_old_rec.object_version_number
176: );
177: --
178: exception

Line 175: ,p_object_version_number_o => per_ssb_shd.g_old_rec.object_version_number

171: ,p_setup_sub_task_action_o => per_ssb_shd.g_old_rec.setup_sub_task_action
172: ,p_setup_sub_task_creation_da_o => per_ssb_shd.g_old_rec.setup_sub_task_creation_date
173: ,p_setup_sub_task_last_mod_da_o => per_ssb_shd.g_old_rec.setup_sub_task_last_mod_date
174: ,p_legislation_code_o => per_ssb_shd.g_old_rec.legislation_code
175: ,p_object_version_number_o => per_ssb_shd.g_old_rec.object_version_number
176: );
177: --
178: exception
179: --

Line 195: (p_rec in per_ssb_shd.g_rec_type

191: -- ----------------------------------------------------------------------------
192: -- |---------------------------------< del >----------------------------------|
193: -- ----------------------------------------------------------------------------
194: Procedure del
195: (p_rec in per_ssb_shd.g_rec_type
196: ) is
197: --
198: l_proc varchar2(72) := g_package||'del';
199: --

Line 205: per_ssb_shd.lck

201: hr_utility.set_location('Entering:'||l_proc, 5);
202: --
203: -- We must lock the row which we need to delete.
204: --
205: per_ssb_shd.lck
206: (p_rec.setup_sub_task_code
207: ,p_rec.object_version_number
208: );
209: --

Line 242: l_rec per_ssb_shd.g_rec_type;

238: (p_setup_sub_task_code in varchar2
239: ,p_object_version_number in number
240: ) is
241: --
242: l_rec per_ssb_shd.g_rec_type;
243: l_proc varchar2(72) := g_package||'del';
244: --
245: Begin
246: hr_utility.set_location('Entering:'||l_proc, 5);