[Home] [Help]
PACKAGE: APPS.IGF_AP_OSS_INTEGR
Source
1 PACKAGE igf_ap_oss_integr AS
2 /* $Header: IGFAP19S.pls 120.0 2005/06/01 14:41:58 appldev noship $ */
3
4 PROCEDURE get_pe_visa_type(p_person_id IN hz_parties.party_id%TYPE,
5 p_visa_type OUT NOCOPY igs_pe_visa.visa_type%TYPE,
6 p_visa_desc OUT NOCOPY fnd_lookup_values.meaning%TYPE,
7 p_multiple OUT NOCOPY VARCHAR2);
8
9
10 PROCEDURE get_pe_active_holds(p_person_id IN hz_parties.party_id%TYPE,
11 p_encumb_type OUT NOCOPY VARCHAR2,
12 p_encumb_desc OUT NOCOPY VARCHAR2,
13 p_multiple OUT NOCOPY VARCHAR2);
14
15
16 PROCEDURE get_pe_citizenship_stat(p_person_id IN hz_parties.party_id%TYPE,
17 p_citizenship_stat OUT NOCOPY igs_lookups_view.lookup_code%TYPE,
18 p_citizenship_desc OUT NOCOPY igs_lookups_view.meaning%TYPE);
19
20
21 PROCEDURE get_pe_mil_service_type(p_person_id IN hz_parties.party_id%TYPE,
22 p_mil_service_type OUT NOCOPY igs_lookups_view.lookup_code%TYPE,
23 p_mil_service_desc OUT NOCOPY igs_lookups_view.meaning%TYPE,
24 p_multiple OUT NOCOPY VARCHAR2);
25
26
27 PROCEDURE get_acad_cal_from_awd(p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,
28 p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
29 p_acad_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
30 p_acad_seq_num OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,
31 p_acad_alt_code OUT NOCOPY igs_ca_inst_all.alternate_code%TYPE);
32
33 PROCEDURE get_awd_cal_from_acad(p_acad_cal_type IN igs_ca_inst_all.cal_type%TYPE,
34 p_acad_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
35 p_awd_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
36 p_awd_seq_num OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,
37 p_awd_alt_code OUT NOCOPY igs_ca_inst_all.alternate_code%TYPE);
38
39
40 --Made the p_adm_appl_number,p_course-cd,p_crv_version_number as IN OUT NOCOPY parameters From IN
41 --as per the FACCR001 DLD
42
43 PROCEDURE get_adm_appl_details( p_person_id IN hz_parties.party_id%TYPE,
44 p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,
45 p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
46 p_ad_appl_row_id OUT NOCOPY ROWID,
47 p_ad_prog_appl_row_id OUT NOCOPY ROWID,
48 p_adm_appl_number IN OUT NOCOPY igs_ad_appl_all.admission_appl_number%TYPE,
49 p_course_cd IN OUT NOCOPY igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
50 p_crv_version_number IN OUT NOCOPY igs_ad_ps_appl_inst_all.sequence_number%TYPE,
51 p_adm_offer_resp_stat OUT NOCOPY igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,
52 p_adm_outcome_stat OUT NOCOPY igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE,
53 p_adm_appl_status OUT NOCOPY igs_ad_appl_all.adm_appl_status%TYPE,
54 p_multiple OUT NOCOPY VARCHAR2 );
55
56
57 FUNCTION get_adm_appl_val(p_person_id IN hz_parties.party_id%TYPE,
58 p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,
59 p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE)
60 RETURN ROWID;
61
62 FUNCTION get_adm_prog_appl_val(p_person_id IN hz_parties.party_id%TYPE,
63 p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,
64 p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE)
65 RETURN ROWID;
66
67 PRAGMA RESTRICT_REFERENCES (get_pe_active_holds, WNDS);
68 PRAGMA RESTRICT_REFERENCES (get_pe_visa_type, WNDS);
69 PRAGMA RESTRICT_REFERENCES (get_pe_citizenship_stat, WNDS);
70 PRAGMA RESTRICT_REFERENCES (get_pe_mil_service_type, WNDS,WNPS,RNPS);
71 --PRAGMA RESTRICT_REFERENCES (get_acad_cal_from_awd, WNDS,WNPS,RNPS);
72 --PRAGMA RESTRICT_REFERENCES (get_awd_cal_from_acad, WNDS,WNPS,RNPS);
73 PRAGMA RESTRICT_REFERENCES (get_adm_appl_details, WNDS,WNPS,RNPS);
74 PRAGMA RESTRICT_REFERENCES (get_adm_appl_val, WNDS,WNPS,RNPS);
75 PRAGMA RESTRICT_REFERENCES (get_adm_prog_appl_val, WNDS,WNPS,RNPS);
76
77 END igf_ap_oss_integr;