APPS.IGF_AP_OSS_INTR_DTLS dependencies on IGS_AD_APPL_ALL

Line 32: adm_appl_status igs_ad_appl_all.adm_appl_status%TYPE,

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

Line 34: appl_dt igs_ad_appl_all.appl_dt%TYPE,

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,

Line 38: admission_cat igs_ad_appl_all.admission_cat%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 ||||igs_ad_ps_appl_inst.crv_version_number%TYPE,
42: prog_att_course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE,

Line 52: adm_fee_status igs_ad_appl_all.adm_fee_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,

Line 98: admission_appl_number igs_ad_appl_all. admission_appl_number%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

Line 120: PROCEDURE get_details (p_person_id IN igs_ad_appl_all.person_id%TYPE,

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: ) ;