APPS.IGS_PE_PERSON_SS_PKG dependencies on IGS_EN_STDNT_PS_ATT

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 1166: FROM igs_en_stdnt_ps_att

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;
1169:
1170: -- l_stdnt_ps_attempt_dtls_rec c_get_stdnt_ps_att_dtls%ROWTYPE;

Line 1189: IGS_EN_STDNT_PS_ATT_PKG.LOCK_ROW(

1185: FND_MSG_PUB.initialize;
1186:
1187: IF P_ACTION = 'LOCK' THEN
1188: FOR l_stdnt_ps_attempt_dtls_rec IN c_get_stdnt_ps_att_dtls(p_person_id, p_course_cd) LOOP
1189: IGS_EN_STDNT_PS_ATT_PKG.LOCK_ROW(
1190: X_ROWID => l_stdnt_ps_attempt_dtls_rec.row_id,
1191: X_PERSON_ID => l_stdnt_ps_attempt_dtls_rec.PERSON_ID,
1192: X_COURSE_CD => l_stdnt_ps_attempt_dtls_rec.COURSE_CD,
1193: X_ADVANCED_STANDING_IND => l_stdnt_ps_attempt_dtls_rec.ADVANCED_STANDING_IND,

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,

Line 1270: IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW(

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,
1272: X_PERSON_ID => l_stdnt_ps_attempt_dtls_rec.PERSON_ID,
1273: X_COURSE_CD => l_stdnt_ps_attempt_dtls_rec.COURSE_CD,
1274: X_ADVANCED_STANDING_IND => l_stdnt_ps_attempt_dtls_rec.ADVANCED_STANDING_IND,