1 PACKAGE IGS_PR_GEN_005 AS
2 /* $Header: IGSPR26S.pls 120.0 2005/07/05 12:26:21 appldev noship $ */
3
4 FUNCTION IGS_PR_CLC_APL_EXPRY(
5 p_course_cd IN VARCHAR2 ,
6 p_version_number IN NUMBER ,
7 p_prg_cal_type IN VARCHAR2 ,
8 p_prg_sequence_number IN NUMBER ,
9 p_progression_rule_cat IN VARCHAR2 ,
10 p_pra_sequence_number IN NUMBER ,
11 p_sequence_number IN NUMBER )
12 RETURN DATE ;
13
14 FUNCTION IGS_PR_CLC_CAUSE_EXPRY(
15 p_course_cd IN VARCHAR2 ,
16 p_version_number IN NUMBER ,
17 p_prg_cal_type IN VARCHAR2 ,
18 p_prg_sequence_number IN NUMBER ,
19 p_progression_rule_cat IN VARCHAR2 ,
20 p_pra_sequence_number IN NUMBER ,
21 p_sequence_number IN NUMBER )
22 RETURN DATE ;
23
24 FUNCTION IGS_PR_CLC_STDNT_COMP(
25 p_person_id IN NUMBER ,
26 p_sca_course_cd IN VARCHAR2 ,
27 p_sca_version_number IN NUMBER ,
28 p_course_cd IN VARCHAR2 ,
29 p_version_number IN NUMBER ,
30 p_unit_set_cd IN VARCHAR2 ,
31 p_us_version_number NUMBER ,
32 p_cst_sequence_number IN NUMBER ,
33 p_predicted_ind IN VARCHAR2 DEFAULT 'N',
34 p_s_rule_call_cd IN VARCHAR2 ,
35 p_key IN VARCHAR2 ,
36 p_evaluate_ind IN VARCHAR2 DEFAULT 'N',
37 p_log_dt OUT NOCOPY DATE ,
38 p_message_name OUT NOCOPY VARCHAR2 )
39 RETURN BOOLEAN ;
40
41 FUNCTION IGS_PR_get_appeal_alwd(
42 p_progression_rule_cat IN VARCHAR2 ,
43 p_pra_sequence_number IN NUMBER ,
44 p_sequence_number IN NUMBER ,
45 p_course_cd IN VARCHAR2 ,
46 p_version_number IN NUMBER )
47 RETURN VARCHAR2 ;
48
49 FUNCTION IGS_PR_get_cause_alwd(
50 p_progression_rule_cat IN VARCHAR2 ,
51 p_pra_sequence_number IN NUMBER ,
52 p_sequence_number IN NUMBER ,
53 p_course_cd IN VARCHAR2 ,
54 p_version_number IN NUMBER )
55 RETURN VARCHAR2 ;
56
57 FUNCTION IGS_PR_get_num_fail(
58 p_person_id IN NUMBER ,
59 p_course_cd IN VARCHAR2 ,
60 p_version_number IN NUMBER ,
61 p_progression_rule_cat IN VARCHAR2 ,
62 p_pra_sequence_number IN NUMBER ,
63 p_prg_cal_type IN VARCHAR2 ,
64 p_prg_sequence_number IN NUMBER ,
65 p_prg_rule_repeat_fail_type IN VARCHAR2 )
66 RETURN NUMBER ;
67
68 FUNCTION IGS_PR_get_prg_dai(
69 p_course_cd IN VARCHAR2 ,
70 p_version_number IN NUMBER ,
71 p_prg_cal_type IN VARCHAR2 ,
72 p_prg_sequence_number IN NUMBER ,
73 p_alias_type IN VARCHAR2 )
74 RETURN DATE ;
75
76 FUNCTION IGS_PR_GET_PRG_PEN_END(
77 p_prg_cal_type IN VARCHAR2 ,
78 p_prg_sequence_number IN NUMBER )
79 RETURN DATE ;
80
81 FUNCTION IGS_PR_get_prg_status(
82 p_person_id IN NUMBER ,
83 p_course_cd IN VARCHAR2 ,
84 p_version_number IN NUMBER,
85 p_prg_cal_type IN VARCHAR2,
86
87 p_prg_ci_sequence_number IN NUMBER )
88
89 RETURN VARCHAR2 ;
90
91 FUNCTION IGS_PR_get_sca_appeal(
92 p_person_id IN NUMBER ,
93 p_course_cd IN VARCHAR2 )
94 RETURN VARCHAR2 ;
95
96 FUNCTION IGS_PR_GET_SCA_APPL(
97 p_person_id IN NUMBER ,
98 p_course_cd IN VARCHAR2 ,
99 p_course_version_number IN NUMBER ,
100 p_course_type IN VARCHAR2 ,
101 p_progression_rule_cat IN VARCHAR2 ,
102 p_pra_sequence_number IN NUMBER ,
103 p_prg_cal_type IN VARCHAR2 ,
104 p_prg_ci_sequence_number IN NUMBER ,
105 p_start_effective_period IN NUMBER ,
106 p_num_of_applications IN NUMBER ,
107 p_pra_s_relation_type IN VARCHAR2 ,
108 p_pra_sca_person_id IN NUMBER ,
109 p_pra_sca_course_cd IN VARCHAR2 ,
110 p_pra_crv_course_cd IN VARCHAR2 ,
111 p_pra_crv_version_number IN NUMBER ,
112 p_pra_ou_org_unit_cd IN VARCHAR2 ,
113 p_pra_ou_start_dt IN DATE ,
114 p_pra_course_type IN VARCHAR2 )
115 RETURN VARCHAR2 ;
116
117 FUNCTION IGS_PR_GET_SCA_CMT(
118 p_person_id IN NUMBER ,
119 p_course_cd IN VARCHAR2 ,
120 p_version_number IN NUMBER ,
121 p_org_unit_cd IN VARCHAR2 ,
122 p_ou_start_dt IN DATE )
123 RETURN VARCHAR2 ;
124
125 FUNCTION IGS_PR_GET_SCA_STATE(
126 p_person_id IN NUMBER ,
127 p_course_cd IN VARCHAR2 ,
128 p_prg_cal_type IN VARCHAR2 ,
129 p_prg_sequence_number IN NUMBER )
130 RETURN VARCHAR2 ;
131
132 FUNCTION IGS_PR_GET_SCPM_VALUE(
133 p_person_id IN NUMBER ,
134 p_course_cd IN VARCHAR2 ,
135 p_prg_cal_type IN VARCHAR2 ,
136 p_prg_ci_sequence_number IN NUMBER ,
137 p_s_prg_measure_type IN VARCHAR2 )
138 RETURN NUMBER ;
139
140 END IGS_PR_GEN_005;