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_GR_GEN dependencies on IGS_CA_INST

Line 146: -- Removed cursor which picks the year part of end date from IGS_CA_INST for the calendar instance.

142: --mesriniv 22-jul-2002 Cycle Year should be 4 chars starting from 6th char in File Version.
143: -- Eg If File Version is 2002-2003 then cycle year is 2003
144: -- Cursor used to pick the year part of end date from Cal Instance for award year
145: -- may not always return the ending year.
146: -- Removed cursor which picks the year part of end date from IGS_CA_INST for the calendar instance.
147:
148: l_ver_num VARCHAR2(30); -- Flat File Version Number
149: l_cycle_year VARCHAR2(4);
150:

Line 204: FUNCTION get_alt_code ( p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,

200:
201: END disb_has_adj;
202:
203:
204: FUNCTION get_alt_code ( p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
205: p_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE)
206: RETURN VARCHAR2
207: IS
208: --------------------------------------------------------------------------------------------

Line 205: p_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE)

201: END disb_has_adj;
202:
203:
204: FUNCTION get_alt_code ( p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
205: p_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE)
206: RETURN VARCHAR2
207: IS
208: --------------------------------------------------------------------------------------------
209: --

Line 216: CURSOR cur_alt_code ( p_ci_cal_type igs_ca_inst_all.cal_type%TYPE,

212: -- Purpose : Returns alternate code of calendar
213: --
214: --------------------------------------------------------------------------------------------
215:
216: CURSOR cur_alt_code ( p_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
217: p_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE)
218:
219: IS
220: SELECT

Line 217: p_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE)

213: --
214: --------------------------------------------------------------------------------------------
215:
216: CURSOR cur_alt_code ( p_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
217: p_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE)
218:
219: IS
220: SELECT
221: alternate_code

Line 223: igs_ca_inst

219: IS
220: SELECT
221: alternate_code
222: FROM
223: igs_ca_inst
224: WHERE
225: cal_type = p_ci_cal_type AND
226: sequence_number = p_ci_sequence_number;
227:

Line 253: FUNCTION get_calendar_desc ( p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,

249:
250:
251: END get_alt_code;
252:
253: FUNCTION get_calendar_desc ( p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
254: p_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE)
255: RETURN VARCHAR2
256: IS
257: --------------------------------------------------------------------------------------------

Line 254: p_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE)

250:
251: END get_alt_code;
252:
253: FUNCTION get_calendar_desc ( p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
254: p_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE)
255: RETURN VARCHAR2
256: IS
257: --------------------------------------------------------------------------------------------
258: --

Line 265: CURSOR cur_cal_desc ( p_ci_cal_type igs_ca_inst_all.cal_type%TYPE,

261: -- Purpose : Returns calendar description.
262: --
263: --------------------------------------------------------------------------------------------
264:
265: CURSOR cur_cal_desc ( p_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
266: p_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE)
267:
268: IS
269: SELECT

Line 266: p_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE)

262: --
263: --------------------------------------------------------------------------------------------
264:
265: CURSOR cur_cal_desc ( p_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
266: p_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE)
267:
268: IS
269: SELECT
270: description,

Line 273: igs_ca_inst

269: SELECT
270: description,
271: alternate_code
272: FROM
273: igs_ca_inst
274: WHERE
275: cal_type = p_ci_cal_type AND
276: sequence_number = p_ci_sequence_number;
277:

Line 1923: PROCEDURE get_def_awd_year(p_alternate_code OUT NOCOPY igs_ca_inst_all.alternate_code%TYPE,

1919:
1920: END update_item_dist;
1921:
1922:
1923: PROCEDURE get_def_awd_year(p_alternate_code OUT NOCOPY igs_ca_inst_all.alternate_code%TYPE,
1924: p_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
1925: p_sequence_number OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,
1926: p_start_date OUT NOCOPY igs_ca_inst_all.start_dt%TYPE,
1927: p_end_date OUT NOCOPY igs_ca_inst_all.end_dt%TYPE,

Line 1924: p_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,

1920: END update_item_dist;
1921:
1922:
1923: PROCEDURE get_def_awd_year(p_alternate_code OUT NOCOPY igs_ca_inst_all.alternate_code%TYPE,
1924: p_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
1925: p_sequence_number OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,
1926: p_start_date OUT NOCOPY igs_ca_inst_all.start_dt%TYPE,
1927: p_end_date OUT NOCOPY igs_ca_inst_all.end_dt%TYPE,
1928: p_err_msg OUT NOCOPY VARCHAR2

Line 1925: p_sequence_number OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,

1921:
1922:
1923: PROCEDURE get_def_awd_year(p_alternate_code OUT NOCOPY igs_ca_inst_all.alternate_code%TYPE,
1924: p_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
1925: p_sequence_number OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,
1926: p_start_date OUT NOCOPY igs_ca_inst_all.start_dt%TYPE,
1927: p_end_date OUT NOCOPY igs_ca_inst_all.end_dt%TYPE,
1928: p_err_msg OUT NOCOPY VARCHAR2
1929: )

Line 1926: p_start_date OUT NOCOPY igs_ca_inst_all.start_dt%TYPE,

1922:
1923: PROCEDURE get_def_awd_year(p_alternate_code OUT NOCOPY igs_ca_inst_all.alternate_code%TYPE,
1924: p_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
1925: p_sequence_number OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,
1926: p_start_date OUT NOCOPY igs_ca_inst_all.start_dt%TYPE,
1927: p_end_date OUT NOCOPY igs_ca_inst_all.end_dt%TYPE,
1928: p_err_msg OUT NOCOPY VARCHAR2
1929: )
1930:

Line 1927: p_end_date OUT NOCOPY igs_ca_inst_all.end_dt%TYPE,

1923: PROCEDURE get_def_awd_year(p_alternate_code OUT NOCOPY igs_ca_inst_all.alternate_code%TYPE,
1924: p_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
1925: p_sequence_number OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,
1926: p_start_date OUT NOCOPY igs_ca_inst_all.start_dt%TYPE,
1927: p_end_date OUT NOCOPY igs_ca_inst_all.end_dt%TYPE,
1928: p_err_msg OUT NOCOPY VARCHAR2
1929: )
1930:
1931: IS

Line 2676: PROCEDURE get_base_id(p_cal_type IN igs_ca_inst_all.cal_type%TYPE,

2672: --
2673: -- Routine to fetch base id
2674: --
2675:
2676: PROCEDURE get_base_id(p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2677: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
2678: p_person_id IN igf_ap_fa_base_rec_all.person_id%TYPE,
2679: p_base_id OUT NOCOPY igf_ap_fa_base_rec_all.base_id%TYPE,
2680: p_err_msg OUT NOCOPY VARCHAR2

Line 2677: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,

2673: -- Routine to fetch base id
2674: --
2675:
2676: PROCEDURE get_base_id(p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2677: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
2678: p_person_id IN igf_ap_fa_base_rec_all.person_id%TYPE,
2679: p_base_id OUT NOCOPY igf_ap_fa_base_rec_all.base_id%TYPE,
2680: p_err_msg OUT NOCOPY VARCHAR2
2681: )

Line 2689: CURSOR cur_get_base (p_cal_type igs_ca_inst_all.cal_type%TYPE,

2685: --
2686: -- Cursor to get base id
2687: --
2688:
2689: CURSOR cur_get_base (p_cal_type igs_ca_inst_all.cal_type%TYPE,
2690: p_sequence_number igs_ca_inst_all.sequence_number%TYPE,
2691: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE)
2692: IS
2693: SELECT

Line 2690: p_sequence_number igs_ca_inst_all.sequence_number%TYPE,

2686: -- Cursor to get base id
2687: --
2688:
2689: CURSOR cur_get_base (p_cal_type igs_ca_inst_all.cal_type%TYPE,
2690: p_sequence_number igs_ca_inst_all.sequence_number%TYPE,
2691: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE)
2692: IS
2693: SELECT
2694: base_id

Line 2992: FUNCTION get_rep_pell_from_ope(p_cal_type igs_ca_inst_all.cal_type%TYPE,

2988:
2989: END get_min_disb_number;
2990:
2991:
2992: FUNCTION get_rep_pell_from_ope(p_cal_type igs_ca_inst_all.cal_type%TYPE,
2993: p_seq_num igs_ca_inst_all.sequence_number%TYPE,
2994: p_ope_cd igf_gr_report_pell.ope_cd%TYPE)
2995: RETURN VARCHAR2
2996: AS

Line 2993: p_seq_num igs_ca_inst_all.sequence_number%TYPE,

2989: END get_min_disb_number;
2990:
2991:
2992: FUNCTION get_rep_pell_from_ope(p_cal_type igs_ca_inst_all.cal_type%TYPE,
2993: p_seq_num igs_ca_inst_all.sequence_number%TYPE,
2994: p_ope_cd igf_gr_report_pell.ope_cd%TYPE)
2995: RETURN VARCHAR2
2996: AS
2997:

Line 3025: FUNCTION get_rep_pell_from_att(p_cal_type igs_ca_inst_all.cal_type%TYPE,

3021: END IF;
3022:
3023: END get_rep_pell_from_ope;
3024:
3025: FUNCTION get_rep_pell_from_att(p_cal_type igs_ca_inst_all.cal_type%TYPE,
3026: p_seq_num igs_ca_inst_all.sequence_number%TYPE,
3027: p_att_pell igf_gr_attend_pell.attending_pell_cd%TYPE)
3028: RETURN VARCHAR2
3029: AS

Line 3026: p_seq_num igs_ca_inst_all.sequence_number%TYPE,

3022:
3023: END get_rep_pell_from_ope;
3024:
3025: FUNCTION get_rep_pell_from_att(p_cal_type igs_ca_inst_all.cal_type%TYPE,
3026: p_seq_num igs_ca_inst_all.sequence_number%TYPE,
3027: p_att_pell igf_gr_attend_pell.attending_pell_cd%TYPE)
3028: RETURN VARCHAR2
3029: AS
3030:

Line 3060: FUNCTION get_rep_pell_from_base(p_cal_type igs_ca_inst_all.cal_type%TYPE,

3056: END IF;
3057:
3058: END get_rep_pell_from_att;
3059:
3060: FUNCTION get_rep_pell_from_base(p_cal_type igs_ca_inst_all.cal_type%TYPE,
3061: p_seq_num igs_ca_inst_all.sequence_number%TYPE,
3062: p_base_id NUMBER)
3063: RETURN VARCHAR2
3064: AS

Line 3061: p_seq_num igs_ca_inst_all.sequence_number%TYPE,

3057:
3058: END get_rep_pell_from_att;
3059:
3060: FUNCTION get_rep_pell_from_base(p_cal_type igs_ca_inst_all.cal_type%TYPE,
3061: p_seq_num igs_ca_inst_all.sequence_number%TYPE,
3062: p_base_id NUMBER)
3063: RETURN VARCHAR2
3064: AS
3065: