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_TCC_UPD dependencies on OTA_TCC_SHD

Line 55: (p_rec in out nocopy ota_tcc_shd.g_rec_type

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

Line 90: ota_tcc_shd.constraint_error

86: Exception
87: When hr_api.check_integrity_violated Then
88: -- A check constraint has been violated
89: --
90: ota_tcc_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_tcc_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_tcc_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_tcc_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_tcc_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_tcc_shd.g_rec_type

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

Line 185: ,p_rec in ota_tcc_shd.g_rec_type

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

Line 213: => ota_tcc_shd.g_old_rec.business_group_id

209: => p_rec.start_date_active
210: ,p_end_date_active
211: => p_rec.end_date_active
212: ,p_business_group_id_o
213: => ota_tcc_shd.g_old_rec.business_group_id
214: ,p_gl_set_of_books_id_o
215: => ota_tcc_shd.g_old_rec.gl_set_of_books_id
216: ,p_object_version_number_o
217: => ota_tcc_shd.g_old_rec.object_version_number

Line 215: => ota_tcc_shd.g_old_rec.gl_set_of_books_id

211: => p_rec.end_date_active
212: ,p_business_group_id_o
213: => ota_tcc_shd.g_old_rec.business_group_id
214: ,p_gl_set_of_books_id_o
215: => ota_tcc_shd.g_old_rec.gl_set_of_books_id
216: ,p_object_version_number_o
217: => ota_tcc_shd.g_old_rec.object_version_number
218: ,p_type_o
219: => ota_tcc_shd.g_old_rec.type

Line 217: => ota_tcc_shd.g_old_rec.object_version_number

213: => ota_tcc_shd.g_old_rec.business_group_id
214: ,p_gl_set_of_books_id_o
215: => ota_tcc_shd.g_old_rec.gl_set_of_books_id
216: ,p_object_version_number_o
217: => ota_tcc_shd.g_old_rec.object_version_number
218: ,p_type_o
219: => ota_tcc_shd.g_old_rec.type
220: ,p_from_to_o
221: => ota_tcc_shd.g_old_rec.from_to

Line 219: => ota_tcc_shd.g_old_rec.type

215: => ota_tcc_shd.g_old_rec.gl_set_of_books_id
216: ,p_object_version_number_o
217: => ota_tcc_shd.g_old_rec.object_version_number
218: ,p_type_o
219: => ota_tcc_shd.g_old_rec.type
220: ,p_from_to_o
221: => ota_tcc_shd.g_old_rec.from_to
222: ,p_start_date_active_o
223: => ota_tcc_shd.g_old_rec.start_date_active

Line 221: => ota_tcc_shd.g_old_rec.from_to

217: => ota_tcc_shd.g_old_rec.object_version_number
218: ,p_type_o
219: => ota_tcc_shd.g_old_rec.type
220: ,p_from_to_o
221: => ota_tcc_shd.g_old_rec.from_to
222: ,p_start_date_active_o
223: => ota_tcc_shd.g_old_rec.start_date_active
224: ,p_end_date_active_o
225: => ota_tcc_shd.g_old_rec.end_date_active

Line 223: => ota_tcc_shd.g_old_rec.start_date_active

219: => ota_tcc_shd.g_old_rec.type
220: ,p_from_to_o
221: => ota_tcc_shd.g_old_rec.from_to
222: ,p_start_date_active_o
223: => ota_tcc_shd.g_old_rec.start_date_active
224: ,p_end_date_active_o
225: => ota_tcc_shd.g_old_rec.end_date_active
226: );
227: --

Line 225: => ota_tcc_shd.g_old_rec.end_date_active

221: => ota_tcc_shd.g_old_rec.from_to
222: ,p_start_date_active_o
223: => ota_tcc_shd.g_old_rec.start_date_active
224: ,p_end_date_active_o
225: => ota_tcc_shd.g_old_rec.end_date_active
226: );
227: --
228: exception
229: --

Line 285: (p_rec in out nocopy ota_tcc_shd.g_rec_type

281: --
282: -- {End Of Comments}
283: -- ----------------------------------------------------------------------------
284: Procedure convert_defs
285: (p_rec in out nocopy ota_tcc_shd.g_rec_type
286: ) is
287: --
288: Begin
289: --

Line 297: ota_tcc_shd.g_old_rec.business_group_id;

293: -- is being used then we must set to the 'current' argument value.
294: --
295: If (p_rec.business_group_id = hr_api.g_number) then
296: p_rec.business_group_id :=
297: ota_tcc_shd.g_old_rec.business_group_id;
298: End If;
299: If (p_rec.gl_set_of_books_id = hr_api.g_number) then
300: p_rec.gl_set_of_books_id :=
301: ota_tcc_shd.g_old_rec.gl_set_of_books_id;

Line 301: ota_tcc_shd.g_old_rec.gl_set_of_books_id;

297: ota_tcc_shd.g_old_rec.business_group_id;
298: End If;
299: If (p_rec.gl_set_of_books_id = hr_api.g_number) then
300: p_rec.gl_set_of_books_id :=
301: ota_tcc_shd.g_old_rec.gl_set_of_books_id;
302: End If;
303: If (p_rec.type = hr_api.g_varchar2) then
304: p_rec.type :=
305: ota_tcc_shd.g_old_rec.type;

Line 305: ota_tcc_shd.g_old_rec.type;

301: ota_tcc_shd.g_old_rec.gl_set_of_books_id;
302: End If;
303: If (p_rec.type = hr_api.g_varchar2) then
304: p_rec.type :=
305: ota_tcc_shd.g_old_rec.type;
306: End If;
307: If (p_rec.from_to = hr_api.g_varchar2) then
308: p_rec.from_to :=
309: ota_tcc_shd.g_old_rec.from_to;

Line 309: ota_tcc_shd.g_old_rec.from_to;

305: ota_tcc_shd.g_old_rec.type;
306: End If;
307: If (p_rec.from_to = hr_api.g_varchar2) then
308: p_rec.from_to :=
309: ota_tcc_shd.g_old_rec.from_to;
310: End If;
311: If (p_rec.start_date_active = hr_api.g_date) then
312: p_rec.start_date_active :=
313: ota_tcc_shd.g_old_rec.start_date_active;

Line 313: ota_tcc_shd.g_old_rec.start_date_active;

309: ota_tcc_shd.g_old_rec.from_to;
310: End If;
311: If (p_rec.start_date_active = hr_api.g_date) then
312: p_rec.start_date_active :=
313: ota_tcc_shd.g_old_rec.start_date_active;
314: End If;
315: If (p_rec.end_date_active = hr_api.g_date) then
316: p_rec.end_date_active :=
317: ota_tcc_shd.g_old_rec.end_date_active;

Line 317: ota_tcc_shd.g_old_rec.end_date_active;

313: ota_tcc_shd.g_old_rec.start_date_active;
314: End If;
315: If (p_rec.end_date_active = hr_api.g_date) then
316: p_rec.end_date_active :=
317: ota_tcc_shd.g_old_rec.end_date_active;
318: End If;
319: --
320: End convert_defs;
321: --

Line 327: ,p_rec in out nocopy ota_tcc_shd.g_rec_type

323: -- |---------------------------------< upd >----------------------------------|
324: -- ----------------------------------------------------------------------------
325: Procedure upd
326: (p_effective_date in date
327: ,p_rec in out nocopy ota_tcc_shd.g_rec_type
328: ,p_validate in boolean default false
329: ) is
330: --
331: l_proc varchar2(72) := g_package||'upd';

Line 346: ota_tcc_shd.lck

342:
343: --
344: -- We must lock the row which we need to update.
345: --
346: ota_tcc_shd.lck
347: (p_rec.cross_charge_id
348: ,p_rec.object_version_number
349: );
350: --

Line 409: l_rec ota_tcc_shd.g_rec_type;

405: ,p_end_date_active in date default hr_api.g_date
406: ,p_validate in boolean default false
407: ) is
408: --
409: l_rec ota_tcc_shd.g_rec_type;
410: l_proc varchar2(72) := g_package||'upd';
411: --
412: Begin
413: hr_utility.set_location('Entering:'||l_proc, 5);

Line 419: ota_tcc_shd.convert_args

415: -- Call conversion function to turn arguments into the
416: -- l_rec structure.
417: --
418: l_rec :=
419: ota_tcc_shd.convert_args
420: (p_cross_charge_id
421: ,p_business_group_id
422: ,p_gl_set_of_books_id
423: ,p_object_version_number