APPS.IGS_PR_GEN_003 dependencies on IGS_PR_SDT_PS_PR_MSR

Line 626: IGS_PR_SDT_PS_PR_MSR.s_prg_measure_type%TYPE) IS

622: v_course_wam NUMBER;
623: v_period_wam NUMBER;
624: v_value NUMBER;
625: CURSOR c_scpm (cp_prg_measure_type
626: IGS_PR_SDT_PS_PR_MSR.s_prg_measure_type%TYPE) IS
627: SELECT scpm.value
628: FROM IGS_PR_SDT_PS_PR_MSR scpm
629: WHERE scpm.person_id = p_person_id AND
630: scpm.course_cd = p_course_cd AND

Line 628: FROM IGS_PR_SDT_PS_PR_MSR scpm

624: v_value NUMBER;
625: CURSOR c_scpm (cp_prg_measure_type
626: IGS_PR_SDT_PS_PR_MSR.s_prg_measure_type%TYPE) IS
627: SELECT scpm.value
628: FROM IGS_PR_SDT_PS_PR_MSR scpm
629: WHERE scpm.person_id = p_person_id AND
630: scpm.course_cd = p_course_cd AND
631: scpm.prg_cal_type = p_prg_cal_type AND
632: scpm.prg_ci_sequence_number = p_prg_sequence_number AND

Line 726: IGS_PR_SDT_PS_PR_MSR_PKG .INSERT_ROW (

722: v_course_gpa:=nvl(v_course_gpa,0);
723: DECLARE
724: lv_rowid VARCHAR2(25);
725: BEGIN
726: IGS_PR_SDT_PS_PR_MSR_PKG .INSERT_ROW (
727: X_ROWID => lv_rowid,
728: X_PERSON_ID => p_person_id,
729: X_COURSE_CD => p_course_cd,
730: X_PRG_CAL_TYPE => p_prg_cal_type,

Line 775: IGS_PR_SDT_PS_PR_MSR_PKG.INSERT_ROW (

771: v_period_gpa:=nvl(v_period_gpa,0);
772: DECLARE
773: lv_rowid VARCHAR2(25);
774: BEGIN
775: IGS_PR_SDT_PS_PR_MSR_PKG.INSERT_ROW (
776: X_ROWID => lv_rowid,
777: X_PERSON_ID => p_person_id,
778: X_COURSE_CD => p_course_cd,
779: X_PRG_CAL_TYPE => p_prg_cal_type,

Line 803: /* INSERT INTO IGS_PR_SDT_PS_PR_MSR(

799: FETCH c_scpm INTO v_value;
800: CLOSE c_scpm;
801: IF v_course_wam IS NOT NULL OR v_value IS NOT NULL THEN
802: IF NVL(v_course_wam,-1) <> NVL(v_value,-1) THEN
803: /* INSERT INTO IGS_PR_SDT_PS_PR_MSR(
804: person_id,
805: course_cd,
806: prg_cal_type,
807: prg_ci_sequence_number,

Line 823: IGS_PR_SDT_PS_PR_MSR_PKG .INSERT_ROW (

819: v_course_wam:=nvl(v_course_wam,0);
820: DECLARE
821: lv_rowid VARCHAR2(25);
822: BEGIN
823: IGS_PR_SDT_PS_PR_MSR_PKG .INSERT_ROW (
824: X_ROWID => lv_rowid,
825: X_PERSON_ID => p_person_id,
826: X_COURSE_CD => p_course_cd,
827: X_PRG_CAL_TYPE => p_prg_cal_type,

Line 849: INSERT INTO IGS_PR_SDT_PS_PR_MSR(

845: CLOSE c_scpm;
846: IF v_period_wam IS NOT NULL OR v_value IS NOT NULL THEN
847: IF NVL(v_period_wam,1) <> NVL(v_value,-1) THEN
848: /*
849: INSERT INTO IGS_PR_SDT_PS_PR_MSR(
850: person_id,
851: course_cd,
852: prg_cal_type,
853: prg_ci_sequence_number,

Line 869: IGS_PR_SDT_PS_PR_MSR_PKG .INSERT_ROW (

865: v_period_wam:=nvl(v_period_wam,0);
866: DECLARE
867: lv_rowid VARCHAR2(25);
868: BEGIN
869: IGS_PR_SDT_PS_PR_MSR_PKG .INSERT_ROW (
870: X_ROWID => lv_rowid,
871: X_PERSON_ID => p_person_id,
872: X_COURSE_CD => p_course_cd,
873: X_PRG_CAL_TYPE => p_prg_cal_type,