APPS.IGF_GR_GEN dependencies on IGF_AP_FA_BASE_REC

Line 84: FUNCTION get_per_num ( p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE)

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;
86:
87:
88:

Line 89: FUNCTION get_per_num ( p_person_id IN igf_ap_fa_base_rec_all.person_id%TYPE,

85: RETURN VARCHAR2;
86:
87:
88:
89: FUNCTION get_per_num ( p_person_id IN igf_ap_fa_base_rec_all.person_id%TYPE,
90: p_person_number OUT NOCOPY igf_ap_person_v.person_number%TYPE )
91: RETURN BOOLEAN;
92:
93:

Line 94: FUNCTION get_person_id ( p_base_id igf_ap_fa_base_rec_all.base_id%TYPE)

90: p_person_number OUT NOCOPY igf_ap_person_v.person_number%TYPE )
91: RETURN BOOLEAN;
92:
93:
94: FUNCTION get_person_id ( p_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
95: RETURN VARCHAR2;
96:
97:
98: FUNCTION get_per_num_oss ( p_person_id igf_ap_fa_base_rec_all.person_id%TYPE)

Line 98: FUNCTION get_per_num_oss ( p_person_id igf_ap_fa_base_rec_all.person_id%TYPE)

94: FUNCTION get_person_id ( p_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
95: RETURN VARCHAR2;
96:
97:
98: FUNCTION get_per_num_oss ( p_person_id igf_ap_fa_base_rec_all.person_id%TYPE)
99: RETURN VARCHAR2;
100:
101:
102: PROCEDURE insert_sys_holds ( p_award_id igf_aw_award_all.award_id%TYPE,

Line 343: p_cal_type IN igf_ap_fa_base_rec.ci_cal_type%TYPE,

339: );
340:
341:
342: FUNCTION get_pell_code(p_att_code IN igs_en_stdnt_ps_att_all.derived_att_type%TYPE,
343: p_cal_type IN igf_ap_fa_base_rec.ci_cal_type%TYPE,
344: p_sequence_number IN igf_ap_fa_base_rec.ci_sequence_number%TYPE)
345: RETURN VARCHAR2;
346:
347:

Line 344: p_sequence_number IN igf_ap_fa_base_rec.ci_sequence_number%TYPE)

340:
341:
342: FUNCTION get_pell_code(p_att_code IN igs_en_stdnt_ps_att_all.derived_att_type%TYPE,
343: p_cal_type IN igf_ap_fa_base_rec.ci_cal_type%TYPE,
344: p_sequence_number IN igf_ap_fa_base_rec.ci_sequence_number%TYPE)
345: RETURN VARCHAR2;
346:
347:
348: --

Line 358: p_person_id IN igf_ap_fa_base_rec_all.person_id%TYPE,

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: );
362:

Line 359: p_base_id OUT NOCOPY igf_ap_fa_base_rec_all.base_id%TYPE,

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: );
362:
363: --

Line 367: PROCEDURE update_current_ssn (p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

363: --
364: -- sjadhav,2/4/03
365: -- FA116 Build - Bug 2758812 - 2/4/03
366: --
367: PROCEDURE update_current_ssn (p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
368: p_cur_ssn IN igf_ap_isir_matched_all.current_ssn%TYPE,
369: p_message OUT NOCOPY fnd_new_messages.message_name%TYPE);
370:
371: PROCEDURE update_pell_status (p_award_id IN igf_aw_award_all.award_id%TYPE,

Line 383: FUNCTION chk_orig_isir_exists( p_base_id IN igf_ap_fa_base_rec.base_id%TYPE,

379:
380: FUNCTION get_min_disb_number (p_award_id igf_aw_award_all.award_id%TYPE)
381: RETURN NUMBER;
382: -- Added As part of FA121 Build (Verification Worksheet Enhancements)
383: FUNCTION chk_orig_isir_exists( p_base_id IN igf_ap_fa_base_rec.base_id%TYPE,
384: p_transaction_num IN igf_ap_ISIR_matched.transaction_num%TYPE)
385: RETURN BOOLEAN;
386:
387: