1 PACKAGE IGS_AS_GEN_001 AUTHID CURRENT_USER AS
2 /* $Header: IGSAS01S.pls 120.0 2005/07/05 12:17:00 appldev noship $ */
3
4 FUNCTION assp_clc_esu_ese_num (
5 p_person_id IN NUMBER,
6 p_exam_cal_type IN VARCHAR2,
7 p_exam_ci_sequence_number IN NUMBER
8 ) RETURN NUMBER;
9
10 FUNCTION assp_clc_suaai_valid (
11 p_person_id IN NUMBER,
12 p_unit_cd IN VARCHAR2,
13 p_course_cd IN VARCHAR2,
14 p_cal_type IN VARCHAR2,
15 p_ci_sequence_number IN NUMBER,
16 p_ass_pattern_id IN NUMBER,
17 p_ass_id IN NUMBER,
18 p_logical_delete_dt IN DATE,
19 -- anilk, 22-Apr-2003, Bug# 2829262
20 p_uoo_id IN NUMBER
21 ) RETURN VARCHAR2;
22
23 PRAGMA RESTRICT_REFERENCES (assp_clc_suaai_valid, WNDS, WNPS);
24
25 FUNCTION assp_clc_week_extnsn (
26 p_week_ending_due_dt IN DATE,
27 p_override_due_dt IN DATE,
28 p_num_week_extnsn IN NUMBER
29 ) RETURN NUMBER;
30
31 FUNCTION assp_del_suaai (
32 p_person_id IN NUMBER,
33 p_course_cd IN VARCHAR2,
34 p_unit_cd IN VARCHAR2,
35 p_cal_type IN VARCHAR2,
36 p_ci_sequence_number IN NUMBER,
37 p_message_name OUT NOCOPY VARCHAR2,
38 -- anilk, 22-Apr-2003, Bug# 2829262
39 p_uoo_id IN NUMBER
40 ) RETURN BOOLEAN;
41
42 FUNCTION assp_del_suaai_dflt (
43 p_person_id IN NUMBER,
44 p_cal_type IN VARCHAR2,
45 p_ci_sequence_number IN NUMBER,
46 p_course_cd IN VARCHAR2,
47 p_unit_cd IN VARCHAR2,
48 p_ass_id IN NUMBER,
49 p_s_log_type IN VARCHAR2,
50 p_key IN VARCHAR2,
51 p_sle_key IN VARCHAR2,
52 p_error_count IN OUT NOCOPY NUMBER,
53 p_warning_count IN OUT NOCOPY NUMBER,
54 p_message_name OUT NOCOPY VARCHAR2,
55 p_uoo_id IN NUMBER,
56 p_unit_ass_id IN NUMBER DEFAULT NULL
57 ) RETURN BOOLEAN;
58
59 FUNCTION assp_del_suaap_dflt (
60 p_person_id IN NUMBER,
61 p_cal_type IN VARCHAR2,
62 p_ci_sequence_number IN NUMBER,
63 p_course_cd IN VARCHAR2,
64 p_unit_cd IN VARCHAR2,
65 p_ass_pattern_id IN NUMBER,
66 p_s_log_type IN VARCHAR2,
67 p_key IN VARCHAR2,
68 p_sle_key IN VARCHAR2,
69 p_error_count IN OUT NOCOPY NUMBER,
70 p_warning_count IN OUT NOCOPY NUMBER,
71 p_message_name OUT NOCOPY VARCHAR2,
72 -- anilk, 22-Apr-2003, Bug# 2829262
73 p_uoo_id IN NUMBER
74 ) RETURN BOOLEAN;
75
76 FUNCTION assp_del_suaap_suaai (
77 p_person_id IN NUMBER,
78 p_course_cd IN VARCHAR2,
79 p_unit_cd IN VARCHAR2,
80 p_cal_type IN VARCHAR2,
81 p_ci_sequence_number IN NUMBER,
82 p_ass_pattern_id IN NUMBER,
83 p_creation_dt IN DATE,
84 p_ass_id IN NUMBER,
85 p_call_from_db_trg IN VARCHAR2 DEFAULT 'N',
86 p_s_log_type IN VARCHAR2,
87 p_key IN VARCHAR2,
88 p_sle_key IN VARCHAR2,
89 p_error_count IN OUT NOCOPY NUMBER,
90 p_warning_count IN OUT NOCOPY NUMBER,
91 p_message_name OUT NOCOPY VARCHAR2,
92 -- anilk, 22-Apr-2003, Bug# 2829262
93 p_uoo_id IN NUMBER
94 ) RETURN BOOLEAN;
95
96 FUNCTION assp_get_actn_msg (
97 p_action_type IN VARCHAR2,
98 p_s_student_todo_type IN VARCHAR2
99 ) RETURN VARCHAR2;
100
101 PRAGMA RESTRICT_REFERENCES (assp_get_actn_msg, WNDS, WNPS);
102
103 FUNCTION assp_get_ai_a_type (
104 p_ass_id IN NUMBER
105 ) RETURN VARCHAR2;
106
107 FUNCTION assp_val_sua_display (
108 p_person_id IN NUMBER,
109 p_course_cd IN VARCHAR2,
110 p_version_number IN NUMBER,
111 p_unit_cd IN VARCHAR2,
112 p_cal_type IN VARCHAR2,
113 p_ci_sequence_number IN NUMBER,
114 p_unit_attempt_status IN VARCHAR2,
115 p_administrative_unit_status IN VARCHAR2,
116 p_finalised_ind IN VARCHAR2 DEFAULT 'N',
117 p_include_fail_grade_ind IN VARCHAR2 DEFAULT 'N',
118 p_enrolled_units_ind IN VARCHAR2 DEFAULT 'C',
119 p_exclude_research_units_ind IN VARCHAR2 DEFAULT 'N',
120 p_exclude_unit_category IN VARCHAR2,
121 -- anilk, 22-Apr-2003, Bug# 2829262
122 p_uoo_id IN NUMBER
123 ) RETURN VARCHAR2;
124
125 PRAGMA RESTRICT_REFERENCES (assp_val_sua_display, WNDS, WNPS);
126 END igs_as_gen_001;