APPS.IGS_PS_GEN_005 dependencies on IGS_PS_ANL_LOAD

Line 83: v_unit_cd IGS_PS_ANL_LOAD_U_LN.unit_cd%TYPE;

79: -- IGS_PS_COURSE annual load to the IGS_PS_COURSE annual load passed to this
80: -- module.
81: DECLARE
82: v_effective_start_dt DATE;
83: v_unit_cd IGS_PS_ANL_LOAD_U_LN.unit_cd%TYPE;
84: v_uv_version_number IGS_PS_ANL_LOAD_U_LN.uv_version_number%TYPE;
85: v_s_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;
86: v_rec_inserted_cnt NUMBER(5) DEFAULT 0;
87: CURSOR c_max_eff_start_dt IS

Line 84: v_uv_version_number IGS_PS_ANL_LOAD_U_LN.uv_version_number%TYPE;

80: -- module.
81: DECLARE
82: v_effective_start_dt DATE;
83: v_unit_cd IGS_PS_ANL_LOAD_U_LN.unit_cd%TYPE;
84: v_uv_version_number IGS_PS_ANL_LOAD_U_LN.uv_version_number%TYPE;
85: v_s_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;
86: v_rec_inserted_cnt NUMBER(5) DEFAULT 0;
87: CURSOR c_max_eff_start_dt IS
88: SELECT max(effective_start_dt)

Line 89: FROM IGS_PS_ANL_LOAD

85: v_s_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;
86: v_rec_inserted_cnt NUMBER(5) DEFAULT 0;
87: CURSOR c_max_eff_start_dt IS
88: SELECT max(effective_start_dt)
89: FROM IGS_PS_ANL_LOAD
90: WHERE course_cd = p_course_cd AND
91: version_number = p_version_number AND
92: yr_num = p_yr_num AND
93: effective_start_dt < p_effective_start_dt;

Line 98: FROM IGS_PS_ANL_LOAD_U_LN calul,

94: CURSOR c_calul (cp_effective_start_dt DATE) IS
95: SELECT calul.unit_cd,
96: calul.uv_version_number,
97: us.s_unit_status
98: FROM IGS_PS_ANL_LOAD_U_LN calul,
99: IGS_PS_UNIT_VER uv,
100: IGS_PS_UNIT_STAT us
101: WHERE calul.course_cd = p_course_cd AND
102: calul.crv_version_number = p_version_number AND

Line 130: IGS_PS_ANL_LOAD_U_LN_PKG.Insert_Row(

126: -- Do not insert records with system status of 'INACTIVE'
127: IF (v_s_unit_status <> 'INACTIVE') THEN
128: v_rec_inserted_cnt := v_rec_inserted_cnt + 1;
129:
130: IGS_PS_ANL_LOAD_U_LN_PKG.Insert_Row(
131: X_ROWID => x_rowid,
132: X_COURSE_CD => p_course_cd,
133: X_CRV_VERSION_NUMBER => p_version_number,
134: X_EFFECTIVE_START_DT => p_effective_start_dt,

Line 142: -- no IGS_PS_ANL_LOAD_U_LN record inserted

138: X_MODE => 'R');
139:
140: END IF;
141: END LOOP;
142: -- no IGS_PS_ANL_LOAD_U_LN record inserted
143: IF (v_rec_inserted_cnt = 0) THEN
144: p_message_name := 'IGS_PS_NOPRG_ANNUAL_LOADLINKS';
145: -- all IGS_PS_ANL_LOAD_U_LN records inserted
146: ELSIF (v_rec_inserted_cnt = c_calul%ROWCOUNT) THEN

Line 145: -- all IGS_PS_ANL_LOAD_U_LN records inserted

141: END LOOP;
142: -- no IGS_PS_ANL_LOAD_U_LN record inserted
143: IF (v_rec_inserted_cnt = 0) THEN
144: p_message_name := 'IGS_PS_NOPRG_ANNUAL_LOADLINKS';
145: -- all IGS_PS_ANL_LOAD_U_LN records inserted
146: ELSIF (v_rec_inserted_cnt = c_calul%ROWCOUNT) THEN
147: p_message_name := 'IGS_PS_SUCCESS_COPY_PRGANNUAL';
148: -- some IGS_PS_ANL_LOAD_U_LN record inserted
149: ELSE

Line 148: -- some IGS_PS_ANL_LOAD_U_LN record inserted

144: p_message_name := 'IGS_PS_NOPRG_ANNUAL_LOADLINKS';
145: -- all IGS_PS_ANL_LOAD_U_LN records inserted
146: ELSIF (v_rec_inserted_cnt = c_calul%ROWCOUNT) THEN
147: p_message_name := 'IGS_PS_SUCCESS_COPY_PRGANNUAL';
148: -- some IGS_PS_ANL_LOAD_U_LN record inserted
149: ELSE
150: p_message_name := 'IGS_PS_SOME_PRGANNUAL_LOADLIN';
151: END IF;
152: CLOSE c_calul;