APPS.IGS_AD_DEF_APPL_PKG dependencies on IGS_PE_PERSID_GROUP

Line 40: p_group_id igs_pe_persid_group.group_id%TYPE,

36: PROCEDURE admp_val_offer_defer_term(
37: errbuf out NOCOPY varchar2,
38: retcode out NOCOPY number ,
39: p_person_id hz_parties.party_id%TYPE,
40: p_group_id igs_pe_persid_group.group_id%TYPE,
41: p_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%TYPE,
42: p_prev_acad_adm_cal VARCHAR2,
43: p_def_acad_adm_cal VARCHAR2,
44: p_offer_dt VARCHAR2,

Line 83: l_group_desc igs_pe_persid_group.description%TYPE;

79: cst_deferral CONSTANT VARCHAR2(9) := 'DEFERRAL';
80: cst_approved CONSTANT VARCHAR2(9) := 'APPROVED';
81:
82: l_person_number hz_parties.party_number%TYPE;
83: l_group_desc igs_pe_persid_group.description%TYPE;
84:
85:
86: ---End Variable Declarations--------------------------------------------------------------------------------------------
87:

Line 104: igs_pe_persid_group

100: CURSOR c_pergr_cur IS
101: SELECT
102: description
103: FROM
104: igs_pe_persid_group
105: WHERE
106: group_id = p_group_id;
107:
108: -- Cursor for getting the alternade academic/admission code for a given academic/admission cal type and sequence number

Line 158: CURSOR c_group_id(p_person_id hz_parties.party_id%TYPE,p_group_id igs_pe_persid_group.group_id%TYPE) IS

154:
155:
156: c_appl_inst_rec c_appl_inst%ROWTYPE;
157:
158: CURSOR c_group_id(p_person_id hz_parties.party_id%TYPE,p_group_id igs_pe_persid_group.group_id%TYPE) IS
159: SELECT 'X'
160: FROM igs_pe_prsid_grp_mem
161: WHERE person_id = p_person_id
162: AND group_id = p_group_id

Line 176: l_group_type IGS_PE_PERSID_GROUP_V.group_type%type;

172: c_ref_cur_rec c_ref_cur_rec_typ;
173:
174: -- for bug 5245277 and sql id 17651648
175: l_status VARCHAR2(1);
176: l_group_type IGS_PE_PERSID_GROUP_V.group_type%type;
177:
178: -- End cursor declarations -----------------------------------------------------------------------------------------------
179: BEGIN
180: