APPS.IGS_PS_UNIT_VER_PKG dependencies on IGS_PE_PERSON

Line 495: v_preferred_name IGS_PE_PERSON.preferred_given_name%TYPE;

491: v_assessable_ind IGS_PS_UNIT_VER_ALL.assessable_ind%TYPE;
492: v_unit_int_course_level_cd IGS_PS_UNIT_VER_ALL.unit_int_course_level_cd%TYPE;
493: cst_error VARCHAR2(1);
494: v_s_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;
495: v_preferred_name IGS_PE_PERSON.preferred_given_name%TYPE;
496: v_ss_enrol_ind IGS_PS_UNIT_VER_ALL.ss_enrol_ind%TYPE;
497: v_ivr_enrol_ind IGS_PS_UNIT_VER_ALL.ivr_enrol_ind%TYPE;
498:
499: -- Modified by rbezawad on 24-May-2001. Added following 47 fields as per PSP001-US DLD.

Line 2256: IF NOT IGS_PE_PERSON_PKG.Get_PK_For_Validation (

2252: IF (((old_references.coord_person_id = new_references.coord_person_id)) OR
2253: ((new_references.coord_person_id IS NULL))) THEN
2254: NULL;
2255: ELSE
2256: IF NOT IGS_PE_PERSON_PKG.Get_PK_For_Validation (
2257: new_references.coord_person_id) THEN
2258:
2259: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
2260: IGS_GE_MSG_STACK.ADD;

Line 2716: PROCEDURE GET_FK_IGS_PE_PERSON (

2712: Close cur_rowid;
2713:
2714: END GET_FK_IGS_OR_UNIT;
2715: ---------------------------------------------------------------
2716: PROCEDURE GET_FK_IGS_PE_PERSON (
2717: x_person_id IN NUMBER
2718: ) AS
2719:
2720: CURSOR cur_rowid IS

Line 2740: END GET_FK_IGS_PE_PERSON;

2736: Return;
2737: END IF;
2738: Close cur_rowid;
2739:
2740: END GET_FK_IGS_PE_PERSON;
2741: ---------------------------------------------------------------
2742: PROCEDURE GET_FK_IGS_PS_UNIT_INT_LVL (
2743: x_unit_int_course_level_cd IN VARCHAR2
2744: ) AS