APPS.IGS_PS_GEN_001 dependencies on IGS_PS_OFR_INST

Line 81: gv_coi_rec IGS_PS_OFR_INST%ROWTYPE;

77: gv_co_rec IGS_PS_OFR%ROWTYPE;
78: gv_coo_rec IGS_PS_OFR_OPT%ROWTYPE;
79: gv_ceprcd_rec IGS_PS_ENT_PT_REF_CD%ROWTYPE;
80: gv_calulink_rec IGS_PS_ANL_LOAD_U_LN%ROWTYPE;
81: gv_coi_rec IGS_PS_OFR_INST%ROWTYPE;
82: gv_cop_rec IGS_PS_OFR_PAT%ROWTYPE;
83: gv_copn_rec IGS_PS_OFR_PAT_NOTE%ROWTYPE;
84: gv_ref_num IGS_GE_NOTE.reference_number%TYPE;
85: gv_coo_seq_num IGS_PS_OFR_OPT.coo_id%TYPE;

Line 248: -- Find the latest IGS_CA_INST of IGS_PS_OFR_INST

244: EXISTS (SELECT 1
245: FROM IGS_GE_NOTE nte
246: WHERE nte.reference_number = coon.reference_number AND
247: nte.note_text IS NOT NULL);
248: -- Find the latest IGS_CA_INST of IGS_PS_OFR_INST
249: -- which returns the list in descending order, and the first record
250: -- (ie. the latest instance) will be selected
251: CURSOR gc_coi_rec IS
252: SELECT *

Line 253: FROM IGS_PS_OFR_INST coi

249: -- which returns the list in descending order, and the first record
250: -- (ie. the latest instance) will be selected
251: CURSOR gc_coi_rec IS
252: SELECT *
253: FROM IGS_PS_OFR_INST coi
254: WHERE coi.course_cd = p_old_course_cd AND
255: coi.version_number = p_old_version_number AND
256: coi.cal_type = gv_co_rec.cal_type
257: ORDER BY coi.ci_end_dt DESC, coi.ci_start_dt DESC;

Line 778: -- associated with each IGS_PS_OFR instance record

774: END IF;
775: END LOOP;
776: CLOSE gc_coon_rec;
777: -- calling procedure to insert IGS_PS_ENT_PT_REF_CD records
778: -- associated with each IGS_PS_OFR instance record
779: OPEN gc_ceprcd_rec;
780: LOOP
781: FETCH gc_ceprcd_rec INTO gv_ceprcd_rec;
782: IF gc_ceprcd_rec%FOUND THEN

Line 832: -- procedure for inserting new IGS_PS_OFR_INST records

828: ELSE
829: App_Exception.Raise_Exception;
830: END IF;
831: END crsp_ins_coo_rec;
832: -- procedure for inserting new IGS_PS_OFR_INST records
833: PROCEDURE crsp_ins_coi_rec (
834: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
835: p_new_version_number IGS_PS_VER.version_number%TYPE)
836: IS

Line 856: IGS_PS_OFR_INST_PKG.INSERT_ROW(

852: coo.delete_flag = 'N';
853: v_dummy VARCHAR2(1);
854: BEGIN
855: x_rowid := NULL;
856: IGS_PS_OFR_INST_PKG.INSERT_ROW(
857: X_ROWID => x_rowid,
858: X_COURSE_CD => p_new_course_cd,
859: X_VERSION_NUMBER => p_new_version_number,
860: X_CAL_TYPE => gv_coi_rec.cal_type,

Line 868: -- associated with each IGS_PS_OFR instance record

864: X_MIN_ENTRY_ASS_SCORE => gv_coi_rec.min_entry_ass_score,
865: X_GUARANTEED_ENTRY_ASS_SCR => gv_coi_rec.guaranteed_entry_ass_scr,
866: X_MODE => 'R' );
867: -- calling procedure to insert IGS_PS_OFR_PAT records
868: -- associated with each IGS_PS_OFR instance record
869: OPEN gc_cop_rec;
870: LOOP
871: FETCH gc_cop_rec INTO gv_cop_rec;
872: IF gc_cop_rec%FOUND THEN

Line 1254: -- calling procedure to insert IGS_PS_OFR_INST records

1250: EXIT;
1251: END IF;
1252: END LOOP;
1253: CLOSE gc_coo_rec;
1254: -- calling procedure to insert IGS_PS_OFR_INST records
1255: -- associated with each IGS_PS_OFR record
1256: OPEN gc_coi_rec;
1257: FETCH gc_coi_rec INTO gv_coi_rec;
1258: IF gc_coi_rec%FOUND THEN