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.OTA_CHA_DEL dependencies on OTA_CHA_SHD

Line 52: (p_rec in ota_cha_shd.g_rec_type

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

Line 75: ota_cha_shd.constraint_error

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

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

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

Line 168: => ota_cha_shd.g_old_rec.business_group_id

164: ota_cha_rkd.after_delete
165: (p_chat_id
166: => p_rec.chat_id
167: ,p_business_group_id_o
168: => ota_cha_shd.g_old_rec.business_group_id
169: ,p_object_version_number_o
170: => ota_cha_shd.g_old_rec.object_version_number
171: ,p_public_flag_o
172: => ota_cha_shd.g_old_rec.public_flag

Line 170: => ota_cha_shd.g_old_rec.object_version_number

166: => p_rec.chat_id
167: ,p_business_group_id_o
168: => ota_cha_shd.g_old_rec.business_group_id
169: ,p_object_version_number_o
170: => ota_cha_shd.g_old_rec.object_version_number
171: ,p_public_flag_o
172: => ota_cha_shd.g_old_rec.public_flag
173: ,p_start_date_active_o
174: => ota_cha_shd.g_old_rec.start_date_active

Line 172: => ota_cha_shd.g_old_rec.public_flag

168: => ota_cha_shd.g_old_rec.business_group_id
169: ,p_object_version_number_o
170: => ota_cha_shd.g_old_rec.object_version_number
171: ,p_public_flag_o
172: => ota_cha_shd.g_old_rec.public_flag
173: ,p_start_date_active_o
174: => ota_cha_shd.g_old_rec.start_date_active
175: ,p_end_date_active_o
176: => ota_cha_shd.g_old_rec.end_date_active

Line 174: => ota_cha_shd.g_old_rec.start_date_active

170: => ota_cha_shd.g_old_rec.object_version_number
171: ,p_public_flag_o
172: => ota_cha_shd.g_old_rec.public_flag
173: ,p_start_date_active_o
174: => ota_cha_shd.g_old_rec.start_date_active
175: ,p_end_date_active_o
176: => ota_cha_shd.g_old_rec.end_date_active
177: ,p_start_time_active_o
178: => ota_cha_shd.g_old_rec.start_time_active

Line 176: => ota_cha_shd.g_old_rec.end_date_active

172: => ota_cha_shd.g_old_rec.public_flag
173: ,p_start_date_active_o
174: => ota_cha_shd.g_old_rec.start_date_active
175: ,p_end_date_active_o
176: => ota_cha_shd.g_old_rec.end_date_active
177: ,p_start_time_active_o
178: => ota_cha_shd.g_old_rec.start_time_active
179: ,p_end_time_active_o
180: => ota_cha_shd.g_old_rec.end_time_active

Line 178: => ota_cha_shd.g_old_rec.start_time_active

174: => ota_cha_shd.g_old_rec.start_date_active
175: ,p_end_date_active_o
176: => ota_cha_shd.g_old_rec.end_date_active
177: ,p_start_time_active_o
178: => ota_cha_shd.g_old_rec.start_time_active
179: ,p_end_time_active_o
180: => ota_cha_shd.g_old_rec.end_time_active
181: ,p_timezone_code_o
182: => ota_cha_shd.g_old_rec.timezone_code

Line 180: => ota_cha_shd.g_old_rec.end_time_active

176: => ota_cha_shd.g_old_rec.end_date_active
177: ,p_start_time_active_o
178: => ota_cha_shd.g_old_rec.start_time_active
179: ,p_end_time_active_o
180: => ota_cha_shd.g_old_rec.end_time_active
181: ,p_timezone_code_o
182: => ota_cha_shd.g_old_rec.timezone_code
183: );
184: --

Line 182: => ota_cha_shd.g_old_rec.timezone_code

178: => ota_cha_shd.g_old_rec.start_time_active
179: ,p_end_time_active_o
180: => ota_cha_shd.g_old_rec.end_time_active
181: ,p_timezone_code_o
182: => ota_cha_shd.g_old_rec.timezone_code
183: );
184: --
185: exception
186: --

Line 202: (p_rec in ota_cha_shd.g_rec_type

198: -- ----------------------------------------------------------------------------
199: -- |---------------------------------< del >----------------------------------|
200: -- ----------------------------------------------------------------------------
201: Procedure del
202: (p_rec in ota_cha_shd.g_rec_type
203: ) is
204: --
205: l_proc varchar2(72) := g_package||'del';
206: --

Line 212: ota_cha_shd.lck

208: hr_utility.set_location('Entering:'||l_proc, 5);
209: --
210: -- We must lock the row which we need to delete.
211: --
212: ota_cha_shd.lck
213: (p_rec.chat_id
214: ,p_rec.object_version_number
215: );
216: --

Line 249: l_rec ota_cha_shd.g_rec_type;

245: (p_chat_id in number
246: ,p_object_version_number in number
247: ) is
248: --
249: l_rec ota_cha_shd.g_rec_type;
250: l_proc varchar2(72) := g_package||'del';
251: --
252: Begin
253: hr_utility.set_location('Entering:'||l_proc, 5);