APPS.IGS_EN_STDNT_PS_ATT_PKG dependencies on IGS_PE_PERSON

Line 385: FROM IGS_PE_PERSON_TYPES_V

381:
382: CURSOR cur_per_type IS
383:
384: SELECT person_type_code
385: FROM IGS_PE_PERSON_TYPES_V
386: WHERE system_type = 'STAFF';
387:
388: BEGIN
389:

Line 904: FROM igs_pe_person_types

900: pti.END_DATE IS NULL;
901:
902: CURSOR cur_pers_type(p_system_type varchar2) IS
903: SELECT PERSON_TYPE_CODE
904: FROM igs_pe_person_types
905: WHERE SYSTEM_TYPE = p_system_type AND
906: CLOSED_IND = 'N';
907:
908: -- Cursor used to fetch the Person Type Instance record which is being opened

Line 913: p_system_type igs_pe_person_types.SYSTEM_TYPE%TYPE) IS

909: -- irrespective of the system person type is closed or not.
910: -- Cursor is being created for the bug fix: 2389552
911: CURSOR cur_pe_typ_inst( p_person_id igs_pe_typ_instances.PERSON_ID%TYPE,
912: p_course_cd igs_pe_typ_instances.course_cd%TYPE,
913: p_system_type igs_pe_person_types.SYSTEM_TYPE%TYPE) IS
914: SELECT pti.rowid row_id ,pti.*
915: FROM igs_pe_typ_instances_all pti,
916: igs_pe_person_types pty
917: WHERE pti.person_id = p_person_id AND

Line 916: igs_pe_person_types pty

912: p_course_cd igs_pe_typ_instances.course_cd%TYPE,
913: p_system_type igs_pe_person_types.SYSTEM_TYPE%TYPE) IS
914: SELECT pti.rowid row_id ,pti.*
915: FROM igs_pe_typ_instances_all pti,
916: igs_pe_person_types pty
917: WHERE pti.person_id = p_person_id AND
918: pti.course_cd = p_course_cd AND
919: pti.end_date IS NULL AND
920: pty.person_type_code = pti.person_type_code AND

Line 923: CURSOR cur_find_interm(cp_perosn_id igs_pe_person.person_id%TYPE,

919: pti.end_date IS NULL AND
920: pty.person_type_code = pti.person_type_code AND
921: pty.system_type = p_system_type;
922:
923: CURSOR cur_find_interm(cp_perosn_id igs_pe_person.person_id%TYPE,
924: cp_course_cd igs_ps_ver.course_cd%TYPE) IS
925: SELECT sci.person_id,sci.course_cd,start_dt, sci.end_dt, sci.voluntary_ind,sci.comments ,sci.created_by ,sci.creation_date ,
926: sci.last_updated_by ,sci.last_update_date , sci.last_update_login , sci.intermission_type , sci.approved ,sci.institution_name,
927: sci.max_credit_pts, sci.max_terms, sci.anticipated_credit_points, sci.approver_id

Line 938: CURSOR cur_re_canditure(cp_person_id igs_pe_person.person_id%TYPE,

934: AND sci.logical_delete_date = TO_DATE ('31-12-4712','DD-MM-YYYY');
935:
936:
937:
938: CURSOR cur_re_canditure(cp_person_id igs_pe_person.person_id%TYPE,
939: cp_course_cd igs_ps_ver.course_cd%TYPE) IS
940: SELECT 1
941: FROM igs_re_candidature
942: WHERE sca_course_cd = cp_course_cd

Line 953: l_person_type igs_pe_person_types.PERSON_TYPE_CODE%TYPE;

949: v_message_name VARCHAR2(30);
950: v_save_row BOOLEAN := FALSE;
951: r_sca IGS_EN_STDNT_PS_ATT_ALL%ROWTYPE;
952: l_method igs_pe_typ_instances.CREATE_METHOD%TYPE;
953: l_person_type igs_pe_person_types.PERSON_TYPE_CODE%TYPE;
954: l_rowid VARCHAR2(25);
955: l_TYPE_INSTANCE_ID igs_pe_typ_instances.TYPE_INSTANCE_ID%TYPE;
956: cur_typ_id_inst_rec cur_typ_id_inst%ROWTYPE;
957: l_cur_find_interm cur_find_interm%ROWTYPE;

Line 2021: IF NOT IGS_PE_PERSON_PKG.Get_PK_For_Validation (

2017: IF (((old_references.person_id = new_references.person_id)) OR
2018: ((new_references.person_id IS NULL))) THEN
2019: NULL;
2020: ELSE
2021: IF NOT IGS_PE_PERSON_PKG.Get_PK_For_Validation (
2022: new_references.person_id
2023: ) THEN
2024: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
2025: IGS_GE_MSG_STACK.ADD;

Line 2585: PROCEDURE GET_FK_IGS_PE_PERSON (

2581: END IF;
2582: CLOSE cur_rowid;
2583: END GET_FK_IGS_AD_LOCATION;
2584:
2585: PROCEDURE GET_FK_IGS_PE_PERSON (
2586: x_person_id IN NUMBER
2587: ) AS
2588: CURSOR cur_rowid IS
2589: SELECT ROWID

Line 2604: END GET_FK_IGS_PE_PERSON;

2600: App_Exception.Raise_Exception;
2601: RETURN;
2602: END IF;
2603: CLOSE cur_rowid;
2604: END GET_FK_IGS_PE_PERSON;
2605:
2606: -- added as part of Enroll process Build for class standing dld
2607: -- amuthu 30-JUL-2001
2608: PROCEDURE GET_FK_IGS_PR_CLASS_STD(