DBA Data[Home] [Help]

APPS.IGF_GR_GEN dependencies on IGF_AW_COA_LD_ALL

Line 2279: p_ld_cal_type IN igf_aw_coa_ld_all.ld_cal_type%TYPE,

2275:
2276: PROCEDURE insert_coa_terms( p_coa_code IN igf_aw_coa_group_all.coa_code%TYPE,
2277: p_cal_type IN igf_aw_coa_group_all.ci_cal_type%TYPE,
2278: p_sequence_number IN igf_aw_coa_group_all.ci_sequence_number%TYPE,
2279: p_ld_cal_type IN igf_aw_coa_ld_all.ld_cal_type%TYPE,
2280: p_ld_sequence_number IN igf_aw_coa_ld_all.ld_sequence_number%TYPE
2281: )
2282:
2283: IS

Line 2280: p_ld_sequence_number IN igf_aw_coa_ld_all.ld_sequence_number%TYPE

2276: PROCEDURE insert_coa_terms( p_coa_code IN igf_aw_coa_group_all.coa_code%TYPE,
2277: p_cal_type IN igf_aw_coa_group_all.ci_cal_type%TYPE,
2278: p_sequence_number IN igf_aw_coa_group_all.ci_sequence_number%TYPE,
2279: p_ld_cal_type IN igf_aw_coa_ld_all.ld_cal_type%TYPE,
2280: p_ld_sequence_number IN igf_aw_coa_ld_all.ld_sequence_number%TYPE
2281: )
2282:
2283: IS
2284:

Line 2346: p_ld_cal_type IN igf_aw_coa_ld_all.ld_cal_type%TYPE,

2342: END insert_coa_terms;
2343:
2344:
2345: PROCEDURE insert_stu_coa_terms( p_base_id IN igf_aw_coa_itm_terms.base_id%TYPE,
2346: p_ld_cal_type IN igf_aw_coa_ld_all.ld_cal_type%TYPE,
2347: p_ld_sequence_number IN igf_aw_coa_ld_all.ld_sequence_number%TYPE,
2348: p_result OUT NOCOPY VARCHAR2
2349: )
2350: IS

Line 2347: p_ld_sequence_number IN igf_aw_coa_ld_all.ld_sequence_number%TYPE,

2343:
2344:
2345: PROCEDURE insert_stu_coa_terms( p_base_id IN igf_aw_coa_itm_terms.base_id%TYPE,
2346: p_ld_cal_type IN igf_aw_coa_ld_all.ld_cal_type%TYPE,
2347: p_ld_sequence_number IN igf_aw_coa_ld_all.ld_sequence_number%TYPE,
2348: p_result OUT NOCOPY VARCHAR2
2349: )
2350: IS
2351:

Line 2447: p_ld_cal_type IN igf_aw_coa_ld_all.ld_cal_type%TYPE,

2443:
2444: END insert_existing_terms;
2445:
2446: PROCEDURE delete_stu_coa_terms( p_base_id IN igf_aw_coa_itm_terms.base_id%TYPE,
2447: p_ld_cal_type IN igf_aw_coa_ld_all.ld_cal_type%TYPE,
2448: p_ld_sequence_number IN igf_aw_coa_ld_all.ld_sequence_number%TYPE,
2449: p_result OUT NOCOPY VARCHAR2
2450: )
2451:

Line 2448: p_ld_sequence_number IN igf_aw_coa_ld_all.ld_sequence_number%TYPE,

2444: END insert_existing_terms;
2445:
2446: PROCEDURE delete_stu_coa_terms( p_base_id IN igf_aw_coa_itm_terms.base_id%TYPE,
2447: p_ld_cal_type IN igf_aw_coa_ld_all.ld_cal_type%TYPE,
2448: p_ld_sequence_number IN igf_aw_coa_ld_all.ld_sequence_number%TYPE,
2449: p_result OUT NOCOPY VARCHAR2
2450: )
2451:
2452: IS

Line 2456: p_ld_cal_type igf_aw_coa_ld_all.ld_cal_type%TYPE,

2452: IS
2453:
2454:
2455: CURSOR cur_get_terms (p_base_id igf_aw_coa_itm_terms.base_id%TYPE,
2456: p_ld_cal_type igf_aw_coa_ld_all.ld_cal_type%TYPE,
2457: p_ld_sequence_number igf_aw_coa_ld_all.ld_sequence_number%TYPE
2458: )
2459: IS
2460: SELECT rowid

Line 2457: p_ld_sequence_number igf_aw_coa_ld_all.ld_sequence_number%TYPE

2453:
2454:
2455: CURSOR cur_get_terms (p_base_id igf_aw_coa_itm_terms.base_id%TYPE,
2456: p_ld_cal_type igf_aw_coa_ld_all.ld_cal_type%TYPE,
2457: p_ld_sequence_number igf_aw_coa_ld_all.ld_sequence_number%TYPE
2458: )
2459: IS
2460: SELECT rowid
2461: FROM igf_aw_coa_itm_terms