APPS.IGF_GR_GEN dependencies on IGF_AW_COA_ITEMS

Line 2355: FROM igf_aw_coa_items

2351:
2352: CURSOR cur_get_terms (p_base_id igf_aw_coa_itm_terms.base_id%TYPE)
2353: IS
2354: SELECT item_code
2355: FROM igf_aw_coa_items
2356: WHERE base_id = p_base_id;
2357:
2358: lv_rowid ROWID;
2359:

Line 2496: p_item_code IN igf_aw_coa_items.item_code%TYPE

2492:
2493:
2494: PROCEDURE delete_stu_coa_items( p_base_id IN igf_aw_coa_itm_terms.base_id%TYPE,
2495: p_result OUT NOCOPY VARCHAR2,
2496: p_item_code IN igf_aw_coa_items.item_code%TYPE
2497: )
2498: IS
2499:
2500: CURSOR cur_get_coa_itms (p_base_id igf_aw_coa_itm_terms.base_id%TYPE,

Line 2501: p_item_code igf_aw_coa_items.item_code%TYPE)

2497: )
2498: IS
2499:
2500: CURSOR cur_get_coa_itms (p_base_id igf_aw_coa_itm_terms.base_id%TYPE,
2501: p_item_code igf_aw_coa_items.item_code%TYPE)
2502: IS
2503: SELECT item_code,rowid
2504: FROM igf_aw_coa_items
2505: WHERE base_id = p_base_id

Line 2504: FROM igf_aw_coa_items

2500: CURSOR cur_get_coa_itms (p_base_id igf_aw_coa_itm_terms.base_id%TYPE,
2501: p_item_code igf_aw_coa_items.item_code%TYPE)
2502: IS
2503: SELECT item_code,rowid
2504: FROM igf_aw_coa_items
2505: WHERE base_id = p_base_id
2506: AND item_code = NVL(p_item_code,item_code);
2507:
2508:

Line 2530: -- igf_aw_coa_items_pkg.delete_row(x_rowid => get_coa_itms_rec.rowid);

2526: get_coa_itms_rec.item_code)
2527: LOOP
2528: igf_aw_coa_itm_terms_pkg.delete_row(x_rowid => get_coa_terms_rec.rowid);
2529: END LOOP;
2530: -- igf_aw_coa_items_pkg.delete_row(x_rowid => get_coa_itms_rec.rowid);
2531: END LOOP;
2532:
2533: EXCEPTION
2534: WHEN OTHERS THEN

Line 2560: igf_aw_coa_items items

2556: p_item_code igf_aw_coa_itm_terms.item_code%TYPE)
2557: IS
2558: SELECT items.rowid,items.*
2559: FROM
2560: igf_aw_coa_items items
2561: WHERE base_id = p_base_id
2562: AND item_code = NVL(p_item_code,item_code);
2563:
2564: CURSOR cur_get_terms (p_base_id igf_aw_coa_itm_terms.base_id%TYPE,

Line 2565: p_item_code igf_aw_coa_items.item_code%TYPE)

2561: WHERE base_id = p_base_id
2562: AND item_code = NVL(p_item_code,item_code);
2563:
2564: CURSOR cur_get_terms (p_base_id igf_aw_coa_itm_terms.base_id%TYPE,
2565: p_item_code igf_aw_coa_items.item_code%TYPE)
2566: IS
2567: SELECT
2568: SUM (amount) item_amount
2569: FROM igf_aw_coa_itm_terms

Line 2584: igf_aw_coa_items_pkg.update_row (x_rowid => get_items_rec.rowid,

2580: LOOP
2581: FOR get_terms_rec IN cur_get_terms ( p_base_id,
2582: get_items_rec.item_code)
2583: LOOP
2584: igf_aw_coa_items_pkg.update_row (x_rowid => get_items_rec.rowid,
2585: x_base_id => p_base_id,
2586: x_item_code => get_items_rec.item_code,
2587: x_amount => get_terms_rec.item_amount,
2588: x_pell_coa_amount => get_items_rec.pell_coa_amount,