APPS.IGF_AW_COA_GEN dependencies on IGF_AW_AWARD_PRD

Line 26: p_awd_prd_code igf_aw_award_prd.award_prd_cd%TYPE,

22: g_unlock_level NUMBER;
23:
24: FUNCTION coa_amount(
25: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
26: p_awd_prd_code igf_aw_award_prd.award_prd_cd%TYPE,
27: p_use_direct_costs igf_aw_coa_items.fixed_cost%TYPE
28: ) RETURN NUMBER AS
29: ------------------------------------------------------------------
30: --Created by : veramach, Oracle India

Line 43: cp_awd_prd_code igf_aw_award_prd.award_prd_cd%TYPE,

39: --Who When What
40: -------------------------------------------------------------------
41: CURSOR c_coa_amount(
42: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
43: cp_awd_prd_code igf_aw_award_prd.award_prd_cd%TYPE,
44: cp_use_direct_costs igf_aw_coa_items.fixed_cost%TYPE
45: ) IS
46: SELECT SUM(coa.amount)
47: FROM igf_aw_coa_itm_terms coa,

Line 114: p_awd_prd_code igf_aw_award_prd.award_prd_cd%TYPE,

110: END coa_amount;
111:
112: FUNCTION award_amount(
113: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
114: p_awd_prd_code igf_aw_award_prd.award_prd_cd%TYPE,
115: p_award_id igf_aw_award_all.award_id%TYPE DEFAULT NULL
116: ) RETURN NUMBER AS
117: ------------------------------------------------------------------
118: --Created by : veramach, Oracle India

Line 132: cp_awd_prd_code igf_aw_award_prd.award_prd_cd%TYPE,

128: -------------------------------------------------------------------
129:
130: CURSOR c_award_amount(
131: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
132: cp_awd_prd_code igf_aw_award_prd.award_prd_cd%TYPE,
133: cp_award_id igf_aw_award_all.award_id%TYPE
134: ) IS
135: SELECT SUM(NVL(disb.disb_gross_amt, 0)) award_amount
136: FROM igf_aw_award_all awd,

Line 1957: p_award_prd_code IN igf_aw_award_prd.award_prd_cd%TYPE DEFAULT NULL

1953:
1954: -- This procedure is to set and return the Awarding Process Status
1955: FUNCTION set_awd_proc_status(
1956: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
1957: p_award_prd_code IN igf_aw_award_prd.award_prd_cd%TYPE DEFAULT NULL
1958: ) RETURN VARCHAR2 AS
1959: --------------------------------------------------------------------------------
1960: -- Created by : ridas, Oracle India
1961: -- Date created: 27-OCT-2004

Line 1970: c_award_prd_code igf_aw_award_prd.award_prd_cd%TYPE

1966:
1967: --Cursor to filter out those awards that fall within the awarding period
1968: CURSOR c_award_prd(
1969: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE ,
1970: c_award_prd_code igf_aw_award_prd.award_prd_cd%TYPE
1971: ) IS
1972: SELECT awd.rowid row_id,
1973: awd.*
1974: FROM igf_aw_award_all awd