APPS.IGF_GR_GEN dependencies on IGF_AW_COA_LD

Line 1563: igf_aw_coa_ld

1559: IS
1560: SELECT
1561: row_id
1562: FROM
1563: igf_aw_coa_ld
1564: WHERE
1565: coa_code = p_coa_code AND
1566: ci_cal_type = p_cal_type AND
1567: ci_sequence_number = p_sequence_number;

Line 1662: igf_aw_coa_ld_pkg.delete_row(l_term.row_id);

1658: FOR l_term IN cur_coa_terms(p_coa_code,
1659: p_cal_type,
1660: p_sequence_number)
1661: LOOP
1662: igf_aw_coa_ld_pkg.delete_row(l_term.row_id);
1663: END LOOP;
1664:
1665: END IF;
1666:

Line 1740: igf_aw_coa_ld

1736: IS
1737: SELECT
1738: ld_perct
1739: FROM
1740: igf_aw_coa_ld
1741: WHERE
1742: coa_code = p_coa_code AND
1743: ci_cal_type = p_cal_type AND
1744: ci_sequence_number = p_sequence_number

Line 1797: TYPE def_list IS TABLE OF igf_aw_coa_ld.ld_perct%TYPE

1793: --
1794: -- PL/SQL table to store default load %
1795: --
1796:
1797: TYPE def_list IS TABLE OF igf_aw_coa_ld.ld_perct%TYPE
1798: INDEX BY BINARY_INTEGER;
1799: def_ele def_list;
1800:
1801: --

Line 2180: igf_aw_coa_ld

2176: ld_perct,
2177: ci_cal_type,
2178: ci_sequence_number
2179: FROM
2180: igf_aw_coa_ld
2181: WHERE
2182: coa_code = p_coa_code AND
2183: ci_cal_type = p_cal_type AND
2184: ci_sequence_number = p_sequence_number;

Line 2279: p_ld_cal_type IN igf_aw_coa_ld_all.ld_cal_type%TYPE,

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

Line 2280: p_ld_sequence_number IN igf_aw_coa_ld_all.ld_sequence_number%TYPE

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:
2283: IS
2284:

Line 2346: p_ld_cal_type IN igf_aw_coa_ld_all.ld_cal_type%TYPE,

2342: END insert_coa_terms;
2343:
2344:
2345: PROCEDURE insert_stu_coa_terms( p_base_id IN igf_aw_coa_itm_terms.base_id%TYPE,
2346: p_ld_cal_type IN igf_aw_coa_ld_all.ld_cal_type%TYPE,
2347: p_ld_sequence_number IN igf_aw_coa_ld_all.ld_sequence_number%TYPE,
2348: p_result OUT NOCOPY VARCHAR2
2349: )
2350: IS

Line 2347: p_ld_sequence_number IN igf_aw_coa_ld_all.ld_sequence_number%TYPE,

2343:
2344:
2345: PROCEDURE insert_stu_coa_terms( p_base_id IN igf_aw_coa_itm_terms.base_id%TYPE,
2346: p_ld_cal_type IN igf_aw_coa_ld_all.ld_cal_type%TYPE,
2347: p_ld_sequence_number IN igf_aw_coa_ld_all.ld_sequence_number%TYPE,
2348: p_result OUT NOCOPY VARCHAR2
2349: )
2350: IS
2351:

Line 2447: p_ld_cal_type IN igf_aw_coa_ld_all.ld_cal_type%TYPE,

2443:
2444: END insert_existing_terms;
2445:
2446: PROCEDURE delete_stu_coa_terms( p_base_id IN igf_aw_coa_itm_terms.base_id%TYPE,
2447: p_ld_cal_type IN igf_aw_coa_ld_all.ld_cal_type%TYPE,
2448: p_ld_sequence_number IN igf_aw_coa_ld_all.ld_sequence_number%TYPE,
2449: p_result OUT NOCOPY VARCHAR2
2450: )
2451:

Line 2448: p_ld_sequence_number IN igf_aw_coa_ld_all.ld_sequence_number%TYPE,

2444: END insert_existing_terms;
2445:
2446: PROCEDURE delete_stu_coa_terms( p_base_id IN igf_aw_coa_itm_terms.base_id%TYPE,
2447: p_ld_cal_type IN igf_aw_coa_ld_all.ld_cal_type%TYPE,
2448: p_ld_sequence_number IN igf_aw_coa_ld_all.ld_sequence_number%TYPE,
2449: p_result OUT NOCOPY VARCHAR2
2450: )
2451:
2452: IS

Line 2456: p_ld_cal_type igf_aw_coa_ld_all.ld_cal_type%TYPE,

2452: IS
2453:
2454:
2455: CURSOR cur_get_terms (p_base_id igf_aw_coa_itm_terms.base_id%TYPE,
2456: p_ld_cal_type igf_aw_coa_ld_all.ld_cal_type%TYPE,
2457: p_ld_sequence_number igf_aw_coa_ld_all.ld_sequence_number%TYPE
2458: )
2459: IS
2460: SELECT rowid

Line 2457: p_ld_sequence_number igf_aw_coa_ld_all.ld_sequence_number%TYPE

2453:
2454:
2455: CURSOR cur_get_terms (p_base_id igf_aw_coa_itm_terms.base_id%TYPE,
2456: p_ld_cal_type igf_aw_coa_ld_all.ld_cal_type%TYPE,
2457: p_ld_sequence_number igf_aw_coa_ld_all.ld_sequence_number%TYPE
2458: )
2459: IS
2460: SELECT rowid
2461: FROM igf_aw_coa_itm_terms