DBA Data[Home] [Help]

APPS.IGS_EN_SPLACEMENTS_API dependencies on IGS_PE_PERSON

Line 69: l_person_id IGS_PE_PERSON.PERSON_ID%TYPE :=P_PERSON_ID;

65: l_rowid VARCHAR2(25) :=NULL;
66: l_msg_data VARCHAR2(2000) :=NULL;
67: l_msg_count NUMBER :=NULL;
68: l_return_status VARCHAR2(10) :=NULL;
69: l_person_id IGS_PE_PERSON.PERSON_ID%TYPE :=P_PERSON_ID;
70: l_person_number IGS_PE_PERSON.PERSON_NUMBER%TYPE :=NULL;
71: l_hz_parties_ovn NUMBER(10);
72: l_last_update_date HZ_CONTACT_POINTS.LAST_UPDATE_DATE%TYPE :=NULL;
73: l_contact_point_id HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE :=NULL;

Line 70: l_person_number IGS_PE_PERSON.PERSON_NUMBER%TYPE :=NULL;

66: l_msg_data VARCHAR2(2000) :=NULL;
67: l_msg_count NUMBER :=NULL;
68: l_return_status VARCHAR2(10) :=NULL;
69: l_person_id IGS_PE_PERSON.PERSON_ID%TYPE :=P_PERSON_ID;
70: l_person_number IGS_PE_PERSON.PERSON_NUMBER%TYPE :=NULL;
71: l_hz_parties_ovn NUMBER(10);
72: l_last_update_date HZ_CONTACT_POINTS.LAST_UPDATE_DATE%TYPE :=NULL;
73: l_contact_point_id HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE :=NULL;
74: l_contact_point_ovn HZ_CONTACT_POINTS.OBJECT_VERSION_NUMBER%TYPE :=NULL;

Line 113: IGS_PE_PERSON_PKG.INSERT_ROW(

109: APP_EXCEPTION.RAISE_EXCEPTION;
110: END IF;
111: END IF;
112:
113: IGS_PE_PERSON_PKG.INSERT_ROW(
114: X_ROWID => l_rowid,
115: X_MSG_DATA => L_MSG_DATA,
116: X_MSG_COUNT => L_MSG_COUNT,
117: X_RETURN_STATUS => L_RETURN_STATUS,