APPS.IGS_AD_DEF_APPL_PKG dependencies on HZ_PARTIES

Line 4: FUNCTION get_person_number ( p_person_id hz_parties.party_id%TYPE ) RETURN VARCHAR2 IS

1: PACKAGE BODY igs_ad_def_appl_pkg AS
2: /* $Header: IGSADC1B.pls 120.8 2006/05/29 12:25:04 apadegal ship $ */
3:
4: FUNCTION get_person_number ( p_person_id hz_parties.party_id%TYPE ) RETURN VARCHAR2 IS
5:
6: CURSOR c_person_num IS
7: SELECT party_number
8: FROM hz_parties hp

Line 8: FROM hz_parties hp

4: FUNCTION get_person_number ( p_person_id hz_parties.party_id%TYPE ) RETURN VARCHAR2 IS
5:
6: CURSOR c_person_num IS
7: SELECT party_number
8: FROM hz_parties hp
9: WHERE hp.party_id = p_person_id;
10:
11: lv_person_number hz_parties.party_number%TYPE DEFAULT NULL;
12: BEGIN

Line 11: lv_person_number hz_parties.party_number%TYPE DEFAULT NULL;

7: SELECT party_number
8: FROM hz_parties hp
9: WHERE hp.party_id = p_person_id;
10:
11: lv_person_number hz_parties.party_number%TYPE DEFAULT NULL;
12: BEGIN
13:
14: OPEN c_person_num;
15: FETCH c_person_num INTO lv_person_number;

Line 39: p_person_id hz_parties.party_id%TYPE,

35: *******************************************************************************/
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,

Line 82: l_person_number hz_parties.party_number%TYPE;

78: l_new_sequence_number igs_ad_ps_appl_inst.sequence_number%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--------------------------------------------------------------------------------------------

Line 127: CURSOR c_appl_inst(p_person_id hz_parties.party_id%TYPE) IS

123: cur_acad_adm_alt_code VARCHAR2(200);
124: def_acad_adm_alt_code VARCHAR2(200);
125:
126: -- Cursor to get the current application attributes -----
127: CURSOR c_appl_inst(p_person_id hz_parties.party_id%TYPE) IS
128: SELECT
129: acai.*
130: FROM
131: igs_ad_appl aa,

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 339: p_person_id hz_parties.party_id%TYPE,

335: END admp_val_offer_defer_term;
336:
337: PROCEDURE cmn_handle_application
338: (
339: p_person_id hz_parties.party_id%TYPE,
340: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
341: p_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE,
342: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ,
343: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE ,

Line 501: p_person_id hz_parties.party_id%TYPE,

497: END IF; -- End if for handle application
498: END cmn_handle_application;
499:
500: FUNCTION handle_application(
501: p_person_id hz_parties.party_id%TYPE,
502: p_admission_appl_number igs_ad_appl.admission_appl_number%TYPE,
503: p_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%TYPE,
504: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
505: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,

Line 752: FUNCTION validate_offer_validations(p_person_id HZ_PARTIES.PARTY_ID%TYPE,

748: fnd_file.put_line(fnd_file.log, 'Exception From handle application log ' || l_message_name);
749: RETURN FALSE;
750: END handle_application;
751:
752: FUNCTION validate_offer_validations(p_person_id HZ_PARTIES.PARTY_ID%TYPE,
753: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
754: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
755: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
756: p_old_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,

Line 1232: FUNCTION copy_entrycomp_qual_status(p_person_id HZ_PARTIES.PARTY_ID%TYPE,

1228: fnd_file.put_line(fnd_file.log, 'Sequence Number : ' || p_sequence_number);
1229: RETURN FALSE;
1230: END validate_offer_validations;
1231:
1232: FUNCTION copy_entrycomp_qual_status(p_person_id HZ_PARTIES.PARTY_ID%TYPE,
1233: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
1234: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1235: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
1236: p_new_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,

Line 1525: FUNCTION Update_offer_response_accepted (p_person_id HZ_PARTIES.party_id%TYPE,

1521: RETURN FALSE;
1522: END copy_entrycomp_qual_status;
1523:
1524:
1525: FUNCTION Update_offer_response_accepted (p_person_id HZ_PARTIES.party_id%TYPE,
1526: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1527: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
1528: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE) RETURN BOOLEAN IS
1529: /*******************************************************************************