APPS.IGS_AD_GEN_001 dependencies on IGS_GR_SPECIAL_AWARD_ALL

Line 1346: FROM IGS_GR_SPECIAL_AWARD_ALL gsa

1342: DECLARE
1343: CURSOR c_gsa IS
1344: SELECT award_cd,
1345: award_dt
1346: FROM IGS_GR_SPECIAL_AWARD_ALL gsa
1347: WHERE gsa.person_id = p_person_id AND
1348: gsa.course_cd = p_course_cd;
1349:
1350: CURSOR c_gsa_del (

Line 1351: cp_award_cd IGS_GR_SPECIAL_AWARD_ALL.award_cd%TYPE,

1347: WHERE gsa.person_id = p_person_id AND
1348: gsa.course_cd = p_course_cd;
1349:
1350: CURSOR c_gsa_del (
1351: cp_award_cd IGS_GR_SPECIAL_AWARD_ALL.award_cd%TYPE,
1352: cp_award_dt IGS_GR_SPECIAL_AWARD_ALL.award_dt%TYPE) IS
1353: SELECT rowid
1354: FROM IGS_GR_SPECIAL_AWARD_ALL gsa
1355: WHERE gsa.person_id = p_person_id AND

Line 1352: cp_award_dt IGS_GR_SPECIAL_AWARD_ALL.award_dt%TYPE) IS

1348: gsa.course_cd = p_course_cd;
1349:
1350: CURSOR c_gsa_del (
1351: cp_award_cd IGS_GR_SPECIAL_AWARD_ALL.award_cd%TYPE,
1352: cp_award_dt IGS_GR_SPECIAL_AWARD_ALL.award_dt%TYPE) IS
1353: SELECT rowid
1354: FROM IGS_GR_SPECIAL_AWARD_ALL gsa
1355: WHERE gsa.person_id = p_person_id AND
1356: gsa.course_cd = p_course_cd AND

Line 1354: FROM IGS_GR_SPECIAL_AWARD_ALL gsa

1350: CURSOR c_gsa_del (
1351: cp_award_cd IGS_GR_SPECIAL_AWARD_ALL.award_cd%TYPE,
1352: cp_award_dt IGS_GR_SPECIAL_AWARD_ALL.award_dt%TYPE) IS
1353: SELECT rowid
1354: FROM IGS_GR_SPECIAL_AWARD_ALL gsa
1355: WHERE gsa.person_id = p_person_id AND
1356: gsa.course_cd = p_course_cd AND
1357: gsa.award_cd = cp_award_cd AND
1358: gsa.award_dt = cp_award_dt

Line 1386: l_entity_name := 'IGS_GR_SPECIAL_AWARD_ALL';

1382: END IF;
1383: IF c_gsa_del%ISOPEN THEN
1384: CLOSE c_gsa_del;
1385: END IF;
1386: l_entity_name := 'IGS_GR_SPECIAL_AWARD_ALL';
1387: RETURN FALSE;
1388: WHEN OTHERS THEN
1389: IF c_gsa%ISOPEN THEN
1390: CLOSE c_gsa;