APPS.IGF_AW_COA_GEN dependencies on IGF_AW_COA_ITEMS

Line 27: p_use_direct_costs igf_aw_coa_items.fixed_cost%TYPE

23:
24: FUNCTION coa_amount(
25: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
26: p_awd_prd_code igf_aw_award_prd.award_prd_cd%TYPE,
27: p_use_direct_costs igf_aw_coa_items.fixed_cost%TYPE
28: ) RETURN NUMBER AS
29: ------------------------------------------------------------------
30: --Created by : veramach, Oracle India
31: --Date created: 07-OCT-2004

Line 44: cp_use_direct_costs igf_aw_coa_items.fixed_cost%TYPE

40: -------------------------------------------------------------------
41: CURSOR c_coa_amount(
42: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
43: cp_awd_prd_code igf_aw_award_prd.award_prd_cd%TYPE,
44: cp_use_direct_costs igf_aw_coa_items.fixed_cost%TYPE
45: ) IS
46: SELECT SUM(coa.amount)
47: FROM igf_aw_coa_itm_terms coa,
48: igf_aw_awd_prd_term trms,

Line 50: igf_aw_coa_items item

46: SELECT SUM(coa.amount)
47: FROM igf_aw_coa_itm_terms coa,
48: igf_aw_awd_prd_term trms,
49: igf_ap_fa_base_rec_all fa,
50: igf_aw_coa_items item
51: WHERE fa.base_id = coa.base_id
52: AND fa.ci_cal_type = trms.ci_cal_type
53: AND fa.ci_sequence_number = trms.ci_sequence_number
54: AND coa.ld_cal_type = trms.ld_cal_type

Line 69: cp_use_direct_costs igf_aw_coa_items.fixed_cost%TYPE

65: ln_coa NUMBER;
66:
67: CURSOR c_coa_amount_awd(
68: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
69: cp_use_direct_costs igf_aw_coa_items.fixed_cost%TYPE
70: ) IS
71: SELECT SUM(coa.amount)
72: FROM igf_aw_coa_itm_terms coa,
73: igf_aw_coa_items item

Line 73: igf_aw_coa_items item

69: cp_use_direct_costs igf_aw_coa_items.fixed_cost%TYPE
70: ) IS
71: SELECT SUM(coa.amount)
72: FROM igf_aw_coa_itm_terms coa,
73: igf_aw_coa_items item
74: WHERE coa.base_id = cp_base_id
75: AND item.base_id = coa.base_id
76: AND item.item_code = coa.item_code
77: AND (

Line 236: FROM igf_aw_coa_items

232: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
233: cp_item_code igf_aw_item.item_code%TYPE
234: ) IS
235: SELECT NVL(lock_flag,'N') lock_flag
236: FROM igf_aw_coa_items
237: WHERE base_id = cp_base_id
238: AND item_code = cp_item_code;
239: l_item c_item%ROWTYPE;
240:

Line 450: FROM igf_aw_coa_items items

446: cp_item_code igf_aw_item.item_code%TYPE
447: ) IS
448: SELECT items.rowid row_id,
449: items.*
450: FROM igf_aw_coa_items items
451: WHERE base_id = cp_base_id
452: AND item_code = cp_item_code;
453: l_item c_item%ROWTYPE;
454:

Line 479: FROM igf_aw_coa_items items

475: CURSOR c_items(
476: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
477: ) IS
478: SELECT items.item_code
479: FROM igf_aw_coa_items items
480: WHERE base_id = cp_base_id;
481:
482:
483: BEGIN

Line 541: igf_aw_coa_items_pkg.update_row(

537: OPEN c_item(p_base_id,p_item_code);
538: FETCH c_item INTO l_item;
539: CLOSE c_item;
540:
541: igf_aw_coa_items_pkg.update_row(
542: x_rowid => l_item.row_id,
543: x_base_id => l_item.base_id,
544: x_item_code => l_item.item_code,
545: x_amount => l_item.amount,

Line 768: igf_aw_coa_items_pkg.update_row(

764: OPEN c_item(p_base_id,p_item_code);
765: FETCH c_item INTO l_item;
766: CLOSE c_item;
767:
768: igf_aw_coa_items_pkg.update_row(
769: x_rowid => l_item.row_id,
770: x_base_id => l_item.base_id,
771: x_item_code => l_item.item_code,
772: x_amount => l_item.amount,

Line 1868: igf_aw_coa_items coa

1864: SELECT batch.ci_cal_type,
1865: batch.ci_sequence_number
1866: FROM igf_ap_batch_aw_map_all batch,
1867: igf_ap_fa_base_rec_all fa,
1868: igf_aw_coa_items coa
1869: WHERE batch.award_year_status_code = 'O'
1870: AND fa.ci_cal_type = batch.ci_cal_type
1871: AND fa.ci_sequence_number = batch.ci_sequence_number
1872: AND fa.base_id = coa.base_id