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_AW_COA_CALC dependencies on IGF_AW_COA_GRP_ITEM

Line 431: p_grp_coa_code IN igf_aw_coa_grp_item.coa_code%TYPE,

427: -- The procedure populate_setup_table populates the temporary table igf_aw_award_t
428: -- CREATED BY:gmuralid
429: --------------------------------------------------------------------------------------
430: PROCEDURE populate_setup_table(
431: p_grp_coa_code IN igf_aw_coa_grp_item.coa_code%TYPE,
432: p_ci_cal_type IN igf_aw_coa_grp_item.ci_cal_type%TYPE,
433: p_ci_sequence_number IN igf_aw_coa_grp_item.ci_sequence_number%TYPE,
434: l_process_id IN NUMBER
435: ) IS

Line 432: p_ci_cal_type IN igf_aw_coa_grp_item.ci_cal_type%TYPE,

428: -- CREATED BY:gmuralid
429: --------------------------------------------------------------------------------------
430: PROCEDURE populate_setup_table(
431: p_grp_coa_code IN igf_aw_coa_grp_item.coa_code%TYPE,
432: p_ci_cal_type IN igf_aw_coa_grp_item.ci_cal_type%TYPE,
433: p_ci_sequence_number IN igf_aw_coa_grp_item.ci_sequence_number%TYPE,
434: l_process_id IN NUMBER
435: ) IS
436:

Line 433: p_ci_sequence_number IN igf_aw_coa_grp_item.ci_sequence_number%TYPE,

429: --------------------------------------------------------------------------------------
430: PROCEDURE populate_setup_table(
431: p_grp_coa_code IN igf_aw_coa_grp_item.coa_code%TYPE,
432: p_ci_cal_type IN igf_aw_coa_grp_item.ci_cal_type%TYPE,
433: p_ci_sequence_number IN igf_aw_coa_grp_item.ci_sequence_number%TYPE,
434: l_process_id IN NUMBER
435: ) IS
436:
437: -- Cursor retrieves all item and term information for a given group code and award year

Line 440: c_coa_code igf_aw_coa_grp_item.coa_code%TYPE,

436:
437: -- Cursor retrieves all item and term information for a given group code and award year
438:
439: CURSOR c_item_term_info(
440: c_coa_code igf_aw_coa_grp_item.coa_code%TYPE,
441: c_ci_cal_type igf_aw_coa_grp_item.ci_cal_type%TYPE,
442: c_ci_sequence_number igf_aw_coa_grp_item.ci_sequence_number%TYPE
443: ) IS
444: SELECT grp.item_code,

Line 441: c_ci_cal_type igf_aw_coa_grp_item.ci_cal_type%TYPE,

437: -- Cursor retrieves all item and term information for a given group code and award year
438:
439: CURSOR c_item_term_info(
440: c_coa_code igf_aw_coa_grp_item.coa_code%TYPE,
441: c_ci_cal_type igf_aw_coa_grp_item.ci_cal_type%TYPE,
442: c_ci_sequence_number igf_aw_coa_grp_item.ci_sequence_number%TYPE
443: ) IS
444: SELECT grp.item_code,
445: grp.fixed_cost,

Line 442: c_ci_sequence_number igf_aw_coa_grp_item.ci_sequence_number%TYPE

438:
439: CURSOR c_item_term_info(
440: c_coa_code igf_aw_coa_grp_item.coa_code%TYPE,
441: c_ci_cal_type igf_aw_coa_grp_item.ci_cal_type%TYPE,
442: c_ci_sequence_number igf_aw_coa_grp_item.ci_sequence_number%TYPE
443: ) IS
444: SELECT grp.item_code,
445: grp.fixed_cost,
446: grp.default_value item_amount,

Line 453: FROM igf_aw_coa_grp_item grp,

449: grp.lock_flag,
450: def.ld_cal_type,
451: def.ld_sequence_number,
452: def.ld_perct
453: FROM igf_aw_coa_grp_item grp,
454: igf_aw_coa_ld def
455: WHERE grp.coa_code = c_coa_code
456: AND grp.ci_cal_type = c_ci_cal_type
457: AND grp.ci_sequence_number = c_ci_sequence_number

Line 476: igf_aw_coa_grp_item grp

472: ovrd.ld_cal_type,
473: ovrd.ld_sequence_number,
474: ovrd.ld_perct
475: FROM igf_aw_cit_ld_overide ovrd ,
476: igf_aw_coa_grp_item grp
477: WHERE grp.coa_code = c_coa_code
478: AND grp.ci_cal_type = c_ci_cal_type
479: AND grp.ci_sequence_number = c_ci_sequence_number
480: AND grp.coa_code = ovrd.coa_code

Line 575: p_grp_code IN igf_aw_coa_grp_item.coa_code%TYPE,

571: --CREATED BY :gmuralid
572: -------------------------------------------------------------------------------------------------
573: PROCEDURE add_coa_items(
574: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
575: p_grp_code IN igf_aw_coa_grp_item.coa_code%TYPE,
576: exeorder IN VARCHAR2,
577: l_process_id IN NUMBER,
578: result OUT NOCOPY VARCHAR2
579: ) IS

Line 1740: p_grp_code igf_aw_coa_grp_item.coa_code%TYPE,

1736:
1737:
1738: PROCEDURE process_student(
1739: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1740: p_grp_code igf_aw_coa_grp_item.coa_code%TYPE,
1741: p_process_id NUMBER
1742: ) IS
1743: ------------------------------------------------------------------
1744: --Created by :

Line 1988: p_grp_code IN igf_aw_coa_grp_item.coa_code%TYPE,

1984: PROCEDURE run(
1985: errbuf OUT NOCOPY VARCHAR2,
1986: retcode OUT NOCOPY NUMBER,
1987: p_award_year IN VARCHAR2,
1988: p_grp_code IN igf_aw_coa_grp_item.coa_code%TYPE,
1989: p_update_coa IN VARCHAR2,
1990: p_update_method IN VARCHAR2,
1991: l_run_type IN VARCHAR2,
1992: p_pergrp_id IN igs_pe_prsid_grp_mem_all.group_id%TYPE,