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

Line 73: p_cal_type IN igs_ca_inst.cal_type%TYPE,

69: ) ;
70:
71: -- function to validate the fund
72: FUNCTION validate_fund(p_fund IN igf_aw_fund_mast.fund_id%TYPE ,
73: p_cal_type IN igs_ca_inst.cal_type%TYPE,
74: p_sequence_number IN igs_ca_inst.sequence_number%TYPE,
75: p_err_message OUT NOCOPY VARCHAR2
76: ) RETURN BOOLEAN;
77:

Line 74: p_sequence_number IN igs_ca_inst.sequence_number%TYPE,

70:
71: -- function to validate the fund
72: FUNCTION validate_fund(p_fund IN igf_aw_fund_mast.fund_id%TYPE ,
73: p_cal_type IN igs_ca_inst.cal_type%TYPE,
74: p_sequence_number IN igs_ca_inst.sequence_number%TYPE,
75: p_err_message OUT NOCOPY VARCHAR2
76: ) RETURN BOOLEAN;
77:
78: -- function to validate award year

Line 79: FUNCTION validate_award_year(p_cal_type IN igs_ca_inst.cal_type%TYPE,

75: p_err_message OUT NOCOPY VARCHAR2
76: ) RETURN BOOLEAN;
77:
78: -- function to validate award year
79: FUNCTION validate_award_year(p_cal_type IN igs_ca_inst.cal_type%TYPE,
80: p_sequence_number IN igs_ca_inst.sequence_number%TYPE,
81: p_err_message OUT NOCOPY VARCHAR2
82: ) RETURN BOOLEAN;
83:

Line 80: p_sequence_number IN igs_ca_inst.sequence_number%TYPE,

76: ) RETURN BOOLEAN;
77:
78: -- function to validate award year
79: FUNCTION validate_award_year(p_cal_type IN igs_ca_inst.cal_type%TYPE,
80: p_sequence_number IN igs_ca_inst.sequence_number%TYPE,
81: p_err_message OUT NOCOPY VARCHAR2
82: ) RETURN BOOLEAN;
83:
84: -- procedure which rollover over the sponsor fund details

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 112: CURSOR c_igf_aw_cal_rel(cp_cal_type igs_ca_inst.cal_type%TYPE,

108:
109:
110: -- cursor to retrieve the succeeding year for the current award year passed as
111: -- parameter to it.
112: CURSOR c_igf_aw_cal_rel(cp_cal_type igs_ca_inst.cal_type%TYPE,
113: cp_seq_num igs_ca_inst.sequence_number%TYPE
114: ) IS
115: SELECT sc_cal_type , sc_sequence_number,
116: sc_alternate_code , sc_start_dt,

Line 113: cp_seq_num igs_ca_inst.sequence_number%TYPE

109:
110: -- cursor to retrieve the succeeding year for the current award year passed as
111: -- parameter to it.
112: CURSOR c_igf_aw_cal_rel(cp_cal_type igs_ca_inst.cal_type%TYPE,
113: cp_seq_num igs_ca_inst.sequence_number%TYPE
114: ) IS
115: SELECT sc_cal_type , sc_sequence_number,
116: sc_alternate_code , sc_start_dt,
117: sc_end_dt

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 407: p_cal_type IN igs_ca_inst.cal_type%TYPE,

403: END log_messages;
404:
405:
406: FUNCTION validate_fund(p_fund IN igf_aw_fund_mast.fund_id%TYPE ,
407: p_cal_type IN igs_ca_inst.cal_type%TYPE,
408: p_sequence_number IN igs_ca_inst.sequence_number%TYPE,
409: p_err_message OUT NOCOPY VARCHAR2
410: ) RETURN BOOLEAN IS
411: ------------------------------------------------------------------

Line 408: p_sequence_number IN igs_ca_inst.sequence_number%TYPE,

404:
405:
406: FUNCTION validate_fund(p_fund IN igf_aw_fund_mast.fund_id%TYPE ,
407: p_cal_type IN igs_ca_inst.cal_type%TYPE,
408: p_sequence_number IN igs_ca_inst.sequence_number%TYPE,
409: p_err_message OUT NOCOPY VARCHAR2
410: ) RETURN BOOLEAN IS
411: ------------------------------------------------------------------
412: --Created by : Sanil Madathil, Oracle IDC

Line 442: FUNCTION validate_award_year(p_cal_type IN igs_ca_inst.cal_type%TYPE,

438: RETURN (TRUE);
439: END validate_fund;
440:
441:
442: FUNCTION validate_award_year(p_cal_type IN igs_ca_inst.cal_type%TYPE,
443: p_sequence_number IN igs_ca_inst.sequence_number%TYPE,
444: p_err_message OUT NOCOPY VARCHAR2
445: ) RETURN BOOLEAN IS
446: ------------------------------------------------------------------

Line 443: p_sequence_number IN igs_ca_inst.sequence_number%TYPE,

439: END validate_fund;
440:
441:
442: FUNCTION validate_award_year(p_cal_type IN igs_ca_inst.cal_type%TYPE,
443: p_sequence_number IN igs_ca_inst.sequence_number%TYPE,
444: p_err_message OUT NOCOPY VARCHAR2
445: ) RETURN BOOLEAN IS
446: ------------------------------------------------------------------
447: --Created by : Sanil Madathil, Oracle IDC

Line 462: -- sequence number is present in igs_ca_inst table

458: --Who When What
459: ------------------------------------------------------------------
460:
461: -- cursor which validates whether the term calendar type and
462: -- sequence number is present in igs_ca_inst table
463: CURSOR c_igs_ca_inst(cp_cal_type igs_ca_inst.cal_type%TYPE,
464: cp_sequence_number igs_ca_inst.sequence_number%TYPE
465: ) IS
466: SELECT '1'

Line 463: CURSOR c_igs_ca_inst(cp_cal_type igs_ca_inst.cal_type%TYPE,

459: ------------------------------------------------------------------
460:
461: -- cursor which validates whether the term calendar type and
462: -- sequence number is present in igs_ca_inst table
463: CURSOR c_igs_ca_inst(cp_cal_type igs_ca_inst.cal_type%TYPE,
464: cp_sequence_number igs_ca_inst.sequence_number%TYPE
465: ) IS
466: SELECT '1'
467: FROM igs_ca_inst

Line 464: cp_sequence_number igs_ca_inst.sequence_number%TYPE

460:
461: -- cursor which validates whether the term calendar type and
462: -- sequence number is present in igs_ca_inst table
463: CURSOR c_igs_ca_inst(cp_cal_type igs_ca_inst.cal_type%TYPE,
464: cp_sequence_number igs_ca_inst.sequence_number%TYPE
465: ) IS
466: SELECT '1'
467: FROM igs_ca_inst
468: WHERE cal_type = cp_cal_type

Line 467: FROM igs_ca_inst

463: CURSOR c_igs_ca_inst(cp_cal_type igs_ca_inst.cal_type%TYPE,
464: cp_sequence_number igs_ca_inst.sequence_number%TYPE
465: ) IS
466: SELECT '1'
467: FROM igs_ca_inst
468: WHERE cal_type = cp_cal_type
469: AND sequence_number = cp_sequence_number;
470:
471: l_c_igs_ca_inst c_igs_ca_inst%ROWTYPE;

Line 471: l_c_igs_ca_inst c_igs_ca_inst%ROWTYPE;

467: FROM igs_ca_inst
468: WHERE cal_type = cp_cal_type
469: AND sequence_number = cp_sequence_number;
470:
471: l_c_igs_ca_inst c_igs_ca_inst%ROWTYPE;
472: BEGIN
473: OPEN c_igs_ca_inst(cp_cal_type => p_cal_type,
474: cp_sequence_number => p_sequence_number
475: ) ;

Line 473: OPEN c_igs_ca_inst(cp_cal_type => p_cal_type,

469: AND sequence_number = cp_sequence_number;
470:
471: l_c_igs_ca_inst c_igs_ca_inst%ROWTYPE;
472: BEGIN
473: OPEN c_igs_ca_inst(cp_cal_type => p_cal_type,
474: cp_sequence_number => p_sequence_number
475: ) ;
476: FETCH c_igs_ca_inst into l_c_igs_ca_inst ;
477: -- if records are not found for the passed calendar type and sequence number

Line 476: FETCH c_igs_ca_inst into l_c_igs_ca_inst ;

472: BEGIN
473: OPEN c_igs_ca_inst(cp_cal_type => p_cal_type,
474: cp_sequence_number => p_sequence_number
475: ) ;
476: FETCH c_igs_ca_inst into l_c_igs_ca_inst ;
477: -- if records are not found for the passed calendar type and sequence number
478: -- assign error message to out NOCOPY parameter and function returns false
479: IF c_igs_ca_inst%NOTFOUND THEN
480: CLOSE c_igs_ca_inst;

Line 479: IF c_igs_ca_inst%NOTFOUND THEN

475: ) ;
476: FETCH c_igs_ca_inst into l_c_igs_ca_inst ;
477: -- if records are not found for the passed calendar type and sequence number
478: -- assign error message to out NOCOPY parameter and function returns false
479: IF c_igs_ca_inst%NOTFOUND THEN
480: CLOSE c_igs_ca_inst;
481: p_err_message := 'IGS_GE_INVALID_VALUE';
482: RETURN (FALSE);
483: END IF;

Line 480: CLOSE c_igs_ca_inst;

476: FETCH c_igs_ca_inst into l_c_igs_ca_inst ;
477: -- if records are not found for the passed calendar type and sequence number
478: -- assign error message to out NOCOPY parameter and function returns false
479: IF c_igs_ca_inst%NOTFOUND THEN
480: CLOSE c_igs_ca_inst;
481: p_err_message := 'IGS_GE_INVALID_VALUE';
482: RETURN (FALSE);
483: END IF;
484: CLOSE c_igs_ca_inst;

Line 484: CLOSE c_igs_ca_inst;

480: CLOSE c_igs_ca_inst;
481: p_err_message := 'IGS_GE_INVALID_VALUE';
482: RETURN (FALSE);
483: END IF;
484: CLOSE c_igs_ca_inst;
485: p_err_message := NULL;
486: RETURN (TRUE);
487: END validate_award_year;
488:

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

Line 964: cp_cal_type igs_ca_inst.cal_type%TYPE,

960: --vvutukur 07-Mar-2003 Bug#2822725. Removed parameters p_cal_type,p_sequence_number and from the cursor c_igf_aw_fund_mast usage also.
961: ------------------------------------------------------------------
962: -- cursor to select fund code from igf_aw_fund_mast to get fund code for fund id parameter
963: CURSOR c_fund_mast(cp_fund_code igf_aw_fund_mast.fund_code%TYPE,
964: cp_cal_type igs_ca_inst.cal_type%TYPE,
965: cp_sequence_number igs_ca_inst.sequence_number%TYPE
966: ) IS
967: SELECT fmast.*
968: FROM igf_aw_fund_mast fmast ,

Line 965: cp_sequence_number igs_ca_inst.sequence_number%TYPE

961: ------------------------------------------------------------------
962: -- cursor to select fund code from igf_aw_fund_mast to get fund code for fund id parameter
963: CURSOR c_fund_mast(cp_fund_code igf_aw_fund_mast.fund_code%TYPE,
964: cp_cal_type igs_ca_inst.cal_type%TYPE,
965: cp_sequence_number igs_ca_inst.sequence_number%TYPE
966: ) IS
967: SELECT fmast.*
968: FROM igf_aw_fund_mast fmast ,
969: igf_aw_fund_cat fcat

Line 996: cp_cal_type igs_ca_inst.cal_type%TYPE,

992: l_c_igf_sp_stdnt_rel c_igf_sp_stdnt_rel%ROWTYPE;
993:
994:
995: CURSOR c_igf_ap_fa_base_rec(cp_person_id igs_pe_person.person_id%TYPE,
996: cp_cal_type igs_ca_inst.cal_type%TYPE,
997: cp_seq_num igs_ca_inst.sequence_number%TYPE
998: ) IS
999: SELECT base_id
1000: FROM igf_ap_fa_base_rec

Line 997: cp_seq_num igs_ca_inst.sequence_number%TYPE

993:
994:
995: CURSOR c_igf_ap_fa_base_rec(cp_person_id igs_pe_person.person_id%TYPE,
996: cp_cal_type igs_ca_inst.cal_type%TYPE,
997: cp_seq_num igs_ca_inst.sequence_number%TYPE
998: ) IS
999: SELECT base_id
1000: FROM igf_ap_fa_base_rec
1001: WHERE person_id = cp_person_id