APPS.IGF_AP_LG_VER_IMP dependencies on IGF_AP_FA_BASE_REC_ALL

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 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);