DBA Data[Home] [Help]

APPS.IGF_AW_GEN dependencies on IGF_AW_AWARD_PRD

Line 1892: p_awarding_period IN igf_aw_award_prd.award_prd_cd%TYPE,

1888: */
1889: PROCEDURE get_notification_status (
1890: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1891: p_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
1892: p_awarding_period IN igf_aw_award_prd.award_prd_cd%TYPE,
1893: p_base_id IN igf_ap_fa_base_rec_all.base_id%type,
1894: p_notification_status_code OUT NOCOPY igf_aw_award_all.notification_status_code%TYPE,
1895: p_notification_status_date OUT NOCOPY igf_aw_award_all.notification_status_date%TYPE
1896: ) AS

Line 1985: p_awarding_period IN igf_aw_award_prd.award_prd_cd%TYPE,

1981: */
1982: PROCEDURE update_notification_status (
1983: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1984: p_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
1985: p_awarding_period IN igf_aw_award_prd.award_prd_cd%TYPE,
1986: p_base_id IN igf_ap_fa_base_rec_all.base_id%type,
1987: p_notification_status_code IN igf_aw_award_all.notification_status_code%TYPE,
1988: p_notification_status_date IN igf_aw_award_all.notification_status_date%TYPE,
1989: p_called_from IN VARCHAR2

Line 2202: p_awarding_period IN igf_aw_award_prd.award_prd_cd%TYPE,

2198: FUNCTION is_fund_locked_for_awd_period (
2199: p_base_id IN igf_ap_fa_base_rec_all.base_id%type,
2200: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2201: p_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
2202: p_awarding_period IN igf_aw_award_prd.award_prd_cd%TYPE,
2203: p_fund_id IN igf_aw_award_all.fund_id%TYPE
2204: ) RETURN BOOLEAN AS
2205: CURSOR locked_award_count_cur (
2206: cp_base_id IN igf_ap_fa_base_rec_all.base_id%type,

Line 2209: cp_awarding_period IN igf_aw_award_prd.award_prd_cd%TYPE,

2205: CURSOR locked_award_count_cur (
2206: cp_base_id IN igf_ap_fa_base_rec_all.base_id%type,
2207: cp_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2208: cp_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
2209: cp_awarding_period IN igf_aw_award_prd.award_prd_cd%TYPE,
2210: cp_fund_id IN igf_aw_award_all.fund_id%TYPE
2211: )
2212: IS
2213: SELECT