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_CALENDAR_UTILS dependencies on PA_SCHEDULE_UTILS

Line 326: PA_SCHEDULE_UTILS.copy_schedule_rec_tab(p_sch_record_tab,p_sch_record_tab.first,p_sch_record_tab.last,

322: -- Storing the status for error handling
323: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
324: x_return_status := FND_API.G_RET_STS_SUCCESS; -- 4537865
325: -- Storing the record for using this table of record in forther calculation
326: PA_SCHEDULE_UTILS.copy_schedule_rec_tab(p_sch_record_tab,p_sch_record_tab.first,p_sch_record_tab.last,
327: x_sch_record_tab,l_x_return_status,x_msg_count,x_msg_data);
328:
329: -- deleting sothat no previos appended record exist
330: l_out_sch_record_tab.delete;

Line 348: PA_SCHEDULE_UTILS.log_message(1,'EXCPT : '||to_char(p_cal_except_record_tab(l_I).except_start_date+i,'dd/mm/yyyy'));

344: for i in 0..excep_days_count -- Loop Added for bug 4870111
345: Loop
346: l_J := x_sch_record_tab.first;
347: l_shift_change := FALSE;
348: PA_SCHEDULE_UTILS.log_message(1,'EXCPT : '||to_char(p_cal_except_record_tab(l_I).except_start_date+i,'dd/mm/yyyy'));
349: LOOP
350: PA_SCHEDULE_UTILS.log_message(1,'SCH : '||to_char(x_sch_record_tab(l_J).start_date,'dd/mm/yyyy')||' '
351: ||to_char(x_sch_record_tab(l_J).end_date,'dd/mm/yyyy'));
352:

Line 350: PA_SCHEDULE_UTILS.log_message(1,'SCH : '||to_char(x_sch_record_tab(l_J).start_date,'dd/mm/yyyy')||' '

346: l_J := x_sch_record_tab.first;
347: l_shift_change := FALSE;
348: PA_SCHEDULE_UTILS.log_message(1,'EXCPT : '||to_char(p_cal_except_record_tab(l_I).except_start_date+i,'dd/mm/yyyy'));
349: LOOP
350: PA_SCHEDULE_UTILS.log_message(1,'SCH : '||to_char(x_sch_record_tab(l_J).start_date,'dd/mm/yyyy')||' '
351: ||to_char(x_sch_record_tab(l_J).end_date,'dd/mm/yyyy'));
352:
353: /* Exception date is falling either before the start date of schedule or after end date of schedule */
354: IF (( p_cal_except_record_tab(l_I).except_start_date+i < x_sch_record_tab(l_J).start_date) OR

Line 357: -- PA_SCHEDULE_UTILS.log_message(1,'inside exp_dt < sch_st_dt or exp_dt > sch_end_dt ');

353: /* Exception date is falling either before the start date of schedule or after end date of schedule */
354: IF (( p_cal_except_record_tab(l_I).except_start_date+i < x_sch_record_tab(l_J).start_date) OR
355: (p_cal_except_record_tab(l_I).except_start_date+i > x_sch_record_tab(l_J).end_date) ) THEN
356:
357: -- PA_SCHEDULE_UTILS.log_message(1,'inside exp_dt < sch_st_dt or exp_dt > sch_end_dt ');
358: -- storing this record in temp variable to copy in final variable
359: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
360: PA_SCHEDULE_UTILS.add_schedule_rec_tab(x_sch_record_tab,l_j,l_j,l_out_sch_record_tab,l_x_return_status,
361: x_msg_count,x_msg_data);

Line 360: PA_SCHEDULE_UTILS.add_schedule_rec_tab(x_sch_record_tab,l_j,l_j,l_out_sch_record_tab,l_x_return_status,

356:
357: -- PA_SCHEDULE_UTILS.log_message(1,'inside exp_dt < sch_st_dt or exp_dt > sch_end_dt ');
358: -- storing this record in temp variable to copy in final variable
359: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
360: PA_SCHEDULE_UTILS.add_schedule_rec_tab(x_sch_record_tab,l_j,l_j,l_out_sch_record_tab,l_x_return_status,
361: x_msg_count,x_msg_data);
362: END IF;
363:
364: /* Exception date is falling between the start date of schedule and end date of schedule */

Line 368: PA_SCHEDULE_UTILS.log_message(1,'inside exp_dt >= sch_st_dt AND exp_dt <= sch_end_dt ');

364: /* Exception date is falling between the start date of schedule and end date of schedule */
365: ELSIF ((p_cal_except_record_tab(l_I).except_start_date+i >= x_sch_record_tab(l_J).start_date) AND
366: (p_cal_except_record_tab(l_I).except_start_date+i <= x_sch_record_tab(l_J).end_date)) THEN
367:
368: PA_SCHEDULE_UTILS.log_message(1,'inside exp_dt >= sch_st_dt AND exp_dt <= sch_end_dt ');
369:
370: l_shift_change := TRUE;
371: -- storing the value in temp variable and using in updation of schedule record which are without exception
372: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 373: PA_SCHEDULE_UTILS.copy_schedule_rec_tab(x_sch_record_tab,l_J,l_J,l_temp_sch_record_tab,

369:
370: l_shift_change := TRUE;
371: -- storing the value in temp variable and using in updation of schedule record which are without exception
372: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
373: PA_SCHEDULE_UTILS.copy_schedule_rec_tab(x_sch_record_tab,l_J,l_J,l_temp_sch_record_tab,
374: l_x_return_status,x_msg_count,x_msg_data );
375: END IF;
376:
377: -- storing the value in temp variable and using in updation of schedule record which are with exception

Line 379: PA_SCHEDULE_UTILS.copy_schedule_rec_tab(x_sch_record_tab,l_J,l_J,l_temp_exp_sch_record_tab,

375: END IF;
376:
377: -- storing the value in temp variable and using in updation of schedule record which are with exception
378: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
379: PA_SCHEDULE_UTILS.copy_schedule_rec_tab(x_sch_record_tab,l_J,l_J,l_temp_exp_sch_record_tab,
380: l_x_return_status,x_msg_count,x_msg_data );
381: END IF;
382:
383: l_temp_first := l_temp_sch_record_tab.first;

Line 392: PA_SCHEDULE_UTILS.update_sch_rec_tab(px_sch_record_tab =>l_temp_exp_sch_record_tab,

388: x_sch_record_tab(l_J).end_date = p_cal_except_record_tab(l_I).except_start_date+i )) THEN
389:
390: -- updating that schedule record with zero hours and keeping start date and end date is same
391: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
392: PA_SCHEDULE_UTILS.update_sch_rec_tab(px_sch_record_tab =>l_temp_exp_sch_record_tab,
393: p_start_date => p_cal_except_record_tab(l_I).except_start_date+i
394: ,p_end_date =>p_cal_except_record_tab(l_I).except_start_date+i,p_monday_hours =>0,p_tuesday_hours =>0,
395: p_wednesday_hours =>0,p_thursday_hours =>0,p_friday_hours =>0,p_saturday_hours =>0,p_sunday_hours =>0,
396: x_return_status =>l_x_return_status,x_msg_count =>x_msg_count,x_msg_data =>x_msg_data);

Line 400: PA_SCHEDULE_UTILS.add_schedule_rec_tab(l_temp_exp_sch_record_tab,l_temp_first,l_temp_last,

396: x_return_status =>l_x_return_status,x_msg_count =>x_msg_count,x_msg_data =>x_msg_data);
397: END IF;
398: -- adding in other temp variable just to copy in final variable
399: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
400: PA_SCHEDULE_UTILS.add_schedule_rec_tab(l_temp_exp_sch_record_tab,l_temp_first,l_temp_last,
401: l_out_sch_record_tab,l_x_return_status, x_msg_count,x_msg_data);
402: END IF;
403:
404: /* Exception date is on the start date and breaking that record in two records one with the zero

Line 409: PA_SCHEDULE_UTILS.update_sch_rec_tab(px_sch_record_tab =>l_temp_exp_sch_record_tab,

405: schedule and other with the defined schedule */
406: ELSIF ( x_sch_record_tab(l_J).start_date = p_cal_except_record_tab(l_I).except_start_date+i ) THEN
407:
408: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
409: PA_SCHEDULE_UTILS.update_sch_rec_tab(px_sch_record_tab =>l_temp_exp_sch_record_tab,
410: p_start_date => p_cal_except_record_tab(l_I).except_start_date+i
411: ,p_end_date =>p_cal_except_record_tab(l_I).except_start_date+i,p_monday_hours =>0,p_tuesday_hours =>0,
412: p_wednesday_hours =>0,p_thursday_hours =>0,p_friday_hours =>0,p_saturday_hours =>0,
413: p_sunday_hours =>0,x_return_status =>l_x_return_status,x_msg_count =>x_msg_count,

Line 418: PA_SCHEDULE_UTILS.add_schedule_rec_tab(l_temp_exp_sch_record_tab,l_temp_first,l_temp_last,

414: x_msg_data =>x_msg_data);
415: END IF;
416:
417: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
418: PA_SCHEDULE_UTILS.add_schedule_rec_tab(l_temp_exp_sch_record_tab,l_temp_first,l_temp_last,
419: l_out_sch_record_tab,l_x_return_status, x_msg_count,x_msg_data);
420: END IF;
421:
422: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 423: PA_SCHEDULE_UTILS.update_sch_rec_tab(px_sch_record_tab =>l_temp_sch_record_tab,

419: l_out_sch_record_tab,l_x_return_status, x_msg_count,x_msg_data);
420: END IF;
421:
422: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
423: PA_SCHEDULE_UTILS.update_sch_rec_tab(px_sch_record_tab =>l_temp_sch_record_tab,
424: p_start_date =>p_cal_except_record_tab(l_I).except_start_date+i + 1 ,
425: p_end_date =>x_sch_record_tab(l_J).end_date,x_return_status =>l_x_return_status,
426: x_msg_count =>x_msg_count,x_msg_data =>x_msg_data);
427: END IF;

Line 430: PA_SCHEDULE_UTILS.add_schedule_rec_tab(l_temp_sch_record_tab,l_temp_first,l_temp_last,

426: x_msg_count =>x_msg_count,x_msg_data =>x_msg_data);
427: END IF;
428:
429: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
430: PA_SCHEDULE_UTILS.add_schedule_rec_tab(l_temp_sch_record_tab,l_temp_first,l_temp_last,
431: l_out_sch_record_tab,l_x_return_status, x_msg_count,x_msg_data);
432: END IF;
433:
434: /* Exception date is under the end date and breaking into three records one with strating date as

Line 441: PA_SCHEDULE_UTILS.update_sch_rec_tab(px_sch_record_tab =>l_temp_sch_record_tab,

437: the exception date and end date is passed end date */
438: ELSIF (p_cal_except_record_tab(l_I).except_start_date+i < x_sch_record_tab(l_J).end_date ) THEN
439:
440: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
441: PA_SCHEDULE_UTILS.update_sch_rec_tab(px_sch_record_tab =>l_temp_sch_record_tab,
442: p_start_date =>x_sch_record_tab(l_J).start_date ,
443: p_end_date =>p_cal_except_record_tab(l_I).except_start_date+i - 1,
444: x_return_status =>l_x_return_status,x_msg_count =>x_msg_count,x_msg_data =>x_msg_data);
445: END IF;

Line 448: PA_SCHEDULE_UTILS.add_schedule_rec_tab(l_temp_sch_record_tab,l_temp_first,l_temp_last,

444: x_return_status =>l_x_return_status,x_msg_count =>x_msg_count,x_msg_data =>x_msg_data);
445: END IF;
446:
447: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
448: PA_SCHEDULE_UTILS.add_schedule_rec_tab(l_temp_sch_record_tab,l_temp_first,l_temp_last,
449: l_out_sch_record_tab,l_x_return_status,
450: x_msg_count,x_msg_data);
451: END IF;
452:

Line 454: PA_SCHEDULE_UTILS.update_sch_rec_tab(px_sch_record_tab =>l_temp_exp_sch_record_tab,

450: x_msg_count,x_msg_data);
451: END IF;
452:
453: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
454: PA_SCHEDULE_UTILS.update_sch_rec_tab(px_sch_record_tab =>l_temp_exp_sch_record_tab,
455: p_start_date => p_cal_except_record_tab(l_I). except_start_date+i
456: ,p_end_date =>p_cal_except_record_tab(l_I).except_start_date+i,p_monday_hours =>0,p_tuesday_hours =>0,
457: p_wednesday_hours =>0,p_thursday_hours =>0,p_friday_hours =>0,p_saturday_hours =>0,
458: p_sunday_hours =>0,x_return_status =>l_x_return_status,x_msg_count =>x_msg_count,

Line 463: PA_SCHEDULE_UTILS.add_schedule_rec_tab(l_temp_exp_sch_record_tab,l_temp_first,l_temp_last,

459: x_msg_data =>x_msg_data);
460: END IF;
461:
462: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
463: PA_SCHEDULE_UTILS.add_schedule_rec_tab(l_temp_exp_sch_record_tab,l_temp_first,l_temp_last,
464: l_out_sch_record_tab,l_x_return_status, x_msg_count,x_msg_data);
465: END IF;
466:
467: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 468: PA_SCHEDULE_UTILS.update_sch_rec_tab(px_sch_record_tab =>l_temp_sch_record_tab,

464: l_out_sch_record_tab,l_x_return_status, x_msg_count,x_msg_data);
465: END IF;
466:
467: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
468: PA_SCHEDULE_UTILS.update_sch_rec_tab(px_sch_record_tab =>l_temp_sch_record_tab,
469: p_start_date =>p_cal_except_record_tab(l_I).except_start_date+i + 1 ,
470: p_end_date =>x_sch_record_tab(l_J).end_date,
471: x_return_status =>l_x_return_status,x_msg_count =>x_msg_count,x_msg_data =>x_msg_data);
472: END IF;

Line 475: PA_SCHEDULE_UTILS.add_schedule_rec_tab(l_temp_sch_record_tab,l_temp_first,l_temp_last,

471: x_return_status =>l_x_return_status,x_msg_count =>x_msg_count,x_msg_data =>x_msg_data);
472: END IF;
473:
474: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
475: PA_SCHEDULE_UTILS.add_schedule_rec_tab(l_temp_sch_record_tab,l_temp_first,l_temp_last,
476: l_out_sch_record_tab,l_x_return_status,x_msg_count,x_msg_data);
477: END IF;
478:
479: /* Exception date is on the end date and breaking into two records one with start date is as

Line 485: PA_SCHEDULE_UTILS.update_sch_rec_tab(px_sch_record_tab =>l_temp_sch_record_tab,

481: the exception date and end date is also the exception date i.e. end date of the previous schedule*/
482: ELSIF (p_cal_except_record_tab(l_I).except_start_date+i = x_sch_record_tab(l_J).end_date) THEN
483:
484: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
485: PA_SCHEDULE_UTILS.update_sch_rec_tab(px_sch_record_tab =>l_temp_sch_record_tab,
486: p_start_date =>x_sch_record_tab(l_J).start_date ,
487: p_end_date =>p_cal_except_record_tab(l_I).except_start_date+i - 1,
488: x_return_status =>l_x_return_status,x_msg_count =>x_msg_count,x_msg_data =>x_msg_data);
489: END IF;

Line 492: PA_SCHEDULE_UTILS.add_schedule_rec_tab(l_temp_sch_record_tab,l_temp_first,l_temp_last,

488: x_return_status =>l_x_return_status,x_msg_count =>x_msg_count,x_msg_data =>x_msg_data);
489: END IF;
490:
491: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
492: PA_SCHEDULE_UTILS.add_schedule_rec_tab(l_temp_sch_record_tab,l_temp_first,l_temp_last,
493: l_out_sch_record_tab,l_x_return_status,x_msg_count,x_msg_data);
494: END IF;
495:
496: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 497: PA_SCHEDULE_UTILS.update_sch_rec_tab(px_sch_record_tab =>l_temp_exp_sch_record_tab,

493: l_out_sch_record_tab,l_x_return_status,x_msg_count,x_msg_data);
494: END IF;
495:
496: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
497: PA_SCHEDULE_UTILS.update_sch_rec_tab(px_sch_record_tab =>l_temp_exp_sch_record_tab,
498: p_start_date => p_cal_except_record_tab(l_I). except_start_date+i
499: ,p_end_date =>p_cal_except_record_tab(l_I).except_start_date+i,p_monday_hours =>0,p_tuesday_hours =>0,
500: p_wednesday_hours =>0,p_thursday_hours =>0,p_friday_hours =>0,p_saturday_hours =>0,
501: p_sunday_hours =>0,x_return_status =>l_x_return_status,x_msg_count =>x_msg_count,

Line 506: PA_SCHEDULE_UTILS.add_schedule_rec_tab(l_temp_exp_sch_record_tab,l_temp_first,l_temp_last,

502: x_msg_data =>x_msg_data);
503: END IF;
504:
505: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
506: PA_SCHEDULE_UTILS.add_schedule_rec_tab(l_temp_exp_sch_record_tab,l_temp_first,l_temp_last,
507: l_out_sch_record_tab,l_x_return_status,x_msg_count,x_msg_data);
508: END IF;
509:
510: END IF;

Line 517: PA_SCHEDULE_UTILS.add_schedule_rec_tab(x_sch_record_tab,l_temp_next,l_temp_last,

513: l_temp_next := x_sch_record_tab.next(l_J);
514: l_temp_last := x_sch_record_tab.last;
515:
516: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
517: PA_SCHEDULE_UTILS.add_schedule_rec_tab(x_sch_record_tab,l_temp_next,l_temp_last,
518: l_out_sch_record_tab,l_x_return_status,x_msg_count,x_msg_data );
519: END IF;
520: END IF;
521: EXIT;

Line 535: PA_SCHEDULE_UTILS.copy_schedule_rec_tab(l_out_sch_record_tab,l_out_sch_record_tab.first,

531:
532: IF (l_shift_change) THEN
533: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
534: -- finaly copying the records from temp variable to the actual variable
535: PA_SCHEDULE_UTILS.copy_schedule_rec_tab(l_out_sch_record_tab,l_out_sch_record_tab.first,
536: l_out_sch_record_tab.last,x_sch_record_tab,l_x_return_status,x_msg_count,x_msg_data);
537: END IF;
538:
539: END IF;