APPS.IGF_AW_GEN_004 dependencies on IGF_AP_TD_ITEM_INST

Line 1791: FROM igf_ap_td_item_inst tdii

1787: tdii.corsp_count,
1788: tdii.inactive_flag,
1789: tdii.freq_attempt,
1790: tdii.max_attempt
1791: FROM igf_ap_td_item_inst tdii
1792: WHERE NVL(tdii.inactive_flag,'N') = 'N'
1793: AND tdii.status IN ('INC', 'REQ')
1794: AND tdii.base_id = l_base_id;
1795:

Line 1808: l_newcorsp_dt igf_ap_td_item_inst_all.corsp_date%TYPE;

1804: fabase.ci_sequence_number = TO_NUMBER (RTRIM (SUBSTR (p_param1, 11)));
1805:
1806: l_tdrec c_tdcur%ROWTYPE;
1807: l_base igf_ap_fa_base_rec_all.base_id%TYPE;
1808: l_newcorsp_dt igf_ap_td_item_inst_all.corsp_date%TYPE;
1809: l_new_cnt NUMBER;
1810: BEGIN
1811:
1812: -- Get the Baseid for the person in an award year

Line 1969: -- in the table handler calls for igf_ap_td_item_inst_pkg.update_row

1965: Change History
1966: Who When What
1967: --bkkumar 04-jun-2003 Bug #2858504
1968: -- Added legacy_record_flag
1969: -- in the table handler calls for igf_ap_td_item_inst_pkg.update_row
1970: (reverse chronological order - newest change first)
1971: ***************************************************************/
1972:
1973: /*Cursor to get the incomplete to items for the person in an award year*/

Line 1979: igf_ap_td_item_inst_all tdii,

1975: CURSOR cur_incomp_items
1976: IS
1977: SELECT tdii.rowid row_id,tdii.*
1978: FROM
1979: igf_ap_td_item_inst_all tdii,
1980: igf_ap_fa_base_rec_all facon
1981: WHERE
1982: facon.base_id = tdii.base_id AND
1983: NVL(tdii.inactive_flag,'N')='N' AND

Line 2035: igf_ap_td_item_inst_pkg.update_row (

2031: LOOP
2032: FETCH cur_incomp_items INTO l_cur_incomp_items;
2033: EXIT WHEN cur_incomp_items%NOTFOUND;
2034:
2035: igf_ap_td_item_inst_pkg.update_row (
2036: x_rowid => l_cur_incomp_items.row_id,
2037: x_base_id => l_cur_incomp_items.base_id,
2038: x_item_sequence_number => l_cur_incomp_items.item_sequence_number,
2039: x_status => l_cur_incomp_items.status,