APPS.IGF_AW_GEN_004 dependencies on IGF_AP_ST_CORR_TEXT

Line 1996: igf_ap_st_corr_text ctext

1992: CURSOR cur_corr_text
1993: IS
1994: SELECT ctext.rowid row_id,ctext.*
1995: FROM
1996: igf_ap_st_corr_text ctext
1997: WHERE
1998: ctext.active = 'N' AND
1999: ctext.base_id IN (SELECT base_id
2000: FROM

Line 2015: igf_ap_st_corr_text_pkg.update_row (

2011: LOOP
2012: FETCH cur_corr_text INTO l_cur_corr_text;
2013: EXIT WHEN cur_corr_text%NOTFOUND;
2014:
2015: igf_ap_st_corr_text_pkg.update_row (
2016: x_mode => 'R',
2017: x_rowid => l_cur_corr_text.row_id,
2018: x_corsp_id => l_cur_corr_text.corsp_id,
2019: x_base_id => l_cur_corr_text.base_id,

Line 2192: igf_ap_st_corr_text corr,

2188: l_data_text VARCHAR2(32000);
2189: CURSOR c_cust_text IS
2190: SELECT corr.custom_text
2191: FROM
2192: igf_ap_st_corr_text corr,
2193: igf_ap_fa_base_rec_all fbase
2194: WHERE
2195: fbase.base_id = corr.base_id AND
2196: fbase.person_id = p_person_id AND