APPS.IGF_AW_COA_UPDATE dependencies on IGF_AW_COA_ITM_TERMS

Line 488: FROM igf_aw_coa_itm_terms terms

484: c_item_code igf_aw_item.item_code%TYPE
485: ) IS
486: SELECT terms.rowid row_id,
487: terms.*
488: FROM igf_aw_coa_itm_terms terms
489: WHERE base_id = c_base_id
490: AND item_code = c_item_code;
491:
492:

Line 496: c_item_code igf_aw_coa_itm_terms.item_code%TYPE

492:
493: --Cursor to fetch the sum amount of all the terms for the Item code
494: CURSOR c_sum_amt(
495: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
496: c_item_code igf_aw_coa_itm_terms.item_code%TYPE
497: ) IS
498: SELECT SUM(NVL(amount,0)) amount
499: FROM igf_aw_coa_itm_terms term
500: WHERE base_id = c_base_id

Line 499: FROM igf_aw_coa_itm_terms term

495: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
496: c_item_code igf_aw_coa_itm_terms.item_code%TYPE
497: ) IS
498: SELECT SUM(NVL(amount,0)) amount
499: FROM igf_aw_coa_itm_terms term
500: WHERE base_id = c_base_id
501: AND item_code = c_item_code;
502:
503: l_sum_amt c_sum_amt%ROWTYPE;

Line 509: c_item_code igf_aw_coa_itm_terms.item_code%TYPE

505:
506: --Cursor to fetch item details for the base id
507: CURSOR c_item(
508: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
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

Line 626: igf_aw_coa_itm_terms_pkg.update_row(

622: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
623: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.evaluate.debug','ln_amount <> l_terms.amount for base_id:'||p_base_id);
624: END IF;
625:
626: igf_aw_coa_itm_terms_pkg.update_row(
627: x_rowid => l_terms.row_id,
628: x_base_id => l_terms.base_id,
629: x_item_code => l_terms.item_code,
630: x_amount => ln_amount,