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_AP_INST_APP dependencies on IGS_CA_INST_ALL

Line 207: p_cal_type igs_ca_inst_all.cal_type%TYPE,

203: END update_app_status;
204:
205:
206: PROCEDURE update_Ant_Data_For_All_Terms (p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
207: p_cal_type igs_ca_inst_all.cal_type%TYPE,
208: p_seq_number igs_ca_inst_all.sequence_number%TYPE,
209: p_ant_data_column VARCHAR2,
210: p_ant_data_value VARCHAR2,
211: x_return_status OUT NOCOPY VARCHAR2,

Line 208: p_seq_number igs_ca_inst_all.sequence_number%TYPE,

204:
205:
206: PROCEDURE update_Ant_Data_For_All_Terms (p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
207: p_cal_type igs_ca_inst_all.cal_type%TYPE,
208: p_seq_number igs_ca_inst_all.sequence_number%TYPE,
209: p_ant_data_column VARCHAR2,
210: p_ant_data_value VARCHAR2,
211: x_return_status OUT NOCOPY VARCHAR2,
212: p_override_flag VARCHAR2

Line 229: CURSOR c_all_terms(cp_sup_cal_type igs_ca_inst_all.cal_type%TYPE,

225: --Who When What
226: -------------------------------------------------------------------
227:
228: -- cursor to fetch the terms withinn an award year
229: CURSOR c_all_terms(cp_sup_cal_type igs_ca_inst_all.cal_type%TYPE,
230: cp_sup_seq_number igs_ca_inst_all.sequence_number%TYPE)
231: IS
232: SELECT SUB_CAL_TYPE, SUB_CI_SEQUENCE_NUMBER
233: FROM IGS_CA_INST_REL rel, IGS_CA_TYPE typ

Line 230: cp_sup_seq_number igs_ca_inst_all.sequence_number%TYPE)

226: -------------------------------------------------------------------
227:
228: -- cursor to fetch the terms withinn an award year
229: CURSOR c_all_terms(cp_sup_cal_type igs_ca_inst_all.cal_type%TYPE,
230: cp_sup_seq_number igs_ca_inst_all.sequence_number%TYPE)
231: IS
232: SELECT SUB_CAL_TYPE, SUB_CI_SEQUENCE_NUMBER
233: FROM IGS_CA_INST_REL rel, IGS_CA_TYPE typ
234: WHERE rel.SUP_CAL_TYPE = cp_sup_cal_type

Line 243: cp_ld_cal_type igs_ca_inst_all.cal_type%TYPE,

239: l_get_cal_typ_seq_num c_all_terms%ROWTYPE;
240:
241: -- to fetch all the anticipated value for the given base_id and award year
242: CURSOR c_get_ant_data(cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
243: cp_ld_cal_type igs_ca_inst_all.cal_type%TYPE,
244: cp_ld_seq_number igs_ca_inst_all.sequence_number%TYPE
245: )
246: IS
247: SELECT *

Line 244: cp_ld_seq_number igs_ca_inst_all.sequence_number%TYPE

240:
241: -- to fetch all the anticipated value for the given base_id and award year
242: CURSOR c_get_ant_data(cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
243: cp_ld_cal_type igs_ca_inst_all.cal_type%TYPE,
244: cp_ld_seq_number igs_ca_inst_all.sequence_number%TYPE
245: )
246: IS
247: SELECT *
248: FROM IGF_AP_FA_ANT_DATA

Line 394: p_ld_cal_type igs_ca_inst_all.cal_type%TYPE,

390:
391:
392:
393: PROCEDURE update_Ant_Data_a_Term(p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
394: p_ld_cal_type igs_ca_inst_all.cal_type%TYPE,
395: p_ld_seq_number igs_ca_inst_all.sequence_number%TYPE,
396: p_ant_data_column VARCHAR2,
397: p_ant_data_value VARCHAR2,
398: x_return_status OUT NOCOPY VARCHAR2,

Line 395: p_ld_seq_number igs_ca_inst_all.sequence_number%TYPE,

391:
392:
393: PROCEDURE update_Ant_Data_a_Term(p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
394: p_ld_cal_type igs_ca_inst_all.cal_type%TYPE,
395: p_ld_seq_number igs_ca_inst_all.sequence_number%TYPE,
396: p_ant_data_column VARCHAR2,
397: p_ant_data_value VARCHAR2,
398: x_return_status OUT NOCOPY VARCHAR2,
399: p_override_flag VARCHAR2

Line 418: cp_ld_cal_type igs_ca_inst_all.cal_type%TYPE,

414:
415:
416: -- to fetch all the anticipated value for the given base_id and award year
417: CURSOR c_get_ant_data(cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
418: cp_ld_cal_type igs_ca_inst_all.cal_type%TYPE,
419: cp_ld_seq_number igs_ca_inst_all.sequence_number%TYPE
420: )
421: IS
422: SELECT *

Line 419: cp_ld_seq_number igs_ca_inst_all.sequence_number%TYPE

415:
416: -- to fetch all the anticipated value for the given base_id and award year
417: CURSOR c_get_ant_data(cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
418: cp_ld_cal_type igs_ca_inst_all.cal_type%TYPE,
419: cp_ld_seq_number igs_ca_inst_all.sequence_number%TYPE
420: )
421: IS
422: SELECT *
423: FROM IGF_AP_FA_ANT_DATA

Line 592: FROM igs_ca_inst_all ca,

588: CURSOR c_award_year(
589: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
590: ) IS
591: SELECT ca.alternate_code
592: FROM igs_ca_inst_all ca,
593: igf_ap_fa_base_rec_all fa
594: WHERE fa.base_id = cp_base_id
595: AND fa.ci_cal_type = ca.cal_type
596: AND fa.ci_sequence_number = ca.sequence_number;

Line 597: l_alternate_code igs_ca_inst_all.alternate_code%TYPE;

593: igf_ap_fa_base_rec_all fa
594: WHERE fa.base_id = cp_base_id
595: AND fa.ci_cal_type = ca.cal_type
596: AND fa.ci_sequence_number = ca.sequence_number;
597: l_alternate_code igs_ca_inst_all.alternate_code%TYPE;
598:
599:
600: -- Get Institutional application name
601: CURSOR c_application_name(