APPS.IGS_PS_OFR_OPT_PKG dependencies on IGS_PE_PERSON

Line 143: v_preferred_name IGS_PE_PERSON.preferred_given_name%TYPE;

139: ) AS
140: v_message_name VARCHAR2(30);
141: v_course_cd IGS_PS_VER.course_cd%TYPE;
142: v_version_number IGS_PS_VER.version_number%TYPE;
143: v_preferred_name IGS_PE_PERSON.preferred_given_name%TYPE;
144: BEGIN
145:
146: -- Set variables
147: IF p_inserting OR p_updating THEN

Line 200: -- Validate enrolment officer IGS_PE_PERSON id

196: END IF;
197: END IF;
198: IF p_inserting OR p_updating THEN
199: IF new_references.enr_officer_person_id IS NOT NULL THEN
200: -- Validate enrolment officer IGS_PE_PERSON id
201: IF IGS_GE_MNT_SDTT.PID_VAL_STAFF (
202: new_references.enr_officer_person_id,
203: v_preferred_name) = FALSE THEN
204: Fnd_Message.Set_Name('IGS','IGS_GE_NOT_STAFF_MEMBER');

Line 414: IF NOT IGS_PE_PERSON_PKG.Get_PK_For_Validation (

410: IF (((old_references.enr_officer_person_id = new_references.enr_officer_person_id)) OR
411: ((new_references.enr_officer_person_id IS NULL))) THEN
412: NULL;
413: ELSE
414: IF NOT IGS_PE_PERSON_PKG.Get_PK_For_Validation (
415: new_references.enr_officer_person_id
416: ) THEN
417: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
418: IGS_GE_MSG_STACK.ADD;

Line 758: PROCEDURE GET_FK_IGS_PE_PERSON (

754: Close cur_rowid;
755:
756: END GET_FK_IGS_AD_LOCATION;
757:
758: PROCEDURE GET_FK_IGS_PE_PERSON (
759: x_person_id IN VARCHAR2 --ssawhney
760: ) AS
761:
762: CURSOR cur_rowid IS

Line 783: END GET_FK_IGS_PE_PERSON;

779: Return;
780: END IF;
781: Close cur_rowid;
782:
783: END GET_FK_IGS_PE_PERSON;
784:
785: PROCEDURE Before_DML (
786: p_action IN VARCHAR2,
787: x_rowid IN VARCHAR2 ,