DBA Data[Home] [Help]

APPS.IGF_AW_COA_UPDATE dependencies on IGF_AW_COA_ITEMS

Line 477: FROM igf_aw_coa_items items

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

Line 513: FROM igf_aw_coa_items 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;

Line 661: igf_aw_coa_items_pkg.update_row(

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,