APPS.IGF_DB_DL_RECONC dependencies on IGF_SL_DL_SETUP_V

Line 117: PROCEDURE load_ytd_summary(p_school_code VARCHAR2, p_award_year igf_sl_dl_setup_v.ci_alternate_code%TYPE) AS

113: END IF;
114:
115: END valid_trailer ;
116:
117: PROCEDURE load_ytd_summary(p_school_code VARCHAR2, p_award_year igf_sl_dl_setup_v.ci_alternate_code%TYPE) AS
118: /***************************************************************
119: Created By : adhawan
120: Date Created By : 22-jan-2002
121: Purpose : To load the table igf_db_ytd_sum from igf_sl_load_file_t table

Line 312: PROCEDURE load_ytd_detail(p_school_code VARCHAR2, p_award_year igf_sl_dl_setup_v.ci_alternate_code%TYPE, p_c_dl_version igf_sl_dl_setup_v.DL_VERSION%TYPE) AS

308: APP_EXCEPTION.RAISE_EXCEPTION;
309:
310: END load_ytd_summary;
311:
312: PROCEDURE load_ytd_detail(p_school_code VARCHAR2, p_award_year igf_sl_dl_setup_v.ci_alternate_code%TYPE, p_c_dl_version igf_sl_dl_setup_v.DL_VERSION%TYPE) AS
313: /***************************************************************
314: Created By : adhawan
315: Date Created By : 22-jan-2002
316: Purpose : To load igf_db_ytd_dtl from igf_sl_load_file_t

Line 555: igf_sl_dl_setup_v

551:
552:
553: CURSOR c_get_ver IS
554: SELECT dl_version , ci_alternate_code FROM
555: igf_sl_dl_setup_v
556: WHERE
557: ci_cal_type =l_ci_cal_type AND
558: ci_sequence_number =l_ci_sequence_number ;
559: c_get_ver_rec c_get_ver%ROWTYPE ;

Line 561: l_award_year igf_sl_dl_setup_v.ci_alternate_code%TYPE;

557: ci_cal_type =l_ci_cal_type AND
558: ci_sequence_number =l_ci_sequence_number ;
559: c_get_ver_rec c_get_ver%ROWTYPE ;
560:
561: l_award_year igf_sl_dl_setup_v.ci_alternate_code%TYPE;
562:
563: BEGIN
564: igf_aw_gen.set_org_id(NULL);
565: retcode :=0;

Line 643: igf_sl_dl_setup_v

639:
640:
641: CURSOR c_get_ver IS
642: SELECT dl_version , ci_alternate_code FROM
643: igf_sl_dl_setup_v
644: WHERE
645: ci_cal_type =l_ci_cal_type AND
646: ci_sequence_number =l_ci_sequence_number ;
647:

Line 651: l_award_year igf_sl_dl_setup_v.ci_alternate_code%TYPE;

647:
648: c_get_ver_rec c_get_ver%ROWTYPE ;
649:
650:
651: l_award_year igf_sl_dl_setup_v.ci_alternate_code%TYPE;
652:
653: BEGIN
654: igf_aw_gen.set_org_id(NULL);
655: retcode :=0;