APPS.IGS_HE_IDENTIFY_TARGET_POP dependencies on IGS_HE_ST_SPA

Line 24: p_person_id IN igs_he_st_spa.person_id%TYPE,

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: );

Line 25: p_course_cd IN igs_he_st_spa.course_cd%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:

Line 26: p_version_number IN igs_he_st_spa.version_number%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,

Line 36: p_person_id IN igs_he_st_spa.person_id%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,

Line 37: p_course_cd IN igs_he_st_spa.course_cd%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

Line 38: p_version_number IN igs_he_st_spa.version_number%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: );