eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_AP_LG_COA_IMP dependencies on IGF_AW_COA_ITM_TERMS

Line 199: CURSOR person_terms ( cp_base_id igf_aw_coa_itm_terms.base_id%TYPE ) IS

195: WHERE base_id = cp_base_id ;
196: l_item_code person_coa_items%ROWTYPE;
197:
198: -- Count all terms for a person in the system
199: CURSOR person_terms ( cp_base_id igf_aw_coa_itm_terms.base_id%TYPE ) IS
200: SELECT COUNT(DISTINCT (ld_sequence_number)) person_terms
201: FROM igf_aw_coa_itm_terms
202: WHERE base_id = cp_base_id ;
203: l_person_terms NUMBER;

Line 201: FROM igf_aw_coa_itm_terms

197:
198: -- Count all terms for a person in the system
199: CURSOR person_terms ( cp_base_id igf_aw_coa_itm_terms.base_id%TYPE ) IS
200: SELECT COUNT(DISTINCT (ld_sequence_number)) person_terms
201: FROM igf_aw_coa_itm_terms
202: WHERE base_id = cp_base_id ;
203: l_person_terms NUMBER;
204:
205: -- Count all terms for a person for a COA Item

Line 206: CURSOR person_coa_terms ( cp_base_id igf_aw_coa_itm_terms.base_id%TYPE ,

202: WHERE base_id = cp_base_id ;
203: l_person_terms NUMBER;
204:
205: -- Count all terms for a person for a COA Item
206: CURSOR person_coa_terms ( cp_base_id igf_aw_coa_itm_terms.base_id%TYPE ,
207: cp_item_code igf_aw_li_coa_ints.item_code%TYPE) IS
208: SELECT COUNT(DISTINCT(ld_sequence_number)) coa_terms
209: FROM igf_aw_coa_itm_terms
210: WHERE base_id = cp_base_id

Line 209: FROM igf_aw_coa_itm_terms

205: -- Count all terms for a person for a COA Item
206: CURSOR person_coa_terms ( cp_base_id igf_aw_coa_itm_terms.base_id%TYPE ,
207: cp_item_code igf_aw_li_coa_ints.item_code%TYPE) IS
208: SELECT COUNT(DISTINCT(ld_sequence_number)) coa_terms
209: FROM igf_aw_coa_itm_terms
210: WHERE base_id = cp_base_id
211: AND item_code = cp_item_code ;
212: l_person_coa_terms NUMBER;
213:

Line 251: PROCEDURE check_dup_coa ( p_item_code IN igf_aw_coa_itm_terms.item_code%TYPE,

247:
248: END check_person_terms ;
249:
250:
251: PROCEDURE check_dup_coa ( p_item_code IN igf_aw_coa_itm_terms.item_code%TYPE,
252: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
253: p_dup_coa OUT NOCOPY BOOLEAN ) IS
254: /*
255: || Created By : masehgal

Line 296: PROCEDURE check_dup_coa_term ( p_item_code IN igf_aw_coa_itm_terms.item_code%TYPE,

292: END check_dup_coa ;
293:
294:
295:
296: PROCEDURE check_dup_coa_term ( p_item_code IN igf_aw_coa_itm_terms.item_code%TYPE,
297: p_ld_cal_type IN igs_ca_inst.cal_type%TYPE,
298: p_ld_seq_num IN igs_ca_inst.sequence_number%TYPE,
299: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
300: p_dup_term OUT NOCOPY BOOLEAN ) IS

Line 312: cp_item_code igf_aw_coa_itm_terms.item_code%TYPE,

308: || (reverse chronological order - newest change first)
309: */
310:
311: CURSOR chk_dup_term ( cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
312: cp_item_code igf_aw_coa_itm_terms.item_code%TYPE,
313: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
314: cp_ld_seq_num igs_ca_inst.sequence_number%TYPE) IS
315: SELECT 1
316: FROM igf_aw_coa_itm_terms

Line 316: FROM igf_aw_coa_itm_terms

312: cp_item_code igf_aw_coa_itm_terms.item_code%TYPE,
313: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
314: cp_ld_seq_num igs_ca_inst.sequence_number%TYPE) IS
315: SELECT 1
316: FROM igf_aw_coa_itm_terms
317: WHERE base_id = cp_base_id
318: AND item_code = cp_item_code
319: AND ld_cal_type = cp_ld_cal_type
320: AND ld_sequence_number = cp_ld_seq_num ;

Line 357: CURSOR del_coa_terms( cp_base_id igf_aw_coa_itm_terms.base_id%TYPE) IS

353: || Who When What
354: || (reverse chronological order - newest change first)
355: */
356:
357: CURSOR del_coa_terms( cp_base_id igf_aw_coa_itm_terms.base_id%TYPE) IS
358: SELECT rowid
359: FROM igf_aw_coa_itm_terms
360: WHERE base_id = cp_base_id ;
361: lv_rowid del_coa_terms%ROWTYPE;

Line 359: FROM igf_aw_coa_itm_terms

355: */
356:
357: CURSOR del_coa_terms( cp_base_id igf_aw_coa_itm_terms.base_id%TYPE) IS
358: SELECT rowid
359: FROM igf_aw_coa_itm_terms
360: WHERE base_id = cp_base_id ;
361: lv_rowid del_coa_terms%ROWTYPE;
362:
363: BEGIN

Line 366: igf_aw_coa_itm_terms_pkg.delete_row( x_rowid => lv_rowid.rowid);

362:
363: BEGIN
364: FOR lv_rowid IN del_coa_terms ( p_base_id)
365: LOOP
366: igf_aw_coa_itm_terms_pkg.delete_row( x_rowid => lv_rowid.rowid);
367: END LOOP;
368:
369: EXCEPTION
370: WHEN OTHERS THEN

Line 394: CURSOR del_coa_items( cp_base_id igf_aw_coa_itm_terms.base_id%TYPE) IS --,

390: || Who When What
391: || (reverse chronological order - newest change first)
392: */
393:
394: CURSOR del_coa_items( cp_base_id igf_aw_coa_itm_terms.base_id%TYPE) IS --,
395: SELECT rowid
396: FROM igf_aw_coa_items
397: WHERE base_id = cp_base_id ;
398: lv_rowid del_coa_items%ROWTYPE;

Line 522: CURSOR cur_get_items (cp_base_id igf_aw_coa_itm_terms.base_id%TYPE,

518: AND rownum = 1;
519: l_coa_exist NUMBER ;
520:
521: -- cursor for items update
522: CURSOR cur_get_items (cp_base_id igf_aw_coa_itm_terms.base_id%TYPE,
523: cp_item_code igf_aw_coa_itm_terms.item_code%TYPE) IS
524: SELECT items.rowid,items.*
525: FROM igf_aw_coa_items items
526: WHERE base_id = cp_base_id

Line 523: cp_item_code igf_aw_coa_itm_terms.item_code%TYPE) IS

519: l_coa_exist NUMBER ;
520:
521: -- cursor for items update
522: CURSOR cur_get_items (cp_base_id igf_aw_coa_itm_terms.base_id%TYPE,
523: cp_item_code igf_aw_coa_itm_terms.item_code%TYPE) IS
524: SELECT items.rowid,items.*
525: FROM igf_aw_coa_items items
526: WHERE base_id = cp_base_id
527: AND item_code = cp_item_code ;

Line 997: igf_aw_coa_itm_terms_pkg.insert_row(

993: -- insert into the terms table
994:
995: BEGIN
996:
997: igf_aw_coa_itm_terms_pkg.insert_row(
998: x_rowid => lv_term_rowid,
999: x_base_id => l_fa_base_id,
1000: x_item_code => person_rec.item_code,
1001: x_amount => person_rec.term_amt,