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 43: l_temp_fnd_end_date date := to_date(to_char(FND_API.G_MISS_DATE,'dd-MM-RRRR'),'dd-MM-RRRR');

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

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

81: -- Modified by jawang on 06/05/2002 to fix bug 2180182
82: AND (( X_START_DATE_TIME <= start_date_time AND NVL(X_END_DATE_TIME,l_temp_fnd_end_date)
83: >= NVL(end_date_time,l_temp_fnd_end_date) )
84: OR ( X_START_DATE_TIME BETWEEN start_date_time AND NVL(end_date_time,l_temp_fnd_end_date))
85: OR ( NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) BETWEEN start_date_time AND
86: NVL(end_date_time,l_temp_fnd_end_date))
87: OR ((X_START_DATE_TIME < start_date_time) AND (NVL(X_END_DATE_TIME,l_temp_fnd_end_date)
88: > NVL(end_date_time,l_temp_fnd_end_date)))
89: OR ((X_START_DATE_TIME > start_date_time) AND (NVL(X_END_DATE_TIME,l_temp_fnd_end_date) <

Line 93: /*AND (( X_START_DATE_TIME <= start_date_time AND NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)

89: OR ((X_START_DATE_TIME > start_date_time) AND (NVL(X_END_DATE_TIME,l_temp_fnd_end_date) <
90: NVL(end_date_time,l_temp_fnd_end_date))));
91:
92:
93: /*AND (( X_START_DATE_TIME <= start_date_time AND NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
94: >= NVL(end_date_time,Fnd_Api.g_miss_date) )
95: OR ( X_START_DATE_TIME BETWEEN start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
96: OR ( NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) BETWEEN start_date_time AND
97: NVL(end_date_time,Fnd_Api.g_miss_date))

Line 94: >= NVL(end_date_time,Fnd_Api.g_miss_date) )

90: NVL(end_date_time,l_temp_fnd_end_date))));
91:
92:
93: /*AND (( X_START_DATE_TIME <= start_date_time AND NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
94: >= NVL(end_date_time,Fnd_Api.g_miss_date) )
95: OR ( X_START_DATE_TIME BETWEEN start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
96: OR ( NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) BETWEEN start_date_time AND
97: NVL(end_date_time,Fnd_Api.g_miss_date))
98: OR ((X_START_DATE_TIME < start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)

Line 95: OR ( X_START_DATE_TIME BETWEEN start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))

91:
92:
93: /*AND (( X_START_DATE_TIME <= start_date_time AND NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
94: >= NVL(end_date_time,Fnd_Api.g_miss_date) )
95: OR ( X_START_DATE_TIME BETWEEN start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
96: OR ( NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) BETWEEN start_date_time AND
97: NVL(end_date_time,Fnd_Api.g_miss_date))
98: OR ((X_START_DATE_TIME < start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
99: > NVL(end_date_time,Fnd_Api.g_miss_date)))

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

92:
93: /*AND (( X_START_DATE_TIME <= start_date_time AND NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
94: >= NVL(end_date_time,Fnd_Api.g_miss_date) )
95: OR ( X_START_DATE_TIME BETWEEN start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
96: OR ( NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) BETWEEN start_date_time AND
97: NVL(end_date_time,Fnd_Api.g_miss_date))
98: OR ((X_START_DATE_TIME < start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
99: > NVL(end_date_time,Fnd_Api.g_miss_date)))
100: OR ((X_START_DATE_TIME > start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) <

Line 97: NVL(end_date_time,Fnd_Api.g_miss_date))

93: /*AND (( X_START_DATE_TIME <= start_date_time AND NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
94: >= NVL(end_date_time,Fnd_Api.g_miss_date) )
95: OR ( X_START_DATE_TIME BETWEEN start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
96: OR ( NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) BETWEEN start_date_time AND
97: NVL(end_date_time,Fnd_Api.g_miss_date))
98: OR ((X_START_DATE_TIME < start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
99: > NVL(end_date_time,Fnd_Api.g_miss_date)))
100: OR ((X_START_DATE_TIME > start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) <
101: NVL(end_date_time,Fnd_Api.g_miss_date))));

Line 98: OR ((X_START_DATE_TIME < start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)

94: >= NVL(end_date_time,Fnd_Api.g_miss_date) )
95: OR ( X_START_DATE_TIME BETWEEN start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
96: OR ( NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) BETWEEN start_date_time AND
97: NVL(end_date_time,Fnd_Api.g_miss_date))
98: OR ((X_START_DATE_TIME < start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
99: > NVL(end_date_time,Fnd_Api.g_miss_date)))
100: OR ((X_START_DATE_TIME > start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) <
101: NVL(end_date_time,Fnd_Api.g_miss_date))));
102: */

Line 99: > NVL(end_date_time,Fnd_Api.g_miss_date)))

95: OR ( X_START_DATE_TIME BETWEEN start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
96: OR ( NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) BETWEEN start_date_time AND
97: NVL(end_date_time,Fnd_Api.g_miss_date))
98: OR ((X_START_DATE_TIME < start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
99: > NVL(end_date_time,Fnd_Api.g_miss_date)))
100: OR ((X_START_DATE_TIME > start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) <
101: NVL(end_date_time,Fnd_Api.g_miss_date))));
102: */
103:

Line 100: OR ((X_START_DATE_TIME > start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) <

96: OR ( NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) BETWEEN start_date_time AND
97: NVL(end_date_time,Fnd_Api.g_miss_date))
98: OR ((X_START_DATE_TIME < start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
99: > NVL(end_date_time,Fnd_Api.g_miss_date)))
100: OR ((X_START_DATE_TIME > start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) <
101: NVL(end_date_time,Fnd_Api.g_miss_date))));
102: */
103:
104:

Line 101: NVL(end_date_time,Fnd_Api.g_miss_date))));

97: NVL(end_date_time,Fnd_Api.g_miss_date))
98: OR ((X_START_DATE_TIME < start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
99: > NVL(end_date_time,Fnd_Api.g_miss_date)))
100: OR ((X_START_DATE_TIME > start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) <
101: NVL(end_date_time,Fnd_Api.g_miss_date))));
102: */
103:
104:
105: /* this has been changed for date nls issue on using dd-mon-yyyy format

Line 123: AND (( X_START_DATE_TIME <= start_date_time AND NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)

119: SELECT COUNT(*) INTO v_count FROM jtf_cal_resource_assign
120: WHERE resource_id = X_RESOURCE_ID
121: AND resource_type_code = X_RESOURCE_TYPE_CODE
122: AND primary_calendar_flag = 'N'
123: AND (( X_START_DATE_TIME <= start_date_time AND NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
124: >= NVL(end_date_time,Fnd_Api.g_miss_date))
125: OR ( X_START_DATE_TIME BETWEEN start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
126: OR ( NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) BETWEEN
127: start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))

Line 124: >= NVL(end_date_time,Fnd_Api.g_miss_date))

120: WHERE resource_id = X_RESOURCE_ID
121: AND resource_type_code = X_RESOURCE_TYPE_CODE
122: AND primary_calendar_flag = 'N'
123: AND (( X_START_DATE_TIME <= start_date_time AND NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
124: >= NVL(end_date_time,Fnd_Api.g_miss_date))
125: OR ( X_START_DATE_TIME BETWEEN start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
126: OR ( NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) BETWEEN
127: start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
128: OR ((X_START_DATE_TIME < start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)

Line 125: OR ( X_START_DATE_TIME BETWEEN start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))

121: AND resource_type_code = X_RESOURCE_TYPE_CODE
122: AND primary_calendar_flag = 'N'
123: AND (( X_START_DATE_TIME <= start_date_time AND NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
124: >= NVL(end_date_time,Fnd_Api.g_miss_date))
125: OR ( X_START_DATE_TIME BETWEEN start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
126: OR ( NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) BETWEEN
127: start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
128: OR ((X_START_DATE_TIME < start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
129: > NVL(end_date_time,Fnd_Api.g_miss_date))));

Line 126: OR ( NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) BETWEEN

122: AND primary_calendar_flag = 'N'
123: AND (( X_START_DATE_TIME <= start_date_time AND NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
124: >= NVL(end_date_time,Fnd_Api.g_miss_date))
125: OR ( X_START_DATE_TIME BETWEEN start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
126: OR ( NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) BETWEEN
127: start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
128: OR ((X_START_DATE_TIME < start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
129: > NVL(end_date_time,Fnd_Api.g_miss_date))));
130:

Line 127: start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))

123: AND (( X_START_DATE_TIME <= start_date_time AND NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
124: >= NVL(end_date_time,Fnd_Api.g_miss_date))
125: OR ( X_START_DATE_TIME BETWEEN start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
126: OR ( NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) BETWEEN
127: start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
128: OR ((X_START_DATE_TIME < start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
129: > NVL(end_date_time,Fnd_Api.g_miss_date))));
130:
131:

Line 128: OR ((X_START_DATE_TIME < start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)

124: >= NVL(end_date_time,Fnd_Api.g_miss_date))
125: OR ( X_START_DATE_TIME BETWEEN start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
126: OR ( NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) BETWEEN
127: start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
128: OR ((X_START_DATE_TIME < start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
129: > NVL(end_date_time,Fnd_Api.g_miss_date))));
130:
131:
132: /* check_dup_rec

Line 129: > NVL(end_date_time,Fnd_Api.g_miss_date))));

125: OR ( X_START_DATE_TIME BETWEEN start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
126: OR ( NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) BETWEEN
127: start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
128: OR ((X_START_DATE_TIME < start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
129: > NVL(end_date_time,Fnd_Api.g_miss_date))));
130:
131:
132: /* check_dup_rec
133: (v_COUNT,

Line 410: AND (( X_START_DATE_TIME <= start_date_time AND NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)

406: WHERE resource_id = X_RESOURCE_ID
407: AND resource_type_code = X_RESOURCE_TYPE_CODE
408: AND primary_calendar_flag = 'Y'
409: AND CAL_RESOURCE_ASSIGN_ID <> X_CAL_RESOURCE_ASSIGN_ID
410: AND (( X_START_DATE_TIME <= start_date_time AND NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
411: >= NVL(end_date_time,Fnd_Api.g_miss_date))
412: OR ( X_START_DATE_TIME BETWEEN start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
413: OR ( NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) BETWEEN start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
414: OR ((X_START_DATE_TIME < start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) >

Line 411: >= NVL(end_date_time,Fnd_Api.g_miss_date))

407: AND resource_type_code = X_RESOURCE_TYPE_CODE
408: AND primary_calendar_flag = 'Y'
409: AND CAL_RESOURCE_ASSIGN_ID <> X_CAL_RESOURCE_ASSIGN_ID
410: AND (( X_START_DATE_TIME <= start_date_time AND NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
411: >= NVL(end_date_time,Fnd_Api.g_miss_date))
412: OR ( X_START_DATE_TIME BETWEEN start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
413: OR ( NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) BETWEEN start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
414: OR ((X_START_DATE_TIME < start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) >
415: NVL(end_date_time,Fnd_Api.g_miss_date)))

Line 412: OR ( X_START_DATE_TIME BETWEEN start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))

408: AND primary_calendar_flag = 'Y'
409: AND CAL_RESOURCE_ASSIGN_ID <> X_CAL_RESOURCE_ASSIGN_ID
410: AND (( X_START_DATE_TIME <= start_date_time AND NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
411: >= NVL(end_date_time,Fnd_Api.g_miss_date))
412: OR ( X_START_DATE_TIME BETWEEN start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
413: OR ( NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) BETWEEN start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
414: OR ((X_START_DATE_TIME < start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) >
415: NVL(end_date_time,Fnd_Api.g_miss_date)))
416: OR ((X_START_DATE_TIME > start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)

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

409: AND CAL_RESOURCE_ASSIGN_ID <> X_CAL_RESOURCE_ASSIGN_ID
410: AND (( X_START_DATE_TIME <= start_date_time AND NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
411: >= NVL(end_date_time,Fnd_Api.g_miss_date))
412: OR ( X_START_DATE_TIME BETWEEN start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
413: OR ( NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) BETWEEN start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
414: OR ((X_START_DATE_TIME < start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) >
415: NVL(end_date_time,Fnd_Api.g_miss_date)))
416: OR ((X_START_DATE_TIME > start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
417: < NVL(end_date_time,Fnd_Api.g_miss_date))));

Line 414: OR ((X_START_DATE_TIME < start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) >

410: AND (( X_START_DATE_TIME <= start_date_time AND NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
411: >= NVL(end_date_time,Fnd_Api.g_miss_date))
412: OR ( X_START_DATE_TIME BETWEEN start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
413: OR ( NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) BETWEEN start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
414: OR ((X_START_DATE_TIME < start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) >
415: NVL(end_date_time,Fnd_Api.g_miss_date)))
416: OR ((X_START_DATE_TIME > start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
417: < NVL(end_date_time,Fnd_Api.g_miss_date))));
418:

Line 415: NVL(end_date_time,Fnd_Api.g_miss_date)))

411: >= NVL(end_date_time,Fnd_Api.g_miss_date))
412: OR ( X_START_DATE_TIME BETWEEN start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
413: OR ( NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) BETWEEN start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
414: OR ((X_START_DATE_TIME < start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) >
415: NVL(end_date_time,Fnd_Api.g_miss_date)))
416: OR ((X_START_DATE_TIME > start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
417: < NVL(end_date_time,Fnd_Api.g_miss_date))));
418:
419: IF prime_flag_count = 1 AND X_PRIMARY_CALENDAR_FLAG = 'Y' THEN

Line 416: OR ((X_START_DATE_TIME > start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)

412: OR ( X_START_DATE_TIME BETWEEN start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
413: OR ( NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) BETWEEN start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
414: OR ((X_START_DATE_TIME < start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) >
415: NVL(end_date_time,Fnd_Api.g_miss_date)))
416: OR ((X_START_DATE_TIME > start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
417: < NVL(end_date_time,Fnd_Api.g_miss_date))));
418:
419: IF prime_flag_count = 1 AND X_PRIMARY_CALENDAR_FLAG = 'Y' THEN
420: Fnd_Message.set_name('JTF', 'JTF_CAL_DUP_PRIMARY_CAL_FLAG');

Line 417: < NVL(end_date_time,Fnd_Api.g_miss_date))));

413: OR ( NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) BETWEEN start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
414: OR ((X_START_DATE_TIME < start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) >
415: NVL(end_date_time,Fnd_Api.g_miss_date)))
416: OR ((X_START_DATE_TIME > start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
417: < NVL(end_date_time,Fnd_Api.g_miss_date))));
418:
419: IF prime_flag_count = 1 AND X_PRIMARY_CALENDAR_FLAG = 'Y' THEN
420: Fnd_Message.set_name('JTF', 'JTF_CAL_DUP_PRIMARY_CAL_FLAG');
421: Fnd_Msg_Pub.ADD;

Line 430: AND (( X_START_DATE_TIME <= start_date_time AND NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)

426: WHERE resource_id = X_RESOURCE_ID
427: AND resource_type_code = X_RESOURCE_TYPE_CODE
428: AND primary_calendar_flag = 'N'
429: AND CAL_RESOURCE_ASSIGN_ID <> X_CAL_RESOURCE_ASSIGN_ID
430: AND (( X_START_DATE_TIME <= start_date_time AND NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
431: >= NVL(end_date_time,Fnd_Api.g_miss_date))
432: OR ( X_START_DATE_TIME BETWEEN start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
433: OR ( NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) BETWEEN
434: start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))

Line 431: >= NVL(end_date_time,Fnd_Api.g_miss_date))

427: AND resource_type_code = X_RESOURCE_TYPE_CODE
428: AND primary_calendar_flag = 'N'
429: AND CAL_RESOURCE_ASSIGN_ID <> X_CAL_RESOURCE_ASSIGN_ID
430: AND (( X_START_DATE_TIME <= start_date_time AND NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
431: >= NVL(end_date_time,Fnd_Api.g_miss_date))
432: OR ( X_START_DATE_TIME BETWEEN start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
433: OR ( NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) BETWEEN
434: start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
435: OR ((X_START_DATE_TIME < start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)

Line 432: OR ( X_START_DATE_TIME BETWEEN start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))

428: AND primary_calendar_flag = 'N'
429: AND CAL_RESOURCE_ASSIGN_ID <> X_CAL_RESOURCE_ASSIGN_ID
430: AND (( X_START_DATE_TIME <= start_date_time AND NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
431: >= NVL(end_date_time,Fnd_Api.g_miss_date))
432: OR ( X_START_DATE_TIME BETWEEN start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
433: OR ( NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) BETWEEN
434: start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
435: OR ((X_START_DATE_TIME < start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
436: > NVL(end_date_time,Fnd_Api.g_miss_date))));

Line 433: OR ( NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) BETWEEN

429: AND CAL_RESOURCE_ASSIGN_ID <> X_CAL_RESOURCE_ASSIGN_ID
430: AND (( X_START_DATE_TIME <= start_date_time AND NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
431: >= NVL(end_date_time,Fnd_Api.g_miss_date))
432: OR ( X_START_DATE_TIME BETWEEN start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
433: OR ( NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) BETWEEN
434: start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
435: OR ((X_START_DATE_TIME < start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
436: > NVL(end_date_time,Fnd_Api.g_miss_date))));
437:

Line 434: start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))

430: AND (( X_START_DATE_TIME <= start_date_time AND NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
431: >= NVL(end_date_time,Fnd_Api.g_miss_date))
432: OR ( X_START_DATE_TIME BETWEEN start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
433: OR ( NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) BETWEEN
434: start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
435: OR ((X_START_DATE_TIME < start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
436: > NVL(end_date_time,Fnd_Api.g_miss_date))));
437:
438: /* check_dup_rec

Line 435: OR ((X_START_DATE_TIME < start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)

431: >= NVL(end_date_time,Fnd_Api.g_miss_date))
432: OR ( X_START_DATE_TIME BETWEEN start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
433: OR ( NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) BETWEEN
434: start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
435: OR ((X_START_DATE_TIME < start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
436: > NVL(end_date_time,Fnd_Api.g_miss_date))));
437:
438: /* check_dup_rec
439: (v_COUNT,

Line 436: > NVL(end_date_time,Fnd_Api.g_miss_date))));

432: OR ( X_START_DATE_TIME BETWEEN start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
433: OR ( NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) BETWEEN
434: start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
435: OR ((X_START_DATE_TIME < start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
436: > NVL(end_date_time,Fnd_Api.g_miss_date))));
437:
438: /* check_dup_rec
439: (v_COUNT,
440: X_CALENDAR_ID ,