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_AW_FISAP_PKG dependencies on IGF_AW_FISAP_REP

Line 454: FROM IGF_AW_FISAP_REP rep

450: ***************************************************************/
451:
452: CURSOR cur_fisap_rep(cp_batch_id NUMBER) IS
453: SELECT rep.ROWID row_id
454: FROM IGF_AW_FISAP_REP rep
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

Line 581: -- 3. inserts all eligible students in IGF_AW_FISAP_REP table.

577: --
578: -- Steps
579: -- 1. print parameters
580: -- 2. delete previous batches based on p_retain_prev_batches param
581: -- 3. inserts all eligible students in IGF_AW_FISAP_REP table.
582: -- 4. raise business event to send notification mail
583: --
584:
585: igf_aw_gen.set_org_id(NULL);

Line 614: igf_aw_fisap_rep_pkg.delete_row(rec_fisap_rep.row_id);

610: LOOP
611: -- delete from the child(reporting) table
612: FOR rec_fisap_rep IN cur_fisap_rep(rec_fisap_batch.batch_id)
613: LOOP
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);

Line 699: -- INSERT this record into the IGF_AW_FISAP_REP table

695: x_mode => 'R'
696: );
697: END IF;
698:
699: -- INSERT this record into the IGF_AW_FISAP_REP table
700: -- call table handler to insert the record with the above calculated
701: -- attributes and collect the primary key fisap_dtls_id which may be
702: -- used in Part VI for updating record with Part VI information.
703: igf_aw_fisap_rep_pkg.insert_row (

Line 703: igf_aw_fisap_rep_pkg.insert_row (

699: -- INSERT this record into the IGF_AW_FISAP_REP table
700: -- call table handler to insert the record with the above calculated
701: -- attributes and collect the primary key fisap_dtls_id which may be
702: -- used in Part VI for updating record with Part VI information.
703: igf_aw_fisap_rep_pkg.insert_row (
704: x_rowid => lv_rep_rowid,
705: x_fisap_dtls_id => ln_fisap_dtls_id,
706: x_batch_id => ln_batch_id,
707: x_isir_id => ln_isir_id,

Line 765: -- UPDATE/INSERT this record into the IGF_AW_FISAP_REP table

761: x_mode => 'R'
762: );
763: END IF;
764:
765: -- UPDATE/INSERT this record into the IGF_AW_FISAP_REP table
766: igf_aw_fisap_rep_pkg.add_row (
767: x_rowid => lv_rep_rowid,
768: x_fisap_dtls_id => ln_fisap_dtls_id,
769: x_batch_id => ln_batch_id,

Line 766: igf_aw_fisap_rep_pkg.add_row (

762: );
763: END IF;
764:
765: -- UPDATE/INSERT this record into the IGF_AW_FISAP_REP table
766: igf_aw_fisap_rep_pkg.add_row (
767: x_rowid => lv_rep_rowid,
768: x_fisap_dtls_id => ln_fisap_dtls_id,
769: x_batch_id => ln_batch_id,
770: x_isir_id => ln_isir_id,

Line 863: FROM IGF_AW_FISAP_REP fisap,

859: SELECT fs.start_range_amt,
860: fs.end_range_amt,
861: SUM(DECODE(NVL(fisap.career_level, 'ZERO'), 'UG_WOUT', 1, 0)) AS ug_wout,
862: SUM(DECODE(NVL(fisap.career_level, 'ZERO'), 'UG_WITH', 1, 0)) AS ug_with
863: FROM IGF_AW_FISAP_REP fisap,
864: IGF_AW_FISAP_RANGES fs,
865: IGF_AP_BATCH_AW_MAP_ALL awmap
866: WHERE awmap.ci_cal_type = cp_cal_type
867: AND awmap.ci_sequence_number = cp_seq_number

Line 887: FROM IGF_AW_FISAP_REP fisap,

883: fs.end_range_amt,
884: SUM(DECODE(NVL(fisap.career_level, 'ZERO'), 'UG_WOUT', 1, 0)) AS ug_wout,
885: SUM(DECODE(NVL(fisap.career_level, 'ZERO'), 'UG_WITH', 1, 0)) AS ug_with,
886: SUM(DECODE(NVL(fisap.career_level, 'ZERO'), 'GRAD_PROF', 1, 0)) AS grad_prof
887: FROM IGF_AW_FISAP_REP fisap,
888: IGF_AW_FISAP_RANGES fs,
889: IGF_AP_BATCH_AW_MAP_ALL awmap
890: WHERE awmap.ci_cal_type = cp_cal_type
891: AND awmap.ci_sequence_number = cp_seq_number

Line 908: FROM IGF_AW_FISAP_REP fisap

904:
905: CURSOR cur_2f_depend_efc ( cp_batch_id IN NUMBER) IS
906: SELECT SUM(DECODE(NVL(fisap.career_level, 'ZERO'), 'UG_WOUT', 1, 0)) AS ug_wout,
907: SUM(DECODE(NVL(fisap.career_level, 'ZERO'), 'UG_WITH', 1, 0)) AS ug_with
908: FROM IGF_AW_FISAP_REP fisap
909: WHERE fisap.batch_id = cp_batch_id
910: AND fisap.dependency_status = 'D'
911: AND fisap.auto_zero_efc_flag = 'Y'
912: AND fisap.part_ii_section_f_flag = 'Y'

Line 920: FROM IGF_AW_FISAP_REP fisap

916: CURSOR cur_2f_independ_efc ( cp_batch_id IN NUMBER) IS
917: SELECT SUM(DECODE(NVL(fisap.career_level, 'ZERO'), 'UG_WOUT', 1, 0)) AS ug_wout,
918: SUM(DECODE(NVL(fisap.career_level, 'ZERO'), 'UG_WITH', 1, 0)) AS ug_with,
919: SUM(DECODE(NVL(fisap.career_level, 'ZERO'), 'GRAD_PROF', 1, 0)) AS grad_prof
920: FROM IGF_AW_FISAP_REP fisap
921: WHERE fisap.batch_id = cp_batch_id
922: AND fisap.dependency_status = 'I'
923: AND fisap.auto_zero_efc_flag = 'Y'
924: AND fisap.part_ii_section_f_flag = 'Y'

Line 943: FROM IGF_AW_FISAP_REP FISAP,

939: DECODE(NVL(fisap.fws_disb_amt, -1), -1, 0, 1) ,
940: 0, 0, 1
941: )
942: ) g
943: FROM IGF_AW_FISAP_REP FISAP,
944: IGF_AW_FISAP_RANGES FS,
945: IGF_AP_BATCH_AW_MAP_ALL AWMAP
946: WHERE awmap.ci_cal_type = cp_cal_type
947: AND awmap.ci_sequence_number = cp_seq_number

Line 977: FROM IGF_AW_FISAP_REP fisap,

973: DECODE(NVL(fisap.fws_disb_amt, -1), -1, 0, 1) ,
974: 0, 0, 1
975: )
976: ) g
977: FROM IGF_AW_FISAP_REP fisap,
978: IGF_AW_FISAP_RANGES fs,
979: IGF_AP_BATCH_AW_MAP_ALL awmap
980: WHERE awmap.ci_cal_type = cp_cal_type
981: AND awmap.ci_sequence_number = cp_seq_number

Line 1006: FROM IGF_AW_FISAP_REP FISAP

1002: DECODE(NVL(fisap.fws_disb_amt, -1), -1, 0, 1) ,
1003: 0, 0, 1
1004: )
1005: ) g
1006: FROM IGF_AW_FISAP_REP FISAP
1007: WHERE fisap.batch_id = cp_batch_id
1008: AND fisap.dependency_status = 'I'
1009: AND fisap.career_level = 'GRAD_PROF'
1010: AND fisap.part_vi_section_a_flag = 'Y';

Line 1025: FROM IGF_AW_FISAP_REP fisap

1021: DECODE(NVL(fisap.fws_disb_amt, -1), -1, 0, 1) ,
1022: 0, 0, 1
1023: )
1024: ) g
1025: FROM IGF_AW_FISAP_REP fisap
1026: WHERE fisap.batch_id = cp_batch_id
1027: AND fisap.enrollment_status = 'FT'
1028: AND fisap.part_vi_section_a_flag = 'Y';
1029: rec_ltfulltime cur_ltfulltime%ROWTYPE;

Line 1044: FROM IGF_AW_FISAP_REP fisap

1040: DECODE(NVL(fisap.fws_disb_amt, -1), -1, 0, 1) ,
1041: 0, 0, 1
1042: )
1043: ) g
1044: FROM IGF_AW_FISAP_REP fisap
1045: WHERE fisap.batch_id = cp_batch_id
1046: AND fisap.auto_zero_efc_flag = 'Y'
1047: AND fisap.part_vi_section_a_flag = 'Y';
1048: rec_6a_efc cur_6a_efc%ROWTYPE;