APPS.IGF_GR_GEN dependencies on IGF_AW_COA_GRP_ITEM

Line 1520: p_item_code IN igf_aw_coa_grp_item_all.item_code%TYPE

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:
1524: --

Line 1544: igf_aw_coa_grp_item

1540: IS
1541: SELECT
1542: *
1543: FROM
1544: igf_aw_coa_grp_item
1545: WHERE
1546: coa_code = p_coa_code AND
1547: ci_cal_type = p_cal_type AND
1548: ci_sequence_number = p_sequence_number;

Line 1576: p_item_code igf_aw_coa_grp_item_all.item_code%TYPE)

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
1580: FROM

Line 1626: igf_aw_coa_grp_item_pkg.delete_row(coa_items_rec.row_id);

1622: -- Delete Items only if p_record = COA_GROUP
1623: --
1624:
1625: IF p_record = 'COA_GROUP' THEN
1626: igf_aw_coa_grp_item_pkg.delete_row(coa_items_rec.row_id);
1627: END IF;
1628:
1629: --
1630: -- Update Items with item_dist = 'N' only if p_record = COA_TERM

Line 1634: igf_aw_coa_grp_item_pkg.update_row (

1630: -- Update Items with item_dist = 'N' only if p_record = COA_TERM
1631: --
1632:
1633: IF p_record = 'COA_TERM' THEN
1634: igf_aw_coa_grp_item_pkg.update_row (
1635: x_mode => 'R',
1636: x_rowid => coa_items_rec.row_id,
1637: x_coa_code => coa_items_rec.coa_code,
1638: x_ci_cal_type => coa_items_rec.ci_cal_type,

Line 1720: igf_aw_coa_grp_item

1716: IS
1717: SELECT
1718: *
1719: FROM
1720: igf_aw_coa_grp_item
1721: WHERE
1722: item_code = p_item_code AND
1723: coa_code = p_coa_code AND
1724: ci_cal_type = p_cal_type AND

Line 1773: lv_item_dist igf_aw_coa_grp_item_all.item_dist%TYPE;

1769: ld_sequence_number;
1770:
1771: overide_ld_rec cur_overide_ld%ROWTYPE;
1772:
1773: lv_item_dist igf_aw_coa_grp_item_all.item_dist%TYPE;
1774:
1775: CURSOR cur_pct_total( p_coa_code igf_aw_cit_ld_ovrd_all.coa_code%TYPE,
1776: p_cal_type igf_aw_cit_ld_ovrd_all.ci_cal_type%TYPE,
1777: p_sequence_number igf_aw_cit_ld_ovrd_all.ci_sequence_number%TYPE,

Line 1889: igf_aw_coa_grp_item_pkg.update_row (

1885: END IF;
1886:
1887: IF NVL(coa_items_rec.item_dist,'N') <> lv_item_dist THEN
1888:
1889: igf_aw_coa_grp_item_pkg.update_row (
1890: x_mode => 'R',
1891: x_rowid => coa_items_rec.row_id,
1892: x_coa_code => coa_items_rec.coa_code,
1893: x_ci_cal_type => coa_items_rec.ci_cal_type,

Line 2159: p_item_code IN igf_aw_coa_grp_item_all.item_code%TYPE,

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:
2163: IS