1 PACKAGE IGS_RE_GEN_002 AS
2 /* $Header: IGSRE02S.pls 120.0 2005/06/02 04:07:36 appldev noship $ */
3 PROCEDURE resp_get_ca_exists(
4 p_person_id IN NUMBER ,
5 p_ca_sequence_number IN NUMBER ,
6 p_effective_dt IN DATE ,
7 p_check_thesis IN BOOLEAN ,
8 p_check_field_of_study IN BOOLEAN ,
9 p_check_seo_class_cd IN BOOLEAN ,
10 p_check_supervisor IN BOOLEAN ,
11 p_check_milestone IN BOOLEAN ,
12 p_check_scholarship IN BOOLEAN ,
13 p_thesis_exists OUT NOCOPY BOOLEAN ,
14 p_field_of_study_exists OUT NOCOPY BOOLEAN ,
15 p_seo_class_cd_exists OUT NOCOPY BOOLEAN ,
16 p_supervisor_exists OUT NOCOPY BOOLEAN ,
17 p_milestone_exists OUT NOCOPY BOOLEAN ,
18 p_scholarship_exists OUT NOCOPY BOOLEAN ) ;
19
20 FUNCTION resp_get_rsup_start(
21 p_person_id IN NUMBER ,
22 p_ca_sequence_number IN NUMBER ,
23 p_sca_course_cd IN VARCHAR2 ,
24 p_acai_admission_appl_number IN NUMBER ,
25 p_acai_nominated_course_cd IN VARCHAR2 ,
26 p_acai_sequence_number IN NUMBER ,
27 p_parent IN VARCHAR2 )
28 RETURN DATE ;
29 PRAGMA RESTRICT_REFERENCES(RESP_GET_RSUP_START,WNDS,WNPS);
30
31 PROCEDURE resp_get_sca_ca_acai(
32 p_person_id IN NUMBER ,
33 p_course_cd IN VARCHAR2 ,
34 p_admission_appl_number IN NUMBER ,
35 p_nominated_course_cd IN VARCHAR2 ,
36 p_acai_sequence_number IN NUMBER ,
37 p_out_admission_appl_number OUT NOCOPY NUMBER ,
38 p_out_nominated_course_cd OUT NOCOPY VARCHAR2 ,
39 p_out_acai_sequence_number OUT NOCOPY NUMBER ) ;
40
41
42 FUNCTION RESP_GET_SUA_EFTD(
43 p_person_id IN NUMBER ,
44 p_course_cd IN VARCHAR2 ,
45 p_unit_cd IN VARCHAR2 ,
46 p_unit_version_number IN NUMBER ,
47 p_cal_type IN VARCHAR2 ,
48 p_ci_sequence_number IN NUMBER ,
49 p_effective_dt IN DATE ,
50 p_load_cal_type IN VARCHAR2 ,
51 p_load_ci_sequence_number IN NUMBER ,
52 p_cal_type_eftd OUT NOCOPY NUMBER )
53 RETURN NUMBER ;
54 PRAGMA RESTRICT_REFERENCES(RESP_GET_SUA_EFTD,WNDS,WNPS);
55
56
57 FUNCTION RESP_GET_TEACH_DAYS(
58 p_cal_type IN VARCHAR2 ,
59 p_ci_sequence_number IN NUMBER ,
60 p_start_dt OUT NOCOPY DATE ,
61 p_end_dt OUT NOCOPY DATE )
62 RETURN NUMBER ;
63 PRAGMA RESTRICT_REFERENCES(RESP_GET_TEACH_DAYS, WNDS,WNPS);
64
65
66 PROCEDURE RESP_GET_THE_EXISTS(
67 p_person_id IN NUMBER ,
68 p_ca_sequence_number IN NUMBER ,
69 p_the_sequence_number IN NUMBER ,
70 p_check_thesis_exam IN boolean ,
71 p_check_milestone IN boolean ,
72 p_thesis_exam_exists OUT NOCOPY boolean ,
73 p_milestone_exists OUT NOCOPY boolean ) ;
74
75
76
77 FUNCTION RESP_GET_THE_STATUS(
78 p_person_id IN NUMBER ,
79 p_ca_sequence_number IN NUMBER ,
80 p_the_sequence_number IN NUMBER ,
81 p_details_passed_ind IN VARCHAR2 ,
82 p_logical_delete_dt IN DATE ,
83 p_thesis_result_cd IN VARCHAR2 )
84 RETURN VARCHAR2 ;
85 PRAGMA RESTRICT_REFERENCES(RESP_GET_THE_STATUS, WNDS,WNPS);
86
87
88 FUNCTION resp_ins_ca_cah(
89 p_person_id IN NUMBER ,
90 p_ca_sequence_number IN NUMBER ,
91 p_sca_course_cd IN VARCHAR2 ,
92 p_old_attendance_percentage IN NUMBER ,
93 p_message_name OUT NOCOPY VARCHAR2 )
94 RETURN BOOLEAN ;
95
96 PROCEDURE resp_ins_ca_hist(
97 p_person_id IN NUMBER ,
98 p_sequence_number IN NUMBER ,
99 p_old_sca_course_cd IN VARCHAR2 ,
100 p_new_sca_course_cd IN VARCHAR2 ,
101 p_old_acai_adm_appl_num IN NUMBER ,
102 p_new_acai_adm_appl_num IN NUMBER ,
103 p_old_acai_nominated_course_cd IN VARCHAR2 ,
104 p_new_acai_nominated_course_cd IN VARCHAR2 ,
105 p_old_acai_sequence_number IN NUMBER ,
106 p_new_acai_sequence_number IN NUMBER ,
107 p_old_attendance_percentage IN NUMBER ,
108 p_new_attendance_percentage IN NUMBER ,
109 p_old_govt_type_of_activity_cd IN VARCHAR2 ,
110 p_new_govt_type_of_activity_cd IN VARCHAR2 ,
111 p_old_max_submission_dt IN DATE ,
112 p_new_max_submission_dt IN DATE ,
113 p_old_min_submission_dt IN DATE ,
114 p_new_min_submission_dt IN DATE ,
115 p_old_research_topic IN VARCHAR2 ,
116 p_new_research_topic IN VARCHAR2 ,
117 p_old_industry_links IN VARCHAR2 ,
118 p_new_industry_links IN VARCHAR2 ,
119 p_old_update_who IN NUMBER ,
120 p_new_update_who IN NUMBER ,
121 p_old_update_on IN DATE ,
122 p_new_update_on IN DATE ) ;
123
124
125 FUNCTION RESP_INS_DFLT_MIL(
126 p_person_id IN NUMBER ,
127 p_ca_sequence_number IN NUMBER ,
128 p_message_name OUT NOCOPY VARCHAR2 )
129 RETURN boolean ;
130
131 END IGS_RE_GEN_002;