APPS.IGF_AP_LG_COA_IMP dependencies on IGF_AP_FA_BASE_REC

Line 179: PROCEDURE check_person_terms ( p_fa_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

175: END chk_per_rec_stat;
176:
177:
178:
179: PROCEDURE check_person_terms ( p_fa_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
180: l_per_terms_match OUT NOCOPY BOOLEAN ) IS
181: /*
182: || Created By : masehgal
183: || Created On : 28-May-2003

Line 192: CURSOR person_coa_items (cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE ) IS

188: || (reverse chronological order - newest change first)
189: */
190:
191: -- Select All COA Items for a person
192: CURSOR person_coa_items (cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE ) IS
193: SELECT DISTINCT item_code
194: FROM igf_aw_coa_items
195: WHERE base_id = cp_base_id ;
196: l_item_code person_coa_items%ROWTYPE;

Line 252: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

248: END check_person_terms ;
249:
250:
251: PROCEDURE check_dup_coa ( p_item_code IN igf_aw_coa_itm_terms.item_code%TYPE,
252: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
253: p_dup_coa OUT NOCOPY BOOLEAN ) IS
254: /*
255: || Created By : masehgal
256: || Created On : 28-May-2003

Line 264: CURSOR chk_dup_coa ( cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

260: || Who When What
261: || (reverse chronological order - newest change first)
262: */
263:
264: CURSOR chk_dup_coa ( cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
265: cp_item_code igf_aw_coa_items.item_code%TYPE) IS
266: SELECT 1
267: FROM igf_aw_coa_items
268: WHERE base_id = cp_base_id

Line 299: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

295:
296: PROCEDURE check_dup_coa_term ( p_item_code IN igf_aw_coa_itm_terms.item_code%TYPE,
297: p_ld_cal_type IN igs_ca_inst.cal_type%TYPE,
298: p_ld_seq_num IN igs_ca_inst.sequence_number%TYPE,
299: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
300: p_dup_term OUT NOCOPY BOOLEAN ) IS
301: /*
302: || Created By : masehgal
303: || Created On : 28-May-2003

Line 311: CURSOR chk_dup_term ( cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

307: || Who When What
308: || (reverse chronological order - newest change first)
309: */
310:
311: CURSOR chk_dup_term ( cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
312: cp_item_code igf_aw_coa_itm_terms.item_code%TYPE,
313: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
314: cp_ld_seq_num igs_ca_inst.sequence_number%TYPE) IS
315: SELECT 1

Line 346: PROCEDURE delete_coa_terms ( p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE) IS

342:
343: END check_dup_coa_term ;
344:
345:
346: PROCEDURE delete_coa_terms ( p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE) IS
347: /*
348: || Created By : masehgal
349: || Created On : 28-May-2003
350: || Purpose : deletion of COA Terms

Line 383: PROCEDURE delete_coa_items ( p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE) IS

379: END delete_coa_terms ;
380:
381:
382:
383: PROCEDURE delete_coa_items ( p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE) IS
384: /*
385: || Created By : masehgal
386: || Created On : 28-May-2003
387: || Purpose : deletion of COA Items

Line 448: l_fa_base_id igf_ap_fa_base_rec.base_id%TYPE;

444: l_rec_imported NUMBER;
445: l_rec_error NUMBER;
446: l_last_person_number igf_aw_li_coa_ints.person_number%TYPE ;
447: l_item_setup_found BOOLEAN ;
448: l_fa_base_id igf_ap_fa_base_rec.base_id%TYPE;
449: l_person_id igf_ap_fa_base_rec.person_id%TYPE;
450: l_dup_item_found BOOLEAN;
451: l_dup_coa_found BOOLEAN;
452: l_per_terms_match BOOLEAN;

Line 449: l_person_id igf_ap_fa_base_rec.person_id%TYPE;

445: l_rec_error NUMBER;
446: l_last_person_number igf_aw_li_coa_ints.person_number%TYPE ;
447: l_item_setup_found BOOLEAN ;
448: l_fa_base_id igf_ap_fa_base_rec.base_id%TYPE;
449: l_person_id igf_ap_fa_base_rec.person_id%TYPE;
450: l_dup_item_found BOOLEAN;
451: l_dup_coa_found BOOLEAN;
452: l_per_terms_match BOOLEAN;
453: l_oss_terms_match BOOLEAN;