APPS.IGS_PS_GEN_001 dependencies on IGS_PS_ENT_PT_REF_CD

Line 79: gv_ceprcd_rec IGS_PS_ENT_PT_REF_CD%ROWTYPE;

75: gv_con_rec IGS_PS_OFR_NOTE%ROWTYPE;
76: gv_coon_rec IGS_PS_OFR_OPT_NOTE%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;

Line 214: FROM IGS_PS_ENT_PT_REF_CD

210: AND delete_flag = 'N';
211:
212: CURSOR gc_ceprcd_rec IS
213: SELECT *
214: FROM IGS_PS_ENT_PT_REF_CD
215: WHERE course_cd = p_old_course_cd AND
216: version_number = p_old_version_number AND
217: cal_type = gv_coo_rec.cal_type AND
218: location_cd = gv_coo_rec.location_cd AND

Line 548: -- procedure for inserting new IGS_PS_ENT_PT_REF_CD records

544: ELSE
545: App_Exception.Raise_Exception;
546: END IF;
547: END crsp_ins_con_rec;
548: -- procedure for inserting new IGS_PS_ENT_PT_REF_CD records
549: PROCEDURE crsp_ins_ceprcd_rec (
550: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
551: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
552: BEGIN

Line 554: IGS_PS_ENT_PT_REF_CD_PKG.INSERT_ROW(

550: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
551: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
552: BEGIN
553: x_rowid := NULL;
554: IGS_PS_ENT_PT_REF_CD_PKG.INSERT_ROW(
555: X_ROWID => x_rowid,
556: X_COURSE_CD => p_new_course_cd,
557: X_SEQUENCE_NUMBER => gv_ceprcd_rec.sequence_number,
558: X_REFERENCE_CD_TYPE => gv_ceprcd_rec.reference_cd_type,

Line 777: -- calling procedure to insert IGS_PS_ENT_PT_REF_CD records

773: EXIT;
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;