1 PACKAGE igs_as_entry_conf_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSDI46S.pls 115.7 2003/12/05 10:51:11 kdande ship $ */
3 PROCEDURE insert_row (
4 x_rowid IN OUT NOCOPY VARCHAR2,
5 x_s_control_num IN NUMBER,
6 x_key_allow_invalid_ind IN VARCHAR2,
7 x_key_collect_mark_ind IN VARCHAR2,
8 x_key_grade_derive_ind IN VARCHAR2,
9 x_key_mark_mndtry_ind IN VARCHAR2,
10 x_upld_person_no_exist IN VARCHAR2,
11 x_upld_crs_not_enrolled IN VARCHAR2,
12 x_upld_unit_not_enrolled IN VARCHAR2,
13 x_upld_unit_discont IN VARCHAR2,
14 x_upld_grade_invalid IN VARCHAR2,
15 x_upld_mark_grade_invalid IN VARCHAR2,
16 x_key_mark_entry_dec_points IN NUMBER,
17 x_mode IN VARCHAR2 DEFAULT 'R',
18 x_key_prtl_sbmn_allowed_ind IN VARCHAR2,
19 x_upld_ug_sbmtd_grade_exist IN VARCHAR2,
20 x_upld_ug_saved_grade_exist IN VARCHAR2,
21 x_upld_asmnt_item_not_exist IN VARCHAR2,
22 x_upld_asmnt_item_grd_exist IN VARCHAR2,
23 x_key_derive_unit_grade_flag IN VARCHAR2,
24 x_key_allow_inst_finalize_flag IN VARCHAR2,
25 x_key_ai_collect_mark_flag IN VARCHAR2,
26 x_key_ai_mark_mndtry_flag IN VARCHAR2,
27 x_key_ai_grade_derive_flag IN VARCHAR2,
28 x_key_ai_allow_invalid_flag IN VARCHAR2,
29 x_key_ai_mark_entry_dec_points IN NUMBER
30 );
31
32 PROCEDURE lock_row (
33 x_rowid IN VARCHAR2,
34 x_s_control_num IN NUMBER,
35 x_key_allow_invalid_ind IN VARCHAR2,
36 x_key_collect_mark_ind IN VARCHAR2,
37 x_key_grade_derive_ind IN VARCHAR2,
38 x_key_mark_mndtry_ind IN VARCHAR2,
39 x_upld_person_no_exist IN VARCHAR2,
40 x_upld_crs_not_enrolled IN VARCHAR2,
41 x_upld_unit_not_enrolled IN VARCHAR2,
42 x_upld_unit_discont IN VARCHAR2,
43 x_upld_grade_invalid IN VARCHAR2,
44 x_upld_mark_grade_invalid IN VARCHAR2,
45 x_key_mark_entry_dec_points IN NUMBER,
46 x_key_prtl_sbmn_allowed_ind IN VARCHAR2,
47 x_upld_ug_sbmtd_grade_exist IN VARCHAR2,
48 x_upld_ug_saved_grade_exist IN VARCHAR2,
49 x_upld_asmnt_item_not_exist IN VARCHAR2,
50 x_upld_asmnt_item_grd_exist IN VARCHAR2,
51 x_key_derive_unit_grade_flag IN VARCHAR2,
52 x_key_allow_inst_finalize_flag IN VARCHAR2,
53 x_key_ai_collect_mark_flag IN VARCHAR2,
54 x_key_ai_mark_mndtry_flag IN VARCHAR2,
55 x_key_ai_grade_derive_flag IN VARCHAR2,
56 x_key_ai_allow_invalid_flag IN VARCHAR2,
57 x_key_ai_mark_entry_dec_points IN NUMBER
58 );
59
60 PROCEDURE update_row (
61 x_rowid IN VARCHAR2,
62 x_s_control_num IN NUMBER,
63 x_key_allow_invalid_ind IN VARCHAR2,
64 x_key_collect_mark_ind IN VARCHAR2,
65 x_key_grade_derive_ind IN VARCHAR2,
66 x_key_mark_mndtry_ind IN VARCHAR2,
67 x_upld_person_no_exist IN VARCHAR2,
68 x_upld_crs_not_enrolled IN VARCHAR2,
69 x_upld_unit_not_enrolled IN VARCHAR2,
70 x_upld_unit_discont IN VARCHAR2,
71 x_upld_grade_invalid IN VARCHAR2,
72 x_upld_mark_grade_invalid IN VARCHAR2,
73 x_key_mark_entry_dec_points IN NUMBER,
74 x_mode IN VARCHAR2 DEFAULT 'R',
75 x_key_prtl_sbmn_allowed_ind IN VARCHAR2,
76 x_upld_ug_sbmtd_grade_exist IN VARCHAR2,
77 x_upld_ug_saved_grade_exist IN VARCHAR2,
78 x_upld_asmnt_item_not_exist IN VARCHAR2,
79 x_upld_asmnt_item_grd_exist IN VARCHAR2,
80 x_key_derive_unit_grade_flag IN VARCHAR2,
81 x_key_allow_inst_finalize_flag IN VARCHAR2,
82 x_key_ai_collect_mark_flag IN VARCHAR2,
83 x_key_ai_mark_mndtry_flag IN VARCHAR2,
84 x_key_ai_grade_derive_flag IN VARCHAR2,
85 x_key_ai_allow_invalid_flag IN VARCHAR2,
86 x_key_ai_mark_entry_dec_points IN NUMBER
87 );
88
89 PROCEDURE add_row (
90 x_rowid IN OUT NOCOPY VARCHAR2,
91 x_s_control_num IN NUMBER,
92 x_key_allow_invalid_ind IN VARCHAR2,
93 x_key_collect_mark_ind IN VARCHAR2,
94 x_key_grade_derive_ind IN VARCHAR2,
95 x_key_mark_mndtry_ind IN VARCHAR2,
96 x_upld_person_no_exist IN VARCHAR2,
97 x_upld_crs_not_enrolled IN VARCHAR2,
98 x_upld_unit_not_enrolled IN VARCHAR2,
99 x_upld_unit_discont IN VARCHAR2,
100 x_upld_grade_invalid IN VARCHAR2,
101 x_upld_mark_grade_invalid IN VARCHAR2,
102 x_key_mark_entry_dec_points IN NUMBER,
103 x_mode IN VARCHAR2 DEFAULT 'R',
104 x_key_prtl_sbmn_allowed_ind IN VARCHAR2,
105 x_upld_ug_sbmtd_grade_exist IN VARCHAR2,
106 x_upld_ug_saved_grade_exist IN VARCHAR2,
107 x_upld_asmnt_item_not_exist IN VARCHAR2,
108 x_upld_asmnt_item_grd_exist IN VARCHAR2,
109 x_key_derive_unit_grade_flag IN VARCHAR2,
110 x_key_allow_inst_finalize_flag IN VARCHAR2,
111 x_key_ai_collect_mark_flag IN VARCHAR2,
112 x_key_ai_mark_mndtry_flag IN VARCHAR2,
113 x_key_ai_grade_derive_flag IN VARCHAR2,
114 x_key_ai_allow_invalid_flag IN VARCHAR2,
115 x_key_ai_mark_entry_dec_points IN NUMBER
116 );
117
118 PROCEDURE delete_row (x_rowid IN VARCHAR2);
119
120 FUNCTION get_pk_for_validation (x_s_control_num IN NUMBER)
121 RETURN BOOLEAN;
122
123 PROCEDURE check_constraints (
124 column_name IN VARCHAR2 DEFAULT NULL,
125 column_value IN VARCHAR2 DEFAULT NULL
126 );
127
128 PROCEDURE before_dml (
129 p_action IN VARCHAR2,
130 x_rowid IN VARCHAR2 DEFAULT NULL,
131 x_s_control_num IN NUMBER DEFAULT NULL,
132 x_key_allow_invalid_ind IN VARCHAR2 DEFAULT NULL,
133 x_key_collect_mark_ind IN VARCHAR2 DEFAULT NULL,
134 x_key_grade_derive_ind IN VARCHAR2 DEFAULT NULL,
135 x_key_mark_mndtry_ind IN VARCHAR2 DEFAULT NULL,
136 x_upld_person_no_exist IN VARCHAR2 DEFAULT NULL,
137 x_upld_crs_not_enrolled IN VARCHAR2 DEFAULT NULL,
138 x_upld_unit_not_enrolled IN VARCHAR2 DEFAULT NULL,
139 x_upld_unit_discont IN VARCHAR2 DEFAULT NULL,
140 x_upld_grade_invalid IN VARCHAR2 DEFAULT NULL,
141 x_upld_mark_grade_invalid IN VARCHAR2 DEFAULT NULL,
142 x_key_mark_entry_dec_points IN NUMBER DEFAULT NULL,
143 x_creation_date IN DATE DEFAULT NULL,
144 x_created_by IN NUMBER DEFAULT NULL,
145 x_last_update_date IN DATE DEFAULT NULL,
146 x_last_updated_by IN NUMBER DEFAULT NULL,
147 x_last_update_login IN NUMBER DEFAULT NULL,
148 x_key_prtl_sbmn_allowed_ind IN VARCHAR2 DEFAULT NULL,
149 x_upld_ug_sbmtd_grade_exist IN VARCHAR2 DEFAULT NULL,
150 x_upld_ug_saved_grade_exist IN VARCHAR2 DEFAULT NULL,
151 x_upld_asmnt_item_not_exist IN VARCHAR2 DEFAULT NULL,
152 x_upld_asmnt_item_grd_exist IN VARCHAR2 DEFAULT NULL,
153 x_key_derive_unit_grade_flag IN VARCHAR2 DEFAULT NULL,
154 x_key_allow_inst_finalize_flag IN VARCHAR2 DEFAULT NULL,
155 x_key_ai_collect_mark_flag IN VARCHAR2 DEFAULT NULL,
156 x_key_ai_mark_mndtry_flag IN VARCHAR2 DEFAULT NULL,
157 x_key_ai_grade_derive_flag IN VARCHAR2 DEFAULT NULL,
158 x_key_ai_allow_invalid_flag IN VARCHAR2 DEFAULT NULL,
159 x_key_ai_mark_entry_dec_points IN NUMBER DEFAULT NULL
160 );
161 END igs_as_entry_conf_pkg;