473: CURSOR c_items(
474: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE
475: ) IS
476: SELECT items.*
477: FROM igf_aw_coa_items items
478: WHERE items.base_id = c_base_id;
479:
480:
481: --This cursor is to fetch terms details against an item
509: c_item_code igf_aw_coa_itm_terms.item_code%TYPE
510: ) IS
511: SELECT item.rowid row_id,
512: item.*
513: FROM igf_aw_coa_items item
514: WHERE base_id = c_base_id
515: AND item_code = c_item_code;
516:
517: l_item c_item%ROWTYPE;
657: OPEN c_item(p_base_id,l_items.item_code);
658: FETCH c_item INTO l_item;
659: CLOSE c_item;
660:
661: igf_aw_coa_items_pkg.update_row(
662: x_rowid => l_item.row_id,
663: x_base_id => l_item.base_id,
664: x_item_code => l_item.item_code,
665: x_amount => l_sum_amt.amount,