APPS.IGF_AW_ROLLOVER dependencies on IGF_AW_FUND_PRG_ALL

Line 328: p_pay_program OUT NOCOPY igf_aw_fund_prg_all.course_cd%TYPE

324:
325: --Create pay programs for the target award year
326: FUNCTION create_pay_program (p_ref_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
327: p_new_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
328: p_pay_program OUT NOCOPY igf_aw_fund_prg_all.course_cd%TYPE
329: )
330: RETURN BOOLEAN IS
331: --------------------------------------------------------------------------------
332: -- Created by : ridas, Oracle India

Line 344: FROM igf_aw_fund_prg_all prg

340: -- Get the details of the pay programs for a given Fund ID
341: CURSOR c_get_programs ( cp_ref_fund_id igf_aw_fund_excl_all.fund_id%TYPE
342: ) IS
343: SELECT prg.course_cd
344: FROM igf_aw_fund_prg_all prg
345: WHERE fund_id = cp_ref_fund_id;
346:
347: -- Cursor to fetch all the existing versions for the program type
348: CURSOR c_get_program_ver ( cp_program_code igs_ps_ver_all.course_cd%TYPE

Line 357: l_fprg_id igf_aw_fund_prg_all.fprg_id%TYPE;

353: ORDER BY version_number asc;
354:
355:
356: l_rowid VARCHAR2(25);
357: l_fprg_id igf_aw_fund_prg_all.fprg_id%TYPE;
358:
359: BEGIN
360: FOR l_get_programs IN c_get_programs( p_ref_fund_id ) LOOP
361: FOR l_get_program_ver IN c_get_program_ver (l_get_programs.course_cd)

Line 770: l_pay_program igf_aw_fund_prg_all.course_cd%TYPE;

766: ORDER BY fnd.fund_id;
767:
768: l_new_fund_id igf_aw_fund_mast_all.fund_id%TYPE := NULL;
769: E_SKIP_FUND EXCEPTION;
770: l_pay_program igf_aw_fund_prg_all.course_cd%TYPE;
771: l_pay_unit igf_aw_fund_unit_all.unit_cd%TYPE;
772: l_fee_class igf_aw_fund_feeclas_all.fee_class%TYPE;
773: l_todo_item igf_ap_td_item_mst_all.item_code%TYPE;
774: l_inclusive_fund igf_aw_fund_mast_all.fund_code%TYPE;