eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_SP_ROLLOVER dependencies on IGS_CA_INST_ALL

Line 85: PROCEDURE sponsor_fund_rollover ( p_sc_cal_type IN igs_ca_inst_all.cal_type%TYPE,

81: p_err_message OUT NOCOPY VARCHAR2
82: ) RETURN BOOLEAN;
83:
84: -- procedure which rollover over the sponsor fund details
85: PROCEDURE sponsor_fund_rollover ( p_sc_cal_type IN igs_ca_inst_all.cal_type%TYPE,
86: p_sc_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
87: p_fund IN igf_aw_fund_mast_all.fund_id%TYPE
88: ) ;
89:

Line 86: p_sc_seq_num IN igs_ca_inst_all.sequence_number%TYPE,

82: ) RETURN BOOLEAN;
83:
84: -- procedure which rollover over the sponsor fund details
85: PROCEDURE sponsor_fund_rollover ( p_sc_cal_type IN igs_ca_inst_all.cal_type%TYPE,
86: p_sc_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
87: p_fund IN igf_aw_fund_mast_all.fund_id%TYPE
88: ) ;
89:
90: -- procedure which rollover over the sponsor student relation

Line 91: PROCEDURE sponsor_student_rollover ( p_sc_cal_type IN igs_ca_inst_all.cal_type%TYPE,

87: p_fund IN igf_aw_fund_mast_all.fund_id%TYPE
88: ) ;
89:
90: -- procedure which rollover over the sponsor student relation
91: PROCEDURE sponsor_student_rollover ( p_sc_cal_type IN igs_ca_inst_all.cal_type%TYPE,
92: p_sc_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
93: p_fund IN igf_aw_fund_mast_all.fund_id%TYPE
94: );
95:

Line 92: p_sc_seq_num IN igs_ca_inst_all.sequence_number%TYPE,

88: ) ;
89:
90: -- procedure which rollover over the sponsor student relation
91: PROCEDURE sponsor_student_rollover ( p_sc_cal_type IN igs_ca_inst_all.cal_type%TYPE,
92: p_sc_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
93: p_fund IN igf_aw_fund_mast_all.fund_id%TYPE
94: );
95:
96: -- Forward declaration of functions/procedures ends here

Line 170: l_cal_type igs_ca_inst_all.cal_type%TYPE;

166: l_c_igs_lookups c_igs_lookups%ROWTYPE;
167:
168: l_ans BOOLEAN := FALSE ;
169: l_appl_name VARCHAR2(30) := NULL;
170: l_cal_type igs_ca_inst_all.cal_type%TYPE;
171: l_sequence_number igs_ca_inst_all.sequence_number%TYPE;
172: l_sc_cal_type igs_ca_inst_all.cal_type%TYPE;
173: l_sc_sequence_number igs_ca_inst_all.sequence_number%TYPE;
174: l_err_message VARCHAR2(30);

Line 171: l_sequence_number igs_ca_inst_all.sequence_number%TYPE;

167:
168: l_ans BOOLEAN := FALSE ;
169: l_appl_name VARCHAR2(30) := NULL;
170: l_cal_type igs_ca_inst_all.cal_type%TYPE;
171: l_sequence_number igs_ca_inst_all.sequence_number%TYPE;
172: l_sc_cal_type igs_ca_inst_all.cal_type%TYPE;
173: l_sc_sequence_number igs_ca_inst_all.sequence_number%TYPE;
174: l_err_message VARCHAR2(30);
175: -- cursor variable for c_igf_aw_cal_rel

Line 172: l_sc_cal_type igs_ca_inst_all.cal_type%TYPE;

168: l_ans BOOLEAN := FALSE ;
169: l_appl_name VARCHAR2(30) := NULL;
170: l_cal_type igs_ca_inst_all.cal_type%TYPE;
171: l_sequence_number igs_ca_inst_all.sequence_number%TYPE;
172: l_sc_cal_type igs_ca_inst_all.cal_type%TYPE;
173: l_sc_sequence_number igs_ca_inst_all.sequence_number%TYPE;
174: l_err_message VARCHAR2(30);
175: -- cursor variable for c_igf_aw_cal_rel
176: l_c_igf_aw_cal_rel c_igf_aw_cal_rel%ROWTYPE;

Line 173: l_sc_sequence_number igs_ca_inst_all.sequence_number%TYPE;

169: l_appl_name VARCHAR2(30) := NULL;
170: l_cal_type igs_ca_inst_all.cal_type%TYPE;
171: l_sequence_number igs_ca_inst_all.sequence_number%TYPE;
172: l_sc_cal_type igs_ca_inst_all.cal_type%TYPE;
173: l_sc_sequence_number igs_ca_inst_all.sequence_number%TYPE;
174: l_err_message VARCHAR2(30);
175: -- cursor variable for c_igf_aw_cal_rel
176: l_c_igf_aw_cal_rel c_igf_aw_cal_rel%ROWTYPE;
177: -- cursor variable for c_igf_aw_fund_mast

Line 490: PROCEDURE sponsor_fund_rollover ( p_sc_cal_type IN igs_ca_inst_all.cal_type%TYPE,

486: RETURN (TRUE);
487: END validate_award_year;
488:
489: -- procedure which rollover over the sponsor fund details
490: PROCEDURE sponsor_fund_rollover ( p_sc_cal_type IN igs_ca_inst_all.cal_type%TYPE,
491: p_sc_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
492: p_fund IN igf_aw_fund_mast_all.fund_id%TYPE
493: ) IS
494: ------------------------------------------------------------------

Line 491: p_sc_seq_num IN igs_ca_inst_all.sequence_number%TYPE,

487: END validate_award_year;
488:
489: -- procedure which rollover over the sponsor fund details
490: PROCEDURE sponsor_fund_rollover ( p_sc_cal_type IN igs_ca_inst_all.cal_type%TYPE,
491: p_sc_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
492: p_fund IN igf_aw_fund_mast_all.fund_id%TYPE
493: ) IS
494: ------------------------------------------------------------------
495: --Created by : Sanil Madathil, Oracle IDC

Line 935: PROCEDURE sponsor_student_rollover ( p_sc_cal_type IN igs_ca_inst_all.cal_type%TYPE,

931:
932: END sponsor_fund_rollover;
933:
934: -- procedure which rollover over the sponsor student relation
935: PROCEDURE sponsor_student_rollover ( p_sc_cal_type IN igs_ca_inst_all.cal_type%TYPE,
936: p_sc_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
937: p_fund IN igf_aw_fund_mast_all.fund_id%TYPE
938: ) IS
939: ------------------------------------------------------------------

Line 936: p_sc_seq_num IN igs_ca_inst_all.sequence_number%TYPE,

932: END sponsor_fund_rollover;
933:
934: -- procedure which rollover over the sponsor student relation
935: PROCEDURE sponsor_student_rollover ( p_sc_cal_type IN igs_ca_inst_all.cal_type%TYPE,
936: p_sc_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
937: p_fund IN igf_aw_fund_mast_all.fund_id%TYPE
938: ) IS
939: ------------------------------------------------------------------
940: --Created by : Sanil Madathil, Oracle IDC