DBA Data[Home] [Help]

APPS.IGF_AW_COA_CALC dependencies on IGF_AW_COA_ITEMS_PKG

Line 402: igf_aw_coa_items_pkg.delete_row(

398: x_rowid => coa_terms_rec.row_id
399: );
400: END LOOP;
401:
402: igf_aw_coa_items_pkg.delete_row(
403: x_rowid => coa_rec.row_id
404: );
405: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_DEL');
406: fnd_message.set_token('ITEM_CODE',coa_rec.item_code);

Line 776: igf_aw_coa_items_pkg.insert_row(

772: p_base_id || ' / '|| first_coa_rec.item_code);
773: END IF;
774: g_coa_updated := 'Y' ;
775:
776: igf_aw_coa_items_pkg.insert_row(
777: x_rowid => l_rowid,
778: x_base_id => p_base_id,
779: x_item_code => first_coa_rec.item_code,
780: x_amount => NVL(first_coa_rec.item_amount,0),

Line 913: igf_aw_coa_items_pkg.insert_row(

909: result := 'Y';
910: g_coa_updated := 'Y' ;
911: lv_item_assigned := 'N';
912:
913: igf_aw_coa_items_pkg.insert_row(
914: x_rowid => l_rowid,
915: x_base_id => p_base_id,
916: x_item_code => chk_item_match_rec.new_item,
917: x_amount => NVL(chk_item_match_rec.item_amount,0),

Line 1055: igf_aw_coa_items_pkg.insert_row(

1051: --so insert the item
1052: g_coa_updated := 'Y' ;
1053: lv_item_assigned := 'N';
1054:
1055: igf_aw_coa_items_pkg.insert_row(
1056: x_rowid => l_rowid,
1057: x_base_id => p_base_id,
1058: x_item_code => chk_item_match_rec.new_item,
1059: x_amount => NVL(chk_item_match_rec.item_amount,0),

Line 1177: igf_aw_coa_items_pkg.update_row(

1173: IF coa_needs_update(chk_item_match_rec.new_item,p_base_id,chk_item_match_rec.item_amount,chk_item_match_rec.pell_amt,chk_item_match_rec.pell_alt_amt,chk_item_match_rec.fixed_cost) THEN
1174: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1175: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_calc.add_coa_items.debug','updating item '||chk_item_match_rec.new_item);
1176: END IF;
1177: igf_aw_coa_items_pkg.update_row(
1178: x_rowid => chk_item_match_rec.row_id,
1179: x_base_id => p_base_id,
1180: x_item_code => chk_item_match_rec.new_item,
1181: x_amount => NVL(chk_item_match_rec.item_amount,0),

Line 1351: igf_aw_coa_items_pkg.insert_row(

1347: --so insert the item
1348: g_coa_updated := 'Y' ;
1349: lv_item_assigned := 'N';
1350:
1351: igf_aw_coa_items_pkg.insert_row(
1352: x_rowid => l_rowid,
1353: x_base_id => p_base_id,
1354: x_item_code => chk_item_match_rec.new_item,
1355: x_amount => NVL(chk_item_match_rec.item_amount,0),

Line 1469: igf_aw_coa_items_pkg.update_row(

1465: ELSE
1466: --the student has the COA item assigned
1467: --so if it needs update, update it
1468: IF coa_needs_update(chk_item_match_rec.new_item,p_base_id,chk_item_match_rec.item_amount,chk_item_match_rec.pell_amt,chk_item_match_rec.pell_alt_amt,chk_item_match_rec.fixed_cost) THEN
1469: igf_aw_coa_items_pkg.update_row(
1470: x_rowid => chk_item_match_rec.row_id,
1471: x_base_id => p_base_id,
1472: x_item_code => chk_item_match_rec.new_item,
1473: x_amount => NVL(chk_item_match_rec.item_amount,0),

Line 1625: igf_aw_coa_items_pkg.update_row(

1621: OPEN c_items(p_base_id,l_terms.item_code);
1622: FETCH c_items INTO l_items;
1623: CLOSE c_items;
1624:
1625: igf_aw_coa_items_pkg.update_row(
1626: x_rowid => l_items.row_id,
1627: x_base_id => l_items.base_id,
1628: x_item_code => l_items.item_code,
1629: x_amount => l_terms.amount,