2: /* $Header: IGSHE25S.pls 115.1 2003/05/07 13:05:47 pmarada noship $ */
3:
4: PROCEDURE dlhe_identify_population (errbuf OUT NOCOPY VARCHAR2,
5: retcode OUT NOCOPY NUMBER,
6: p_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,
7: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
8: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE
9: );
10:
3:
4: PROCEDURE dlhe_identify_population (errbuf OUT NOCOPY VARCHAR2,
5: retcode OUT NOCOPY NUMBER,
6: p_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,
7: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
8: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE
9: );
10:
11: PROCEDURE Dlhe_identify_spa (p_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,
4: PROCEDURE dlhe_identify_population (errbuf OUT NOCOPY VARCHAR2,
5: retcode OUT NOCOPY NUMBER,
6: p_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,
7: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
8: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE
9: );
10:
11: PROCEDURE Dlhe_identify_spa (p_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,
12: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
7: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
8: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE
9: );
10:
11: PROCEDURE Dlhe_identify_spa (p_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,
12: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
13: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,
14: p_qual_type IN igs_he_sub_rtn_qual.qual_period_type%TYPE,
15: p_qual_start_date IN igs_he_sub_rtn_qual.qual_period_start_date%TYPE,
8: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE
9: );
10:
11: PROCEDURE Dlhe_identify_spa (p_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,
12: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
13: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,
14: p_qual_type IN igs_he_sub_rtn_qual.qual_period_type%TYPE,
15: p_qual_start_date IN igs_he_sub_rtn_qual.qual_period_start_date%TYPE,
16: p_qual_end_date IN igs_he_sub_rtn_qual.qual_period_end_date%TYPE,
9: );
10:
11: PROCEDURE Dlhe_identify_spa (p_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,
12: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
13: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,
14: p_qual_type IN igs_he_sub_rtn_qual.qual_period_type%TYPE,
15: p_qual_start_date IN igs_he_sub_rtn_qual.qual_period_start_date%TYPE,
16: p_qual_end_date IN igs_he_sub_rtn_qual.qual_period_end_date%TYPE,
17: p_closed_ind IN igs_he_sub_rtn_qual.closed_ind%TYPE
10:
11: PROCEDURE Dlhe_identify_spa (p_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,
12: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
13: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,
14: p_qual_type IN igs_he_sub_rtn_qual.qual_period_type%TYPE,
15: p_qual_start_date IN igs_he_sub_rtn_qual.qual_period_start_date%TYPE,
16: p_qual_end_date IN igs_he_sub_rtn_qual.qual_period_end_date%TYPE,
17: p_closed_ind IN igs_he_sub_rtn_qual.closed_ind%TYPE
18: );
11: PROCEDURE Dlhe_identify_spa (p_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,
12: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
13: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,
14: p_qual_type IN igs_he_sub_rtn_qual.qual_period_type%TYPE,
15: p_qual_start_date IN igs_he_sub_rtn_qual.qual_period_start_date%TYPE,
16: p_qual_end_date IN igs_he_sub_rtn_qual.qual_period_end_date%TYPE,
17: p_closed_ind IN igs_he_sub_rtn_qual.closed_ind%TYPE
18: );
19:
12: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
13: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,
14: p_qual_type IN igs_he_sub_rtn_qual.qual_period_type%TYPE,
15: p_qual_start_date IN igs_he_sub_rtn_qual.qual_period_start_date%TYPE,
16: p_qual_end_date IN igs_he_sub_rtn_qual.qual_period_end_date%TYPE,
17: p_closed_ind IN igs_he_sub_rtn_qual.closed_ind%TYPE
18: );
19:
20: PROCEDURE Dlhe_Process_spa (p_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,
13: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,
14: p_qual_type IN igs_he_sub_rtn_qual.qual_period_type%TYPE,
15: p_qual_start_date IN igs_he_sub_rtn_qual.qual_period_start_date%TYPE,
16: p_qual_end_date IN igs_he_sub_rtn_qual.qual_period_end_date%TYPE,
17: p_closed_ind IN igs_he_sub_rtn_qual.closed_ind%TYPE
18: );
19:
20: PROCEDURE Dlhe_Process_spa (p_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,
21: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
16: p_qual_end_date IN igs_he_sub_rtn_qual.qual_period_end_date%TYPE,
17: p_closed_ind IN igs_he_sub_rtn_qual.closed_ind%TYPE
18: );
19:
20: PROCEDURE Dlhe_Process_spa (p_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,
21: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
22: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,
23: p_qual_type IN igs_he_sub_rtn_qual.qual_period_type%TYPE,
24: p_person_id IN igs_he_st_spa.person_id%TYPE,
17: p_closed_ind IN igs_he_sub_rtn_qual.closed_ind%TYPE
18: );
19:
20: PROCEDURE Dlhe_Process_spa (p_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,
21: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
22: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,
23: p_qual_type IN igs_he_sub_rtn_qual.qual_period_type%TYPE,
24: p_person_id IN igs_he_st_spa.person_id%TYPE,
25: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
18: );
19:
20: PROCEDURE Dlhe_Process_spa (p_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,
21: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
22: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,
23: p_qual_type IN igs_he_sub_rtn_qual.qual_period_type%TYPE,
24: p_person_id IN igs_he_st_spa.person_id%TYPE,
25: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
26: p_version_number IN igs_he_st_spa.version_number%TYPE,
19:
20: PROCEDURE Dlhe_Process_spa (p_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,
21: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
22: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,
23: p_qual_type IN igs_he_sub_rtn_qual.qual_period_type%TYPE,
24: p_person_id IN igs_he_st_spa.person_id%TYPE,
25: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
26: p_version_number IN igs_he_st_spa.version_number%TYPE,
27: P_cre_upd_dlhe OUT NOCOPY VARCHAR2
26: p_version_number IN igs_he_st_spa.version_number%TYPE,
27: P_cre_upd_dlhe OUT NOCOPY VARCHAR2
28: );
29:
30: PROCEDURE Dlhe_review_spa ( p_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,
31: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
32: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,
33: p_qual_type IN igs_he_sub_rtn_qual.qual_period_type%TYPE,
34: p_qual_start_dt IN igs_he_sub_rtn_qual.qual_period_start_date%TYPE,
27: P_cre_upd_dlhe OUT NOCOPY VARCHAR2
28: );
29:
30: PROCEDURE Dlhe_review_spa ( p_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,
31: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
32: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,
33: p_qual_type IN igs_he_sub_rtn_qual.qual_period_type%TYPE,
34: p_qual_start_dt IN igs_he_sub_rtn_qual.qual_period_start_date%TYPE,
35: p_qual_end_dt IN igs_he_sub_rtn_qual.qual_period_end_date%TYPE,
28: );
29:
30: PROCEDURE Dlhe_review_spa ( p_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,
31: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
32: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,
33: p_qual_type IN igs_he_sub_rtn_qual.qual_period_type%TYPE,
34: p_qual_start_dt IN igs_he_sub_rtn_qual.qual_period_start_date%TYPE,
35: p_qual_end_dt IN igs_he_sub_rtn_qual.qual_period_end_date%TYPE,
36: p_person_id IN igs_he_st_spa.person_id%TYPE,
29:
30: PROCEDURE Dlhe_review_spa ( p_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,
31: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
32: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,
33: p_qual_type IN igs_he_sub_rtn_qual.qual_period_type%TYPE,
34: p_qual_start_dt IN igs_he_sub_rtn_qual.qual_period_start_date%TYPE,
35: p_qual_end_dt IN igs_he_sub_rtn_qual.qual_period_end_date%TYPE,
36: p_person_id IN igs_he_st_spa.person_id%TYPE,
37: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
30: PROCEDURE Dlhe_review_spa ( p_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,
31: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
32: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,
33: p_qual_type IN igs_he_sub_rtn_qual.qual_period_type%TYPE,
34: p_qual_start_dt IN igs_he_sub_rtn_qual.qual_period_start_date%TYPE,
35: p_qual_end_dt IN igs_he_sub_rtn_qual.qual_period_end_date%TYPE,
36: p_person_id IN igs_he_st_spa.person_id%TYPE,
37: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
38: p_version_number IN igs_he_st_spa.version_number%TYPE,
31: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
32: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,
33: p_qual_type IN igs_he_sub_rtn_qual.qual_period_type%TYPE,
34: p_qual_start_dt IN igs_he_sub_rtn_qual.qual_period_start_date%TYPE,
35: p_qual_end_dt IN igs_he_sub_rtn_qual.qual_period_end_date%TYPE,
36: p_person_id IN igs_he_st_spa.person_id%TYPE,
37: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
38: p_version_number IN igs_he_st_spa.version_number%TYPE,
39: p_include OUT NOCOPY VARCHAR2,