APPS.IGS_PS_OFR_OPT_PKG dependencies on IGS_PS_ENT_PT_REF_CD_PKG

Line 445: IGS_PS_ENT_PT_REF_CD_PKG.GET_FK_IGS_PS_OFR_OPT (

441: */
442:
443: BEGIN
444:
445: IGS_PS_ENT_PT_REF_CD_PKG.GET_FK_IGS_PS_OFR_OPT (
446: old_references.course_cd,
447: old_references.version_number,
448: old_references.cal_type,
449: old_references.location_cd,

Line 454: IGS_PS_ENT_PT_REF_CD_PKG.GET_UFK_IGS_PS_OFR_OPT (

450: old_references.attendance_mode,
451: old_references.attendance_type
452: );
453:
454: IGS_PS_ENT_PT_REF_CD_PKG.GET_UFK_IGS_PS_OFR_OPT (
455: old_references.coo_id
456: );
457:
458: IGS_PS_OFR_OPT_NOTE_PKG.GET_FK_IGS_PS_OFR_OPT (

Line 570: IGS_PS_ENT_PT_REF_CD_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);

566:
567: IF (old_references.coo_id = new_references.coo_id) OR (old_references.coo_id IS NULL) THEN
568: NULL;
569: ELSE
570: IGS_PS_ENT_PT_REF_CD_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);
571: IGS_PS_OFR_OPT_NOTE_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);
572: IGS_PS_OFR_PAT_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);
573: IGS_PS_OF_OPT_UNT_ST_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);
574: IGS_EN_STDNT_PS_ATT_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);

Line 992: igs_ps_ent_pt_ref_cd_pkg.insert_row( x_rowid => l_c_rowid,

988: -- insert a value in igs_ps_ent_pt_ref_cd for every value of course_cd and version_number having
989: -- a applicable program offering option defined as mandatory and a default reference code
990: BEGIN
991: l_c_rowid:=NULL;
992: igs_ps_ent_pt_ref_cd_pkg.insert_row( x_rowid => l_c_rowid,
993: x_course_cd => l_ofr_opt.course_cd,
994: x_sequence_number => l_n_sequence_number,
995: x_reference_cd_type => cur_igs_ge_ref_cd_type_all.reference_cd_type,
996: x_attendance_type => l_ofr_opt.attendance_type,