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.JTF_CAL_RESOURCE_ASSIGN_PKG dependencies on FND_API

Line 46: l_temp_fnd_end_date date := to_date(to_char(FND_API.G_MISS_DATE,'dd-MM-RRRR'),'dd-MM-RRRR');

42: v_calendar_name VARCHAR2(100);
43: prime_flag_count NUMBER := 0;
44:
45: -- Added by jawang on 06/05/2002 to fix bug 2180182
46: l_temp_fnd_end_date date := to_date(to_char(FND_API.G_MISS_DATE,'dd-MM-RRRR'),'dd-MM-RRRR');
47:
48: CURSOR C IS SELECT ROWID FROM JTF_CAL_RESOURCE_ASSIGN
49: WHERE CAL_RESOURCE_ASSIGN_ID = X_CAL_RESOURCE_ASSIGN_ID;
50:

Line 69: OR ( NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) BETWEEN start_date_time AND

65: AND primary_calendar_flag = p_primary_calendar_flag
66: AND (( X_START_DATE_TIME <= start_date_time AND NVL(X_END_DATE_TIME,l_temp_fnd_end_date)
67: >= NVL(end_date_time,l_temp_fnd_end_date) )
68: OR ( X_START_DATE_TIME BETWEEN start_date_time AND NVL(end_date_time,l_temp_fnd_end_date))
69: OR ( NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) BETWEEN start_date_time AND
70: NVL(end_date_time,l_temp_fnd_end_date))
71: OR ((X_START_DATE_TIME < start_date_time) AND (NVL(X_END_DATE_TIME,l_temp_fnd_end_date)
72: > NVL(end_date_time,l_temp_fnd_end_date)))
73: OR ((X_START_DATE_TIME > start_date_time) AND (NVL(X_END_DATE_TIME,l_temp_fnd_end_date) <

Line 370: l_temp_fnd_end_date date := to_date(to_char(FND_API.G_MISS_DATE,'dd-MM-RRRR'),'dd-MM-RRRR');

366: v_calendar_id NUMBER := 0;
367: v_resource_name VARCHAR2(100);
368: v_calendar_name VARCHAR2(100);
369: prime_flag_count NUMBER := 0;
370: l_temp_fnd_end_date date := to_date(to_char(FND_API.G_MISS_DATE,'dd-MM-RRRR'),'dd-MM-RRRR');
371:
372: CURSOR C_RES_NAME IS SELECT RESOURCE_NAME
373: FROM JTF_TASK_RESOURCES_VL
374: WHERE RESOURCE_ID = X_RESOURCE_ID

Line 391: OR ( NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) BETWEEN start_date_time AND

387: AND cal_resource_assign_id <> X_CAL_RESOURCE_ASSIGN_ID
388: AND (( X_START_DATE_TIME <= start_date_time AND NVL(X_END_DATE_TIME,l_temp_fnd_end_date)
389: >= NVL(end_date_time,l_temp_fnd_end_date) )
390: OR ( X_START_DATE_TIME BETWEEN start_date_time AND NVL(end_date_time,l_temp_fnd_end_date))
391: OR ( NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) BETWEEN start_date_time AND
392: NVL(end_date_time,l_temp_fnd_end_date))
393: OR ((X_START_DATE_TIME < start_date_time) AND (NVL(X_END_DATE_TIME,l_temp_fnd_end_date)
394: > NVL(end_date_time,l_temp_fnd_end_date)))
395: OR ((X_START_DATE_TIME > start_date_time) AND (NVL(X_END_DATE_TIME,l_temp_fnd_end_date) <

Line 428: -- Used l_temp_fnd_end_date instead of FND_API.G_MISS_DATE to fix bug 4200240

424: Fnd_Msg_Pub.ADD;
425: v_error := 'Y';
426: END IF;
427:
428: -- Used l_temp_fnd_end_date instead of FND_API.G_MISS_DATE to fix bug 4200240
429:
430: OPEN C_CAL_ID('Y');
431: FETCH C_CAL_ID INTO v_calendar_id;
432: prime_flag_count := C_CAL_ID%ROWCOUNT;

Line 451: -- Used l_temp_fnd_end_date instead of FND_API.G_MISS_DATE to fix bug 4200240

447: Fnd_Msg_Pub.ADD;
448: v_error := 'Y';
449: END IF;
450:
451: -- Used l_temp_fnd_end_date instead of FND_API.G_MISS_DATE to fix bug 4200240
452:
453: OPEN C_CAL_ID('N');
454: FETCH C_CAL_ID INTO v_calendar_id;
455: v_count := C_CAL_ID%ROWCOUNT;