APPS.IGF_AP_OSS_INTR_DTLS dependencies on IGS_CA_INST_ALL

Line 72: enrolled_term igs_ca_inst_all.alternate_code%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

Line 73: enrl_load_cal_type igs_ca_inst_all.cal_type%TYPE,

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),

Line 74: enrl_load_seq_num igs_ca_inst_all. sequence_number%TYPE,

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),

Line 121: p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,

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:

Line 122: p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE,

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;