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.PA_SCHEDULE_PVT dependencies on PA_SCHEDULES

Line 47: TYPE calendar_id_tbl IS TABLE OF PA_SCHEDULES.calendar_id%TYPE

43: l_out_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
44: l_temp_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
45:
46:
47: TYPE calendar_id_tbl IS TABLE OF PA_SCHEDULES.calendar_id%TYPE
48: INDEX BY BINARY_INTEGER;
49: TYPE start_date_tbl IS TABLE OF PA_SCHEDULES.start_date%TYPE
50: INDEX BY BINARY_INTEGER;
51: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES.end_date%TYPE

Line 49: TYPE start_date_tbl IS TABLE OF PA_SCHEDULES.start_date%TYPE

45:
46:
47: TYPE calendar_id_tbl IS TABLE OF PA_SCHEDULES.calendar_id%TYPE
48: INDEX BY BINARY_INTEGER;
49: TYPE start_date_tbl IS TABLE OF PA_SCHEDULES.start_date%TYPE
50: INDEX BY BINARY_INTEGER;
51: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES.end_date%TYPE
52: INDEX BY BINARY_INTEGER;
53: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES.Monday_hours%TYPE

Line 51: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES.end_date%TYPE

47: TYPE calendar_id_tbl IS TABLE OF PA_SCHEDULES.calendar_id%TYPE
48: INDEX BY BINARY_INTEGER;
49: TYPE start_date_tbl IS TABLE OF PA_SCHEDULES.start_date%TYPE
50: INDEX BY BINARY_INTEGER;
51: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES.end_date%TYPE
52: INDEX BY BINARY_INTEGER;
53: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES.Monday_hours%TYPE
54: INDEX BY BINARY_INTEGER;
55: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES.Tuesday_hours%TYPE

Line 53: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES.Monday_hours%TYPE

49: TYPE start_date_tbl IS TABLE OF PA_SCHEDULES.start_date%TYPE
50: INDEX BY BINARY_INTEGER;
51: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES.end_date%TYPE
52: INDEX BY BINARY_INTEGER;
53: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES.Monday_hours%TYPE
54: INDEX BY BINARY_INTEGER;
55: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES.Tuesday_hours%TYPE
56: INDEX BY BINARY_INTEGER;
57: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES.Wednesday_hours%TYPE

Line 55: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES.Tuesday_hours%TYPE

51: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES.end_date%TYPE
52: INDEX BY BINARY_INTEGER;
53: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES.Monday_hours%TYPE
54: INDEX BY BINARY_INTEGER;
55: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES.Tuesday_hours%TYPE
56: INDEX BY BINARY_INTEGER;
57: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES.Wednesday_hours%TYPE
58: INDEX BY BINARY_INTEGER;
59: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES.Thursday_hours%TYPE

Line 57: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES.Wednesday_hours%TYPE

53: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES.Monday_hours%TYPE
54: INDEX BY BINARY_INTEGER;
55: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES.Tuesday_hours%TYPE
56: INDEX BY BINARY_INTEGER;
57: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES.Wednesday_hours%TYPE
58: INDEX BY BINARY_INTEGER;
59: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES.Thursday_hours%TYPE
60: INDEX BY BINARY_INTEGER;
61: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES.Friday_hours%TYPE

Line 59: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES.Thursday_hours%TYPE

55: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES.Tuesday_hours%TYPE
56: INDEX BY BINARY_INTEGER;
57: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES.Wednesday_hours%TYPE
58: INDEX BY BINARY_INTEGER;
59: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES.Thursday_hours%TYPE
60: INDEX BY BINARY_INTEGER;
61: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES.Friday_hours%TYPE
62: INDEX BY BINARY_INTEGER;
63: TYPE Saturday_hours_tbl IS TABLE OF PA_SCHEDULES.Saturday_hours%TYPE

Line 61: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES.Friday_hours%TYPE

57: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES.Wednesday_hours%TYPE
58: INDEX BY BINARY_INTEGER;
59: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES.Thursday_hours%TYPE
60: INDEX BY BINARY_INTEGER;
61: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES.Friday_hours%TYPE
62: INDEX BY BINARY_INTEGER;
63: TYPE Saturday_hours_tbl IS TABLE OF PA_SCHEDULES.Saturday_hours%TYPE
64: INDEX BY BINARY_INTEGER;
65: TYPE Sunday_hours_tbl IS TABLE OF PA_SCHEDULES.Sunday_hours%TYPE

Line 63: TYPE Saturday_hours_tbl IS TABLE OF PA_SCHEDULES.Saturday_hours%TYPE

59: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES.Thursday_hours%TYPE
60: INDEX BY BINARY_INTEGER;
61: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES.Friday_hours%TYPE
62: INDEX BY BINARY_INTEGER;
63: TYPE Saturday_hours_tbl IS TABLE OF PA_SCHEDULES.Saturday_hours%TYPE
64: INDEX BY BINARY_INTEGER;
65: TYPE Sunday_hours_tbl IS TABLE OF PA_SCHEDULES.Sunday_hours%TYPE
66: INDEX BY BINARY_INTEGER;
67:

Line 65: TYPE Sunday_hours_tbl IS TABLE OF PA_SCHEDULES.Sunday_hours%TYPE

61: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES.Friday_hours%TYPE
62: INDEX BY BINARY_INTEGER;
63: TYPE Saturday_hours_tbl IS TABLE OF PA_SCHEDULES.Saturday_hours%TYPE
64: INDEX BY BINARY_INTEGER;
65: TYPE Sunday_hours_tbl IS TABLE OF PA_SCHEDULES.Sunday_hours%TYPE
66: INDEX BY BINARY_INTEGER;
67:
68: l_calendar_id_tbl calendar_id_tbl;
69: l_start_date_tbl start_date_tbl ;

Line 113: FROM PA_SCHEDULES sch

109: l_Thursday_hours_tbl ,
110: l_Friday_hours_tbl ,
111: l_Saturday_hours_tbl ,
112: l_Sunday_hours_tbl
113: FROM PA_SCHEDULES sch
114: WHERE sch.assignment_id = p_assignment_id
115: ORDER BY sch.start_date;
116:
117: l_first_index := NVL(l_start_date_tbl.first,0);

Line 215: -- FROM PA_SCHEDULES sch

211: /* Bug - 1846658- Following lines are commented to incorporate the BULK SELECT to enhance the performance*/
212:
213: -- CURSOR C1 IS SELECT calendar_id,start_date,end_date,Monday_hours,Tuesday_hours,Wednesday_hours,Thursday_hours,
214: -- Friday_hours,Saturday_hours,Sunday_hours
215: -- FROM PA_SCHEDULES sch
216: -- WHERE sch.calendar_id = p_calendar_id
217: -- AND sch.schedule_type_code = 'CALENDAR'
218: -- AND ( ( p_start_date BETWEEN sch.start_date AND sch.end_date)
219: -- OR ( p_end_date BETWEEN sch.start_date AND sch.end_date)

Line 225: TYPE calendar_id_tbl IS TABLE OF PA_SCHEDULES.calendar_id%TYPE

221: -- ORDER BY sch.start_date
222:
223: /* Bug - 1846658- Following lines are added to incorporate the BULK SELECT to enhance the performance*/
224:
225: TYPE calendar_id_tbl IS TABLE OF PA_SCHEDULES.calendar_id%TYPE
226: INDEX BY BINARY_INTEGER;
227: TYPE start_date_tbl IS TABLE OF PA_SCHEDULES.start_date%TYPE
228: INDEX BY BINARY_INTEGER;
229: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES.end_date%TYPE

Line 227: TYPE start_date_tbl IS TABLE OF PA_SCHEDULES.start_date%TYPE

223: /* Bug - 1846658- Following lines are added to incorporate the BULK SELECT to enhance the performance*/
224:
225: TYPE calendar_id_tbl IS TABLE OF PA_SCHEDULES.calendar_id%TYPE
226: INDEX BY BINARY_INTEGER;
227: TYPE start_date_tbl IS TABLE OF PA_SCHEDULES.start_date%TYPE
228: INDEX BY BINARY_INTEGER;
229: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES.end_date%TYPE
230: INDEX BY BINARY_INTEGER;
231: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES.Monday_hours%TYPE

Line 229: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES.end_date%TYPE

225: TYPE calendar_id_tbl IS TABLE OF PA_SCHEDULES.calendar_id%TYPE
226: INDEX BY BINARY_INTEGER;
227: TYPE start_date_tbl IS TABLE OF PA_SCHEDULES.start_date%TYPE
228: INDEX BY BINARY_INTEGER;
229: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES.end_date%TYPE
230: INDEX BY BINARY_INTEGER;
231: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES.Monday_hours%TYPE
232: INDEX BY BINARY_INTEGER;
233: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES.Tuesday_hours%TYPE

Line 231: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES.Monday_hours%TYPE

227: TYPE start_date_tbl IS TABLE OF PA_SCHEDULES.start_date%TYPE
228: INDEX BY BINARY_INTEGER;
229: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES.end_date%TYPE
230: INDEX BY BINARY_INTEGER;
231: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES.Monday_hours%TYPE
232: INDEX BY BINARY_INTEGER;
233: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES.Tuesday_hours%TYPE
234: INDEX BY BINARY_INTEGER;
235: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES.Wednesday_hours%TYPE

Line 233: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES.Tuesday_hours%TYPE

229: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES.end_date%TYPE
230: INDEX BY BINARY_INTEGER;
231: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES.Monday_hours%TYPE
232: INDEX BY BINARY_INTEGER;
233: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES.Tuesday_hours%TYPE
234: INDEX BY BINARY_INTEGER;
235: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES.Wednesday_hours%TYPE
236: INDEX BY BINARY_INTEGER;
237: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES.Thursday_hours%TYPE

Line 235: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES.Wednesday_hours%TYPE

231: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES.Monday_hours%TYPE
232: INDEX BY BINARY_INTEGER;
233: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES.Tuesday_hours%TYPE
234: INDEX BY BINARY_INTEGER;
235: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES.Wednesday_hours%TYPE
236: INDEX BY BINARY_INTEGER;
237: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES.Thursday_hours%TYPE
238: INDEX BY BINARY_INTEGER;
239: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES.Friday_hours%TYPE

Line 237: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES.Thursday_hours%TYPE

233: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES.Tuesday_hours%TYPE
234: INDEX BY BINARY_INTEGER;
235: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES.Wednesday_hours%TYPE
236: INDEX BY BINARY_INTEGER;
237: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES.Thursday_hours%TYPE
238: INDEX BY BINARY_INTEGER;
239: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES.Friday_hours%TYPE
240: INDEX BY BINARY_INTEGER;
241: TYPE Saturday_hours_tbl IS TABLE OF PA_SCHEDULES.Saturday_hours%TYPE

Line 239: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES.Friday_hours%TYPE

235: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES.Wednesday_hours%TYPE
236: INDEX BY BINARY_INTEGER;
237: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES.Thursday_hours%TYPE
238: INDEX BY BINARY_INTEGER;
239: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES.Friday_hours%TYPE
240: INDEX BY BINARY_INTEGER;
241: TYPE Saturday_hours_tbl IS TABLE OF PA_SCHEDULES.Saturday_hours%TYPE
242: INDEX BY BINARY_INTEGER;
243: TYPE Sunday_hours_tbl IS TABLE OF PA_SCHEDULES.Sunday_hours%TYPE

Line 241: TYPE Saturday_hours_tbl IS TABLE OF PA_SCHEDULES.Saturday_hours%TYPE

237: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES.Thursday_hours%TYPE
238: INDEX BY BINARY_INTEGER;
239: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES.Friday_hours%TYPE
240: INDEX BY BINARY_INTEGER;
241: TYPE Saturday_hours_tbl IS TABLE OF PA_SCHEDULES.Saturday_hours%TYPE
242: INDEX BY BINARY_INTEGER;
243: TYPE Sunday_hours_tbl IS TABLE OF PA_SCHEDULES.Sunday_hours%TYPE
244: INDEX BY BINARY_INTEGER;
245:

Line 243: TYPE Sunday_hours_tbl IS TABLE OF PA_SCHEDULES.Sunday_hours%TYPE

239: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES.Friday_hours%TYPE
240: INDEX BY BINARY_INTEGER;
241: TYPE Saturday_hours_tbl IS TABLE OF PA_SCHEDULES.Saturday_hours%TYPE
242: INDEX BY BINARY_INTEGER;
243: TYPE Sunday_hours_tbl IS TABLE OF PA_SCHEDULES.Sunday_hours%TYPE
244: INDEX BY BINARY_INTEGER;
245:
246: l_calendar_id_tbl calendar_id_tbl;
247: l_start_date_tbl start_date_tbl ;

Line 304: FROM PA_SCHEDULES sch

300: l_Thursday_hours_tbl ,
301: l_Friday_hours_tbl ,
302: l_Saturday_hours_tbl ,
303: l_Sunday_hours_tbl
304: FROM PA_SCHEDULES sch
305: WHERE sch.calendar_id = p_calendar_id
306: AND sch.schedule_type_code = 'CALENDAR'
307: AND ( ( p_start_date BETWEEN sch.start_date AND sch.end_date)
308: OR ( p_end_date BETWEEN sch.start_date AND sch.end_date)

Line 492: -- FROM PA_SCHEDULES_V sch

488: -- assignment_id,project_id,schedule_type_code,status_code,
489: -- system_status_code,start_date,end_date,Monday_hours,Tuesday_hours,
490: -- Wednesday_hours,Thursday_hours,
491: -- Friday_hours,Saturday_hours,Sunday_hours
492: -- FROM PA_SCHEDULES_V sch
493: -- WHERE sch.assignment_id = p_assignment_id
494: -- AND sch.schedule_type_code IN
495: -- ('OPEN_ASSIGNMENT','STAFFED_ASSIGNMENT', 'STAFFED_ADMIN_ASSIGNMENT')
496: -- AND ( ( p_start_date BETWEEN sch.start_date AND sch.end_date)

Line 503: TYPE schedule_id_tbl IS TABLE OF PA_SCHEDULES_V.schedule_id%TYPE

499: -- ORDER BY start_date;
500:
501: /* Bug - 1846658- Following lines are added to incorporate the BULK SELECT to enhance the performance*/
502:
503: TYPE schedule_id_tbl IS TABLE OF PA_SCHEDULES_V.schedule_id%TYPE
504: INDEX BY BINARY_INTEGER;
505: TYPE calendar_id_tbl IS TABLE OF PA_SCHEDULES_V.calendar_id%TYPE
506: INDEX BY BINARY_INTEGER;
507: TYPE assignment_id_tbl IS TABLE OF PA_SCHEDULES_V.assignment_id%TYPE

Line 505: TYPE calendar_id_tbl IS TABLE OF PA_SCHEDULES_V.calendar_id%TYPE

501: /* Bug - 1846658- Following lines are added to incorporate the BULK SELECT to enhance the performance*/
502:
503: TYPE schedule_id_tbl IS TABLE OF PA_SCHEDULES_V.schedule_id%TYPE
504: INDEX BY BINARY_INTEGER;
505: TYPE calendar_id_tbl IS TABLE OF PA_SCHEDULES_V.calendar_id%TYPE
506: INDEX BY BINARY_INTEGER;
507: TYPE assignment_id_tbl IS TABLE OF PA_SCHEDULES_V.assignment_id%TYPE
508: INDEX BY BINARY_INTEGER;
509: TYPE project_id_tbl IS TABLE OF PA_SCHEDULES_V.project_id%TYPE

Line 507: TYPE assignment_id_tbl IS TABLE OF PA_SCHEDULES_V.assignment_id%TYPE

503: TYPE schedule_id_tbl IS TABLE OF PA_SCHEDULES_V.schedule_id%TYPE
504: INDEX BY BINARY_INTEGER;
505: TYPE calendar_id_tbl IS TABLE OF PA_SCHEDULES_V.calendar_id%TYPE
506: INDEX BY BINARY_INTEGER;
507: TYPE assignment_id_tbl IS TABLE OF PA_SCHEDULES_V.assignment_id%TYPE
508: INDEX BY BINARY_INTEGER;
509: TYPE project_id_tbl IS TABLE OF PA_SCHEDULES_V.project_id%TYPE
510: INDEX BY BINARY_INTEGER;
511: TYPE schedule_type_code_tbl IS TABLE OF PA_SCHEDULES_V.schedule_type_code%TYPE

Line 509: TYPE project_id_tbl IS TABLE OF PA_SCHEDULES_V.project_id%TYPE

505: TYPE calendar_id_tbl IS TABLE OF PA_SCHEDULES_V.calendar_id%TYPE
506: INDEX BY BINARY_INTEGER;
507: TYPE assignment_id_tbl IS TABLE OF PA_SCHEDULES_V.assignment_id%TYPE
508: INDEX BY BINARY_INTEGER;
509: TYPE project_id_tbl IS TABLE OF PA_SCHEDULES_V.project_id%TYPE
510: INDEX BY BINARY_INTEGER;
511: TYPE schedule_type_code_tbl IS TABLE OF PA_SCHEDULES_V.schedule_type_code%TYPE
512: INDEX BY BINARY_INTEGER;
513: TYPE status_code_tbl IS TABLE OF PA_SCHEDULES_V.status_code%TYPE

Line 511: TYPE schedule_type_code_tbl IS TABLE OF PA_SCHEDULES_V.schedule_type_code%TYPE

507: TYPE assignment_id_tbl IS TABLE OF PA_SCHEDULES_V.assignment_id%TYPE
508: INDEX BY BINARY_INTEGER;
509: TYPE project_id_tbl IS TABLE OF PA_SCHEDULES_V.project_id%TYPE
510: INDEX BY BINARY_INTEGER;
511: TYPE schedule_type_code_tbl IS TABLE OF PA_SCHEDULES_V.schedule_type_code%TYPE
512: INDEX BY BINARY_INTEGER;
513: TYPE status_code_tbl IS TABLE OF PA_SCHEDULES_V.status_code%TYPE
514: INDEX BY BINARY_INTEGER;
515: TYPE system_status_code_tbl IS TABLE OF PA_SCHEDULES_V.system_status_code%TYPE

Line 513: TYPE status_code_tbl IS TABLE OF PA_SCHEDULES_V.status_code%TYPE

509: TYPE project_id_tbl IS TABLE OF PA_SCHEDULES_V.project_id%TYPE
510: INDEX BY BINARY_INTEGER;
511: TYPE schedule_type_code_tbl IS TABLE OF PA_SCHEDULES_V.schedule_type_code%TYPE
512: INDEX BY BINARY_INTEGER;
513: TYPE status_code_tbl IS TABLE OF PA_SCHEDULES_V.status_code%TYPE
514: INDEX BY BINARY_INTEGER;
515: TYPE system_status_code_tbl IS TABLE OF PA_SCHEDULES_V.system_status_code%TYPE
516: INDEX BY BINARY_INTEGER;
517: TYPE start_date_tbl IS TABLE OF PA_SCHEDULES_V.start_date%TYPE

Line 515: TYPE system_status_code_tbl IS TABLE OF PA_SCHEDULES_V.system_status_code%TYPE

511: TYPE schedule_type_code_tbl IS TABLE OF PA_SCHEDULES_V.schedule_type_code%TYPE
512: INDEX BY BINARY_INTEGER;
513: TYPE status_code_tbl IS TABLE OF PA_SCHEDULES_V.status_code%TYPE
514: INDEX BY BINARY_INTEGER;
515: TYPE system_status_code_tbl IS TABLE OF PA_SCHEDULES_V.system_status_code%TYPE
516: INDEX BY BINARY_INTEGER;
517: TYPE start_date_tbl IS TABLE OF PA_SCHEDULES_V.start_date%TYPE
518: INDEX BY BINARY_INTEGER;
519: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES_V.end_date%TYPE

Line 517: TYPE start_date_tbl IS TABLE OF PA_SCHEDULES_V.start_date%TYPE

513: TYPE status_code_tbl IS TABLE OF PA_SCHEDULES_V.status_code%TYPE
514: INDEX BY BINARY_INTEGER;
515: TYPE system_status_code_tbl IS TABLE OF PA_SCHEDULES_V.system_status_code%TYPE
516: INDEX BY BINARY_INTEGER;
517: TYPE start_date_tbl IS TABLE OF PA_SCHEDULES_V.start_date%TYPE
518: INDEX BY BINARY_INTEGER;
519: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES_V.end_date%TYPE
520: INDEX BY BINARY_INTEGER;
521: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Monday_hours%TYPE

Line 519: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES_V.end_date%TYPE

515: TYPE system_status_code_tbl IS TABLE OF PA_SCHEDULES_V.system_status_code%TYPE
516: INDEX BY BINARY_INTEGER;
517: TYPE start_date_tbl IS TABLE OF PA_SCHEDULES_V.start_date%TYPE
518: INDEX BY BINARY_INTEGER;
519: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES_V.end_date%TYPE
520: INDEX BY BINARY_INTEGER;
521: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Monday_hours%TYPE
522: INDEX BY BINARY_INTEGER;
523: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Tuesday_hours%TYPE

Line 521: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Monday_hours%TYPE

517: TYPE start_date_tbl IS TABLE OF PA_SCHEDULES_V.start_date%TYPE
518: INDEX BY BINARY_INTEGER;
519: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES_V.end_date%TYPE
520: INDEX BY BINARY_INTEGER;
521: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Monday_hours%TYPE
522: INDEX BY BINARY_INTEGER;
523: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Tuesday_hours%TYPE
524: INDEX BY BINARY_INTEGER;
525: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Wednesday_hours%TYPE

Line 523: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Tuesday_hours%TYPE

519: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES_V.end_date%TYPE
520: INDEX BY BINARY_INTEGER;
521: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Monday_hours%TYPE
522: INDEX BY BINARY_INTEGER;
523: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Tuesday_hours%TYPE
524: INDEX BY BINARY_INTEGER;
525: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Wednesday_hours%TYPE
526: INDEX BY BINARY_INTEGER;
527: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Thursday_hours%TYPE

Line 525: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Wednesday_hours%TYPE

521: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Monday_hours%TYPE
522: INDEX BY BINARY_INTEGER;
523: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Tuesday_hours%TYPE
524: INDEX BY BINARY_INTEGER;
525: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Wednesday_hours%TYPE
526: INDEX BY BINARY_INTEGER;
527: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Thursday_hours%TYPE
528: INDEX BY BINARY_INTEGER;
529: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Friday_hours%TYPE

Line 527: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Thursday_hours%TYPE

523: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Tuesday_hours%TYPE
524: INDEX BY BINARY_INTEGER;
525: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Wednesday_hours%TYPE
526: INDEX BY BINARY_INTEGER;
527: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Thursday_hours%TYPE
528: INDEX BY BINARY_INTEGER;
529: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Friday_hours%TYPE
530: INDEX BY BINARY_INTEGER;
531: TYPE Saturday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Saturday_hours%TYPE

Line 529: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Friday_hours%TYPE

525: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Wednesday_hours%TYPE
526: INDEX BY BINARY_INTEGER;
527: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Thursday_hours%TYPE
528: INDEX BY BINARY_INTEGER;
529: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Friday_hours%TYPE
530: INDEX BY BINARY_INTEGER;
531: TYPE Saturday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Saturday_hours%TYPE
532: INDEX BY BINARY_INTEGER;
533: TYPE Sunday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Sunday_hours%TYPE

Line 531: TYPE Saturday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Saturday_hours%TYPE

527: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Thursday_hours%TYPE
528: INDEX BY BINARY_INTEGER;
529: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Friday_hours%TYPE
530: INDEX BY BINARY_INTEGER;
531: TYPE Saturday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Saturday_hours%TYPE
532: INDEX BY BINARY_INTEGER;
533: TYPE Sunday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Sunday_hours%TYPE
534: INDEX BY BINARY_INTEGER;
535:

Line 533: TYPE Sunday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Sunday_hours%TYPE

529: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Friday_hours%TYPE
530: INDEX BY BINARY_INTEGER;
531: TYPE Saturday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Saturday_hours%TYPE
532: INDEX BY BINARY_INTEGER;
533: TYPE Sunday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Sunday_hours%TYPE
534: INDEX BY BINARY_INTEGER;
535:
536: l_schedule_id_tbl schedule_id_tbl ;
537: l_calendar_id_tbl calendar_id_tbl ;

Line 559: l_assignment_start_date pa_schedules.start_date%TYPE;

555: i NUMBER;
556:
557: /*Bug 2335580 */
558:
559: l_assignment_start_date pa_schedules.start_date%TYPE;
560: l_assignment_end_date pa_schedules.end_date%TYPE;
561: l_assignment_calendar_id pa_schedules.calendar_id%TYPE;
562:
563: CURSOR CUR_ASSIGNMENT_SCHEDULE(x_assignment_id IN NUMBER) IS

Line 560: l_assignment_end_date pa_schedules.end_date%TYPE;

556:
557: /*Bug 2335580 */
558:
559: l_assignment_start_date pa_schedules.start_date%TYPE;
560: l_assignment_end_date pa_schedules.end_date%TYPE;
561: l_assignment_calendar_id pa_schedules.calendar_id%TYPE;
562:
563: CURSOR CUR_ASSIGNMENT_SCHEDULE(x_assignment_id IN NUMBER) IS
564: SELECT calendar_id, min(start_date), max(end_date)

Line 561: l_assignment_calendar_id pa_schedules.calendar_id%TYPE;

557: /*Bug 2335580 */
558:
559: l_assignment_start_date pa_schedules.start_date%TYPE;
560: l_assignment_end_date pa_schedules.end_date%TYPE;
561: l_assignment_calendar_id pa_schedules.calendar_id%TYPE;
562:
563: CURSOR CUR_ASSIGNMENT_SCHEDULE(x_assignment_id IN NUMBER) IS
564: SELECT calendar_id, min(start_date), max(end_date)
565: FROM PA_SCHEDULES

Line 565: FROM PA_SCHEDULES

561: l_assignment_calendar_id pa_schedules.calendar_id%TYPE;
562:
563: CURSOR CUR_ASSIGNMENT_SCHEDULE(x_assignment_id IN NUMBER) IS
564: SELECT calendar_id, min(start_date), max(end_date)
565: FROM PA_SCHEDULES
566: WHERE assignment_id = x_assignment_id
567: AND schedule_type_code='OPEN_ASSIGNMENT'
568: GROUP BY Calendar_id;
569:

Line 639: FROM PA_SCHEDULES_V sch

635: l_Thursday_hours_tbl,
636: l_Friday_hours_tbl,
637: l_Saturday_hours_tbl,
638: l_Sunday_hours_tbl
639: FROM PA_SCHEDULES_V sch
640: WHERE sch.assignment_id = p_assignment_id
641: AND sch.schedule_type_code IN
642: ('OPEN_ASSIGNMENT','STAFFED_ASSIGNMENT', 'STAFFED_ADMIN_ASSIGNMENT')
643: AND ( ( p_start_date BETWEEN sch.start_date AND sch.end_date)

Line 912: -- FROM PA_SCHEDULES_V sch

908: -- assignment_id,project_id,schedule_type_code,status_code,
909: -- system_status_code,start_date,end_date,Monday_hours,Tuesday_hours,Wednesday_hours,
910: -- Thursday_hours,
911: -- Friday_hours,Saturday_hours,Sunday_hours
912: -- FROM PA_SCHEDULES_V sch
913: -- WHERE sch.assignment_id = p_assignment_id
914: -- AND sch.schedule_type_code IN
915: -- ('OPEN_ASSIGNMENT','STAFFED_ASSIGNMENT', 'STAFFED_ADMIN_ASSIGNMENT')
916: -- ORDER BY start_date;

Line 920: TYPE schedule_id_tbl IS TABLE OF PA_SCHEDULES_V.schedule_id%TYPE

916: -- ORDER BY start_date;
917:
918: /* Bug - 1846658- Following lines are added to incorporate the BULK SELECT to enhance the performance*/
919:
920: TYPE schedule_id_tbl IS TABLE OF PA_SCHEDULES_V.schedule_id%TYPE
921: INDEX BY BINARY_INTEGER;
922: TYPE calendar_id_tbl IS TABLE OF PA_SCHEDULES_V.calendar_id%TYPE
923: INDEX BY BINARY_INTEGER;
924: TYPE assignment_id_tbl IS TABLE OF PA_SCHEDULES_V.assignment_id%TYPE

Line 922: TYPE calendar_id_tbl IS TABLE OF PA_SCHEDULES_V.calendar_id%TYPE

918: /* Bug - 1846658- Following lines are added to incorporate the BULK SELECT to enhance the performance*/
919:
920: TYPE schedule_id_tbl IS TABLE OF PA_SCHEDULES_V.schedule_id%TYPE
921: INDEX BY BINARY_INTEGER;
922: TYPE calendar_id_tbl IS TABLE OF PA_SCHEDULES_V.calendar_id%TYPE
923: INDEX BY BINARY_INTEGER;
924: TYPE assignment_id_tbl IS TABLE OF PA_SCHEDULES_V.assignment_id%TYPE
925: INDEX BY BINARY_INTEGER;
926: TYPE project_id_tbl IS TABLE OF PA_SCHEDULES_V.project_id%TYPE

Line 924: TYPE assignment_id_tbl IS TABLE OF PA_SCHEDULES_V.assignment_id%TYPE

920: TYPE schedule_id_tbl IS TABLE OF PA_SCHEDULES_V.schedule_id%TYPE
921: INDEX BY BINARY_INTEGER;
922: TYPE calendar_id_tbl IS TABLE OF PA_SCHEDULES_V.calendar_id%TYPE
923: INDEX BY BINARY_INTEGER;
924: TYPE assignment_id_tbl IS TABLE OF PA_SCHEDULES_V.assignment_id%TYPE
925: INDEX BY BINARY_INTEGER;
926: TYPE project_id_tbl IS TABLE OF PA_SCHEDULES_V.project_id%TYPE
927: INDEX BY BINARY_INTEGER;
928: TYPE schedule_type_code_tbl IS TABLE OF PA_SCHEDULES_V.schedule_type_code%TYPE

Line 926: TYPE project_id_tbl IS TABLE OF PA_SCHEDULES_V.project_id%TYPE

922: TYPE calendar_id_tbl IS TABLE OF PA_SCHEDULES_V.calendar_id%TYPE
923: INDEX BY BINARY_INTEGER;
924: TYPE assignment_id_tbl IS TABLE OF PA_SCHEDULES_V.assignment_id%TYPE
925: INDEX BY BINARY_INTEGER;
926: TYPE project_id_tbl IS TABLE OF PA_SCHEDULES_V.project_id%TYPE
927: INDEX BY BINARY_INTEGER;
928: TYPE schedule_type_code_tbl IS TABLE OF PA_SCHEDULES_V.schedule_type_code%TYPE
929: INDEX BY BINARY_INTEGER;
930: TYPE status_code_tbl IS TABLE OF PA_SCHEDULES_V.status_code%TYPE

Line 928: TYPE schedule_type_code_tbl IS TABLE OF PA_SCHEDULES_V.schedule_type_code%TYPE

924: TYPE assignment_id_tbl IS TABLE OF PA_SCHEDULES_V.assignment_id%TYPE
925: INDEX BY BINARY_INTEGER;
926: TYPE project_id_tbl IS TABLE OF PA_SCHEDULES_V.project_id%TYPE
927: INDEX BY BINARY_INTEGER;
928: TYPE schedule_type_code_tbl IS TABLE OF PA_SCHEDULES_V.schedule_type_code%TYPE
929: INDEX BY BINARY_INTEGER;
930: TYPE status_code_tbl IS TABLE OF PA_SCHEDULES_V.status_code%TYPE
931: INDEX BY BINARY_INTEGER;
932: TYPE system_status_code_tbl IS TABLE OF PA_SCHEDULES_V.system_status_code%TYPE

Line 930: TYPE status_code_tbl IS TABLE OF PA_SCHEDULES_V.status_code%TYPE

926: TYPE project_id_tbl IS TABLE OF PA_SCHEDULES_V.project_id%TYPE
927: INDEX BY BINARY_INTEGER;
928: TYPE schedule_type_code_tbl IS TABLE OF PA_SCHEDULES_V.schedule_type_code%TYPE
929: INDEX BY BINARY_INTEGER;
930: TYPE status_code_tbl IS TABLE OF PA_SCHEDULES_V.status_code%TYPE
931: INDEX BY BINARY_INTEGER;
932: TYPE system_status_code_tbl IS TABLE OF PA_SCHEDULES_V.system_status_code%TYPE
933: INDEX BY BINARY_INTEGER;
934: TYPE start_date_tbl IS TABLE OF PA_SCHEDULES_V.start_date%TYPE

Line 932: TYPE system_status_code_tbl IS TABLE OF PA_SCHEDULES_V.system_status_code%TYPE

928: TYPE schedule_type_code_tbl IS TABLE OF PA_SCHEDULES_V.schedule_type_code%TYPE
929: INDEX BY BINARY_INTEGER;
930: TYPE status_code_tbl IS TABLE OF PA_SCHEDULES_V.status_code%TYPE
931: INDEX BY BINARY_INTEGER;
932: TYPE system_status_code_tbl IS TABLE OF PA_SCHEDULES_V.system_status_code%TYPE
933: INDEX BY BINARY_INTEGER;
934: TYPE start_date_tbl IS TABLE OF PA_SCHEDULES_V.start_date%TYPE
935: INDEX BY BINARY_INTEGER;
936: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES_V.end_date%TYPE

Line 934: TYPE start_date_tbl IS TABLE OF PA_SCHEDULES_V.start_date%TYPE

930: TYPE status_code_tbl IS TABLE OF PA_SCHEDULES_V.status_code%TYPE
931: INDEX BY BINARY_INTEGER;
932: TYPE system_status_code_tbl IS TABLE OF PA_SCHEDULES_V.system_status_code%TYPE
933: INDEX BY BINARY_INTEGER;
934: TYPE start_date_tbl IS TABLE OF PA_SCHEDULES_V.start_date%TYPE
935: INDEX BY BINARY_INTEGER;
936: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES_V.end_date%TYPE
937: INDEX BY BINARY_INTEGER;
938: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Monday_hours%TYPE

Line 936: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES_V.end_date%TYPE

932: TYPE system_status_code_tbl IS TABLE OF PA_SCHEDULES_V.system_status_code%TYPE
933: INDEX BY BINARY_INTEGER;
934: TYPE start_date_tbl IS TABLE OF PA_SCHEDULES_V.start_date%TYPE
935: INDEX BY BINARY_INTEGER;
936: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES_V.end_date%TYPE
937: INDEX BY BINARY_INTEGER;
938: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Monday_hours%TYPE
939: INDEX BY BINARY_INTEGER;
940: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Tuesday_hours%TYPE

Line 938: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Monday_hours%TYPE

934: TYPE start_date_tbl IS TABLE OF PA_SCHEDULES_V.start_date%TYPE
935: INDEX BY BINARY_INTEGER;
936: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES_V.end_date%TYPE
937: INDEX BY BINARY_INTEGER;
938: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Monday_hours%TYPE
939: INDEX BY BINARY_INTEGER;
940: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Tuesday_hours%TYPE
941: INDEX BY BINARY_INTEGER;
942: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Wednesday_hours%TYPE

Line 940: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Tuesday_hours%TYPE

936: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES_V.end_date%TYPE
937: INDEX BY BINARY_INTEGER;
938: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Monday_hours%TYPE
939: INDEX BY BINARY_INTEGER;
940: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Tuesday_hours%TYPE
941: INDEX BY BINARY_INTEGER;
942: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Wednesday_hours%TYPE
943: INDEX BY BINARY_INTEGER;
944: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Thursday_hours%TYPE

Line 942: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Wednesday_hours%TYPE

938: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Monday_hours%TYPE
939: INDEX BY BINARY_INTEGER;
940: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Tuesday_hours%TYPE
941: INDEX BY BINARY_INTEGER;
942: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Wednesday_hours%TYPE
943: INDEX BY BINARY_INTEGER;
944: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Thursday_hours%TYPE
945: INDEX BY BINARY_INTEGER;
946: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Friday_hours%TYPE

Line 944: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Thursday_hours%TYPE

940: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Tuesday_hours%TYPE
941: INDEX BY BINARY_INTEGER;
942: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Wednesday_hours%TYPE
943: INDEX BY BINARY_INTEGER;
944: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Thursday_hours%TYPE
945: INDEX BY BINARY_INTEGER;
946: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Friday_hours%TYPE
947: INDEX BY BINARY_INTEGER;
948: TYPE Saturday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Saturday_hours%TYPE

Line 946: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Friday_hours%TYPE

942: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Wednesday_hours%TYPE
943: INDEX BY BINARY_INTEGER;
944: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Thursday_hours%TYPE
945: INDEX BY BINARY_INTEGER;
946: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Friday_hours%TYPE
947: INDEX BY BINARY_INTEGER;
948: TYPE Saturday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Saturday_hours%TYPE
949: INDEX BY BINARY_INTEGER;
950: TYPE Sunday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Sunday_hours%TYPE

Line 948: TYPE Saturday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Saturday_hours%TYPE

944: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Thursday_hours%TYPE
945: INDEX BY BINARY_INTEGER;
946: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Friday_hours%TYPE
947: INDEX BY BINARY_INTEGER;
948: TYPE Saturday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Saturday_hours%TYPE
949: INDEX BY BINARY_INTEGER;
950: TYPE Sunday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Sunday_hours%TYPE
951: INDEX BY BINARY_INTEGER;
952:

Line 950: TYPE Sunday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Sunday_hours%TYPE

946: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Friday_hours%TYPE
947: INDEX BY BINARY_INTEGER;
948: TYPE Saturday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Saturday_hours%TYPE
949: INDEX BY BINARY_INTEGER;
950: TYPE Sunday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Sunday_hours%TYPE
951: INDEX BY BINARY_INTEGER;
952:
953: l_schedule_id_tbl schedule_id_tbl ;
954: l_calendar_id_tbl calendar_id_tbl ;

Line 1037: FROM PA_SCHEDULES_V sch

1033: l_Thursday_hours_tbl,
1034: l_Friday_hours_tbl,
1035: l_Saturday_hours_tbl,
1036: l_Sunday_hours_tbl
1037: FROM PA_SCHEDULES_V sch
1038: WHERE sch.assignment_id = p_assignment_id
1039: AND sch.schedule_type_code IN ('OPEN_ASSIGNMENT','STAFFED_ASSIGNMENT', 'STAFFED_ADMIN_ASSIGNMENT')
1040: ORDER BY start_date;
1041:

Line 2476: -- Updating the pa schedules table

2472: END IF; --IF (p_sch_except_record.change_hours_type_code = 'PERCENTAGE')
2473:
2474:
2475: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2476: -- Updating the pa schedules table
2477: PA_SCHEDULE_UTILS.update_sch_rec_tab(x_sch_record_tab,
2478: p_project_id => p_sch_except_record.project_id,
2479: p_schedule_type_code => p_sch_except_record.schedule_type_code,
2480: p_assignment_id => p_sch_except_record.assignment_id,

Line 2670: from pa_schedules

2666: thursday_hours,
2667: friday_hours,
2668: saturday_hours,
2669: sunday_hours
2670: from pa_schedules
2671: where project_id = p_project_id and
2672: assignment_id = p_assignment_id
2673: order by start_date;
2674:

Line 4743: -- Inserting the record in PA_SCHEDULES table

4739: PA_SCHEDULE_UTILS.log_message(1, 'After Calling the API update_sch_rec_tab ....');
4740: PA_SCHEDULE_UTILS.log_message(1, 'Before Calling the API insert_rows ....');
4741:
4742: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
4743: -- Inserting the record in PA_SCHEDULES table
4744: PA_SCHEDULE_PKG.insert_rows(
4745: l_new_schedule_tab,
4746: l_x_return_status,
4747: x_msg_count,

Line 4796: -- deleting the records from pa_schedules,pa_schedule_exceptions and pa_schedule_except_history */

4792:
4793: -- Storing the value for error tracking
4794: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
4795:
4796: -- deleting the records from pa_schedules,pa_schedule_exceptions and pa_schedule_except_history */
4797:
4798: DELETE pa_schedules
4799: WHERE assignment_id = p_assignment_id;
4800:

Line 4798: DELETE pa_schedules

4794: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
4795:
4796: -- deleting the records from pa_schedules,pa_schedule_exceptions and pa_schedule_except_history */
4797:
4798: DELETE pa_schedules
4799: WHERE assignment_id = p_assignment_id;
4800:
4801: DELETE pa_schedule_exceptions
4802: WHERE assignment_id = p_assignment_id;

Line 4817: DELETE pa_schedules_history

4813: end if;
4814:
4815: -- Delete entire schedules history if p_perm_delete.
4816: if FND_API.TO_BOOLEAN(p_perm_delete) then
4817: DELETE pa_schedules_history
4818: WHERE assignment_id = p_assignment_id;
4819: end if;
4820:
4821: -- Calling the Timeline api to delete the timeline records

Line 4873: l_schedule_id pa_schedules.schedule_id%TYPE;

4869:
4870:
4871: /*Added for bug 2279209 */
4872:
4873: l_schedule_id pa_schedules.schedule_id%TYPE;
4874: l_first_status pa_schedules.status_code%TYPE;
4875: l_start_date pa_schedules.start_date%TYPE;
4876: l_end_date pa_schedules.end_date%TYPE;
4877: l_loop_thru_record varchar2(1) :='Y';

Line 4874: l_first_status pa_schedules.status_code%TYPE;

4870:
4871: /*Added for bug 2279209 */
4872:
4873: l_schedule_id pa_schedules.schedule_id%TYPE;
4874: l_first_status pa_schedules.status_code%TYPE;
4875: l_start_date pa_schedules.start_date%TYPE;
4876: l_end_date pa_schedules.end_date%TYPE;
4877: l_loop_thru_record varchar2(1) :='Y';
4878: l_status_code pa_schedules.status_code%TYPE;

Line 4875: l_start_date pa_schedules.start_date%TYPE;

4871: /*Added for bug 2279209 */
4872:
4873: l_schedule_id pa_schedules.schedule_id%TYPE;
4874: l_first_status pa_schedules.status_code%TYPE;
4875: l_start_date pa_schedules.start_date%TYPE;
4876: l_end_date pa_schedules.end_date%TYPE;
4877: l_loop_thru_record varchar2(1) :='Y';
4878: l_status_code pa_schedules.status_code%TYPE;
4879:

Line 4876: l_end_date pa_schedules.end_date%TYPE;

4872:
4873: l_schedule_id pa_schedules.schedule_id%TYPE;
4874: l_first_status pa_schedules.status_code%TYPE;
4875: l_start_date pa_schedules.start_date%TYPE;
4876: l_end_date pa_schedules.end_date%TYPE;
4877: l_loop_thru_record varchar2(1) :='Y';
4878: l_status_code pa_schedules.status_code%TYPE;
4879:
4880: /* Added for bug 2329948 */

Line 4878: l_status_code pa_schedules.status_code%TYPE;

4874: l_first_status pa_schedules.status_code%TYPE;
4875: l_start_date pa_schedules.start_date%TYPE;
4876: l_end_date pa_schedules.end_date%TYPE;
4877: l_loop_thru_record varchar2(1) :='Y';
4878: l_status_code pa_schedules.status_code%TYPE;
4879:
4880: /* Added for bug 2329948 */
4881: l_first_start_date pa_schedules.start_date%TYPE;
4882: l_last_end_date pa_schedules.end_date%TYPE;

Line 4881: l_first_start_date pa_schedules.start_date%TYPE;

4877: l_loop_thru_record varchar2(1) :='Y';
4878: l_status_code pa_schedules.status_code%TYPE;
4879:
4880: /* Added for bug 2329948 */
4881: l_first_start_date pa_schedules.start_date%TYPE;
4882: l_last_end_date pa_schedules.end_date%TYPE;
4883: l_count NUMBER;
4884:
4885:

Line 4882: l_last_end_date pa_schedules.end_date%TYPE;

4878: l_status_code pa_schedules.status_code%TYPE;
4879:
4880: /* Added for bug 2329948 */
4881: l_first_start_date pa_schedules.start_date%TYPE;
4882: l_last_end_date pa_schedules.end_date%TYPE;
4883: l_count NUMBER;
4884:
4885:
4886: CURSOR C1 IS

Line 4888: FROM pa_schedules

4884:
4885:
4886: CURSOR C1 IS
4887: SELECT schedule_id, status_code, start_date, end_date
4888: FROM pa_schedules
4889: WHERE assignment_id = p_assignment_id
4890: ORDER BY start_date;
4891:
4892: CURSOR C2 IS

Line 4950: FROM pa_schedules

4946: PA_SCHEDULE_UTILS.log_message(1,'Change status API called once');
4947:
4948: SELECT min(start_date), max(end_date)
4949: INTO l_start_date, l_end_date
4950: FROM pa_schedules
4951: where assignment_id= p_assignment_id;
4952:
4953: PA_SCHEDULE_UTILS.log_message(1,'Call API to get next status');
4954: PA_PROJECT_STUS_UTILS.get_wf_success_failure_status (

Line 5039: FROM pa_schedules

5035:
5036: /* Added for bug#2329948 */
5037: SELECT COUNT(*)
5038: INTO l_count
5039: FROM pa_schedules
5040: WHERE assignment_id = p_assignment_id;
5041:
5042: OPEN C1;
5043: LOOP

Line 5132: -- If records exist in pa_schedules_history with last_approved_flag

5128: CLOSE C1;
5129: /* End of code added for bug 2329948 */
5130:
5131:
5132: -- If records exist in pa_schedules_history with last_approved_flag
5133: -- set the flag to 'N'
5134: PA_SCHEDULE_UTILS.log_message(1, 'Setting last approved flag to N');
5135: update pa_schedules_history
5136: set last_approved_flag = 'N'

Line 5135: update pa_schedules_history

5131:
5132: -- If records exist in pa_schedules_history with last_approved_flag
5133: -- set the flag to 'N'
5134: PA_SCHEDULE_UTILS.log_message(1, 'Setting last approved flag to N');
5135: update pa_schedules_history
5136: set last_approved_flag = 'N'
5137: where assignment_id = p_assignment_id
5138: and last_approved_flag = 'Y';
5139:

Line 5199: l_schedule_id pa_schedules.schedule_id%TYPE;

5195: -- added for Bug Fix: 4537865
5196:
5197:
5198: /* Added for bug 2329948 */
5199: l_schedule_id pa_schedules.schedule_id%TYPE;
5200: l_start_date pa_schedules.start_date%TYPE;
5201: l_end_date pa_schedules.end_date%TYPE;
5202: l_status_code pa_schedules.status_code%TYPE;
5203: l_first_status pa_schedules.status_code%TYPE;

Line 5200: l_start_date pa_schedules.start_date%TYPE;

5196:
5197:
5198: /* Added for bug 2329948 */
5199: l_schedule_id pa_schedules.schedule_id%TYPE;
5200: l_start_date pa_schedules.start_date%TYPE;
5201: l_end_date pa_schedules.end_date%TYPE;
5202: l_status_code pa_schedules.status_code%TYPE;
5203: l_first_status pa_schedules.status_code%TYPE;
5204: l_first_start_date pa_schedules.start_date%TYPE;

Line 5201: l_end_date pa_schedules.end_date%TYPE;

5197:
5198: /* Added for bug 2329948 */
5199: l_schedule_id pa_schedules.schedule_id%TYPE;
5200: l_start_date pa_schedules.start_date%TYPE;
5201: l_end_date pa_schedules.end_date%TYPE;
5202: l_status_code pa_schedules.status_code%TYPE;
5203: l_first_status pa_schedules.status_code%TYPE;
5204: l_first_start_date pa_schedules.start_date%TYPE;
5205: l_last_end_date pa_schedules.end_date%TYPE;

Line 5202: l_status_code pa_schedules.status_code%TYPE;

5198: /* Added for bug 2329948 */
5199: l_schedule_id pa_schedules.schedule_id%TYPE;
5200: l_start_date pa_schedules.start_date%TYPE;
5201: l_end_date pa_schedules.end_date%TYPE;
5202: l_status_code pa_schedules.status_code%TYPE;
5203: l_first_status pa_schedules.status_code%TYPE;
5204: l_first_start_date pa_schedules.start_date%TYPE;
5205: l_last_end_date pa_schedules.end_date%TYPE;
5206: l_count NUMBER;

Line 5203: l_first_status pa_schedules.status_code%TYPE;

5199: l_schedule_id pa_schedules.schedule_id%TYPE;
5200: l_start_date pa_schedules.start_date%TYPE;
5201: l_end_date pa_schedules.end_date%TYPE;
5202: l_status_code pa_schedules.status_code%TYPE;
5203: l_first_status pa_schedules.status_code%TYPE;
5204: l_first_start_date pa_schedules.start_date%TYPE;
5205: l_last_end_date pa_schedules.end_date%TYPE;
5206: l_count NUMBER;
5207:

Line 5204: l_first_start_date pa_schedules.start_date%TYPE;

5200: l_start_date pa_schedules.start_date%TYPE;
5201: l_end_date pa_schedules.end_date%TYPE;
5202: l_status_code pa_schedules.status_code%TYPE;
5203: l_first_status pa_schedules.status_code%TYPE;
5204: l_first_start_date pa_schedules.start_date%TYPE;
5205: l_last_end_date pa_schedules.end_date%TYPE;
5206: l_count NUMBER;
5207:
5208: CURSOR C1 IS

Line 5205: l_last_end_date pa_schedules.end_date%TYPE;

5201: l_end_date pa_schedules.end_date%TYPE;
5202: l_status_code pa_schedules.status_code%TYPE;
5203: l_first_status pa_schedules.status_code%TYPE;
5204: l_first_start_date pa_schedules.start_date%TYPE;
5205: l_last_end_date pa_schedules.end_date%TYPE;
5206: l_count NUMBER;
5207:
5208: CURSOR C1 IS
5209: SELECT schedule_id, status_code, start_date, end_date

Line 5210: FROM pa_schedules

5206: l_count NUMBER;
5207:
5208: CURSOR C1 IS
5209: SELECT schedule_id, status_code, start_date, end_date
5210: FROM pa_schedules
5211: WHERE assignment_id = p_assignment_id
5212: ORDER BY start_date;
5213:
5214: CURSOR C2 IS

Line 5288: FROM pa_schedules

5284:
5285: /* Added for bug#2329948 */
5286: SELECT COUNT(*)
5287: INTO l_count
5288: FROM pa_schedules
5289: WHERE assignment_id = p_assignment_id;
5290:
5291: OPEN C1;
5292: LOOP

Line 5437: from pa_schedules_history

5433: tuesday_hours, wednesday_hours, thursday_hours, friday_hours,
5434: saturday_hours, sunday_hours, change_id, last_approved_flag, request_id,
5435: program_application_id, program_id, program_update_date, creation_date,
5436: created_by, last_update_date, last_update_by, last_update_login
5437: from pa_schedules_history
5438: where assignment_id = p_assignment_id
5439: and last_approved_flag = 'Y';
5440:
5441: BEGIN

Line 5460: -- Insert row into PA_SCHEDULES

5456: x_return_status => l_x_return_status,
5457: x_msg_count => x_msg_count,
5458: x_msg_data => x_msg_data);
5459: end if;
5460: -- Insert row into PA_SCHEDULES
5461: pa_schedule_pkg.insert_rows (
5462: p_calendar_id => rec.calendar_id,
5463: p_assignment_id => rec.assignment_id ,
5464: p_project_id => rec.project_id ,

Line 5484: delete pa_schedules_history

5480:
5481: -- Call create_timeline and delete records from schedule history
5482: -- if we inserted any rows.
5483: if l_index <> 0 then
5484: delete pa_schedules_history
5485: where assignment_id = p_assignment_id
5486: and last_approved_flag = 'Y';
5487:
5488: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN

Line 5526: -- Effects: Adds schedule records for p_assignment_id to pa_schedules_history

5522: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
5523: p_procedure_name => 'revert_to_last_approved');
5524: END revert_to_last_approved;
5525:
5526: -- Effects: Adds schedule records for p_assignment_id to pa_schedules_history
5527: -- if they do not already exist.
5528: -- Impl Notes: If records already exist in pa_schedule_history with change_id,
5529: -- then do nothing. Otherwise, uncheck any records with last_approved_flag
5530: -- and copy schedule records there with correct change_id with

Line 5553: from pa_schedules_history

5549:
5550: -- Contains all the records with p_change_id.
5551: CURSOR C1 IS
5552: select assignment_id
5553: from pa_schedules_history
5554: where assignment_id = p_assignment_id
5555: and change_id = p_change_id;
5556:
5557: -- Contains the schedule records for assignment_id.

Line 5565: from pa_schedules

5561: tuesday_hours, wednesday_hours, thursday_hours, friday_hours,
5562: saturday_hours, sunday_hours, creation_date, created_by, last_update_date,
5563: last_update_by, last_update_login, request_id, program_application_id,
5564: program_id, program_update_date
5565: from pa_schedules
5566: where assignment_id = p_assignment_id;
5567:
5568: BEGIN
5569: PA_SCHEDULE_UTILS.log_message(1,'Start of the update_history_table API');

Line 5572: -- If there are no records in pa_schedules_history with change_id

5568: BEGIN
5569: PA_SCHEDULE_UTILS.log_message(1,'Start of the update_history_table API');
5570: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
5571:
5572: -- If there are no records in pa_schedules_history with change_id
5573: -- then update table.
5574: open c1;
5575: fetch c1 into l_assignment_id;
5576: if c1%NOTFOUND then

Line 5579: -- Copy records in pa_schedules to pa_schedules_history

5575: fetch c1 into l_assignment_id;
5576: if c1%NOTFOUND then
5577: close c1;
5578:
5579: -- Copy records in pa_schedules to pa_schedules_history
5580: for rec in c2 loop
5581: insert into pa_schedules_history
5582: ( schedule_id, calendar_id, assignment_id, project_id,
5583: schedule_type_code, status_code, start_date, end_date, monday_hours,

Line 5581: insert into pa_schedules_history

5577: close c1;
5578:
5579: -- Copy records in pa_schedules to pa_schedules_history
5580: for rec in c2 loop
5581: insert into pa_schedules_history
5582: ( schedule_id, calendar_id, assignment_id, project_id,
5583: schedule_type_code, status_code, start_date, end_date, monday_hours,
5584: tuesday_hours, wednesday_hours, thursday_hours, friday_hours,
5585: saturday_hours, sunday_hours, change_id, last_approved_flag,

Line 5600: -- If there are records in pa_schedules_history with change_id

5596: rec.request_id, rec.program_application_id, rec.program_id,
5597: rec.program_update_date);
5598: end loop;
5599:
5600: -- If there are records in pa_schedules_history with change_id
5601: -- then do nothing.
5602: else
5603: close c1;
5604: end if;

Line 5685: l_status_code pa_schedules.status_code%TYPE;

5681: l_start_date DATE;
5682: l_end_date DATE;
5683: l_project_calendar_id NUMBER;
5684: l_assignment_type pa_project_assignments.assignment_type%TYPE;
5685: l_status_code pa_schedules.status_code%TYPE;
5686: l_apprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;
5687: l_shifted_days NUMBER;
5688: l_calendar_id NUMBER;
5689:

Line 6027: from pa_forecast_items fi1, pa_schedules sch, pa_project_statuses a, pa_project_statuses b

6023: sum(item_quantity) total_assigned_quantity,
6024: item_date,
6025: delete_flag,
6026: forecast_item_type
6027: from pa_forecast_items fi1, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
6028: where (fi1.assignment_id = p_assignment_id or asgmt_sys_status_code = 'STAFFED_ASGMT_CONF' )
6029: and fi1.assignment_id = sch.assignment_id
6030: and fi1.item_date between sch.start_date and sch.end_date
6031: and sch.status_code = a.project_status_code

Line 6086: from pa_forecast_items fi1, pa_schedules sch, pa_project_statuses a, pa_project_statuses b

6082: sum(item_quantity) total_assigned_quantity,
6083: GLOBAL_EXP_PERIOD_END_DATE week_end_date,
6084: delete_flag,
6085: forecast_item_type
6086: from pa_forecast_items fi1, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
6087: where (fi1.assignment_id = p_assignment_id or asgmt_sys_status_code = 'STAFFED_ASGMT_CONF' )
6088: and fi1.item_date between l_start_date and l_end_date
6089: and fi1.assignment_id = sch.assignment_id
6090: and fi1.item_date between sch.start_date and sch.end_date

Line 6228: from pa_forecast_items fi, pa_mass_txn_asgmt_success_v mass, pa_schedules sch, pa_project_statuses a, pa_project_statuses b,

6224: IF G_AVAILABILITY_CAL_PERIOD = 'DAILY' THEN
6225: select distinct fi.assignment_id,
6226: decode (mass.assignment_id, null, 'N', 'Y') intra_txn_conflict_flag
6227: BULK COLLECT INTO l_assignment_id_tbl, l_intra_txn_conflict_flag_tbl
6228: from pa_forecast_items fi, pa_mass_txn_asgmt_success_v mass, pa_schedules sch, pa_project_statuses a, pa_project_statuses b,
6229: (select resource_id,
6230: sum(item_quantity) total_assigned_quantity,
6231: item_date,
6232: delete_flag,

Line 6240: from pa_forecast_items fi1, pa_schedules sch, pa_project_statuses a, pa_project_statuses b

6236: item_quantity,
6237: item_date,
6238: delete_flag,
6239: forecast_item_type
6240: from pa_forecast_items fi1, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
6241: where (fi1.assignment_id in (select assignment_id from pa_mass_txn_asgmt_success_v where item_type = p_item_type and item_key = p_item_key) or asgmt_sys_status_code = 'STAFFED_ASGMT_CONF' )
6242: and fi1.assignment_id = sch.assignment_id
6243: and fi1.item_date between sch.start_date and sch.end_date
6244: and sch.status_code = a.project_status_code

Line 6307: from pa_forecast_items fi, pa_mass_txn_asgmt_success_v mass, pa_schedules sch, pa_project_statuses a, pa_project_statuses b,

6303:
6304: select distinct fi.assignment_id,
6305: decode (mass.assignment_id, null, 'N', 'Y') intra_txn_flag
6306: BULK COLLECT INTO l_assignment_id_tbl, l_intra_txn_conflict_flag_tbl
6307: from pa_forecast_items fi, pa_mass_txn_asgmt_success_v mass, pa_schedules sch, pa_project_statuses a, pa_project_statuses b,
6308: (select resource_id,
6309: sum(item_quantity) total_assigned_quantity,
6310: GLOBAL_EXP_PERIOD_END_DATE,
6311: delete_flag,

Line 6319: from pa_forecast_items fi1, pa_schedules sch, pa_project_statuses a, pa_project_statuses b

6315: item_quantity,
6316: GLOBAL_EXP_PERIOD_END_DATE,
6317: delete_flag,
6318: forecast_item_type
6319: from pa_forecast_items fi1, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
6320: where (fi1.assignment_id in (select assignment_id from pa_mass_txn_asgmt_success_v where item_type = p_item_type and item_key = p_item_key) or asgmt_sys_status_code = 'STAFFED_ASGMT_CONF' )
6321: and fi1.item_date between l_start_date and l_end_date
6322: and fi1.assignment_id = sch.assignment_id
6323: and fi1.item_date between sch.start_date and sch.end_date

Line 6479: from pa_forecast_items fi, pa_schedules sch, pa_project_statuses a, pa_project_statuses b

6475: item_quantity,
6476: item_date,
6477: asgmt_sys_status_code,
6478: delete_flag
6479: from pa_forecast_items fi, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
6480: where fi.assignment_id = p_assignment_id
6481: and fi.assignment_id = sch.assignment_id
6482: and fi.item_date between sch.start_date and sch.end_date
6483: and forecast_item_type = 'A'

Line 6512: from pa_forecast_items fi, pa_schedules sch, pa_project_statuses a, pa_project_statuses b

6508: (select resource_id,
6509: sum(item_quantity) weekly_quantity,
6510: GLOBAL_EXP_PERIOD_END_DATE week_end_date,
6511: delete_flag
6512: from pa_forecast_items fi, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
6513: where fi.assignment_id = p_assignment_id
6514: and fi.assignment_id = sch.assignment_id
6515: and item_date between l_week_start_date and l_week_end_date
6516: and item_date between sch.start_date and sch.end_date

Line 8522: FROM pa_schedules_history

8518: to_char(trunc(sunday_hours,2)) sun_hours,
8519: status_code,
8520: start_date,
8521: end_date
8522: FROM pa_schedules_history
8523: WHERE assignment_id = p_assignment_id
8524: AND last_approved_flag = 'Y'
8525: AND ( (start_date <= p_start_date AND end_date >= p_end_date)
8526: OR (start_date >= p_start_date AND end_date <= p_end_date)

Line 8543: FROM pa_schedules

8539: to_char(trunc(sunday_hours,2)) sun_hours,
8540: status_code,
8541: start_date,
8542: end_date
8543: FROM pa_schedules
8544: WHERE assignment_id = p_assignment_id
8545: AND ( (start_date <= p_start_date AND end_date >= p_end_date)
8546: OR (start_date >= p_start_date AND end_date <= p_end_date)
8547: OR (start_date <= p_start_date AND p_start_date <= end_date)

Line 8977: from pa_forecast_items fi1, pa_project_assignments asgn, pa_schedules sch, pa_project_statuses a, pa_project_statuses b

8973: (select fi1.resource_id,
8974: fi1.item_quantity,
8975: fi1.item_date,
8976: fi1.delete_flag
8977: from pa_forecast_items fi1, pa_project_assignments asgn, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
8978: where (fi1.assignment_id = p_assignment_id
8979: or fi1.assignment_id in
8980: (select conflict_assignment_id
8981: from pa_assignment_conflict_hist

Line 9060: from pa_forecast_items fi1, pa_schedules sch, pa_project_statuses a, pa_project_statuses b

9056: sum(item_quantity) total_assigned_quantity,
9057: GLOBAL_EXP_PERIOD_END_DATE week_end_date,
9058: delete_flag,
9059: forecast_item_type
9060: from pa_forecast_items fi1, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
9061: where (fi1.assignment_id = p_assignment_id
9062: or fi1.assignment_id in (select conflict_assignment_id
9063: from pa_assignment_conflict_hist
9064: where conflict_group_id = p_conflict_group_id