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_AP_LG_VER_IMP dependencies on IGF_AP_FA_BASE_REC

Line 19: FROM igf_ap_fa_base_rec fabase,

15:
16: -- global cursor for fa base rec
17: CURSOR c_fabase ( p_person_number hz_parties.party_number%TYPE ) IS
18: SELECT fabase.*
19: FROM igf_ap_fa_base_rec fabase,
20: hz_parties hz
21: WHERE hz.party_id = fabase.person_id
22: AND hz.party_number = p_person_number
23: AND fabase.ci_cal_type = g_ci_cal_type

Line 134: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

130: END print_log_process;
131:
132:
133: PROCEDURE check_dup_ver ( p_sar_num IN igf_ap_inst_ver_item_all.isir_map_col%TYPE,
134: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
135: p_dup_ver OUT NOCOPY BOOLEAN ) IS
136: /*
137: || Created By : masehgal
138: || Created On : 28-May-2003

Line 178: p_pay_isir_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

174: END check_dup_ver ;
175:
176:
177: PROCEDURE chk_corr_items (p_sar_num IN igf_ap_inst_ver_item_all.isir_map_col%TYPE,
178: p_pay_isir_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
179: p_corr_exist OUT NOCOPY BOOLEAN ) IS
180: /*
181: || Created By : masehgal
182: || Created On : 28-May-2003

Line 220: PROCEDURE delete_ver_items ( p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

216:
217: END chk_corr_items ;
218:
219:
220: PROCEDURE delete_ver_items ( p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
221: p_sar_num IN igf_ap_inst_ver_item_all.isir_map_col%TYPE ) IS
222: /*
223: || Created By : masehgal
224: || Created On : 28-May-2003

Line 232: CURSOR del_ver_items( cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

228: || Who When What
229: || (reverse chronological order - newest change first)
230: */
231:
232: CURSOR del_ver_items( cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
233: cp_sar_num igf_ap_inst_ver_item_all.isir_map_col%TYPE ) IS
234: SELECT rowid
235: FROM igf_ap_inst_ver_item_all
236: WHERE base_id = cp_base_id

Line 260: PROCEDURE upd_fed_verif_status ( p_fed_verif_status igf_ap_fa_base_rec_all.fed_verif_status%TYPE ) IS

256: END delete_ver_items ;
257:
258:
259:
260: PROCEDURE upd_fed_verif_status ( p_fed_verif_status igf_ap_fa_base_rec_all.fed_verif_status%TYPE ) IS
261: /*
262: || Created By : masehgal
263: || Created On : 28-May-2003
264: || Purpose : updation of verification status

Line 270: || igf_ap_fa_base_rec_pkg.update_row

266: || Change History :
267: || Who When What
268: || rasahoo 17-NOV-2003 FA 128 - ISIR update 2004-05
269: || added new parameter award_fmly_contribution_type to
270: || igf_ap_fa_base_rec_pkg.update_row
271: || ugummall 26-SEP-2003 FA 126 - Multiple FA Offices.
272: || added new parameter assoc_org_num to TBH call of
273: || igf_ap_fa_base_rec_pkg w.r.t. FA 126
274: ||

Line 273: || igf_ap_fa_base_rec_pkg w.r.t. FA 126

269: || added new parameter award_fmly_contribution_type to
270: || igf_ap_fa_base_rec_pkg.update_row
271: || ugummall 26-SEP-2003 FA 126 - Multiple FA Offices.
272: || added new parameter assoc_org_num to TBH call of
273: || igf_ap_fa_base_rec_pkg w.r.t. FA 126
274: ||
275: || (reverse chronological order - newest change first)
276: */
277:

Line 282: igf_ap_fa_base_rec_pkg.update_row(

278: BEGIN
279: -- get base rec values
280:
281: -- update fa base rec with new verif status ...
282: igf_ap_fa_base_rec_pkg.update_row(
283: x_rowid => g_fabase.row_id,
284: x_base_id => g_fabase.base_id,
285: x_ci_cal_type => g_fabase.ci_cal_type,
286: x_person_id => g_fabase.person_id,

Line 441: l_fa_base_id igf_ap_fa_base_rec.base_id%TYPE;

437: l_alternate_code igs_ca_inst.alternate_code%TYPE ;
438: l_rec_processed NUMBER;
439: l_rec_imported NUMBER;
440: l_last_person_number igf_ap_li_vern_ints.person_number%TYPE ;
441: l_fa_base_id igf_ap_fa_base_rec.base_id%TYPE;
442: l_person_id igf_ap_fa_base_rec.person_id%TYPE;
443: l_dup_item_found BOOLEAN;
444: l_pay_isir_id igf_ap_isir_matched.isir_id%TYPE ;
445: l_act_isir_id igf_ap_isir_matched.isir_id%TYPE ;

Line 442: l_person_id igf_ap_fa_base_rec.person_id%TYPE;

438: l_rec_processed NUMBER;
439: l_rec_imported NUMBER;
440: l_last_person_number igf_ap_li_vern_ints.person_number%TYPE ;
441: l_fa_base_id igf_ap_fa_base_rec.base_id%TYPE;
442: l_person_id igf_ap_fa_base_rec.person_id%TYPE;
443: l_dup_item_found BOOLEAN;
444: l_pay_isir_id igf_ap_isir_matched.isir_id%TYPE ;
445: l_act_isir_id igf_ap_isir_matched.isir_id%TYPE ;
446: l_error igf_lookups_view.meaning%TYPE ;

Line 450: l_fed_verif_status igf_ap_fa_base_rec_all.fed_verif_status%TYPE ;

446: l_error igf_lookups_view.meaning%TYPE ;
447: l_person_number igf_lookups_view.meaning%TYPE ;
448: l_token VARCHAR2(60) ;
449: l_corr_exist BOOLEAN ;
450: l_fed_verif_status igf_ap_fa_base_rec_all.fed_verif_status%TYPE ;
451: l_new_fed_verif_status igf_ap_fa_base_rec_all.fed_verif_status%TYPE ;
452: l_orig_value VARCHAR2(1000);
453: l_doc_value VARCHAR2(1000);
454: lv_rowid ROWID ;

Line 451: l_new_fed_verif_status igf_ap_fa_base_rec_all.fed_verif_status%TYPE ;

447: l_person_number igf_lookups_view.meaning%TYPE ;
448: l_token VARCHAR2(60) ;
449: l_corr_exist BOOLEAN ;
450: l_fed_verif_status igf_ap_fa_base_rec_all.fed_verif_status%TYPE ;
451: l_new_fed_verif_status igf_ap_fa_base_rec_all.fed_verif_status%TYPE ;
452: l_orig_value VARCHAR2(1000);
453: l_doc_value VARCHAR2(1000);
454: lv_rowid ROWID ;
455: lv_stmt VARCHAR2(2000);