[Home] [Help]
PACKAGE: APPS.IGS_AD_VAL_ACAI_FTR_OFFER
Source
1 PACKAGE igs_ad_val_acai_ftr_offer AS
2 /* $Header: IGSADB5S.pls 120.1 2005/09/19 10:40:26 appldev ship $ */
3 /*******************************************************************************
4 Created by : Ramesh Rengarajan
5 Date created: 20 FEB 2002
6
7 Purpose:
8 To create future term application
9
10 Known limitations/enhancements and/or remarks:
11
12 Change History: (who, when, what: )
13 Who When What
14 rrengara 18-sep-2002 added p_process as a parameter to copy_child_records for deferment build 2563941
15 *******************************************************************************/
16 PROCEDURE admp_val_offer_future_term( errbuf out NOCOPY varchar2,
17 retcode out NOCOPY number ,
18 p_person_id hz_parties.party_id%TYPE,
19 p_group_id igs_pe_persid_group.group_id%TYPE,
20 p_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%TYPE,
21 p_prev_acad_adm_cal VARCHAR2,
22 p_future_acad_adm_cal VARCHAR2,
23 p_offer_dt VARCHAR2,
24 p_offer_response_dt VARCHAR2,
25 p_application_type VARCHAR2 DEFAULT NULL,
26 p_application_id NUMBER DEFAULT NULL);
27
28 FUNCTION handle_application( p_person_id hz_parties.party_id%TYPE,
29 p_admission_appl_number igs_ad_appl.admission_appl_number%TYPE,
30 p_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%TYPE,
31 p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
32 p_fut_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
33 p_fut_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
34 p_fut_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
35 p_fut_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
36 p_new_admission_appl_number OUT NOCOPY igs_ad_appl.admission_appl_number%TYPE,
37 p_new_sequence_number OUT NOCOPY igs_ad_ps_appl_inst.sequence_number%TYPE)
38 RETURN BOOLEAN;
39
40 FUNCTION copy_child_records( p_new_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
41 p_new_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
42 p_person_id HZ_PARTIES.party_id%TYPE,
43 p_old_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
44 p_old_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
45 p_nominated_course_cd IGS_AD_PS_APPL.nominated_course_cd%TYPE,
46 p_start_dt DATE,
47 p_process VARCHAR2)
48 RETURN BOOLEAN ;
49
50 FUNCTION validate_offer_validations( p_person_id HZ_PARTIES.PARTY_ID%TYPE,
51 p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
52 p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
53 p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
54 p_old_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
55 p_old_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
56 p_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE,
57 p_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE,
58 p_fut_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
59 p_fut_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
60 p_fut_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
61 p_fut_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
62 p_start_dt DATE) RETURN BOOLEAN;
63
64 FUNCTION copy_entrycomp_qual_status( p_person_id HZ_PARTIES.PARTY_ID%TYPE,
65 p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
66 p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
67 p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
68 p_new_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
69 p_new_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ) RETURN BOOLEAN;
70 END igs_ad_val_acai_ftr_offer;