APPS.IGS_PE_PERSON_SS_PKG dependencies on IGS_EN_STDNT_PS_ATT_ALL

Line 1163: CURSOR c_get_stdnt_ps_att_dtls(cp_person_id igs_en_stdnt_ps_att_all.person_id%TYPE,

1159: l_api_name CONSTANT VARCHAR2(30) := 'Update_Dates';
1160: l_api_version CONSTANT NUMBER := 1.0;
1161: l_rowid VARCHAR2(255);
1162:
1163: CURSOR c_get_stdnt_ps_att_dtls(cp_person_id igs_en_stdnt_ps_att_all.person_id%TYPE,
1164: cp_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE) IS
1165: SELECT *
1166: FROM igs_en_stdnt_ps_att
1167: WHERE person_id = cp_person_id AND

Line 1164: cp_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE) IS

1160: l_api_version CONSTANT NUMBER := 1.0;
1161: l_rowid VARCHAR2(255);
1162:
1163: CURSOR c_get_stdnt_ps_att_dtls(cp_person_id igs_en_stdnt_ps_att_all.person_id%TYPE,
1164: cp_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE) IS
1165: SELECT *
1166: FROM igs_en_stdnt_ps_att
1167: WHERE person_id = cp_person_id AND
1168: course_cd = cp_course_cd;

Line 1267: --Update IGS_EN_STDNT_PS_ATT_ALL table.

1263: );
1264: END LOOP;
1265: ELSE
1266: -- API body
1267: --Update IGS_EN_STDNT_PS_ATT_ALL table.
1268: FOR l_stdnt_ps_attempt_dtls_rec IN c_get_stdnt_ps_att_dtls(p_person_id, p_course_cd) LOOP
1269:
1270: IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW(
1271: X_ROWID => l_stdnt_ps_attempt_dtls_rec.row_id,