APPS.IGS_PE_PERSON_SS_PKG dependencies on IGS_PE_STAT_V

Line 46: | Modified cursors referring igs_pe_person and igs_pe_stat_v to refer base tables in

42: | if error message is IGS_PE_UNIQUE_PID then display IGS_PE_UNIQUE_PID_SS
43: | Added a cursor c_alt_id_desc in the procedure createupdate_pers_altid to
44: | retrieve value of alternate Id description for th given alternate Id type.
45: | pkpatel 12-Jan-2006 Bug 4937960
46: | Modified cursors referring igs_pe_person and igs_pe_stat_v to refer base tables in
47: | Update_Person, Createupdate_Relationship and update_biographic procedures
48: | pkpatel 8-Feb-2006 Bug 4869740 (Changed level to lvl in update_privacy)
49: +=======================================================================+ */
50:

Line 1519: l_ethnicity igs_pe_stat_v.ethnic_origin%TYPE;

1515: l_birth_dt igs_pe_person_base_v.birth_date%TYPE;
1516: v_mar_dt VARCHAR2(100);
1517: v_other_dt VARCHAR2(100);
1518: l_marital_date DATE;
1519: l_ethnicity igs_pe_stat_v.ethnic_origin%TYPE;
1520: l_religion igs_pe_stat_v.religion%TYPE;
1521: BEGIN
1522: SAVEPOINT Update_Biographic;
1523: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1520: l_religion igs_pe_stat_v.religion%TYPE;

1516: v_mar_dt VARCHAR2(100);
1517: v_other_dt VARCHAR2(100);
1518: l_marital_date DATE;
1519: l_ethnicity igs_pe_stat_v.ethnic_origin%TYPE;
1520: l_religion igs_pe_stat_v.religion%TYPE;
1521: BEGIN
1522: SAVEPOINT Update_Biographic;
1523: -- Initialize message list if p_init_msg_list is set to TRUE.
1524: P_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;