APPS.IGF_AW_COA_CALC dependencies on IGF_AW_AWARD_T

Line 234: FROM igf_aw_award_t

230: FROM igf_aw_coa_itm_terms
231: WHERE base_id = c_base_id
232: MINUS
233: SELECT DISTINCT ld_cal_type,ld_sequence_number
234: FROM igf_aw_award_t
235: WHERE process_id = c_process_id;
236:
237: c_cal_chk_rec c_load_cal_chk%ROWTYPE;
238:

Line 245: FROM igf_aw_award_t

241: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
242: c_process_id NUMBER
243: ) IS
244: SELECT DISTINCT ld_cal_type,ld_sequence_number
245: FROM igf_aw_award_t
246: WHERE process_id = c_process_id
247: MINUS
248: SELECT DISTINCT ld_cal_type,ld_sequence_number
249: FROM igf_aw_coa_itm_terms

Line 427: -- The procedure populate_setup_table populates the temporary table igf_aw_award_t

423: END delete_coa;
424:
425:
426: ---------------------------------------------------------------------------------------
427: -- The procedure populate_setup_table populates the temporary table igf_aw_award_t
428: -- CREATED BY:gmuralid
429: --------------------------------------------------------------------------------------
430: PROCEDURE populate_setup_table(
431: p_grp_coa_code IN igf_aw_coa_grp_item.coa_code%TYPE,

Line 488: item_term_amount igf_aw_award_t.accepted_amt%TYPE;

484: AND grp.active = 'Y'
485: AND grp.item_dist = 'Y' ;
486:
487: items_rec c_item_term_info%ROWTYPE;
488: item_term_amount igf_aw_award_t.accepted_amt%TYPE;
489:
490: l_rowid ROWID;
491: l_sl_number NUMBER(15);
492:

Line 522: igf_aw_award_t_pkg.insert_row(

518: 'ld_cal->'||items_rec.ld_cal_type||
519: 'ld_seq->'||items_rec.ld_sequence_number);
520: END IF;
521:
522: igf_aw_award_t_pkg.insert_row(
523: x_rowid => l_rowid,
524: x_process_id => l_process_id,
525: x_sl_number => l_sl_number,
526: x_fund_id => NULL,

Line 610: FROM igf_aw_award_t

606: paid_amt pell_amount,
607: need_reduction_amt pell_alternate_amount,
608: tp_cal_type fixed_cost,
609: lock_award_flag
610: FROM igf_aw_award_t
611: WHERE process_id = c_process_id
612: ORDER BY temp_char_val1;
613: first_coa_rec c_first_coa%ROWTYPE;
614:

Line 623: c_item_code igf_aw_award_t.temp_char_val1%TYPE,

619: --
620:
621:
622: CURSOR c_first_itm_term(
623: c_item_code igf_aw_award_t.temp_char_val1%TYPE,
624: c_process_id NUMBER
625: ) IS
626: SELECT temp_char_val1 item_code,
627: accepted_amt item_term_amount,

Line 634: FROM igf_aw_award_t

630: tp_cal_type fixed_cost,
631: ld_cal_type,
632: ld_sequence_number,
633: lock_award_flag
634: FROM igf_aw_award_t
635: WHERE temp_char_val1 = c_item_code
636: AND process_id=c_process_id;
637:
638: first_itm_term_rec c_first_itm_term%ROWTYPE;

Line 643: c_item_code igf_aw_award_t.temp_char_val1%TYPE,

639:
640:
641: --Cursor to retrieve item-term information for a student who already has some COA items assigned
642: CURSOR c_second_item_term(
643: c_item_code igf_aw_award_t.temp_char_val1%TYPE,
644: c_process_id NUMBER
645: ) IS
646: SELECT temp_char_val1 item_code,
647: accepted_amt item_term_amount,

Line 654: FROM igf_aw_award_t

650: tp_cal_type fixed_cost,
651: ld_cal_type,
652: ld_sequence_number,
653: lock_award_flag
654: FROM igf_aw_award_t
655: WHERE temp_char_val1 = c_item_code
656: AND process_id = c_process_id;
657: sec_itm_term_rec c_second_item_term%ROWTYPE;
658:

Line 682: FROM igf_aw_award_t

678: paid_amt pell_amt,
679: need_reduction_amt pell_alt_amt,
680: tp_cal_type fixed_cost,
681: lock_award_flag
682: FROM igf_aw_award_t
683: WHERE process_id = c_process_id
684: ) coa_group_items,
685: (
686: SELECT rowid row_id,

Line 2050: FROM igf_aw_award_t

2046: CURSOR c_temp_del(
2047: c_process_id NUMBER
2048: ) IS
2049: SELECT row_id rid
2050: FROM igf_aw_award_t
2051: WHERE process_id = c_process_id;
2052: temp_del_rec c_temp_del%ROWTYPE;
2053:
2054: CURSOR c_group_code(

Line 2262: igf_aw_award_t_pkg.delete_row(temp_del_rec.rid);

2258: END IF;
2259: END IF;
2260:
2261: FOR temp_del_rec IN c_temp_del(l_process_id) LOOP
2262: igf_aw_award_t_pkg.delete_row(temp_del_rec.rid);
2263: END LOOP;
2264:
2265: COMMIT;
2266: