APPS.IGS_EN_GEN_010 dependencies on IGS_AS_SUA_REF_CDS

Line 6125: From IGS_AS_SUA_REF_CDS src_ref

6121: cp_source_course_cd VARCHAR2,
6122: cp_uoo_id NUMBER,
6123: cp_dest_course_cd VARCHAR2) IS
6124: Select src_ref.rowid, src_ref.*
6125: From IGS_AS_SUA_REF_CDS src_ref
6126: Where person_id = cp_person_id
6127: And course_cd = cp_source_course_cd
6128: And uoo_id = cp_uoo_id
6129: And deleted_date is null

Line 6131: From IGS_AS_SUA_REF_CDS dest_ref

6127: And course_cd = cp_source_course_cd
6128: And uoo_id = cp_uoo_id
6129: And deleted_date is null
6130: And not exists ( Select 'x'
6131: From IGS_AS_SUA_REF_CDS dest_ref
6132: WHERE dest_ref.person_id = src_ref.person_id
6133: And dest_ref.course_cd = cp_dest_course_cd
6134: And dest_ref.uoo_id = src_ref.uoo_id
6135: And dest_ref.deleted_date is null

Line 6141: l_suarid igs_as_sua_ref_cds.suar_id%TYPE;

6137: And dest_ref. APPLIED_COURSE_CD = src_ref. APPLIED_COURSE_CD
6138: );
6139:
6140: l_rowid VARCHAR2(25);
6141: l_suarid igs_as_sua_ref_cds.suar_id%TYPE;
6142: BEGIN
6143:
6144: FOR vc_source_ref_cd IN c_source_ref_cd(p_person_id,
6145: p_source_course_cd,

Line 6149: igs_as_sua_ref_cds_pkg.insert_row (

6145: p_source_course_cd,
6146: p_uoo_id,
6147: p_dest_course_cd) LOOP
6148:
6149: igs_as_sua_ref_cds_pkg.insert_row (
6150: x_rowid => l_rowid,
6151: x_suar_id => l_suarid,
6152: x_person_id => vc_source_ref_cd.person_id,
6153: x_course_cd => p_dest_course_cd,