APPS.IGS_AS_TRNCMT_LGCY_PUB dependencies on IGS_AS_SU_SETATMPT

Line 401: CURSOR cur_igs_as_su_setatmpt(

397: AND course_type = cp_course_type
398: AND load_cal_type = cp_load_cal_type
399: AND load_ci_sequence_number = cp_load_ci_sequence_number;
400:
401: CURSOR cur_igs_as_su_setatmpt(
402: cp_person_id igs_pe_person.person_id%TYPE,
403: cp_course_cd igs_as_su_setatmpt.course_cd%TYPE,
404: cp_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE
405: ) IS

Line 403: cp_course_cd igs_as_su_setatmpt.course_cd%TYPE,

399: AND load_ci_sequence_number = cp_load_ci_sequence_number;
400:
401: CURSOR cur_igs_as_su_setatmpt(
402: cp_person_id igs_pe_person.person_id%TYPE,
403: cp_course_cd igs_as_su_setatmpt.course_cd%TYPE,
404: cp_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE
405: ) IS
406: SELECT 'X'
407: FROM IGS_AS_SU_SETATMPT

Line 404: cp_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE

400:
401: CURSOR cur_igs_as_su_setatmpt(
402: cp_person_id igs_pe_person.person_id%TYPE,
403: cp_course_cd igs_as_su_setatmpt.course_cd%TYPE,
404: cp_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE
405: ) IS
406: SELECT 'X'
407: FROM IGS_AS_SU_SETATMPT
408: WHERE person_id = cp_person_id

Line 407: FROM IGS_AS_SU_SETATMPT

403: cp_course_cd igs_as_su_setatmpt.course_cd%TYPE,
404: cp_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE
405: ) IS
406: SELECT 'X'
407: FROM IGS_AS_SU_SETATMPT
408: WHERE person_id = cp_person_id
409: AND course_cd = cp_course_cd
410: AND unit_set_cd = cp_unit_set_cd;
411:

Line 414: cp_course_cd igs_as_su_setatmpt.course_cd%TYPE,

410: AND unit_set_cd = cp_unit_set_cd;
411:
412: CURSOR cur_igs_he_en_susa(
413: cp_person_id igs_pe_person.person_id%TYPE,
414: cp_course_cd igs_as_su_setatmpt.course_cd%TYPE,
415: cp_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE
416: ) IS
417: SELECT 'X'
418: FROM igs_he_en_susa

Line 415: cp_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE

411:
412: CURSOR cur_igs_he_en_susa(
413: cp_person_id igs_pe_person.person_id%TYPE,
414: cp_course_cd igs_as_su_setatmpt.course_cd%TYPE,
415: cp_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE
416: ) IS
417: SELECT 'X'
418: FROM igs_he_en_susa
419: WHERE person_id = cp_person_id

Line 507: --Foreign key validation with IGS_AS_SU_SETATMPT

503: FND_MSG_PUB.ADD;
504: l_return_value := 'E';
505: END IF;
506:
507: --Foreign key validation with IGS_AS_SU_SETATMPT
508: IF p_lgcy_trncmt_rec.comment_type_code = 'PROGRAM_YEAR' THEN
509: OPEN cur_igs_as_su_setatmpt(p_person_id,
510: p_lgcy_trncmt_rec.program_cd,
511: p_lgcy_trncmt_rec.unit_set_cd);

Line 509: OPEN cur_igs_as_su_setatmpt(p_person_id,

505: END IF;
506:
507: --Foreign key validation with IGS_AS_SU_SETATMPT
508: IF p_lgcy_trncmt_rec.comment_type_code = 'PROGRAM_YEAR' THEN
509: OPEN cur_igs_as_su_setatmpt(p_person_id,
510: p_lgcy_trncmt_rec.program_cd,
511: p_lgcy_trncmt_rec.unit_set_cd);
512: FETCH cur_igs_as_su_setatmpt into l_dummy;
513: IF cur_igs_as_su_setatmpt%NOTFOUND THEN

Line 512: FETCH cur_igs_as_su_setatmpt into l_dummy;

508: IF p_lgcy_trncmt_rec.comment_type_code = 'PROGRAM_YEAR' THEN
509: OPEN cur_igs_as_su_setatmpt(p_person_id,
510: p_lgcy_trncmt_rec.program_cd,
511: p_lgcy_trncmt_rec.unit_set_cd);
512: FETCH cur_igs_as_su_setatmpt into l_dummy;
513: IF cur_igs_as_su_setatmpt%NOTFOUND THEN
514: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_US_CHK');
515: FND_MSG_PUB.ADD;
516: l_return_value := 'E';

Line 513: IF cur_igs_as_su_setatmpt%NOTFOUND THEN

509: OPEN cur_igs_as_su_setatmpt(p_person_id,
510: p_lgcy_trncmt_rec.program_cd,
511: p_lgcy_trncmt_rec.unit_set_cd);
512: FETCH cur_igs_as_su_setatmpt into l_dummy;
513: IF cur_igs_as_su_setatmpt%NOTFOUND THEN
514: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_US_CHK');
515: FND_MSG_PUB.ADD;
516: l_return_value := 'E';
517: END IF;