DBA Data[Home] [Help]

APPS.IGF_AW_CANCEL_AWD dependencies on IGS_CA_INST_ALL

Line 31: p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,

27: p_fund_id IN igf_aw_award.fund_id%TYPE,
28: p_msg_name OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
29:
30: PROCEDURE cancel_award_fabase (
31: p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
32: p_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
33: p_fund_id IN igf_aw_award_all.fund_id%TYPE,
34: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
35: p_run_mode IN igf_lookups_view.lookup_code%TYPE

Line 32: p_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE,

28: p_msg_name OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
29:
30: PROCEDURE cancel_award_fabase (
31: p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
32: p_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
33: p_fund_id IN igf_aw_award_all.fund_id%TYPE,
34: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
35: p_run_mode IN igf_lookups_view.lookup_code%TYPE
36: );

Line 41: p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,

37:
38: FUNCTION chk_awd_exp_date (
39: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
40: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
41: p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
42: p_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
43: p_run_mode IN igf_lookups_view.lookup_code%TYPE
44: ) RETURN BOOLEAN;
45:

Line 42: p_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE,

38: FUNCTION chk_awd_exp_date (
39: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
40: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
41: p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
42: p_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
43: p_run_mode IN igf_lookups_view.lookup_code%TYPE
44: ) RETURN BOOLEAN;
45:
46: PROCEDURE get_base_id_per_num (

Line 48: p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,

44: ) RETURN BOOLEAN;
45:
46: PROCEDURE get_base_id_per_num (
47: p_person_id IN hz_parties.party_id%TYPE,
48: p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
49: p_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
50: p_base_id OUT NOCOPY igf_ap_fa_base_rec_all.base_id%TYPE,
51: p_per_num OUT NOCOPY igs_pe_person_base_v.person_number%TYPE
52: );

Line 49: p_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE,

45:
46: PROCEDURE get_base_id_per_num (
47: p_person_id IN hz_parties.party_id%TYPE,
48: p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
49: p_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
50: p_base_id OUT NOCOPY igf_ap_fa_base_rec_all.base_id%TYPE,
51: p_per_num OUT NOCOPY igs_pe_person_base_v.person_number%TYPE
52: );
53: