1 PACKAGE igs_ps_unitass_item_pkg AS
2 /* $Header: IGSPI0KS.pls 120.0 2005/06/01 18:14:50 appldev noship $ */
3 PROCEDURE insert_row (
4 x_rowid IN OUT NOCOPY VARCHAR2,
5 x_unit_section_ass_item_id IN OUT NOCOPY NUMBER,
6 x_uoo_id IN NUMBER,
7 x_ass_id IN NUMBER,
8 x_sequence_number IN OUT NOCOPY NUMBER,
9 x_ci_start_dt IN OUT NOCOPY DATE,
10 x_ci_end_dt IN OUT NOCOPY DATE,
11 x_due_dt IN DATE,
12 x_reference IN VARCHAR2,
13 x_dflt_item_ind IN VARCHAR2,
14 x_logical_delete_dt IN DATE,
15 x_action_dt IN DATE,
16 x_exam_cal_type IN VARCHAR2,
17 x_exam_ci_sequence_number IN NUMBER,
18 x_mode IN VARCHAR2 DEFAULT 'R',
19 x_grading_schema_cd IN VARCHAR2,
20 x_gs_version_number IN NUMBER,
21 x_release_date IN DATE,
22 x_description IN VARCHAR2 DEFAULT NULL,
23 x_us_ass_item_group_id IN VARCHAR2 DEFAULT NULL,
24 x_midterm_mandatory_type_code IN VARCHAR2 DEFAULT NULL,
25 x_midterm_weight_qty IN NUMBER DEFAULT NULL,
26 x_final_mandatory_type_code IN VARCHAR2 DEFAULT NULL,
27 x_final_weight_qty IN NUMBER DEFAULT NULL
28 );
29
30 PROCEDURE lock_row (
31 x_rowid IN VARCHAR2,
32 x_unit_section_ass_item_id IN NUMBER,
33 x_uoo_id IN NUMBER,
34 x_ass_id IN NUMBER,
35 x_sequence_number IN NUMBER,
36 x_ci_start_dt IN DATE,
37 x_ci_end_dt IN DATE,
38 x_due_dt IN DATE,
39 x_reference IN VARCHAR2,
40 x_dflt_item_ind IN VARCHAR2,
41 x_logical_delete_dt IN DATE,
42 x_action_dt IN DATE,
43 x_exam_cal_type IN VARCHAR2,
44 x_exam_ci_sequence_number IN NUMBER,
45 x_grading_schema_cd IN VARCHAR2,
46 x_gs_version_number IN NUMBER,
47 x_release_date IN DATE,
48 x_description IN VARCHAR2 DEFAULT NULL,
49 x_us_ass_item_group_id IN VARCHAR2 DEFAULT NULL,
50 x_midterm_mandatory_type_code IN VARCHAR2 DEFAULT NULL,
51 x_midterm_weight_qty IN NUMBER DEFAULT NULL,
52 x_final_mandatory_type_code IN VARCHAR2 DEFAULT NULL,
53 x_final_weight_qty IN NUMBER DEFAULT NULL
54 );
55
56 PROCEDURE update_row (
57 x_rowid IN VARCHAR2,
58 x_unit_section_ass_item_id IN NUMBER,
59 x_uoo_id IN NUMBER,
60 x_ass_id IN NUMBER,
61 x_sequence_number IN NUMBER,
62 x_ci_start_dt IN DATE,
63 x_ci_end_dt IN DATE,
64 x_due_dt IN DATE,
65 x_reference IN VARCHAR2,
66 x_dflt_item_ind IN VARCHAR2,
67 x_logical_delete_dt IN DATE,
68 x_action_dt IN DATE,
69 x_exam_cal_type IN VARCHAR2,
70 x_exam_ci_sequence_number IN NUMBER,
71 x_mode IN VARCHAR2 DEFAULT 'R',
72 x_grading_schema_cd IN VARCHAR2,
73 x_gs_version_number IN NUMBER,
74 x_release_date IN DATE,
75 x_description IN VARCHAR2 DEFAULT NULL,
76 x_us_ass_item_group_id IN VARCHAR2 DEFAULT NULL,
77 x_midterm_mandatory_type_code IN VARCHAR2 DEFAULT NULL,
78 x_midterm_weight_qty IN NUMBER DEFAULT NULL,
79 x_final_mandatory_type_code IN VARCHAR2 DEFAULT NULL,
80 x_final_weight_qty IN NUMBER DEFAULT NULL
81 );
82
83 PROCEDURE add_row (
84 x_rowid IN OUT NOCOPY VARCHAR2,
85 x_unit_section_ass_item_id IN OUT NOCOPY NUMBER,
86 x_uoo_id IN NUMBER,
87 x_ass_id IN NUMBER,
88 x_sequence_number IN OUT NOCOPY NUMBER,
89 x_ci_start_dt IN OUT NOCOPY DATE,
90 x_ci_end_dt IN OUT NOCOPY DATE,
91 x_due_dt IN DATE,
92 x_reference IN VARCHAR2,
93 x_dflt_item_ind IN VARCHAR2,
94 x_logical_delete_dt IN DATE,
95 x_action_dt IN DATE,
96 x_exam_cal_type IN VARCHAR2,
97 x_exam_ci_sequence_number IN NUMBER,
98 x_mode IN VARCHAR2 DEFAULT 'R',
99 x_grading_schema_cd IN VARCHAR2,
100 x_gs_version_number IN NUMBER,
101 x_release_date IN DATE,
102 x_description IN VARCHAR2 DEFAULT NULL,
103 x_us_ass_item_group_id IN VARCHAR2 DEFAULT NULL,
104 x_midterm_mandatory_type_code IN VARCHAR2 DEFAULT NULL,
105 x_midterm_weight_qty IN NUMBER DEFAULT NULL,
106 x_final_mandatory_type_code IN VARCHAR2 DEFAULT NULL,
107 x_final_weight_qty IN NUMBER DEFAULT NULL
108 );
109
110 PROCEDURE delete_row (x_rowid IN VARCHAR2);
111
112 FUNCTION get_pk_for_validation (x_unit_section_ass_item_id IN NUMBER)
113 RETURN BOOLEAN;
114
115 FUNCTION get_uk_for_validation (x_ass_id IN NUMBER, x_sequence_number IN NUMBER, x_uoo_id IN NUMBER)
116 RETURN BOOLEAN;
117
118 -- ADDED BY DDEY FOR BUG # 2162831
119 PROCEDURE get_fk_igs_as_grd_schema (x_grading_schema_cd IN VARCHAR2, x_version_number IN NUMBER);
120
121 PROCEDURE get_fk_igs_as_us_ai_group (x_us_ass_item_group_id IN NUMBER);
122
123 PROCEDURE check_constraints (column_name IN VARCHAR2 DEFAULT NULL, column_value IN VARCHAR2 DEFAULT NULL);
124
125 PROCEDURE before_dml (
126 p_action IN VARCHAR2,
127 x_rowid IN VARCHAR2 DEFAULT NULL,
128 x_unit_section_ass_item_id IN NUMBER DEFAULT NULL,
129 x_uoo_id IN NUMBER DEFAULT NULL,
130 x_ass_id IN NUMBER DEFAULT NULL,
131 x_sequence_number IN NUMBER DEFAULT NULL,
132 x_ci_start_dt IN DATE DEFAULT NULL,
133 x_ci_end_dt IN DATE DEFAULT NULL,
134 x_due_dt IN DATE DEFAULT NULL,
135 x_reference IN VARCHAR2 DEFAULT NULL,
136 x_dflt_item_ind IN VARCHAR2 DEFAULT NULL,
137 x_logical_delete_dt IN DATE DEFAULT NULL,
138 x_action_dt IN DATE DEFAULT NULL,
139 x_exam_cal_type IN VARCHAR2 DEFAULT NULL,
140 x_exam_ci_sequence_number IN NUMBER DEFAULT NULL,
141 x_creation_date IN DATE DEFAULT NULL,
142 x_created_by IN NUMBER DEFAULT NULL,
143 x_last_update_date IN DATE DEFAULT NULL,
144 x_last_updated_by IN NUMBER DEFAULT NULL,
145 x_last_update_login IN NUMBER DEFAULT NULL,
146 x_grading_schema_cd IN VARCHAR2 DEFAULT NULL,
147 x_gs_version_number IN NUMBER DEFAULT NULL,
148 x_release_date IN DATE DEFAULT NULL,
149 x_description IN VARCHAR2 DEFAULT NULL,
150 x_us_ass_item_group_id IN VARCHAR2 DEFAULT NULL,
151 x_midterm_mandatory_type_code IN VARCHAR2 DEFAULT NULL,
152 x_midterm_weight_qty IN NUMBER DEFAULT NULL,
153 x_final_mandatory_type_code IN VARCHAR2 DEFAULT NULL,
154 x_final_weight_qty IN NUMBER DEFAULT NULL
155 );
156 END igs_ps_unitass_item_pkg;