[Home] [Help]
PACKAGE: APPS.IGS_HE_IDENTIFY_TARGET_POP
Source
1 PACKAGE igs_he_identify_target_pop AUTHID CURRENT_USER AS
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
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
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
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,
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,
40 p_qualified_teacher OUT NOCOPY VARCHAR2,
41 p_pt_study OUT NOCOPY VARCHAR2
42 );
43
44 END igs_he_identify_target_pop;