APPS.IGS_EN_SPI_RCOND_LGCY_PUB dependencies on HZ_PARTIES

Line 15: FUNCTION validate_parameters(p_person_id IN hz_parties.party_id%TYPE ,

11: ---------------------------------------------------------------------------------------------*/
12:
13: g_pkg_name CONSTANT VARCHAR2(30) := 'IGS_EN_SPI_RCOND_LGCY_PUB';
14:
15: FUNCTION validate_parameters(p_person_id IN hz_parties.party_id%TYPE ,
16: p_intm_rcond_rec IN en_spi_rcond_rec_type)
17: RETURN VARCHAR2 AS
18:
19: /**********************************************************************************************

Line 52: FUNCTION validate_db_cons ( p_person_id IN hz_parties.party_id%TYPE ,

48: RETURN l_ret_val;
49:
50: END validate_parameters;
51:
52: FUNCTION validate_db_cons ( p_person_id IN hz_parties.party_id%TYPE ,
53: p_intm_rcond_rec IN en_spi_rcond_rec_type)
54: RETURN VARCHAR2 AS
55: /**********************************************************************************************
56: Created By : bdeviset

Line 70: CURSOR chk_intermission (cp_person_id hz_parties.party_id%TYPE) IS

66: FROM igs_lookup_values
67: WHERE lookup_type = 'IGS_EN_INTM_RCOND_STS'
68: AND lookup_Code = p_intm_rcond_rec.status_code;
69:
70: CURSOR chk_intermission (cp_person_id hz_parties.party_id%TYPE) IS
71: SELECT cond_return_flag
72: FROM igs_en_stdnt_ps_intm
73: WHERE person_id = cp_person_id
74: AND course_cd = p_intm_rcond_rec.program_cd

Line 159: l_person_id hz_parties.party_id%TYPE;

155: ***********************************************************************************************/
156:
157: l_rowid ROWID;
158: l_course_attempt_status igs_en_stdnt_ps_att.course_attempt_status%TYPE;
159: l_person_id hz_parties.party_id%TYPE;
160: l_sca_rec igs_en_stdnt_ps_att%ROWTYPE;
161: l_insert_flag BOOLEAN;
162: l_creation_date igs_en_stdnt_ps_intm.creation_date%TYPE;
163: l_last_update_date igs_en_stdnt_ps_intm.last_update_date%TYPE;

Line 169: l_approver_id hz_parties.party_id%TYPE;

165: l_last_updated_by igs_en_stdnt_ps_intm.last_updated_by%TYPE;
166: l_last_update_login igs_en_stdnt_ps_intm.last_update_login%TYPE;
167: l_api_name CONSTANT VARCHAR2(30) := 'create_student_intm_rcond';
168: l_api_version CONSTANT NUMBER := 1.0;
169: l_approver_id hz_parties.party_id%TYPE;
170: l_ret_val VARCHAR2(1);
171:
172: CURSOR c_crs_status (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE) IS
173: SELECT course_attempt_status