APPS.IGF_AW_COA_UPDATE dependencies on IGF_AW_ITEM

Line 193: p_item_code IN igf_aw_item.item_code%TYPE,

189: p_ci_cal_type IN igs_ca_inst.cal_type%TYPE,
190: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
191: p_ld_cal_type IN igs_ca_inst.cal_type%TYPE,
192: p_ld_sequence_number IN igs_ca_inst.sequence_number%TYPE,
193: p_item_code IN igf_aw_item.item_code%TYPE,
194: p_amount OUT NOCOPY NUMBER,
195: p_rate_order_num OUT NOCOPY NUMBER
196: ) RETURN BOOLEAN IS
197: --------------------------------------------------------------------------------

Line 219: c_item_code igf_aw_item.item_code%TYPE

215:
216: CURSOR c_rate_order (
217: c_ci_cal_type igs_ca_inst.cal_type%TYPE,
218: c_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
219: c_item_code igf_aw_item.item_code%TYPE
220: ) IS
221: SELECT rate.*
222: FROM igf_aw_coa_rate_det rate
223: WHERE ci_cal_type = c_ci_cal_type

Line 484: c_item_code igf_aw_item.item_code%TYPE

480:
481: --This cursor is to fetch terms details against an item
482: CURSOR c_terms(
483: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
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

Line 522: cp_item_code igf_aw_item.item_code%TYPE

518:
519: CURSOR c_rate_ord_exists (
520: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
521: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
522: cp_item_code igf_aw_item.item_code%TYPE
523: ) IS
524: SELECT 'X' exist
525: FROM igf_aw_coa_rate_det rate
526: WHERE ci_cal_type = cp_ci_cal_type

Line 640: fnd_message.set_name('IGF','IGF_AW_ITEM_SKIP');

636: lv_coa_itm_update := 'Y';
637: END IF;
638: ELSE
639: IF NVL(ln_rate_order,0) <> -1 THEN
640: fnd_message.set_name('IGF','IGF_AW_ITEM_SKIP');
641: fnd_message.set_token('ITEM_CODE',l_items.item_code);
642: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(l_terms.ld_cal_type,l_terms.ld_sequence_number));
643: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
644: END IF;