APPS.IGF_AW_COA_GEN dependencies on IGF_AP_FA_BASE_REC_ALL

Line 17: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

13: --Who When What
14: -------------------------------------------------------------------
15:
16: FUNCTION coa_amount(
17: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
18: p_awd_prd_code igf_aw_award_prd.award_prd_cd%TYPE DEFAULT NULL,
19: p_use_direct_costs igf_aw_coa_items.fixed_cost%TYPE DEFAULT 'N'
20: ) RETURN NUMBER;
21:

Line 23: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

19: p_use_direct_costs igf_aw_coa_items.fixed_cost%TYPE DEFAULT 'N'
20: ) RETURN NUMBER;
21:
22: FUNCTION award_amount(
23: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
24: p_awd_prd_code igf_aw_award_prd.award_prd_cd%TYPE DEFAULT NULL,
25: p_award_id igf_aw_award_all.award_id%TYPE DEFAULT NULL
26: ) RETURN NUMBER;
27:

Line 29: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

25: p_award_id igf_aw_award_all.award_id%TYPE DEFAULT NULL
26: ) RETURN NUMBER;
27:
28: FUNCTION isCoaLocked(
29: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
30: p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,
31: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,
32: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL
33: ) RETURN BOOLEAN;

Line 36: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

32: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL
33: ) RETURN BOOLEAN;
34:
35: FUNCTION doLock(
36: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
37: p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,
38: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,
39: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL
40: ) RETURN VARCHAR2;

Line 43: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

39: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL
40: ) RETURN VARCHAR2;
41:
42: FUNCTION doUnlock(
43: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
44: p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,
45: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,
46: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL
47: ) RETURN VARCHAR2;

Line 65: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

61: credit_points_num NUMBER
62: );
63:
64: FUNCTION getBaseDetails(
65: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
66: p_ld_cal_type igs_ca_inst.cal_type%TYPE,
67: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE
68: ) RETURN base_details;
69:

Line 101: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

97: --Who When What
98: -------------------------------------------------------------------
99:
100: PROCEDURE get_coa_months(
101: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
102: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL,
103: p_start_dt OUT NOCOPY DATE,
104: p_end_dt OUT NOCOPY DATE,
105: p_coa_months OUT NOCOPY NUMBER

Line 109: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

105: p_coa_months OUT NOCOPY NUMBER
106: );
107:
108: FUNCTION set_awd_proc_status(
109: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
110: p_award_prd_code IN igf_aw_award_prd.award_prd_cd%TYPE DEFAULT NULL
111: ) RETURN VARCHAR2;
112:
113: PROCEDURE get_award_period_dates(

Line 133: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

129: p_attend_mode IN igf_ap_fa_ant_data.attendance_mode%TYPE,
130: p_ret_status OUT NOCOPY VARCHAR2
131: );
132: FUNCTION coa_duration(
133: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
134: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL
135: ) RETURN NUMBER;
136: END igf_aw_coa_gen;