APPS.IGS_PS_GEN_003 dependencies on IGS_PS_OFR_PAT

Line 132: gv_cd_and_vn_passed IGS_PS_OFR_PAT.coo_id%TYPE;

128: lv_param_values VARCHAR2(1080);
129: BEGIN
130: DECLARE
131:
132: gv_cd_and_vn_passed IGS_PS_OFR_PAT.coo_id%TYPE;
133: gv_cop_id_passed IGS_PS_OFR_PAT%ROWTYPE;
134: -- this is used when the course_cd and version_number
135: -- are passed
136: CURSOR gc_cd_and_vn_passed IS

Line 133: gv_cop_id_passed IGS_PS_OFR_PAT%ROWTYPE;

129: BEGIN
130: DECLARE
131:
132: gv_cd_and_vn_passed IGS_PS_OFR_PAT.coo_id%TYPE;
133: gv_cop_id_passed IGS_PS_OFR_PAT%ROWTYPE;
134: -- this is used when the course_cd and version_number
135: -- are passed
136: CURSOR gc_cd_and_vn_passed IS
137: SELECT cop_id

Line 138: FROM IGS_PS_OFR_PAT

134: -- this is used when the course_cd and version_number
135: -- are passed
136: CURSOR gc_cd_and_vn_passed IS
137: SELECT cop_id
138: FROM IGS_PS_OFR_PAT
139: WHERE course_cd = p_course_cd AND
140: version_number = p_version_number AND
141: cal_type = p_cal_type AND
142: ci_sequence_number = p_ci_sequence_number AND

Line 149: FROM IGS_PS_OFR_PAT

145: attendance_type = p_attendance_type;
146: -- this is used when the coo_id is passed
147: CURSOR gc_cop_id_passed IS
148: SELECT *
149: FROM IGS_PS_OFR_PAT
150: WHERE cop_id = p_cop_id;
151: BEGIN
152: -- if only the course_cd was enetered
153: IF(NVL(p_course_cd, 'NO_VALUE') <> 'NO_VALUE') THEN

Line 341: FROM IGS_PS_OFR_PAT

337: adm_ass_officer_person_id,
338: adm_contact_person_id,
339: grading_schema_cd,
340: gs_version_number
341: FROM IGS_PS_OFR_PAT
342: WHERE course_cd = p_course_cd AND
343: version_number = p_version_number AND
344: cal_type = p_source_cal_type AND
345: ci_sequence_number = p_source_sequence_number;

Line 349: FROM IGS_PS_OFR_PAT

345: ci_sequence_number = p_source_sequence_number;
346: v_cop_rec c_course_offering_pattern%ROWTYPE;
347: CURSOR c_check_cop_exist IS
348: SELECT 'x'
349: FROM IGS_PS_OFR_PAT
350: WHERE course_cd = p_course_cd AND
351: version_number = p_version_number AND
352: cal_type = p_dest_cal_type AND
353: ci_sequence_number = p_dest_sequence_number AND

Line 358: SELECT IGS_PS_OFR_PAT_COP_ID_S.NEXTVAL

354: location_cd = v_cop_rec.location_cd AND
355: attendance_type = v_cop_rec.attendance_type AND
356: attendance_mode = v_cop_rec.attendance_mode;
357: CURSOR c_cop_sequence_number IS
358: SELECT IGS_PS_OFR_PAT_COP_ID_S.NEXTVAL
359: FROM DUAL;
360: CURSOR c_latest_gs_version (
361: cp_gs_cd IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE) IS
362: SELECT MAX(gs.version_number)

Line 432: IGS_PS_OFR_PAT_PKG.Insert_Row(

428: v_cop_rec.adm_contact_person_id := NULL;
429: END IF;
430:
431:
432: IGS_PS_OFR_PAT_PKG.Insert_Row(
433: X_ROWID => x_rowid,
434: X_COURSE_CD => p_course_cd,
435: X_CI_SEQUENCE_NUMBER => p_dest_sequence_number,
436: X_CAL_TYPE => p_dest_cal_type,