1 PACKAGE igs_ps_usec_cps_pkg AS
2 /* $Header: IGSPI1AS.pls 120.0 2005/06/01 20:16:57 appldev noship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 x_UNIT_SEC_CREDIT_POINTS_ID IN OUT NOCOPY NUMBER,
6 x_UOO_ID IN NUMBER,
7 x_MINIMUM_CREDIT_POINTS IN NUMBER,
8 x_MAXIMUM_CREDIT_POINTS IN NUMBER,
9 x_VARIABLE_INCREMENT IN NUMBER,
10 x_LECTURE_CREDIT_POINTS IN NUMBER,
11 x_LAB_CREDIT_POINTS IN NUMBER,
12 x_OTHER_CREDIT_POINTS IN NUMBER,
13 x_CLOCK_HOURS IN NUMBER,
14 x_WORK_LOAD_CP_LECTURE IN NUMBER,
15 x_WORK_LOAD_CP_LAB IN NUMBER,
16 x_CONTINUING_EDUCATION_UNITS IN NUMBER,
17 x_WORK_LOAD_OTHER IN NUMBER DEFAULT NULL,
18 x_CONTACT_HRS_LECTURE IN NUMBER DEFAULT NULL,
19 x_CONTACT_HRS_LAB IN NUMBER DEFAULT NULL,
20 x_CONTACT_HRS_OTHER IN NUMBER DEFAULT NULL,
21 x_NON_SCHD_REQUIRED_HRS IN NUMBER DEFAULT NULL,
22 x_EXCLUDE_FROM_MAX_CP_LIMIT IN VARCHAR2 DEFAULT NULL,
23 X_MODE in VARCHAR2 default 'R' ,
24 x_claimable_hours IN NUMBER DEFAULT NULL,
25 x_achievable_credit_points IN NUMBER DEFAULT NULL,
26 x_enrolled_credit_points IN NUMBER DEFAULT NULL ,
27 x_billing_credit_points IN NUMBER DEFAULT NULL ,
28 x_billing_hrs IN NUMBER DEFAULT NULL
29 );
30
31 procedure LOCK_ROW (
32 X_ROWID in VARCHAR2,
33 x_UNIT_SEC_CREDIT_POINTS_ID IN NUMBER,
34 x_UOO_ID IN NUMBER,
35 x_MINIMUM_CREDIT_POINTS IN NUMBER,
36 x_MAXIMUM_CREDIT_POINTS IN NUMBER,
37 x_VARIABLE_INCREMENT IN NUMBER,
38 x_LECTURE_CREDIT_POINTS IN NUMBER,
39 x_LAB_CREDIT_POINTS IN NUMBER,
40 x_OTHER_CREDIT_POINTS IN NUMBER,
41 x_CLOCK_HOURS IN NUMBER,
42 x_WORK_LOAD_CP_LECTURE IN NUMBER,
43 x_WORK_LOAD_CP_LAB IN NUMBER,
44 x_CONTINUING_EDUCATION_UNITS IN NUMBER,
45 x_WORK_LOAD_OTHER IN NUMBER DEFAULT NULL,
46 x_CONTACT_HRS_LECTURE IN NUMBER DEFAULT NULL,
47 x_CONTACT_HRS_LAB IN NUMBER DEFAULT NULL,
48 x_CONTACT_HRS_OTHER IN NUMBER DEFAULT NULL,
49 x_NON_SCHD_REQUIRED_HRS IN NUMBER DEFAULT NULL,
50 x_EXCLUDE_FROM_MAX_CP_LIMIT IN VARCHAR2 DEFAULT NULL,
51 x_claimable_hours IN NUMBER DEFAULT NULL,
52 x_achievable_credit_points IN NUMBER DEFAULT NULL,
53 x_enrolled_credit_points IN NUMBER DEFAULT NULL,
54 x_billing_credit_points IN NUMBER DEFAULT NULL ,
55 x_billing_hrs IN NUMBER DEFAULT NULL
56 );
57
58 procedure UPDATE_ROW (
59 X_ROWID in VARCHAR2,
60 x_UNIT_SEC_CREDIT_POINTS_ID IN NUMBER,
61 x_UOO_ID IN NUMBER,
62 x_MINIMUM_CREDIT_POINTS IN NUMBER,
63 x_MAXIMUM_CREDIT_POINTS IN NUMBER,
64 x_VARIABLE_INCREMENT IN NUMBER,
65 x_LECTURE_CREDIT_POINTS IN NUMBER,
66 x_LAB_CREDIT_POINTS IN NUMBER,
67 x_OTHER_CREDIT_POINTS IN NUMBER,
68 x_CLOCK_HOURS IN NUMBER,
69 x_WORK_LOAD_CP_LECTURE IN NUMBER,
70 x_WORK_LOAD_CP_LAB IN NUMBER,
71 x_CONTINUING_EDUCATION_UNITS IN NUMBER,
72 x_WORK_LOAD_OTHER IN NUMBER DEFAULT NULL,
73 x_CONTACT_HRS_LECTURE IN NUMBER DEFAULT NULL,
74 x_CONTACT_HRS_LAB IN NUMBER DEFAULT NULL,
75 x_CONTACT_HRS_OTHER IN NUMBER DEFAULT NULL,
76 x_NON_SCHD_REQUIRED_HRS IN NUMBER DEFAULT NULL,
77 x_EXCLUDE_FROM_MAX_CP_LIMIT IN VARCHAR2 DEFAULT NULL,
78 X_MODE in VARCHAR2 default 'R',
79 x_claimable_hours IN NUMBER DEFAULT NULL,
80 x_achievable_credit_points IN NUMBER DEFAULT NULL,
81 x_enrolled_credit_points IN NUMBER DEFAULT NULL ,
82 x_billing_credit_points IN NUMBER DEFAULT NULL ,
83 x_billing_hrs IN NUMBER DEFAULT NULL
84 );
85
86 procedure ADD_ROW (
87 X_ROWID in out NOCOPY VARCHAR2,
88 x_UNIT_SEC_CREDIT_POINTS_ID IN OUT NOCOPY NUMBER,
89 x_UOO_ID IN NUMBER,
90 x_MINIMUM_CREDIT_POINTS IN NUMBER,
91 x_MAXIMUM_CREDIT_POINTS IN NUMBER,
92 x_VARIABLE_INCREMENT IN NUMBER,
93 x_LECTURE_CREDIT_POINTS IN NUMBER,
94 x_LAB_CREDIT_POINTS IN NUMBER,
95 x_OTHER_CREDIT_POINTS IN NUMBER,
96 x_CLOCK_HOURS IN NUMBER,
97 x_WORK_LOAD_CP_LECTURE IN NUMBER,
98 x_WORK_LOAD_CP_LAB IN NUMBER,
99 x_CONTINUING_EDUCATION_UNITS IN NUMBER,
100 x_WORK_LOAD_OTHER IN NUMBER DEFAULT NULL,
101 x_CONTACT_HRS_LECTURE IN NUMBER DEFAULT NULL,
102 x_CONTACT_HRS_LAB IN NUMBER DEFAULT NULL,
103 x_CONTACT_HRS_OTHER IN NUMBER DEFAULT NULL,
104 x_NON_SCHD_REQUIRED_HRS IN NUMBER DEFAULT NULL,
105 x_EXCLUDE_FROM_MAX_CP_LIMIT IN VARCHAR2 DEFAULT NULL,
106 X_MODE in VARCHAR2 default 'R' ,
107 x_claimable_hours IN NUMBER DEFAULT NULL,
108 x_achievable_credit_points IN NUMBER DEFAULT NULL,
109 x_enrolled_credit_points IN NUMBER DEFAULT NULL ,
110 x_billing_credit_points IN NUMBER DEFAULT NULL ,
111 x_billing_hrs IN NUMBER DEFAULT NULL
112 ) ;
113
114 procedure DELETE_ROW (
115 X_ROWID in VARCHAR2
116 ) ;
117 FUNCTION Get_PK_For_Validation (
118 x_unit_sec_credit_points_id IN NUMBER
119 ) RETURN BOOLEAN ;
120
121 FUNCTION Get_UK_For_Validation (
122 x_uoo_id IN NUMBER
123 ) RETURN BOOLEAN;
124
125 PROCEDURE Get_UFK_Igs_Ps_Unit_Ofr_Opt (
126 x_uoo_id IN NUMBER
127 );
128
129 PROCEDURE Check_Constraints (
130 Column_Name IN VARCHAR2 DEFAULT NULL,
131 Column_Value IN VARCHAR2 DEFAULT NULL ) ;
132
133 PROCEDURE Before_DML (
134 p_action IN VARCHAR2,
135 x_rowid IN VARCHAR2 DEFAULT NULL,
136 x_unit_sec_credit_points_id IN NUMBER DEFAULT NULL,
137 x_uoo_id IN NUMBER DEFAULT NULL,
138 x_minimum_credit_points IN NUMBER DEFAULT NULL,
139 x_maximum_credit_points IN NUMBER DEFAULT NULL,
140 x_variable_increment IN NUMBER DEFAULT NULL,
141 x_lecture_credit_points IN NUMBER DEFAULT NULL,
142 x_lab_credit_points IN NUMBER DEFAULT NULL,
143 x_other_credit_points IN NUMBER DEFAULT NULL,
144 x_clock_hours IN NUMBER DEFAULT NULL,
145 x_work_load_cp_lecture IN NUMBER DEFAULT NULL,
146 x_work_load_cp_lab IN NUMBER DEFAULT NULL,
147 x_continuing_education_units IN NUMBER DEFAULT NULL,
148 x_WORK_LOAD_OTHER IN NUMBER DEFAULT NULL,
149 x_CONTACT_HRS_LECTURE IN NUMBER DEFAULT NULL,
150 x_CONTACT_HRS_LAB IN NUMBER DEFAULT NULL,
151 x_CONTACT_HRS_OTHER IN NUMBER DEFAULT NULL,
152 x_NON_SCHD_REQUIRED_HRS IN NUMBER DEFAULT NULL,
153 x_EXCLUDE_FROM_MAX_CP_LIMIT IN VARCHAR2 DEFAULT NULL,
154 x_creation_date IN DATE DEFAULT NULL,
155 x_created_by IN NUMBER DEFAULT NULL,
156 x_last_update_date IN DATE DEFAULT NULL,
157 x_last_updated_by IN NUMBER DEFAULT NULL,
158 x_last_update_login IN NUMBER DEFAULT NULL,
159 x_claimable_hours IN NUMBER DEFAULT NULL,
160 x_achievable_credit_points IN NUMBER DEFAULT NULL,
161 x_enrolled_credit_points IN NUMBER DEFAULT NULL ,
162 x_billing_credit_points IN NUMBER DEFAULT NULL ,
163 x_billing_hrs IN NUMBER DEFAULT NULL
164 );
165 END igs_ps_usec_cps_pkg;