753: l_endOpIdx NUMBER;
754:
755: --standard who columns
756: l_sysDate DATE := sysdate;
757: l_userID NUMBER := fnd_global.user_id;
758: l_loginID NUMBER := fnd_global.login_id;
759: l_reqID NUMBER := fnd_global.conc_request_id;
760: l_progApplID NUMBER := fnd_global.prog_appl_id;
761: l_progID NUMBER := fnd_global.conc_program_id;
754:
755: --standard who columns
756: l_sysDate DATE := sysdate;
757: l_userID NUMBER := fnd_global.user_id;
758: l_loginID NUMBER := fnd_global.login_id;
759: l_reqID NUMBER := fnd_global.conc_request_id;
760: l_progApplID NUMBER := fnd_global.prog_appl_id;
761: l_progID NUMBER := fnd_global.conc_program_id;
762: l_minResStartDate DATE;
755: --standard who columns
756: l_sysDate DATE := sysdate;
757: l_userID NUMBER := fnd_global.user_id;
758: l_loginID NUMBER := fnd_global.login_id;
759: l_reqID NUMBER := fnd_global.conc_request_id;
760: l_progApplID NUMBER := fnd_global.prog_appl_id;
761: l_progID NUMBER := fnd_global.conc_program_id;
762: l_minResStartDate DATE;
763: l_maxResEndDate DATE;
756: l_sysDate DATE := sysdate;
757: l_userID NUMBER := fnd_global.user_id;
758: l_loginID NUMBER := fnd_global.login_id;
759: l_reqID NUMBER := fnd_global.conc_request_id;
760: l_progApplID NUMBER := fnd_global.prog_appl_id;
761: l_progID NUMBER := fnd_global.conc_program_id;
762: l_minResStartDate DATE;
763: l_maxResEndDate DATE;
764: l_jobStartDate DATE;
757: l_userID NUMBER := fnd_global.user_id;
758: l_loginID NUMBER := fnd_global.login_id;
759: l_reqID NUMBER := fnd_global.conc_request_id;
760: l_progApplID NUMBER := fnd_global.prog_appl_id;
761: l_progID NUMBER := fnd_global.conc_program_id;
762: l_minResStartDate DATE;
763: l_maxResEndDate DATE;
764: l_jobStartDate DATE;
765: l_jobCplDate DATE;