APPS.IGF_AW_FISAP_PKG dependencies on IGF_AW_FISAP_BATCH

Line 459: FROM IGF_AW_FISAP_BATCH batch

455: WHERE rep.batch_id = cp_batch_id;
456:
457: CURSOR cur_fisap_batch(cp_cal_type VARCHAR2, cp_seq_number NUMBER) IS
458: SELECT batch.ROWID row_id, batch.batch_id
459: FROM IGF_AW_FISAP_BATCH batch
460: WHERE batch.ci_cal_type = cp_cal_type
461: AND batch.ci_sequence_number = cp_seq_number;
462:
463: CURSOR cur_students(cp_cal_type VARCHAR2, cp_seq_number NUMBER) IS

Line 618: igf_aw_fisap_batch_pkg.delete_row(rec_fisap_batch.row_id);

614: igf_aw_fisap_rep_pkg.delete_row(rec_fisap_rep.row_id);
615: END LOOP;
616:
617: -- delete from the parent(batch) table
618: igf_aw_fisap_batch_pkg.delete_row(rec_fisap_batch.row_id);
619: END LOOP;
620: END IF;
621: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
622: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','after deleting previous batches');

Line 685: -- Insert batch record into IGF_AW_FISAP_BATCH table

681: IF is_eligible_aid_applicant(rec_student.base_id) THEN
682: lv_part_II_flag := 'Y';
683:
684: IF ln_batch_id IS NULL THEN
685: -- Insert batch record into IGF_AW_FISAP_BATCH table
686: -- ONLY ONCE in the entire process and collect the
687: -- primary key batch_id into lv_batch_id.
688: igf_aw_fisap_batch_pkg.insert_row (
689: x_rowid => lv_batch_rowid,

Line 688: igf_aw_fisap_batch_pkg.insert_row (

684: IF ln_batch_id IS NULL THEN
685: -- Insert batch record into IGF_AW_FISAP_BATCH table
686: -- ONLY ONCE in the entire process and collect the
687: -- primary key batch_id into lv_batch_id.
688: igf_aw_fisap_batch_pkg.insert_row (
689: x_rowid => lv_batch_rowid,
690: x_batch_id => ln_batch_id,
691: x_ci_cal_type => lv_cal_type,
692: x_ci_sequence_number => ln_seq_number,

Line 751: -- Insert batch record into IGF_AW_FISAP_BATCH table

747: FETCH cur_fseog_amount INTO ln_fseog_disb_amt;
748: CLOSE cur_fseog_amount;
749:
750: IF ln_batch_id IS NULL THEN
751: -- Insert batch record into IGF_AW_FISAP_BATCH table
752: -- ONLY ONCE in the entire process and collect the
753: -- primary key batch_id into lv_batch_id.
754: igf_aw_fisap_batch_pkg.insert_row (
755: x_rowid => lv_batch_rowid,

Line 754: igf_aw_fisap_batch_pkg.insert_row (

750: IF ln_batch_id IS NULL THEN
751: -- Insert batch record into IGF_AW_FISAP_BATCH table
752: -- ONLY ONCE in the entire process and collect the
753: -- primary key batch_id into lv_batch_id.
754: igf_aw_fisap_batch_pkg.insert_row (
755: x_rowid => lv_batch_rowid,
756: x_batch_id => ln_batch_id,
757: x_ci_cal_type => lv_cal_type,
758: x_ci_sequence_number => ln_seq_number,