APPS.IGS_EN_GEN_010 dependencies on IGS_EN_SPLACEMENTS

Line 9113: -- igs_en_splacements_pkg.insert_row from v_dest_splace.uoo_id to p_Dest_uoo_id

9109: --
9110: --Change History:
9111: -- WHO WHEN WHAT
9112: -- amuthu 06-JUL-2006 Replaced the value to the parameter in the call to
9113: -- igs_en_splacements_pkg.insert_row from v_dest_splace.uoo_id to p_Dest_uoo_id
9114: */
9115: v_dummy VARCHAR2(1);
9116:
9117: CURSOR c_splace (cp_person_id IGS_EN_SPLACEMENTS.PERSON_ID%TYPE,

Line 9117: CURSOR c_splace (cp_person_id IGS_EN_SPLACEMENTS.PERSON_ID%TYPE,

9113: -- igs_en_splacements_pkg.insert_row from v_dest_splace.uoo_id to p_Dest_uoo_id
9114: */
9115: v_dummy VARCHAR2(1);
9116:
9117: CURSOR c_splace (cp_person_id IGS_EN_SPLACEMENTS.PERSON_ID%TYPE,
9118: cp_course_cd IGS_EN_SPLACEMENTS.COURSE_CD%TYPE,
9119: cp_uoo_id IGS_EN_SPLACEMENTS.UOO_ID%TYPE) IS
9120: SELECT rowid, SPLACEMENT_ID, person_id, course_cd, uoo_id,start_date,
9121: end_date, institution_code, title, description, category_code,

Line 9118: cp_course_cd IGS_EN_SPLACEMENTS.COURSE_CD%TYPE,

9114: */
9115: v_dummy VARCHAR2(1);
9116:
9117: CURSOR c_splace (cp_person_id IGS_EN_SPLACEMENTS.PERSON_ID%TYPE,
9118: cp_course_cd IGS_EN_SPLACEMENTS.COURSE_CD%TYPE,
9119: cp_uoo_id IGS_EN_SPLACEMENTS.UOO_ID%TYPE) IS
9120: SELECT rowid, SPLACEMENT_ID, person_id, course_cd, uoo_id,start_date,
9121: end_date, institution_code, title, description, category_code,
9122: placement_type_code, SPECIALTY_CODE, compensation_flag,

Line 9119: cp_uoo_id IGS_EN_SPLACEMENTS.UOO_ID%TYPE) IS

9115: v_dummy VARCHAR2(1);
9116:
9117: CURSOR c_splace (cp_person_id IGS_EN_SPLACEMENTS.PERSON_ID%TYPE,
9118: cp_course_cd IGS_EN_SPLACEMENTS.COURSE_CD%TYPE,
9119: cp_uoo_id IGS_EN_SPLACEMENTS.UOO_ID%TYPE) IS
9120: SELECT rowid, SPLACEMENT_ID, person_id, course_cd, uoo_id,start_date,
9121: end_date, institution_code, title, description, category_code,
9122: placement_type_code, SPECIALTY_CODE, compensation_flag,
9123: attendance_type, location, notes

Line 9124: FROM IGS_EN_SPLACEMENTS

9120: SELECT rowid, SPLACEMENT_ID, person_id, course_cd, uoo_id,start_date,
9121: end_date, institution_code, title, description, category_code,
9122: placement_type_code, SPECIALTY_CODE, compensation_flag,
9123: attendance_type, location, notes
9124: FROM IGS_EN_SPLACEMENTS
9125: WHERE person_id = cp_person_id
9126: AND course_cd = cp_course_cd
9127: AND uoo_id = cp_uoo_id;
9128:

Line 9135: CURSOR cur_sp(c_splacement_id IGS_EN_SPLACEMENTS.SPLACEMENT_ID%TYPE) IS

9131: l_rowid VARCHAR2(25);
9132: l_splace_rowid VARCHAR2(25);
9133: l_splacement_id NUMBER;
9134:
9135: CURSOR cur_sp(c_splacement_id IGS_EN_SPLACEMENTS.SPLACEMENT_ID%TYPE) IS
9136: SELECT rowid, supervisor_id
9137: FROM IGS_EN_SPLACE_SUPS
9138: WHERE Splacement_id=c_splacement_id;
9139:

Line 9140: CURSOR cur_fac(c_splacement_id IGS_EN_SPLACEMENTS.SPLACEMENT_ID%TYPE) IS

9136: SELECT rowid, supervisor_id
9137: FROM IGS_EN_SPLACE_SUPS
9138: WHERE Splacement_id=c_splacement_id;
9139:
9140: CURSOR cur_fac(c_splacement_id IGS_EN_SPLACEMENTS.SPLACEMENT_ID%TYPE) IS
9141: SELECT rowid, FACULTY_ID
9142: FROM IGS_EN_SPLACE_FACS
9143: WHERE Splacement_id=c_splacement_id;
9144:

Line 9217: igs_en_splacements_pkg.delete_row(v_source_splace.rowid);

9213: IGS_EN_SPLACE_FACS_pkg.delete_row(v_cur_fac_rec.rowid);
9214: END LOOP;
9215:
9216:
9217: igs_en_splacements_pkg.delete_row(v_source_splace.rowid);
9218:
9219: igs_en_splacements_pkg.insert_row (
9220: x_rowid => l_splace_rowid ,
9221: x_splacement_id => l_splacement_id ,

Line 9219: igs_en_splacements_pkg.insert_row (

9215:
9216:
9217: igs_en_splacements_pkg.delete_row(v_source_splace.rowid);
9218:
9219: igs_en_splacements_pkg.insert_row (
9220: x_rowid => l_splace_rowid ,
9221: x_splacement_id => l_splacement_id ,
9222: x_person_id => v_source_splace.person_id ,
9223: x_course_cd => p_dest_course_cd ,