564: l_sunday_hours(J) ,
565: 1 ,
566: 'N' ,
567: sysdate ,
568: fnd_global.user_id ,
569: sysdate ,
570: fnd_global.user_id ,
571: fnd_global.login_id ,
572: fnd_global.conc_request_id() ,
566: 'N' ,
567: sysdate ,
568: fnd_global.user_id ,
569: sysdate ,
570: fnd_global.user_id ,
571: fnd_global.login_id ,
572: fnd_global.conc_request_id() ,
573: fnd_global.prog_appl_id () ,
574: fnd_global.conc_program_id() ,
567: sysdate ,
568: fnd_global.user_id ,
569: sysdate ,
570: fnd_global.user_id ,
571: fnd_global.login_id ,
572: fnd_global.conc_request_id() ,
573: fnd_global.prog_appl_id () ,
574: fnd_global.conc_program_id() ,
575: trunc(sysdate) );
568: fnd_global.user_id ,
569: sysdate ,
570: fnd_global.user_id ,
571: fnd_global.login_id ,
572: fnd_global.conc_request_id() ,
573: fnd_global.prog_appl_id () ,
574: fnd_global.conc_program_id() ,
575: trunc(sysdate) );
576:
569: sysdate ,
570: fnd_global.user_id ,
571: fnd_global.login_id ,
572: fnd_global.conc_request_id() ,
573: fnd_global.prog_appl_id () ,
574: fnd_global.conc_program_id() ,
575: trunc(sysdate) );
576:
577: PA_SCHEDULE_UTILS.log_message(1,'end of the schedule inser row .... ');
570: fnd_global.user_id ,
571: fnd_global.login_id ,
572: fnd_global.conc_request_id() ,
573: fnd_global.prog_appl_id () ,
574: fnd_global.conc_program_id() ,
575: trunc(sysdate) );
576:
577: PA_SCHEDULE_UTILS.log_message(1,'end of the schedule inser row .... ');
578:
681: p_sunday_hours ,
682: 1 ,
683: 'N' ,
684: sysdate ,
685: fnd_global.user_id ,
686: sysdate ,
687: fnd_global.user_id ,
688: fnd_global.login_id ,
689: fnd_global.conc_request_id() ,
683: 'N' ,
684: sysdate ,
685: fnd_global.user_id ,
686: sysdate ,
687: fnd_global.user_id ,
688: fnd_global.login_id ,
689: fnd_global.conc_request_id() ,
690: fnd_global.prog_appl_id () ,
691: fnd_global.conc_program_id() ,
684: sysdate ,
685: fnd_global.user_id ,
686: sysdate ,
687: fnd_global.user_id ,
688: fnd_global.login_id ,
689: fnd_global.conc_request_id() ,
690: fnd_global.prog_appl_id () ,
691: fnd_global.conc_program_id() ,
692: trunc(sysdate) );
685: fnd_global.user_id ,
686: sysdate ,
687: fnd_global.user_id ,
688: fnd_global.login_id ,
689: fnd_global.conc_request_id() ,
690: fnd_global.prog_appl_id () ,
691: fnd_global.conc_program_id() ,
692: trunc(sysdate) );
693:
686: sysdate ,
687: fnd_global.user_id ,
688: fnd_global.login_id ,
689: fnd_global.conc_request_id() ,
690: fnd_global.prog_appl_id () ,
691: fnd_global.conc_program_id() ,
692: trunc(sysdate) );
693:
694: EXCEPTION
687: fnd_global.user_id ,
688: fnd_global.login_id ,
689: fnd_global.conc_request_id() ,
690: fnd_global.prog_appl_id () ,
691: fnd_global.conc_program_id() ,
692: trunc(sysdate) );
693:
694: EXCEPTION
695: WHEN OTHERS THEN
780: sunday_hours = l_sunday_hours(J),
781: forecast_txn_version_number = forecast_txn_version_number+1,
782: forecast_txn_generated_flag = 'N',
783: last_update_date = sysdate ,
784: last_update_by = fnd_global.user_id,
785: last_update_login = fnd_global.login_id
786: WHERE schedule_id = l_schedule_id(J);
787:
788: PA_SCHEDULE_UTILS.log_message(1,'end of update row .... ');
781: forecast_txn_version_number = forecast_txn_version_number+1,
782: forecast_txn_generated_flag = 'N',
783: last_update_date = sysdate ,
784: last_update_by = fnd_global.user_id,
785: last_update_login = fnd_global.login_id
786: WHERE schedule_id = l_schedule_id(J);
787:
788: PA_SCHEDULE_UTILS.log_message(1,'end of update row .... ');
789: EXCEPTION
857: friday_hours = p_friday_hours,
858: saturday_hours = p_saturday_hours,
859: sunday_hours = p_sunday_hours,
860: last_update_date = sysdate ,
861: last_update_by = fnd_global.user_id,
862: last_update_login = fnd_global.login_id
863: WHERE schedule_id = p_schedule_id;
864:
865:
858: saturday_hours = p_saturday_hours,
859: sunday_hours = p_sunday_hours,
860: last_update_date = sysdate ,
861: last_update_by = fnd_global.user_id,
862: last_update_login = fnd_global.login_id
863: WHERE schedule_id = p_schedule_id;
864:
865:
866: EXCEPTION
932: friday_hours = p_friday_hours,
933: saturday_hours = p_saturday_hours,
934: sunday_hours = p_sunday_hours,
935: last_update_date = sysdate ,
936: last_update_by = fnd_global.user_id,
937: last_update_login = fnd_global.login_id
938: WHERE schedule_id = p_schedule_id;
939:
940:
933: saturday_hours = p_saturday_hours,
934: sunday_hours = p_sunday_hours,
935: last_update_date = sysdate ,
936: last_update_by = fnd_global.user_id,
937: last_update_login = fnd_global.login_id
938: WHERE schedule_id = p_schedule_id;
939:
940:
941: EXCEPTION