APPS.IGS_EN_SU_ATTEMPT_PKG dependencies on IGS_EN_STDNT_PS_ATT

Line 1584: ELSIF NOT IGS_EN_STDNT_PS_ATT_PKG.Get_PK_For_Validation (

1580: (old_references.course_cd = new_references.course_cd)) OR
1581: ((new_references.person_id IS NULL) OR
1582: (new_references.course_cd IS NULL))) THEN
1583: NULL;
1584: ELSIF NOT IGS_EN_STDNT_PS_ATT_PKG.Get_PK_For_Validation (
1585: new_references.person_id,
1586: new_references.course_cd
1587: ) THEN
1588: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

Line 1874: PROCEDURE GET_FK_IGS_EN_STDNT_PS_ATT (

1870: END IF;
1871: CLOSE cur_rowid;
1872: END GET_FK_IGS_PE_PERSON;
1873:
1874: PROCEDURE GET_FK_IGS_EN_STDNT_PS_ATT (
1875: x_person_id IN NUMBER,
1876: x_course_cd IN VARCHAR2
1877: ) AS
1878: CURSOR cur_rowid IS

Line 1895: END GET_FK_IGS_EN_STDNT_PS_ATT;

1891: APP_EXCEPTION.RAISE_EXCEPTION;
1892: RETURN;
1893: END IF;
1894: CLOSE cur_rowid;
1895: END GET_FK_IGS_EN_STDNT_PS_ATT;
1896:
1897: PROCEDURE GET_FK_IGS_LOOKUPS_VIEW (
1898: x_unit_attempt_status IN VARCHAR2
1899: ) AS

Line 2516: IGS_EN_STDNT_PS_ATT spa,

2512: -- of the academic calendar of the student program attempt.
2513: CURSOR c_teach_to_load(cp_acad_cal_type VARCHAR2) IS
2514: SELECT ttl.load_cal_type, ttl.load_ci_sequence_number
2515: FROM IGS_CA_TEACH_TO_LOAD_V ttl,
2516: IGS_EN_STDNT_PS_ATT spa,
2517: IGS_CA_INST_REL cir
2518: WHERE ttl.teach_cal_type= new_references.cal_type
2519: AND ttl.teach_ci_sequence_number = new_references.ci_sequence_number
2520: AND spa.person_id = new_references.person_id

Line 2530: FROM igs_en_spa_terms spat, igs_en_stdnt_ps_att curspa, igs_ps_ver curcv,

2526:
2527: CURSOR c_term (p_person_id number, p_course_cd varchar2,
2528: p_term_cal_type varchar2, p_term_ci_sequence_number number) IS
2529: SELECT 'x'
2530: FROM igs_en_spa_terms spat, igs_en_stdnt_ps_att curspa, igs_ps_ver curcv,
2531: igs_en_stdnt_ps_att spa, igs_ps_ver cv
2532: WHERE spat.person_id = p_person_id
2533: AND term_cal_type = p_term_cal_type AND term_sequence_number = p_term_ci_sequence_number
2534: AND curspa.person_id=spat.person_id AND curspa.course_cd=p_course_Cd

Line 2531: igs_en_stdnt_ps_att spa, igs_ps_ver cv

2527: CURSOR c_term (p_person_id number, p_course_cd varchar2,
2528: p_term_cal_type varchar2, p_term_ci_sequence_number number) IS
2529: SELECT 'x'
2530: FROM igs_en_spa_terms spat, igs_en_stdnt_ps_att curspa, igs_ps_ver curcv,
2531: igs_en_stdnt_ps_att spa, igs_ps_ver cv
2532: WHERE spat.person_id = p_person_id
2533: AND term_cal_type = p_term_cal_type AND term_sequence_number = p_term_ci_sequence_number
2534: AND curspa.person_id=spat.person_id AND curspa.course_cd=p_course_Cd
2535: AND curcv.course_Cd=curspa.course_cd AND curcv.version_number=curspa.version_number

Line 2545: FROM IGS_EN_STDNT_PS_ATT

2541:
2542: CURSOR c_sca IS
2543: SELECT attendance_type, attendance_mode, key_program, fee_cat, igs_pr_class_std_id,
2544: cal_type, location_cd, coo_id, version_number, student_confirmed_ind
2545: FROM IGS_EN_STDNT_PS_ATT
2546: WHERE person_id = new_references.person_id
2547: AND course_cd = new_references.course_cd;
2548:
2549: rec_sca c_sca%ROWTYPE;