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.IGS_PS_GEN_003 dependencies on IGS_PS_OFR_INST

Line 534: v_coi_rec IGS_PS_OFR_INST%ROWTYPE;

530: p_dest_cal_type igs_ca_inst.cal_type%type;
531: p_dest_sequence_number igs_ca_inst.sequence_number%type;
532: p_org_unit_cd igs_or_unit.org_unit_cd%type;
533: v_check CHAR;
534: v_coi_rec IGS_PS_OFR_INST%ROWTYPE;
535: v_message VARCHAR2(30);
536: gv_ci_start_dt IGS_PS_OFR_INST.ci_start_dt%TYPE;
537: gv_ci_end_dt IGS_PS_OFR_INST.ci_end_dt%TYPE;
538: v_rec_inserted_cnt NUMBER(4) := 0;

Line 536: gv_ci_start_dt IGS_PS_OFR_INST.ci_start_dt%TYPE;

532: p_org_unit_cd igs_or_unit.org_unit_cd%type;
533: v_check CHAR;
534: v_coi_rec IGS_PS_OFR_INST%ROWTYPE;
535: v_message VARCHAR2(30);
536: gv_ci_start_dt IGS_PS_OFR_INST.ci_start_dt%TYPE;
537: gv_ci_end_dt IGS_PS_OFR_INST.ci_end_dt%TYPE;
538: v_rec_inserted_cnt NUMBER(4) := 0;
539: cst_none_cop_rec_inserted BOOLEAN := TRUE;
540: cst_partial_cop_rec_inserted BOOLEAN := TRUE;

Line 537: gv_ci_end_dt IGS_PS_OFR_INST.ci_end_dt%TYPE;

533: v_check CHAR;
534: v_coi_rec IGS_PS_OFR_INST%ROWTYPE;
535: v_message VARCHAR2(30);
536: gv_ci_start_dt IGS_PS_OFR_INST.ci_start_dt%TYPE;
537: gv_ci_end_dt IGS_PS_OFR_INST.ci_end_dt%TYPE;
538: v_rec_inserted_cnt NUMBER(4) := 0;
539: cst_none_cop_rec_inserted BOOLEAN := TRUE;
540: cst_partial_cop_rec_inserted BOOLEAN := TRUE;
541: cst_all_cop_rec_inserted BOOLEAN := TRUE;

Line 551: cp_cal_type IGS_PS_OFR_INST.cal_type%TYPE,

547: SELECT 'x'
548: FROM IGS_CA_TYPE
549: WHERE cal_type = p_source_cal_type;
550: CURSOR c_check_cal_instance_exist(
551: cp_cal_type IGS_PS_OFR_INST.cal_type%TYPE,
552: cp_sequence_number IGS_PS_OFR_INST.version_number%TYPE) IS
553: SELECT 'x'
554: FROM IGS_CA_INST
555: WHERE cal_type = cp_cal_type AND

Line 552: cp_sequence_number IGS_PS_OFR_INST.version_number%TYPE) IS

548: FROM IGS_CA_TYPE
549: WHERE cal_type = p_source_cal_type;
550: CURSOR c_check_cal_instance_exist(
551: cp_cal_type IGS_PS_OFR_INST.cal_type%TYPE,
552: cp_sequence_number IGS_PS_OFR_INST.version_number%TYPE) IS
553: SELECT 'x'
554: FROM IGS_CA_INST
555: WHERE cal_type = cp_cal_type AND
556: sequence_number = cp_sequence_number;

Line 558: cp_cal_type IGS_PS_OFR_INST.cal_type%TYPE,

554: FROM IGS_CA_INST
555: WHERE cal_type = cp_cal_type AND
556: sequence_number = cp_sequence_number;
557: CURSOR c_get_cal_instance_dates(
558: cp_cal_type IGS_PS_OFR_INST.cal_type%TYPE,
559: cp_sequence_number IGS_PS_OFR_INST.version_number%TYPE) IS
560: SELECT start_dt, end_dt
561: FROM IGS_CA_INST
562: WHERE cal_type = cp_cal_type AND

Line 559: cp_sequence_number IGS_PS_OFR_INST.version_number%TYPE) IS

555: WHERE cal_type = cp_cal_type AND
556: sequence_number = cp_sequence_number;
557: CURSOR c_get_cal_instance_dates(
558: cp_cal_type IGS_PS_OFR_INST.cal_type%TYPE,
559: cp_sequence_number IGS_PS_OFR_INST.version_number%TYPE) IS
560: SELECT start_dt, end_dt
561: FROM IGS_CA_INST
562: WHERE cal_type = cp_cal_type AND
563: sequence_number = cp_sequence_number;

Line 582: FROM IGS_PS_OFR_INST coi,

578: coi.request_id,
579: coi.PROGRAM_APPLICATION_ID,
580: coi.PROGRAM_ID,
581: coi.PROGRAM_UPDATE_DATE
582: FROM IGS_PS_OFR_INST coi,
583: IGS_PS_VER cv
584: WHERE coi.cal_type=p_source_cal_type AND
585: coi.ci_sequence_number= p_source_sequence_number AND
586: cv.course_cd = coi.course_cd AND

Line 591: cp_course_cd IGS_PS_OFR_INST.course_cd%TYPE,

587: cv.version_number= coi.version_number AND
588: cv.expiry_dt IS NULL AND
589: cv.responsible_org_unit_cd LIKE p_org_unit_cd;
590: CURSOR c_check_coi_exist (
591: cp_course_cd IGS_PS_OFR_INST.course_cd%TYPE,
592: cp_version_number IGS_PS_OFR_INST.version_number%TYPE) IS
593: SELECT 'x'
594: FROM IGS_PS_OFR_INST
595: WHERE course_cd = cp_course_cd AND

Line 592: cp_version_number IGS_PS_OFR_INST.version_number%TYPE) IS

588: cv.expiry_dt IS NULL AND
589: cv.responsible_org_unit_cd LIKE p_org_unit_cd;
590: CURSOR c_check_coi_exist (
591: cp_course_cd IGS_PS_OFR_INST.course_cd%TYPE,
592: cp_version_number IGS_PS_OFR_INST.version_number%TYPE) IS
593: SELECT 'x'
594: FROM IGS_PS_OFR_INST
595: WHERE course_cd = cp_course_cd AND
596: version_number = cp_version_number AND

Line 594: FROM IGS_PS_OFR_INST

590: CURSOR c_check_coi_exist (
591: cp_course_cd IGS_PS_OFR_INST.course_cd%TYPE,
592: cp_version_number IGS_PS_OFR_INST.version_number%TYPE) IS
593: SELECT 'x'
594: FROM IGS_PS_OFR_INST
595: WHERE course_cd = cp_course_cd AND
596: version_number = cp_version_number AND
597: cal_type = p_dest_cal_type AND
598: ci_sequence_number = p_dest_sequence_number;

Line 728: IGS_PS_OFR_INST_PKG.Insert_Row(

724: v_coi_rec.course_cd,
725: v_coi_rec.version_number);
726: FETCH c_check_coi_exist INTO v_check;
727: IF (c_check_coi_exist%NOTFOUND) THEN
728: IGS_PS_OFR_INST_PKG.Insert_Row(
729: X_ROWID => x_rowid,
730: X_COURSE_CD => v_coi_rec.course_cd,
731: X_VERSION_NUMBER => v_coi_rec.version_number,
732: X_CAL_TYPE => p_dest_cal_type,

Line 750: -- within IGS_PS_OFR_INST.

746: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );
747: END IF;
748: CLOSE c_check_coi_exist;
749: -- Rollover all course_offering_patterns
750: -- within IGS_PS_OFR_INST.
751: IF (IGS_PS_GEN_003.crsp_ins_coi_cop(
752: v_coi_rec.course_cd,
753: v_coi_rec.version_number,
754: p_source_cal_type,