[Home] [Help]
PACKAGE: APPS.IGF_AP_OSS_INTR_DTLS
Source
1 PACKAGE igf_ap_oss_intr_dtls AUTHID CURRENT_USER AS
2 /* $Header: IGFAP20S.pls 115.12 2003/09/04 05:52:12 rasahoo ship $ */
3
4 -- rasahoo 01-Sep-2003 modified data types , replaced igf_ap_fa_base_h_all
5 -- as part of FA-114(Obsoletion of FA base record History)
6 -- npalanis 23-OCT-2002 Bug : 2608360
7 -- residency_status_id references are changed to residency_status_cd
8 -- IGS_AD_ATHLETICS_V references changed to igs_pe_athletic_prg_v
9 --
10 --
11 -- this is the declaration of ref cursor which will be returned from the
12 -- get_details procedure
13 -- this ref cursor 'oss_dtl_rec' contains oss data from
14 --
15 -- 1. IGS_AD_APPL
16 -- 2. IGS_AD_APPL_STAT
17 -- 3. IGS_PE_TYP_INSTANCES_V
18 -- 4. IGS_AP_PRCS_CAT
19 -- 5. IGS_AD_PS_APPL_INST
20 -- 6. IGS_AD_OU_STAT
21 -- 7. IGS_AD_OFR_RESP_STAT
22 -- 8. IGS_AD_ATHLETICS_V
23 -- 9. IGS_AD_FEE_STAT
24 -- 10. IGS_PS_VER
25 -- 11. IGS_EN_STDNT_PS_ATT
26 -- 12. IGS_CA_INST / IGS_CA_TYPE
27 --
28
29 -- Note : give all the cols %TYPE or DataType --
30
31 TYPE oss_dtl_rec IS RECORD (
32 adm_appl_status igs_ad_appl_all.adm_appl_status%TYPE,
33 s_adm_appl_status igs_ad_appl_stat.s_adm_appl_status%TYPE,
34 appl_dt igs_ad_appl_all.appl_dt%TYPE,
35 class_standing igs_pr_css_class_std_v.class_standing%TYPE,
36 -- NULL till DLD Build for DLD Class Standing i1a
37 cur_enrol_credit_points NUMBER(15,2),
38 admission_cat igs_ad_appl_all.admission_cat%TYPE,
39 s_admission_process_type igs_ad_prcs_cat_all.s_admission_process_type%TYPE,
40 prog_attempt VARCHAR2(100),
41 -- igs_ad_ps_appl_inst.course_cd ||<space>||igs_ad_ps_appl_inst.crv_version_number%TYPE,
42 prog_att_course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE,
43 prog_att_ver_num igs_ad_ps_appl_inst_all.crv_version_number%TYPE,
44 prog_att_attend_mode igs_ad_ps_appl_inst_all.attendance_mode%TYPE,
45 prog_att_attend_type igs_ad_ps_appl_inst_all.attendance_type%TYPE,
46 adm_outcome_status igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE,
47 s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE,
48 decision_date igs_ad_ps_appl_inst_all.decision_date%TYPE,
49 adm_offer_resp_status igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,
50 s_adm_offer_resp_status igs_ad_ofr_resp_stat.s_adm_offer_resp_status%TYPE,
51 actual_response_date igs_ad_ps_appl_inst_all.actual_response_dt%TYPE,
52 adm_fee_status igs_ad_appl_all.adm_fee_status%TYPE,
53 s_adm_fee_status igs_ad_fee_stat.s_adm_fee_status%TYPE,
54 sp_program_1 igs_ad_appl. spcl_grp_1%TYPE,
55 -- sp_program_1 will be NULL till Admission DLD Build
56 sp_program_2 igs_ad_appl. spcl_grp_2%TYPE,
57 -- sp_program_2 will be NULL till Admission DLD Build
58 entry_level igs_ad_ps_appl_inst. entry_level%TYPE,
59 -- entry_level will be NULL till Admission DLD Build
60 anticip_compl_date DATE,
61 academic_index igs_ad_ps_appl_inst_all.academic_index%TYPE,
62 adm_org_unit_cd igs_ps_ver_all.responsible_org_unit_cd%TYPE,
63 final_unit_set VARCHAR2(100),
64 -- igs_ad_ps_appl_inst.unit_set_cd||<space>||igs_ad_ps_appl_inst.us_version_number%TYPE,
65 final_unit_set_course_cd igs_ad_ps_appl_inst_all.unit_set_cd%TYPE,
66 final_unit_set_ver_num igs_ad_ps_appl_inst_all.us_version_number%TYPE,
67 prog_att_start_dt igs_en_stdnt_ps_att_all.commencement_dt%TYPE,
68 transfered VARCHAR2(30),
69 -- transfered will be NULL as No Mapping exists for this
70 multiple_ad_appl VARCHAR2(10),
71 atb VARCHAR2(30),
72 enrolled_term igs_ca_inst_all.alternate_code%TYPE,
73 enrl_load_cal_type igs_ca_inst_all.cal_type%TYPE,
74 enrl_load_seq_num igs_ca_inst_all. sequence_number%TYPE,
75 sap_evaluation_date DATE, -- NULL
76 sap_selected_flag VARCHAR2(30), -- NULL
77 multiple_prog_d VARCHAR2(10),
78 enrl_primary_program VARCHAR2(100),
79 --igs_en_stdnt_ps_att.course_cd||<space>||igs_en_stdnt_ps_att.version_number%TYPE,
80 enrl_primary_prog_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
81 enrl_primary_prog_ver_num igs_en_stdnt_ps_att_all.version_number%TYPE,
82 enrl_program_type igs_ps_ver_all.course_type%TYPE,
83 enrl_unit_set VARCHAR2(10), -- NULL Not Mapped
84 enrl_uset_course_cd igs_as_su_setatmpt.course_cd%TYPE, -- NULL Not Mapped
85 enrl_uset_ver_num igs_as_su_setatmpt.us_version_number%TYPE, -- NULL Not Mapped
86 enrl_course_attempt_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
87 derived_attend_type igs_en_stdnt_ps_att_all.derived_att_type%TYPE,
88 current_gpa NUMBER, -- NULL Not Mapped
89 cumulative_gpa NUMBER, -- NULL Not Mapped
90 acheived_cr_pts NUMBER, -- NULL Not Mapped
91 pred_class_standing VARCHAR2(60), -- NULL ; till DLD Class Standing i1a build
92 enrl_org_unit_cd igs_ps_ver_all.responsible_org_unit_cd%TYPE,
93 enrl_attend_mode igs_en_stdnt_ps_att_all.attendance_mode%TYPE,
94 enrl_location_cd igs_en_stdnt_ps_att_all.location_cd%TYPE,
95 enrl_total_cp NUMBER(15,2),
96 enrl_cuml_cp NUMBER(15,2),
97 enrl_cuml_trans_cp NUMBER(15,2),
98 admission_appl_number igs_ad_appl_all. admission_appl_number%TYPE
99 );
100
101 --
102 -- end of declaration for oss_dtl_rec Record
103 --
104
105 TYPE oss_dtl_cur IS REF CURSOR RETURN oss_dtl_rec; -- ref cursor of the record type 'oss_dtl_rec'
106
107 --
108 -- this procedure which will be called from other packages / plds
109 -- the parameters passed to this procedure are
110 -- person_id IN
111 -- awd_cal_type IN
112 -- awd_seq_num IN
113 -- ref cursor variable OUT NOCOPY
114 -- all the packages and pls which will be calling this package procedure
115 -- must decalre a record type variable as defined above.
116 --
117
118 --Added the last six parameters as per the FACCR004 in Disbursement Build Jul 2002
119
120 PROCEDURE get_details (p_person_id IN igs_ad_appl_all.person_id%TYPE,
121 p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,
122 p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
123 lv_oss_dtl_rec IN OUT NOCOPY oss_dtl_cur
124 ) ;
125
126 END igf_ap_oss_intr_dtls;