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
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:
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
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:
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:
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
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
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