DBA Data[Home] [Help]

APPS.IGS_HE_IDENTIFY_TARGET_POP dependencies on IGS_HE_SUB_RTN_QUAL

Line 6: p_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,

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:

Line 7: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,

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,

Line 8: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%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,

Line 11: PROCEDURE Dlhe_identify_spa (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,

Line 12: 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,

Line 13: 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

Line 14: p_qual_type IN igs_he_sub_rtn_qual.qual_period_type%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: );

Line 15: p_qual_start_date IN igs_he_sub_rtn_qual.qual_period_start_date%TYPE,

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:

Line 16: p_qual_end_date IN igs_he_sub_rtn_qual.qual_period_end_date%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,

Line 17: p_closed_ind IN igs_he_sub_rtn_qual.closed_ind%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,

Line 20: PROCEDURE Dlhe_Process_spa (p_submission_name IN igs_he_sub_rtn_qual.submission_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,

Line 21: p_return_name IN igs_he_sub_rtn_qual.return_name%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,

Line 22: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%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,

Line 23: p_qual_type IN igs_he_sub_rtn_qual.qual_period_type%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

Line 30: PROCEDURE Dlhe_review_spa ( p_submission_name IN igs_he_sub_rtn_qual.submission_name%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,

Line 31: p_return_name IN igs_he_sub_rtn_qual.return_name%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,

Line 32: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%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,

Line 33: p_qual_type IN igs_he_sub_rtn_qual.qual_period_type%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,

Line 34: p_qual_start_dt IN igs_he_sub_rtn_qual.qual_period_start_date%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,

Line 35: p_qual_end_dt IN igs_he_sub_rtn_qual.qual_period_end_date%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,