DBA Data[Home] [Help]

APPS.IGF_GR_GEN dependencies on IGS_CA_INST_ALL

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

72: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE)
73: RETURN BOOLEAN;
74:
75:
76: FUNCTION get_alt_code ( p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
77: p_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE)
78: RETURN VARCHAR2;
79:
80: FUNCTION get_calendar_desc ( p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,

Line 77: p_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE)

73: RETURN BOOLEAN;
74:
75:
76: FUNCTION get_alt_code ( p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
77: p_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE)
78: RETURN VARCHAR2;
79:
80: FUNCTION get_calendar_desc ( p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
81: p_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE)

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

76: FUNCTION get_alt_code ( p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
77: p_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE)
78: RETURN VARCHAR2;
79:
80: FUNCTION get_calendar_desc ( p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
81: p_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE)
82: RETURN VARCHAR2;
83:
84: FUNCTION get_per_num ( p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE)

Line 81: p_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE)

77: p_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE)
78: RETURN VARCHAR2;
79:
80: FUNCTION get_calendar_desc ( p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
81: p_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE)
82: RETURN VARCHAR2;
83:
84: FUNCTION get_per_num ( p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE)
85: RETURN VARCHAR2;

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

217: --
218: -- Routine to fetch default award year
219: --
220:
221: PROCEDURE get_def_awd_year(p_alternate_code OUT NOCOPY igs_ca_inst_all.alternate_code%TYPE,
222: p_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
223: p_sequence_number OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,
224: p_start_date OUT NOCOPY igs_ca_inst_all.start_dt%TYPE,
225: p_end_date OUT NOCOPY igs_ca_inst_all.end_dt%TYPE,

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

218: -- Routine to fetch default award year
219: --
220:
221: PROCEDURE get_def_awd_year(p_alternate_code OUT NOCOPY igs_ca_inst_all.alternate_code%TYPE,
222: p_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
223: p_sequence_number OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,
224: p_start_date OUT NOCOPY igs_ca_inst_all.start_dt%TYPE,
225: p_end_date OUT NOCOPY igs_ca_inst_all.end_dt%TYPE,
226: p_err_msg OUT NOCOPY VARCHAR2

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

219: --
220:
221: PROCEDURE get_def_awd_year(p_alternate_code OUT NOCOPY igs_ca_inst_all.alternate_code%TYPE,
222: p_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
223: p_sequence_number OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,
224: p_start_date OUT NOCOPY igs_ca_inst_all.start_dt%TYPE,
225: p_end_date OUT NOCOPY igs_ca_inst_all.end_dt%TYPE,
226: p_err_msg OUT NOCOPY VARCHAR2
227: );

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

220:
221: PROCEDURE get_def_awd_year(p_alternate_code OUT NOCOPY igs_ca_inst_all.alternate_code%TYPE,
222: p_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
223: p_sequence_number OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,
224: p_start_date OUT NOCOPY igs_ca_inst_all.start_dt%TYPE,
225: p_end_date OUT NOCOPY igs_ca_inst_all.end_dt%TYPE,
226: p_err_msg OUT NOCOPY VARCHAR2
227: );
228:

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

221: PROCEDURE get_def_awd_year(p_alternate_code OUT NOCOPY igs_ca_inst_all.alternate_code%TYPE,
222: p_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
223: p_sequence_number OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,
224: p_start_date OUT NOCOPY igs_ca_inst_all.start_dt%TYPE,
225: p_end_date OUT NOCOPY igs_ca_inst_all.end_dt%TYPE,
226: p_err_msg OUT NOCOPY VARCHAR2
227: );
228:
229:

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

352: --
353: -- Routine to fetch base id
354: --
355:
356: PROCEDURE get_base_id(p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
357: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
358: p_person_id IN igf_ap_fa_base_rec_all.person_id%TYPE,
359: p_base_id OUT NOCOPY igf_ap_fa_base_rec_all.base_id%TYPE,
360: p_err_msg OUT NOCOPY VARCHAR2

Line 357: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,

353: -- Routine to fetch base id
354: --
355:
356: PROCEDURE get_base_id(p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
357: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
358: p_person_id IN igf_ap_fa_base_rec_all.person_id%TYPE,
359: p_base_id OUT NOCOPY igf_ap_fa_base_rec_all.base_id%TYPE,
360: p_err_msg OUT NOCOPY VARCHAR2
361: );

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

384: p_transaction_num IN igf_ap_ISIR_matched.transaction_num%TYPE)
385: RETURN BOOLEAN;
386:
387:
388: FUNCTION get_rep_pell_from_ope(p_cal_type igs_ca_inst_all.cal_type%TYPE,
389: p_seq_num igs_ca_inst_all.sequence_number%TYPE,
390: p_ope_cd igf_gr_report_pell.ope_cd%TYPE)
391: RETURN VARCHAR2;
392:

Line 389: p_seq_num igs_ca_inst_all.sequence_number%TYPE,

385: RETURN BOOLEAN;
386:
387:
388: FUNCTION get_rep_pell_from_ope(p_cal_type igs_ca_inst_all.cal_type%TYPE,
389: p_seq_num igs_ca_inst_all.sequence_number%TYPE,
390: p_ope_cd igf_gr_report_pell.ope_cd%TYPE)
391: RETURN VARCHAR2;
392:
393: FUNCTION get_rep_pell_from_att(p_cal_type igs_ca_inst_all.cal_type%TYPE,

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

389: p_seq_num igs_ca_inst_all.sequence_number%TYPE,
390: p_ope_cd igf_gr_report_pell.ope_cd%TYPE)
391: RETURN VARCHAR2;
392:
393: FUNCTION get_rep_pell_from_att(p_cal_type igs_ca_inst_all.cal_type%TYPE,
394: p_seq_num igs_ca_inst_all.sequence_number%TYPE,
395: p_att_pell igf_gr_attend_pell.attending_pell_cd%TYPE)
396: RETURN VARCHAR2;
397:

Line 394: p_seq_num igs_ca_inst_all.sequence_number%TYPE,

390: p_ope_cd igf_gr_report_pell.ope_cd%TYPE)
391: RETURN VARCHAR2;
392:
393: FUNCTION get_rep_pell_from_att(p_cal_type igs_ca_inst_all.cal_type%TYPE,
394: p_seq_num igs_ca_inst_all.sequence_number%TYPE,
395: p_att_pell igf_gr_attend_pell.attending_pell_cd%TYPE)
396: RETURN VARCHAR2;
397:
398: FUNCTION get_rep_pell_from_base(p_cal_type igs_ca_inst_all.cal_type%TYPE,

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

394: p_seq_num igs_ca_inst_all.sequence_number%TYPE,
395: p_att_pell igf_gr_attend_pell.attending_pell_cd%TYPE)
396: RETURN VARCHAR2;
397:
398: FUNCTION get_rep_pell_from_base(p_cal_type igs_ca_inst_all.cal_type%TYPE,
399: p_seq_num igs_ca_inst_all.sequence_number%TYPE,
400: p_base_id NUMBER)
401: RETURN VARCHAR2;
402:

Line 399: p_seq_num igs_ca_inst_all.sequence_number%TYPE,

395: p_att_pell igf_gr_attend_pell.attending_pell_cd%TYPE)
396: RETURN VARCHAR2;
397:
398: FUNCTION get_rep_pell_from_base(p_cal_type igs_ca_inst_all.cal_type%TYPE,
399: p_seq_num igs_ca_inst_all.sequence_number%TYPE,
400: p_base_id NUMBER)
401: RETURN VARCHAR2;
402:
403: END igf_gr_gen;