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.OKC_TIME_PVT dependencies on OKC_TIME_PVT

Line 1: PACKAGE BODY OKC_TIME_PVT AS

1: PACKAGE BODY OKC_TIME_PVT AS
2: /* $Header: OKCCTVEB.pls 120.0 2005/05/25 22:39:52 appldev noship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5:

Line 212: p_talv_evt_rec OKC_TIME_PVT.talv_event_rec_type;

208: WHERE id = p_tve_id;
209: l_tve_rec tve_csr%ROWTYPE;
210: l_not_found BOOLEAN := TRUE;
211: item_not_found_error EXCEPTION;
212: p_talv_evt_rec OKC_TIME_PVT.talv_event_rec_type;
213: p_tgnv_rec OKC_TIME_PVT.tgnv_rec_type;
214: p_tavv_rec OKC_TIME_PVT.tavv_rec_type;
215: p_cylv_ext_rec OKC_TIME_PVT.cylv_extended_rec_type;
216: p_tgdv_ext_rec OKC_TIME_PVT.tgdv_extended_rec_type;

Line 213: p_tgnv_rec OKC_TIME_PVT.tgnv_rec_type;

209: l_tve_rec tve_csr%ROWTYPE;
210: l_not_found BOOLEAN := TRUE;
211: item_not_found_error EXCEPTION;
212: p_talv_evt_rec OKC_TIME_PVT.talv_event_rec_type;
213: p_tgnv_rec OKC_TIME_PVT.tgnv_rec_type;
214: p_tavv_rec OKC_TIME_PVT.tavv_rec_type;
215: p_cylv_ext_rec OKC_TIME_PVT.cylv_extended_rec_type;
216: p_tgdv_ext_rec OKC_TIME_PVT.tgdv_extended_rec_type;
217: p_isev_ext_rec OKC_TIME_PVT.isev_extended_rec_type;

Line 214: p_tavv_rec OKC_TIME_PVT.tavv_rec_type;

210: l_not_found BOOLEAN := TRUE;
211: item_not_found_error EXCEPTION;
212: p_talv_evt_rec OKC_TIME_PVT.talv_event_rec_type;
213: p_tgnv_rec OKC_TIME_PVT.tgnv_rec_type;
214: p_tavv_rec OKC_TIME_PVT.tavv_rec_type;
215: p_cylv_ext_rec OKC_TIME_PVT.cylv_extended_rec_type;
216: p_tgdv_ext_rec OKC_TIME_PVT.tgdv_extended_rec_type;
217: p_isev_ext_rec OKC_TIME_PVT.isev_extended_rec_type;
218: p_igsv_ext_rec OKC_TIME_PVT.igsv_extended_rec_type;

Line 215: p_cylv_ext_rec OKC_TIME_PVT.cylv_extended_rec_type;

211: item_not_found_error EXCEPTION;
212: p_talv_evt_rec OKC_TIME_PVT.talv_event_rec_type;
213: p_tgnv_rec OKC_TIME_PVT.tgnv_rec_type;
214: p_tavv_rec OKC_TIME_PVT.tavv_rec_type;
215: p_cylv_ext_rec OKC_TIME_PVT.cylv_extended_rec_type;
216: p_tgdv_ext_rec OKC_TIME_PVT.tgdv_extended_rec_type;
217: p_isev_ext_rec OKC_TIME_PVT.isev_extended_rec_type;
218: p_igsv_ext_rec OKC_TIME_PVT.igsv_extended_rec_type;
219: l_api_name CONSTANT VARCHAR2(30) := 'delete_timevalues_n_tasks';

Line 216: p_tgdv_ext_rec OKC_TIME_PVT.tgdv_extended_rec_type;

212: p_talv_evt_rec OKC_TIME_PVT.talv_event_rec_type;
213: p_tgnv_rec OKC_TIME_PVT.tgnv_rec_type;
214: p_tavv_rec OKC_TIME_PVT.tavv_rec_type;
215: p_cylv_ext_rec OKC_TIME_PVT.cylv_extended_rec_type;
216: p_tgdv_ext_rec OKC_TIME_PVT.tgdv_extended_rec_type;
217: p_isev_ext_rec OKC_TIME_PVT.isev_extended_rec_type;
218: p_igsv_ext_rec OKC_TIME_PVT.igsv_extended_rec_type;
219: l_api_name CONSTANT VARCHAR2(30) := 'delete_timevalues_n_tasks';
220: BEGIN

Line 217: p_isev_ext_rec OKC_TIME_PVT.isev_extended_rec_type;

213: p_tgnv_rec OKC_TIME_PVT.tgnv_rec_type;
214: p_tavv_rec OKC_TIME_PVT.tavv_rec_type;
215: p_cylv_ext_rec OKC_TIME_PVT.cylv_extended_rec_type;
216: p_tgdv_ext_rec OKC_TIME_PVT.tgdv_extended_rec_type;
217: p_isev_ext_rec OKC_TIME_PVT.isev_extended_rec_type;
218: p_igsv_ext_rec OKC_TIME_PVT.igsv_extended_rec_type;
219: l_api_name CONSTANT VARCHAR2(30) := 'delete_timevalues_n_tasks';
220: BEGIN
221: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 218: p_igsv_ext_rec OKC_TIME_PVT.igsv_extended_rec_type;

214: p_tavv_rec OKC_TIME_PVT.tavv_rec_type;
215: p_cylv_ext_rec OKC_TIME_PVT.cylv_extended_rec_type;
216: p_tgdv_ext_rec OKC_TIME_PVT.tgdv_extended_rec_type;
217: p_isev_ext_rec OKC_TIME_PVT.isev_extended_rec_type;
218: p_igsv_ext_rec OKC_TIME_PVT.igsv_extended_rec_type;
219: l_api_name CONSTANT VARCHAR2(30) := 'delete_timevalues_n_tasks';
220: BEGIN
221: x_return_status := OKC_API.G_RET_STS_SUCCESS;
222: if p_chr_id <> 0 Then

Line 241: OKC_TIME_PVT.DELETE_TPA_RELTV(

237: end if;
238: if l_tve_rec.tve_type = 'TAL' Then
239: p_talv_evt_rec.id := p_tve_id;
240: p_talv_evt_rec.tve_id_offset := l_tve_rec.tve_id_offset;
241: OKC_TIME_PVT.DELETE_TPA_RELTV(
242: p_api_version ,
243: p_init_msg_list ,
244: x_return_status ,
245: x_msg_count ,

Line 250: OKC_TIME_PVT.DELETE_TPG_NAMED(

246: x_msg_data ,
247: p_talv_evt_rec) ;
248: elsif l_tve_rec.tve_type = 'TGN' Then
249: p_tgnv_rec.id := p_tve_id;
250: OKC_TIME_PVT.DELETE_TPG_NAMED(
251: p_api_version,
252: p_init_msg_list,
253: x_return_status,
254: x_msg_count,

Line 259: OKC_TIME_PVT.DELETE_TPA_VALUE(

255: x_msg_data,
256: p_tgnv_rec);
257: elsif l_tve_rec.tve_type = 'TAV' Then
258: p_tavv_rec.id := p_tve_id;
259: OKC_TIME_PVT.DELETE_TPA_VALUE(
260: p_api_version,
261: p_init_msg_list,
262: x_return_status,
263: x_msg_count,

Line 268: OKC_TIME_PVT.DELETE_TPG_DELIMITED(

264: x_msg_data,
265: p_tavv_rec);
266: elsif l_tve_rec.tve_type = 'TGD' Then
267: p_tgdv_ext_rec.id := p_tve_id;
268: OKC_TIME_PVT.DELETE_TPG_DELIMITED(
269: p_api_version,
270: p_init_msg_list,
271: x_return_status,
272: x_msg_count,

Line 277: OKC_TIME_PVT.DELETE_CYCLE(

273: x_msg_data,
274: p_tgdv_ext_rec);
275: elsif l_tve_rec.tve_type = 'CYL' Then
276: p_cylv_ext_rec.id := p_tve_id;
277: OKC_TIME_PVT.DELETE_CYCLE(
278: p_api_version,
279: p_init_msg_list,
280: x_return_status,
281: x_msg_count,

Line 289: OKC_TIME_PVT.DELETE_IA_STARTEND(

285: p_isev_ext_rec.id := p_tve_id;
286: --Bug#3080839 Timevalues not getting deleted
287: p_isev_ext_rec.tve_id_started := l_tve_rec.tve_id_started;
288: p_isev_ext_rec.tve_id_ended := l_tve_rec.tve_id_ended;
289: OKC_TIME_PVT.DELETE_IA_STARTEND(
290: p_api_version,
291: p_init_msg_list,
292: x_return_status,
293: x_msg_count,

Line 301: OKC_TIME_PVT.DELETE_IG_STARTEND(

297: p_igsv_ext_rec.id := p_tve_id;
298: --Bug#3080839 Timevalues not getting deleted
299: p_igsv_ext_rec.tve_id_started := l_tve_rec.tve_id_started;
300: p_igsv_ext_rec.tve_id_ended := l_tve_rec.tve_id_ended;
301: OKC_TIME_PVT.DELETE_IG_STARTEND(
302: p_api_version,
303: p_init_msg_list,
304: x_return_status,
305: x_msg_count,

Line 4234: END OKC_TIME_PVT;

4230: EXCEPTION
4231: WHEN OTHERS THEN
4232: RAISE;
4233: END INSERT_ise_ROW_UPG;
4234: END OKC_TIME_PVT;