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.HR_TIS_DEL dependencies on HR_TIS_SHD

Line 52: (p_rec in hr_tis_shd.g_rec_type

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

Line 75: hr_tis_shd.constraint_error

71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: --
75: hr_tis_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 hr_tis_shd.g_rec_type) is

110: -- Internal Row Handler Use Only.
111: --
112: -- {End Of Comments}
113: -- ----------------------------------------------------------------------------
114: Procedure pre_delete(p_rec in hr_tis_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 hr_tis_shd.g_rec_type) is

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

Line 166: ,p_topic_id_o => hr_tis_shd.g_old_rec.topic_id

162: begin
163: --
164: hr_tis_rkd.after_delete
165: (p_topic_integrations_id => p_rec.topic_integrations_id
166: ,p_topic_id_o => hr_tis_shd.g_old_rec.topic_id
167: ,p_integration_id_o => hr_tis_shd.g_old_rec.integration_id
168: ,p_param_name1_o => hr_tis_shd.g_old_rec.param_name1
169: ,p_param_value1_o => hr_tis_shd.g_old_rec.param_value1
170: ,p_param_name2_o => hr_tis_shd.g_old_rec.param_name2

Line 167: ,p_integration_id_o => hr_tis_shd.g_old_rec.integration_id

163: --
164: hr_tis_rkd.after_delete
165: (p_topic_integrations_id => p_rec.topic_integrations_id
166: ,p_topic_id_o => hr_tis_shd.g_old_rec.topic_id
167: ,p_integration_id_o => hr_tis_shd.g_old_rec.integration_id
168: ,p_param_name1_o => hr_tis_shd.g_old_rec.param_name1
169: ,p_param_value1_o => hr_tis_shd.g_old_rec.param_value1
170: ,p_param_name2_o => hr_tis_shd.g_old_rec.param_name2
171: ,p_param_value2_o => hr_tis_shd.g_old_rec.param_value2

Line 168: ,p_param_name1_o => hr_tis_shd.g_old_rec.param_name1

164: hr_tis_rkd.after_delete
165: (p_topic_integrations_id => p_rec.topic_integrations_id
166: ,p_topic_id_o => hr_tis_shd.g_old_rec.topic_id
167: ,p_integration_id_o => hr_tis_shd.g_old_rec.integration_id
168: ,p_param_name1_o => hr_tis_shd.g_old_rec.param_name1
169: ,p_param_value1_o => hr_tis_shd.g_old_rec.param_value1
170: ,p_param_name2_o => hr_tis_shd.g_old_rec.param_name2
171: ,p_param_value2_o => hr_tis_shd.g_old_rec.param_value2
172: ,p_param_name3_o => hr_tis_shd.g_old_rec.param_name3

Line 169: ,p_param_value1_o => hr_tis_shd.g_old_rec.param_value1

165: (p_topic_integrations_id => p_rec.topic_integrations_id
166: ,p_topic_id_o => hr_tis_shd.g_old_rec.topic_id
167: ,p_integration_id_o => hr_tis_shd.g_old_rec.integration_id
168: ,p_param_name1_o => hr_tis_shd.g_old_rec.param_name1
169: ,p_param_value1_o => hr_tis_shd.g_old_rec.param_value1
170: ,p_param_name2_o => hr_tis_shd.g_old_rec.param_name2
171: ,p_param_value2_o => hr_tis_shd.g_old_rec.param_value2
172: ,p_param_name3_o => hr_tis_shd.g_old_rec.param_name3
173: ,p_param_value3_o => hr_tis_shd.g_old_rec.param_value3

Line 170: ,p_param_name2_o => hr_tis_shd.g_old_rec.param_name2

166: ,p_topic_id_o => hr_tis_shd.g_old_rec.topic_id
167: ,p_integration_id_o => hr_tis_shd.g_old_rec.integration_id
168: ,p_param_name1_o => hr_tis_shd.g_old_rec.param_name1
169: ,p_param_value1_o => hr_tis_shd.g_old_rec.param_value1
170: ,p_param_name2_o => hr_tis_shd.g_old_rec.param_name2
171: ,p_param_value2_o => hr_tis_shd.g_old_rec.param_value2
172: ,p_param_name3_o => hr_tis_shd.g_old_rec.param_name3
173: ,p_param_value3_o => hr_tis_shd.g_old_rec.param_value3
174: ,p_param_name4_o => hr_tis_shd.g_old_rec.param_name4

Line 171: ,p_param_value2_o => hr_tis_shd.g_old_rec.param_value2

167: ,p_integration_id_o => hr_tis_shd.g_old_rec.integration_id
168: ,p_param_name1_o => hr_tis_shd.g_old_rec.param_name1
169: ,p_param_value1_o => hr_tis_shd.g_old_rec.param_value1
170: ,p_param_name2_o => hr_tis_shd.g_old_rec.param_name2
171: ,p_param_value2_o => hr_tis_shd.g_old_rec.param_value2
172: ,p_param_name3_o => hr_tis_shd.g_old_rec.param_name3
173: ,p_param_value3_o => hr_tis_shd.g_old_rec.param_value3
174: ,p_param_name4_o => hr_tis_shd.g_old_rec.param_name4
175: ,p_param_value4_o => hr_tis_shd.g_old_rec.param_value4

Line 172: ,p_param_name3_o => hr_tis_shd.g_old_rec.param_name3

168: ,p_param_name1_o => hr_tis_shd.g_old_rec.param_name1
169: ,p_param_value1_o => hr_tis_shd.g_old_rec.param_value1
170: ,p_param_name2_o => hr_tis_shd.g_old_rec.param_name2
171: ,p_param_value2_o => hr_tis_shd.g_old_rec.param_value2
172: ,p_param_name3_o => hr_tis_shd.g_old_rec.param_name3
173: ,p_param_value3_o => hr_tis_shd.g_old_rec.param_value3
174: ,p_param_name4_o => hr_tis_shd.g_old_rec.param_name4
175: ,p_param_value4_o => hr_tis_shd.g_old_rec.param_value4
176: ,p_param_name5_o => hr_tis_shd.g_old_rec.param_name5

Line 173: ,p_param_value3_o => hr_tis_shd.g_old_rec.param_value3

169: ,p_param_value1_o => hr_tis_shd.g_old_rec.param_value1
170: ,p_param_name2_o => hr_tis_shd.g_old_rec.param_name2
171: ,p_param_value2_o => hr_tis_shd.g_old_rec.param_value2
172: ,p_param_name3_o => hr_tis_shd.g_old_rec.param_name3
173: ,p_param_value3_o => hr_tis_shd.g_old_rec.param_value3
174: ,p_param_name4_o => hr_tis_shd.g_old_rec.param_name4
175: ,p_param_value4_o => hr_tis_shd.g_old_rec.param_value4
176: ,p_param_name5_o => hr_tis_shd.g_old_rec.param_name5
177: ,p_param_value5_o => hr_tis_shd.g_old_rec.param_value5

Line 174: ,p_param_name4_o => hr_tis_shd.g_old_rec.param_name4

170: ,p_param_name2_o => hr_tis_shd.g_old_rec.param_name2
171: ,p_param_value2_o => hr_tis_shd.g_old_rec.param_value2
172: ,p_param_name3_o => hr_tis_shd.g_old_rec.param_name3
173: ,p_param_value3_o => hr_tis_shd.g_old_rec.param_value3
174: ,p_param_name4_o => hr_tis_shd.g_old_rec.param_name4
175: ,p_param_value4_o => hr_tis_shd.g_old_rec.param_value4
176: ,p_param_name5_o => hr_tis_shd.g_old_rec.param_name5
177: ,p_param_value5_o => hr_tis_shd.g_old_rec.param_value5
178: ,p_param_name6_o => hr_tis_shd.g_old_rec.param_name6

Line 175: ,p_param_value4_o => hr_tis_shd.g_old_rec.param_value4

171: ,p_param_value2_o => hr_tis_shd.g_old_rec.param_value2
172: ,p_param_name3_o => hr_tis_shd.g_old_rec.param_name3
173: ,p_param_value3_o => hr_tis_shd.g_old_rec.param_value3
174: ,p_param_name4_o => hr_tis_shd.g_old_rec.param_name4
175: ,p_param_value4_o => hr_tis_shd.g_old_rec.param_value4
176: ,p_param_name5_o => hr_tis_shd.g_old_rec.param_name5
177: ,p_param_value5_o => hr_tis_shd.g_old_rec.param_value5
178: ,p_param_name6_o => hr_tis_shd.g_old_rec.param_name6
179: ,p_param_value6_o => hr_tis_shd.g_old_rec.param_value6

Line 176: ,p_param_name5_o => hr_tis_shd.g_old_rec.param_name5

172: ,p_param_name3_o => hr_tis_shd.g_old_rec.param_name3
173: ,p_param_value3_o => hr_tis_shd.g_old_rec.param_value3
174: ,p_param_name4_o => hr_tis_shd.g_old_rec.param_name4
175: ,p_param_value4_o => hr_tis_shd.g_old_rec.param_value4
176: ,p_param_name5_o => hr_tis_shd.g_old_rec.param_name5
177: ,p_param_value5_o => hr_tis_shd.g_old_rec.param_value5
178: ,p_param_name6_o => hr_tis_shd.g_old_rec.param_name6
179: ,p_param_value6_o => hr_tis_shd.g_old_rec.param_value6
180: ,p_param_name7_o => hr_tis_shd.g_old_rec.param_name7

Line 177: ,p_param_value5_o => hr_tis_shd.g_old_rec.param_value5

173: ,p_param_value3_o => hr_tis_shd.g_old_rec.param_value3
174: ,p_param_name4_o => hr_tis_shd.g_old_rec.param_name4
175: ,p_param_value4_o => hr_tis_shd.g_old_rec.param_value4
176: ,p_param_name5_o => hr_tis_shd.g_old_rec.param_name5
177: ,p_param_value5_o => hr_tis_shd.g_old_rec.param_value5
178: ,p_param_name6_o => hr_tis_shd.g_old_rec.param_name6
179: ,p_param_value6_o => hr_tis_shd.g_old_rec.param_value6
180: ,p_param_name7_o => hr_tis_shd.g_old_rec.param_name7
181: ,p_param_value7_o => hr_tis_shd.g_old_rec.param_value7

Line 178: ,p_param_name6_o => hr_tis_shd.g_old_rec.param_name6

174: ,p_param_name4_o => hr_tis_shd.g_old_rec.param_name4
175: ,p_param_value4_o => hr_tis_shd.g_old_rec.param_value4
176: ,p_param_name5_o => hr_tis_shd.g_old_rec.param_name5
177: ,p_param_value5_o => hr_tis_shd.g_old_rec.param_value5
178: ,p_param_name6_o => hr_tis_shd.g_old_rec.param_name6
179: ,p_param_value6_o => hr_tis_shd.g_old_rec.param_value6
180: ,p_param_name7_o => hr_tis_shd.g_old_rec.param_name7
181: ,p_param_value7_o => hr_tis_shd.g_old_rec.param_value7
182: ,p_param_name8_o => hr_tis_shd.g_old_rec.param_name8

Line 179: ,p_param_value6_o => hr_tis_shd.g_old_rec.param_value6

175: ,p_param_value4_o => hr_tis_shd.g_old_rec.param_value4
176: ,p_param_name5_o => hr_tis_shd.g_old_rec.param_name5
177: ,p_param_value5_o => hr_tis_shd.g_old_rec.param_value5
178: ,p_param_name6_o => hr_tis_shd.g_old_rec.param_name6
179: ,p_param_value6_o => hr_tis_shd.g_old_rec.param_value6
180: ,p_param_name7_o => hr_tis_shd.g_old_rec.param_name7
181: ,p_param_value7_o => hr_tis_shd.g_old_rec.param_value7
182: ,p_param_name8_o => hr_tis_shd.g_old_rec.param_name8
183: ,p_param_value8_o => hr_tis_shd.g_old_rec.param_value8

Line 180: ,p_param_name7_o => hr_tis_shd.g_old_rec.param_name7

176: ,p_param_name5_o => hr_tis_shd.g_old_rec.param_name5
177: ,p_param_value5_o => hr_tis_shd.g_old_rec.param_value5
178: ,p_param_name6_o => hr_tis_shd.g_old_rec.param_name6
179: ,p_param_value6_o => hr_tis_shd.g_old_rec.param_value6
180: ,p_param_name7_o => hr_tis_shd.g_old_rec.param_name7
181: ,p_param_value7_o => hr_tis_shd.g_old_rec.param_value7
182: ,p_param_name8_o => hr_tis_shd.g_old_rec.param_name8
183: ,p_param_value8_o => hr_tis_shd.g_old_rec.param_value8
184: ,p_param_name9_o => hr_tis_shd.g_old_rec.param_name9

Line 181: ,p_param_value7_o => hr_tis_shd.g_old_rec.param_value7

177: ,p_param_value5_o => hr_tis_shd.g_old_rec.param_value5
178: ,p_param_name6_o => hr_tis_shd.g_old_rec.param_name6
179: ,p_param_value6_o => hr_tis_shd.g_old_rec.param_value6
180: ,p_param_name7_o => hr_tis_shd.g_old_rec.param_name7
181: ,p_param_value7_o => hr_tis_shd.g_old_rec.param_value7
182: ,p_param_name8_o => hr_tis_shd.g_old_rec.param_name8
183: ,p_param_value8_o => hr_tis_shd.g_old_rec.param_value8
184: ,p_param_name9_o => hr_tis_shd.g_old_rec.param_name9
185: ,p_param_value9_o => hr_tis_shd.g_old_rec.param_value9

Line 182: ,p_param_name8_o => hr_tis_shd.g_old_rec.param_name8

178: ,p_param_name6_o => hr_tis_shd.g_old_rec.param_name6
179: ,p_param_value6_o => hr_tis_shd.g_old_rec.param_value6
180: ,p_param_name7_o => hr_tis_shd.g_old_rec.param_name7
181: ,p_param_value7_o => hr_tis_shd.g_old_rec.param_value7
182: ,p_param_name8_o => hr_tis_shd.g_old_rec.param_name8
183: ,p_param_value8_o => hr_tis_shd.g_old_rec.param_value8
184: ,p_param_name9_o => hr_tis_shd.g_old_rec.param_name9
185: ,p_param_value9_o => hr_tis_shd.g_old_rec.param_value9
186: ,p_param_name10_o => hr_tis_shd.g_old_rec.param_name10

Line 183: ,p_param_value8_o => hr_tis_shd.g_old_rec.param_value8

179: ,p_param_value6_o => hr_tis_shd.g_old_rec.param_value6
180: ,p_param_name7_o => hr_tis_shd.g_old_rec.param_name7
181: ,p_param_value7_o => hr_tis_shd.g_old_rec.param_value7
182: ,p_param_name8_o => hr_tis_shd.g_old_rec.param_name8
183: ,p_param_value8_o => hr_tis_shd.g_old_rec.param_value8
184: ,p_param_name9_o => hr_tis_shd.g_old_rec.param_name9
185: ,p_param_value9_o => hr_tis_shd.g_old_rec.param_value9
186: ,p_param_name10_o => hr_tis_shd.g_old_rec.param_name10
187: ,p_param_value10_o => hr_tis_shd.g_old_rec.param_value10

Line 184: ,p_param_name9_o => hr_tis_shd.g_old_rec.param_name9

180: ,p_param_name7_o => hr_tis_shd.g_old_rec.param_name7
181: ,p_param_value7_o => hr_tis_shd.g_old_rec.param_value7
182: ,p_param_name8_o => hr_tis_shd.g_old_rec.param_name8
183: ,p_param_value8_o => hr_tis_shd.g_old_rec.param_value8
184: ,p_param_name9_o => hr_tis_shd.g_old_rec.param_name9
185: ,p_param_value9_o => hr_tis_shd.g_old_rec.param_value9
186: ,p_param_name10_o => hr_tis_shd.g_old_rec.param_name10
187: ,p_param_value10_o => hr_tis_shd.g_old_rec.param_value10
188: ,p_object_version_number_o => hr_tis_shd.g_old_rec.object_version_number

Line 185: ,p_param_value9_o => hr_tis_shd.g_old_rec.param_value9

181: ,p_param_value7_o => hr_tis_shd.g_old_rec.param_value7
182: ,p_param_name8_o => hr_tis_shd.g_old_rec.param_name8
183: ,p_param_value8_o => hr_tis_shd.g_old_rec.param_value8
184: ,p_param_name9_o => hr_tis_shd.g_old_rec.param_name9
185: ,p_param_value9_o => hr_tis_shd.g_old_rec.param_value9
186: ,p_param_name10_o => hr_tis_shd.g_old_rec.param_name10
187: ,p_param_value10_o => hr_tis_shd.g_old_rec.param_value10
188: ,p_object_version_number_o => hr_tis_shd.g_old_rec.object_version_number
189: );

Line 186: ,p_param_name10_o => hr_tis_shd.g_old_rec.param_name10

182: ,p_param_name8_o => hr_tis_shd.g_old_rec.param_name8
183: ,p_param_value8_o => hr_tis_shd.g_old_rec.param_value8
184: ,p_param_name9_o => hr_tis_shd.g_old_rec.param_name9
185: ,p_param_value9_o => hr_tis_shd.g_old_rec.param_value9
186: ,p_param_name10_o => hr_tis_shd.g_old_rec.param_name10
187: ,p_param_value10_o => hr_tis_shd.g_old_rec.param_value10
188: ,p_object_version_number_o => hr_tis_shd.g_old_rec.object_version_number
189: );
190: --

Line 187: ,p_param_value10_o => hr_tis_shd.g_old_rec.param_value10

183: ,p_param_value8_o => hr_tis_shd.g_old_rec.param_value8
184: ,p_param_name9_o => hr_tis_shd.g_old_rec.param_name9
185: ,p_param_value9_o => hr_tis_shd.g_old_rec.param_value9
186: ,p_param_name10_o => hr_tis_shd.g_old_rec.param_name10
187: ,p_param_value10_o => hr_tis_shd.g_old_rec.param_value10
188: ,p_object_version_number_o => hr_tis_shd.g_old_rec.object_version_number
189: );
190: --
191: exception

Line 188: ,p_object_version_number_o => hr_tis_shd.g_old_rec.object_version_number

184: ,p_param_name9_o => hr_tis_shd.g_old_rec.param_name9
185: ,p_param_value9_o => hr_tis_shd.g_old_rec.param_value9
186: ,p_param_name10_o => hr_tis_shd.g_old_rec.param_name10
187: ,p_param_value10_o => hr_tis_shd.g_old_rec.param_value10
188: ,p_object_version_number_o => hr_tis_shd.g_old_rec.object_version_number
189: );
190: --
191: exception
192: --

Line 208: (p_rec in hr_tis_shd.g_rec_type

204: -- ----------------------------------------------------------------------------
205: -- |---------------------------------< del >----------------------------------|
206: -- ----------------------------------------------------------------------------
207: Procedure del
208: (p_rec in hr_tis_shd.g_rec_type
209: ) is
210: --
211: l_proc varchar2(72) := g_package||'del';
212: --

Line 218: hr_tis_shd.lck

214: hr_utility.set_location('Entering:'||l_proc, 5);
215: --
216: -- We must lock the row which we need to delete.
217: --
218: hr_tis_shd.lck
219: (p_rec.topic_integrations_id
220: ,p_rec.object_version_number
221: );
222: --

Line 255: l_rec hr_tis_shd.g_rec_type;

251: (p_topic_integrations_id in number
252: ,p_object_version_number in number
253: ) is
254: --
255: l_rec hr_tis_shd.g_rec_type;
256: l_proc varchar2(72) := g_package||'del';
257: --
258: Begin
259: hr_utility.set_location('Entering:'||l_proc, 5);