DBA Data[Home] [Help]

APPS.IGF_AW_GEN dependencies on IGS_CA_INST_ALL

Line 36: FUNCTION get_ver_num ( p_cal_type IN igs_ca_inst_all.cal_type%TYPE,

32: -- P - PELL
33: -- I - ISIR
34: -- R - PROFILE
35: --
36: FUNCTION get_ver_num ( p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
37: p_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
38: p_process IN VARCHAR2) RETURN VARCHAR2;
39:
40:

Line 37: p_seq_num IN igs_ca_inst_all.sequence_number%TYPE,

33: -- I - ISIR
34: -- R - PROFILE
35: --
36: FUNCTION get_ver_num ( p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
37: p_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
38: p_process IN VARCHAR2) RETURN VARCHAR2;
39:
40:
41: PROCEDURE update_disb( p_disb_old_rec igf_aw_awd_disb_all%ROWTYPE,

Line 105: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,

101: || Who When What
102: || (reverse chronological order - newest change first)
103: */
104: PROCEDURE get_notification_status (
105: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
106: p_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
107: p_awarding_period IN igf_aw_award_prd.award_prd_cd%TYPE,
108: p_base_id IN igf_ap_fa_base_rec_all.base_id%type,
109: p_notification_status_code OUT NOCOPY igf_aw_award_all.notification_status_code%TYPE,

Line 106: p_seq_num IN igs_ca_inst_all.sequence_number%TYPE,

102: || (reverse chronological order - newest change first)
103: */
104: PROCEDURE get_notification_status (
105: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
106: p_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
107: p_awarding_period IN igf_aw_award_prd.award_prd_cd%TYPE,
108: p_base_id IN igf_ap_fa_base_rec_all.base_id%type,
109: p_notification_status_code OUT NOCOPY igf_aw_award_all.notification_status_code%TYPE,
110: p_notification_status_date OUT NOCOPY igf_aw_award_all.notification_status_date%TYPE

Line 128: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,

124: || Who When What
125: || (reverse chronological order - newest change first)
126: */
127: PROCEDURE update_notification_status (
128: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
129: p_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
130: p_awarding_period IN igf_aw_award_prd.award_prd_cd%TYPE,
131: p_base_id IN igf_ap_fa_base_rec_all.base_id%type,
132: p_notification_status_code IN igf_aw_award_all.notification_status_code%TYPE,

Line 129: p_seq_num IN igs_ca_inst_all.sequence_number%TYPE,

125: || (reverse chronological order - newest change first)
126: */
127: PROCEDURE update_notification_status (
128: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
129: p_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
130: p_awarding_period IN igf_aw_award_prd.award_prd_cd%TYPE,
131: p_base_id IN igf_ap_fa_base_rec_all.base_id%type,
132: p_notification_status_code IN igf_aw_award_all.notification_status_code%TYPE,
133: p_notification_status_date IN igf_aw_award_all.notification_status_date%TYPE,

Line 186: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,

182: || (reverse chronological order - newest change first)
183: */
184: FUNCTION is_fund_locked_for_awd_period (
185: p_base_id IN igf_ap_fa_base_rec_all.base_id%type,
186: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
187: p_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
188: p_awarding_period IN igf_aw_award_prd.award_prd_cd%TYPE,
189: p_fund_id IN igf_aw_award_all.fund_id%TYPE
190: ) RETURN BOOLEAN;

Line 187: p_seq_num IN igs_ca_inst_all.sequence_number%TYPE,

183: */
184: FUNCTION is_fund_locked_for_awd_period (
185: p_base_id IN igf_ap_fa_base_rec_all.base_id%type,
186: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
187: p_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
188: p_awarding_period IN igf_aw_award_prd.award_prd_cd%TYPE,
189: p_fund_id IN igf_aw_award_all.fund_id%TYPE
190: ) RETURN BOOLEAN;
191: