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_GR_GEN dependencies on IGF_AW_COA_GROUP_ALL

Line 1517: p_coa_code IN igf_aw_coa_group_all.coa_code%TYPE,

1513: END get_ssn_digits;
1514:
1515:
1516: PROCEDURE delete_coa( p_record IN VARCHAR2,
1517: p_coa_code IN igf_aw_coa_group_all.coa_code%TYPE,
1518: p_cal_type IN igf_aw_coa_group_all.ci_cal_type%TYPE,
1519: p_sequence_number IN igf_aw_coa_group_all.ci_sequence_number%TYPE,
1520: p_item_code IN igf_aw_coa_grp_item_all.item_code%TYPE
1521: )

Line 1518: p_cal_type IN igf_aw_coa_group_all.ci_cal_type%TYPE,

1514:
1515:
1516: PROCEDURE delete_coa( p_record IN VARCHAR2,
1517: p_coa_code IN igf_aw_coa_group_all.coa_code%TYPE,
1518: p_cal_type IN igf_aw_coa_group_all.ci_cal_type%TYPE,
1519: p_sequence_number IN igf_aw_coa_group_all.ci_sequence_number%TYPE,
1520: p_item_code IN igf_aw_coa_grp_item_all.item_code%TYPE
1521: )
1522: IS

Line 1519: p_sequence_number IN igf_aw_coa_group_all.ci_sequence_number%TYPE,

1515:
1516: PROCEDURE delete_coa( p_record IN VARCHAR2,
1517: p_coa_code IN igf_aw_coa_group_all.coa_code%TYPE,
1518: p_cal_type IN igf_aw_coa_group_all.ci_cal_type%TYPE,
1519: p_sequence_number IN igf_aw_coa_group_all.ci_sequence_number%TYPE,
1520: p_item_code IN igf_aw_coa_grp_item_all.item_code%TYPE
1521: )
1522: IS
1523:

Line 1534: CURSOR cur_coa_items ( p_coa_code igf_aw_coa_group_all.coa_code%TYPE,

1530: --
1531: -- Cursor to fetch the COA Items
1532: --
1533:
1534: CURSOR cur_coa_items ( p_coa_code igf_aw_coa_group_all.coa_code%TYPE,
1535: p_cal_type igf_aw_coa_group_all.ci_cal_type%TYPE,
1536: p_sequence_number igf_aw_coa_group_all.ci_sequence_number%TYPE
1537: )
1538:

Line 1535: p_cal_type igf_aw_coa_group_all.ci_cal_type%TYPE,

1531: -- Cursor to fetch the COA Items
1532: --
1533:
1534: CURSOR cur_coa_items ( p_coa_code igf_aw_coa_group_all.coa_code%TYPE,
1535: p_cal_type igf_aw_coa_group_all.ci_cal_type%TYPE,
1536: p_sequence_number igf_aw_coa_group_all.ci_sequence_number%TYPE
1537: )
1538:
1539:

Line 1536: p_sequence_number igf_aw_coa_group_all.ci_sequence_number%TYPE

1532: --
1533:
1534: CURSOR cur_coa_items ( p_coa_code igf_aw_coa_group_all.coa_code%TYPE,
1535: p_cal_type igf_aw_coa_group_all.ci_cal_type%TYPE,
1536: p_sequence_number igf_aw_coa_group_all.ci_sequence_number%TYPE
1537: )
1538:
1539:
1540: IS

Line 1555: CURSOR cur_coa_terms ( p_coa_code igf_aw_coa_group_all.coa_code%TYPE,

1551: --
1552: -- Cursor to fetch COA Terms
1553: --
1554:
1555: CURSOR cur_coa_terms ( p_coa_code igf_aw_coa_group_all.coa_code%TYPE,
1556: p_cal_type igf_aw_coa_group_all.ci_cal_type%TYPE,
1557: p_sequence_number igf_aw_coa_group_all.ci_sequence_number%TYPE
1558: )
1559: IS

Line 1556: p_cal_type igf_aw_coa_group_all.ci_cal_type%TYPE,

1552: -- Cursor to fetch COA Terms
1553: --
1554:
1555: CURSOR cur_coa_terms ( p_coa_code igf_aw_coa_group_all.coa_code%TYPE,
1556: p_cal_type igf_aw_coa_group_all.ci_cal_type%TYPE,
1557: p_sequence_number igf_aw_coa_group_all.ci_sequence_number%TYPE
1558: )
1559: IS
1560: SELECT

Line 1557: p_sequence_number igf_aw_coa_group_all.ci_sequence_number%TYPE

1553: --
1554:
1555: CURSOR cur_coa_terms ( p_coa_code igf_aw_coa_group_all.coa_code%TYPE,
1556: p_cal_type igf_aw_coa_group_all.ci_cal_type%TYPE,
1557: p_sequence_number igf_aw_coa_group_all.ci_sequence_number%TYPE
1558: )
1559: IS
1560: SELECT
1561: row_id

Line 1573: CURSOR cur_coa_ovrd_items( p_coa_code igf_aw_coa_group_all.coa_code%TYPE,

1569: --
1570: -- Cursor to fetch Overridden COA Items
1571: --
1572:
1573: CURSOR cur_coa_ovrd_items( p_coa_code igf_aw_coa_group_all.coa_code%TYPE,
1574: p_cal_type igf_aw_coa_group_all.ci_cal_type%TYPE,
1575: p_sequence_number igf_aw_coa_group_all.ci_sequence_number%TYPE,
1576: p_item_code igf_aw_coa_grp_item_all.item_code%TYPE)
1577: IS

Line 1574: p_cal_type igf_aw_coa_group_all.ci_cal_type%TYPE,

1570: -- Cursor to fetch Overridden COA Items
1571: --
1572:
1573: CURSOR cur_coa_ovrd_items( p_coa_code igf_aw_coa_group_all.coa_code%TYPE,
1574: p_cal_type igf_aw_coa_group_all.ci_cal_type%TYPE,
1575: p_sequence_number igf_aw_coa_group_all.ci_sequence_number%TYPE,
1576: p_item_code igf_aw_coa_grp_item_all.item_code%TYPE)
1577: IS
1578: SELECT

Line 1575: p_sequence_number igf_aw_coa_group_all.ci_sequence_number%TYPE,

1571: --
1572:
1573: CURSOR cur_coa_ovrd_items( p_coa_code igf_aw_coa_group_all.coa_code%TYPE,
1574: p_cal_type igf_aw_coa_group_all.ci_cal_type%TYPE,
1575: p_sequence_number igf_aw_coa_group_all.ci_sequence_number%TYPE,
1576: p_item_code igf_aw_coa_grp_item_all.item_code%TYPE)
1577: IS
1578: SELECT
1579: row_id

Line 2002: PROCEDURE ovrd_coa_exist( p_coa_code IN igf_aw_coa_group_all.coa_code%TYPE,

1998: -- ovrd_coa_exist will check if there are any overridden coa items
1999: -- for a coa group
2000: --
2001:
2002: PROCEDURE ovrd_coa_exist( p_coa_code IN igf_aw_coa_group_all.coa_code%TYPE,
2003: p_cal_type IN igf_aw_coa_group_all.ci_cal_type%TYPE,
2004: p_sequence_number IN igf_aw_coa_group_all.ci_sequence_number%TYPE,
2005: p_exist OUT NOCOPY VARCHAR2
2006: )

Line 2003: p_cal_type IN igf_aw_coa_group_all.ci_cal_type%TYPE,

1999: -- for a coa group
2000: --
2001:
2002: PROCEDURE ovrd_coa_exist( p_coa_code IN igf_aw_coa_group_all.coa_code%TYPE,
2003: p_cal_type IN igf_aw_coa_group_all.ci_cal_type%TYPE,
2004: p_sequence_number IN igf_aw_coa_group_all.ci_sequence_number%TYPE,
2005: p_exist OUT NOCOPY VARCHAR2
2006: )
2007: IS

Line 2004: p_sequence_number IN igf_aw_coa_group_all.ci_sequence_number%TYPE,

2000: --
2001:
2002: PROCEDURE ovrd_coa_exist( p_coa_code IN igf_aw_coa_group_all.coa_code%TYPE,
2003: p_cal_type IN igf_aw_coa_group_all.ci_cal_type%TYPE,
2004: p_sequence_number IN igf_aw_coa_group_all.ci_sequence_number%TYPE,
2005: p_exist OUT NOCOPY VARCHAR2
2006: )
2007: IS
2008:

Line 2156: PROCEDURE insert_coa_items( p_coa_code IN igf_aw_coa_group_all.coa_code%TYPE,

2152: app_exception.raise_exception;
2153:
2154: END get_tufees_code;
2155:
2156: PROCEDURE insert_coa_items( p_coa_code IN igf_aw_coa_group_all.coa_code%TYPE,
2157: p_cal_type IN igf_aw_coa_group_all.ci_cal_type%TYPE,
2158: p_sequence_number IN igf_aw_coa_group_all.ci_sequence_number%TYPE,
2159: p_item_code IN igf_aw_coa_grp_item_all.item_code%TYPE,
2160: p_count OUT NOCOPY NUMBER

Line 2157: p_cal_type IN igf_aw_coa_group_all.ci_cal_type%TYPE,

2153:
2154: END get_tufees_code;
2155:
2156: PROCEDURE insert_coa_items( p_coa_code IN igf_aw_coa_group_all.coa_code%TYPE,
2157: p_cal_type IN igf_aw_coa_group_all.ci_cal_type%TYPE,
2158: p_sequence_number IN igf_aw_coa_group_all.ci_sequence_number%TYPE,
2159: p_item_code IN igf_aw_coa_grp_item_all.item_code%TYPE,
2160: p_count OUT NOCOPY NUMBER
2161: )

Line 2158: p_sequence_number IN igf_aw_coa_group_all.ci_sequence_number%TYPE,

2154: END get_tufees_code;
2155:
2156: PROCEDURE insert_coa_items( p_coa_code IN igf_aw_coa_group_all.coa_code%TYPE,
2157: p_cal_type IN igf_aw_coa_group_all.ci_cal_type%TYPE,
2158: p_sequence_number IN igf_aw_coa_group_all.ci_sequence_number%TYPE,
2159: p_item_code IN igf_aw_coa_grp_item_all.item_code%TYPE,
2160: p_count OUT NOCOPY NUMBER
2161: )
2162:

Line 2276: PROCEDURE insert_coa_terms( p_coa_code IN igf_aw_coa_group_all.coa_code%TYPE,

2272: app_exception.raise_exception;
2273:
2274: END insert_coa_items;
2275:
2276: PROCEDURE insert_coa_terms( p_coa_code IN igf_aw_coa_group_all.coa_code%TYPE,
2277: p_cal_type IN igf_aw_coa_group_all.ci_cal_type%TYPE,
2278: p_sequence_number IN igf_aw_coa_group_all.ci_sequence_number%TYPE,
2279: p_ld_cal_type IN igf_aw_coa_ld_all.ld_cal_type%TYPE,
2280: p_ld_sequence_number IN igf_aw_coa_ld_all.ld_sequence_number%TYPE

Line 2277: p_cal_type IN igf_aw_coa_group_all.ci_cal_type%TYPE,

2273:
2274: END insert_coa_items;
2275:
2276: PROCEDURE insert_coa_terms( p_coa_code IN igf_aw_coa_group_all.coa_code%TYPE,
2277: p_cal_type IN igf_aw_coa_group_all.ci_cal_type%TYPE,
2278: p_sequence_number IN igf_aw_coa_group_all.ci_sequence_number%TYPE,
2279: p_ld_cal_type IN igf_aw_coa_ld_all.ld_cal_type%TYPE,
2280: p_ld_sequence_number IN igf_aw_coa_ld_all.ld_sequence_number%TYPE
2281: )

Line 2278: p_sequence_number IN igf_aw_coa_group_all.ci_sequence_number%TYPE,

2274: END insert_coa_items;
2275:
2276: PROCEDURE insert_coa_terms( p_coa_code IN igf_aw_coa_group_all.coa_code%TYPE,
2277: p_cal_type IN igf_aw_coa_group_all.ci_cal_type%TYPE,
2278: p_sequence_number IN igf_aw_coa_group_all.ci_sequence_number%TYPE,
2279: p_ld_cal_type IN igf_aw_coa_ld_all.ld_cal_type%TYPE,
2280: p_ld_sequence_number IN igf_aw_coa_ld_all.ld_sequence_number%TYPE
2281: )
2282:

Line 2285: CURSOR cur_get_items (p_coa_code igf_aw_coa_group_all.coa_code%TYPE,

2281: )
2282:
2283: IS
2284:
2285: CURSOR cur_get_items (p_coa_code igf_aw_coa_group_all.coa_code%TYPE,
2286: p_cal_type igf_aw_coa_group_all.ci_cal_type%TYPE,
2287: p_sequence_number igf_aw_coa_group_all.ci_sequence_number%TYPE)
2288: IS
2289: SELECT

Line 2286: p_cal_type igf_aw_coa_group_all.ci_cal_type%TYPE,

2282:
2283: IS
2284:
2285: CURSOR cur_get_items (p_coa_code igf_aw_coa_group_all.coa_code%TYPE,
2286: p_cal_type igf_aw_coa_group_all.ci_cal_type%TYPE,
2287: p_sequence_number igf_aw_coa_group_all.ci_sequence_number%TYPE)
2288: IS
2289: SELECT
2290: DISTINCT item_code

Line 2287: p_sequence_number igf_aw_coa_group_all.ci_sequence_number%TYPE)

2283: IS
2284:
2285: CURSOR cur_get_items (p_coa_code igf_aw_coa_group_all.coa_code%TYPE,
2286: p_cal_type igf_aw_coa_group_all.ci_cal_type%TYPE,
2287: p_sequence_number igf_aw_coa_group_all.ci_sequence_number%TYPE)
2288: IS
2289: SELECT
2290: DISTINCT item_code
2291: FROM