734: l_endOpIdx NUMBER;
735:
736: --standard who columns
737: l_sysDate DATE := sysdate;
738: l_userID NUMBER := fnd_global.user_id;
739: l_loginID NUMBER := fnd_global.login_id;
740: l_reqID NUMBER := fnd_global.conc_request_id;
741: l_progApplID NUMBER := fnd_global.prog_appl_id;
742: l_progID NUMBER := fnd_global.conc_program_id;
735:
736: --standard who columns
737: l_sysDate DATE := sysdate;
738: l_userID NUMBER := fnd_global.user_id;
739: l_loginID NUMBER := fnd_global.login_id;
740: l_reqID NUMBER := fnd_global.conc_request_id;
741: l_progApplID NUMBER := fnd_global.prog_appl_id;
742: l_progID NUMBER := fnd_global.conc_program_id;
743: l_minResStartDate DATE;
736: --standard who columns
737: l_sysDate DATE := sysdate;
738: l_userID NUMBER := fnd_global.user_id;
739: l_loginID NUMBER := fnd_global.login_id;
740: l_reqID NUMBER := fnd_global.conc_request_id;
741: l_progApplID NUMBER := fnd_global.prog_appl_id;
742: l_progID NUMBER := fnd_global.conc_program_id;
743: l_minResStartDate DATE;
744: l_maxResEndDate DATE;
737: l_sysDate DATE := sysdate;
738: l_userID NUMBER := fnd_global.user_id;
739: l_loginID NUMBER := fnd_global.login_id;
740: l_reqID NUMBER := fnd_global.conc_request_id;
741: l_progApplID NUMBER := fnd_global.prog_appl_id;
742: l_progID NUMBER := fnd_global.conc_program_id;
743: l_minResStartDate DATE;
744: l_maxResEndDate DATE;
745: l_jobStartDate DATE;
738: l_userID NUMBER := fnd_global.user_id;
739: l_loginID NUMBER := fnd_global.login_id;
740: l_reqID NUMBER := fnd_global.conc_request_id;
741: l_progApplID NUMBER := fnd_global.prog_appl_id;
742: l_progID NUMBER := fnd_global.conc_program_id;
743: l_minResStartDate DATE;
744: l_maxResEndDate DATE;
745: l_jobStartDate DATE;
746: l_jobCplDate DATE;