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_CUS_UPD dependencies on OTA_CUS_SHD

Line 55: (p_rec in out nocopy ota_cus_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy ota_cus_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 90: ota_cus_shd.constraint_error

86: Exception
87: When hr_api.check_integrity_violated Then
88: -- A check constraint has been violated
89: --
90: ota_cus_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When hr_api.parent_integrity_violated Then
93: -- Parent integrity has been violated
94: --

Line 95: ota_cus_shd.constraint_error

91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When hr_api.parent_integrity_violated Then
93: -- Parent integrity has been violated
94: --
95: ota_cus_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.unique_integrity_violated Then
98: -- Unique integrity has been violated
99: --

Line 100: ota_cus_shd.constraint_error

96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.unique_integrity_violated Then
98: -- Unique integrity has been violated
99: --
100: ota_cus_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When Others Then
103: --
104: Raise;

Line 140: (p_rec in ota_cus_shd.g_rec_type

136: --
137: -- {End Of Comments}
138: -- ----------------------------------------------------------------------------
139: Procedure pre_update
140: (p_rec in ota_cus_shd.g_rec_type
141: ) is
142: --
143: l_proc varchar2(72) := g_package||'pre_update';
144: --

Line 185: ,p_rec in ota_cus_shd.g_rec_type

181: -- {End Of Comments}
182: -- ----------------------------------------------------------------------------
183: Procedure post_update
184: (p_effective_date in date
185: ,p_rec in ota_cus_shd.g_rec_type
186: ) is
187: --
188: l_proc varchar2(72) := g_package||'post_update';
189: --

Line 209: => ota_cus_shd.g_old_rec.business_group_id

205: => p_rec.login_date
206: ,p_object_version_number
207: => p_rec.object_version_number
208: ,p_business_group_id_o
209: => ota_cus_shd.g_old_rec.business_group_id
210: ,p_login_date_o
211: => ota_cus_shd.g_old_rec.login_date
212: ,p_object_version_number_o
213: => ota_cus_shd.g_old_rec.object_version_number

Line 211: => ota_cus_shd.g_old_rec.login_date

207: => p_rec.object_version_number
208: ,p_business_group_id_o
209: => ota_cus_shd.g_old_rec.business_group_id
210: ,p_login_date_o
211: => ota_cus_shd.g_old_rec.login_date
212: ,p_object_version_number_o
213: => ota_cus_shd.g_old_rec.object_version_number
214: );
215: --

Line 213: => ota_cus_shd.g_old_rec.object_version_number

209: => ota_cus_shd.g_old_rec.business_group_id
210: ,p_login_date_o
211: => ota_cus_shd.g_old_rec.login_date
212: ,p_object_version_number_o
213: => ota_cus_shd.g_old_rec.object_version_number
214: );
215: --
216: exception
217: --

Line 273: (p_rec in out nocopy ota_cus_shd.g_rec_type

269: --
270: -- {End Of Comments}
271: -- ----------------------------------------------------------------------------
272: Procedure convert_defs
273: (p_rec in out nocopy ota_cus_shd.g_rec_type
274: ) is
275: --
276: Begin
277: --

Line 285: ota_cus_shd.g_old_rec.business_group_id;

281: -- is being used then we must set to the 'current' argument value.
282: --
283: If (p_rec.business_group_id = hr_api.g_number) then
284: p_rec.business_group_id :=
285: ota_cus_shd.g_old_rec.business_group_id;
286: End If;
287: If (p_rec.login_date = hr_api.g_date) then
288: p_rec.login_date :=
289: ota_cus_shd.g_old_rec.login_date;

Line 289: ota_cus_shd.g_old_rec.login_date;

285: ota_cus_shd.g_old_rec.business_group_id;
286: End If;
287: If (p_rec.login_date = hr_api.g_date) then
288: p_rec.login_date :=
289: ota_cus_shd.g_old_rec.login_date;
290: End If;
291: --
292: End convert_defs;
293: --

Line 299: ,p_rec in out nocopy ota_cus_shd.g_rec_type

295: -- |---------------------------------< upd >----------------------------------|
296: -- ----------------------------------------------------------------------------
297: Procedure upd
298: (p_effective_date in date
299: ,p_rec in out nocopy ota_cus_shd.g_rec_type
300: ) is
301: --
302: l_proc varchar2(72) := g_package||'upd';
303: --

Line 309: ota_cus_shd.lck

305: hr_utility.set_location('Entering:'||l_proc, 5);
306: --
307: -- We must lock the row which we need to update.
308: --
309: ota_cus_shd.lck
310: (p_rec.chat_id
311: ,p_rec.person_id
312: ,p_rec.contact_id
313: ,p_rec.object_version_number

Line 363: l_rec ota_cus_shd.g_rec_type;

359: ,p_business_group_id in number default hr_api.g_number
360: ,p_login_date in date default hr_api.g_date
361: ) is
362: --
363: l_rec ota_cus_shd.g_rec_type;
364: l_proc varchar2(72) := g_package||'upd';
365: --
366: Begin
367: hr_utility.set_location('Entering:'||l_proc, 5);

Line 373: ota_cus_shd.convert_args

369: -- Call conversion function to turn arguments into the
370: -- l_rec structure.
371: --
372: l_rec :=
373: ota_cus_shd.convert_args
374: (p_chat_id
375: ,p_business_group_id
376: ,p_person_id
377: ,p_contact_id