1 package IGS_ST_GVT_STDNTLOAD_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSVI09S.pls 115.4 2003/05/20 06:08:24 svanukur ship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 X_SUBMISSION_YR in NUMBER,
6 X_SUBMISSION_NUMBER in NUMBER,
7 X_PERSON_ID in NUMBER,
8 X_COURSE_CD in VARCHAR2,
9 X_GOVT_SEMESTER in NUMBER,
10 X_UNIT_CD in VARCHAR2,
11 X_SUA_CAL_TYPE in VARCHAR2,
12 X_SUA_CI_SEQUENCE_NUMBER in NUMBER,
13 X_TR_ORG_UNIT_CD in VARCHAR2,
14 X_TR_OU_START_DT in DATE,
15 X_DISCIPLINE_GROUP_CD in VARCHAR2,
16 X_GOVT_DISCIPLINE_GROUP_CD in VARCHAR2,
17 X_INDUSTRIAL_IND in VARCHAR2,
18 X_EFTSU in NUMBER,
19 X_UNIT_COMPLETION_STATUS in NUMBER,
20 X_CRV_VERSION_NUMBER in NUMBER,
21 X_UV_VERSION_NUMBER in NUMBER,
22 X_MODE in VARCHAR2 default 'R',
23 X_UNIT_CLASS in VARCHAR2,
24 X_SUA_LOCATION_CD in varchar2
25 );
26 procedure LOCK_ROW (
27 X_ROWID in VARCHAR2,
28 X_SUBMISSION_YR in NUMBER,
29 X_SUBMISSION_NUMBER in NUMBER,
30 X_PERSON_ID in NUMBER,
31 X_COURSE_CD in VARCHAR2,
32 X_GOVT_SEMESTER in NUMBER,
33 X_UNIT_CD in VARCHAR2,
34 X_SUA_CAL_TYPE in VARCHAR2,
35 X_SUA_CI_SEQUENCE_NUMBER in NUMBER,
36 X_TR_ORG_UNIT_CD in VARCHAR2,
37 X_TR_OU_START_DT in DATE,
38 X_DISCIPLINE_GROUP_CD in VARCHAR2,
39 X_GOVT_DISCIPLINE_GROUP_CD in VARCHAR2,
40 X_INDUSTRIAL_IND in VARCHAR2,
41 X_EFTSU in NUMBER,
42 X_UNIT_COMPLETION_STATUS in NUMBER,
43 X_CRV_VERSION_NUMBER in NUMBER,
44 X_UV_VERSION_NUMBER in NUMBER,
45 X_UNIT_CLASS in VARCHAR2,
46 X_SUA_LOCATION_CD in varchar2
47 );
48 procedure UPDATE_ROW (
49 X_ROWID in VARCHAR2,
50 X_SUBMISSION_YR in NUMBER,
51 X_SUBMISSION_NUMBER in NUMBER,
52 X_PERSON_ID in NUMBER,
53 X_COURSE_CD in VARCHAR2,
54 X_GOVT_SEMESTER in NUMBER,
55 X_UNIT_CD in VARCHAR2,
56 X_SUA_CAL_TYPE in VARCHAR2,
57 X_SUA_CI_SEQUENCE_NUMBER in NUMBER,
58 X_TR_ORG_UNIT_CD in VARCHAR2,
59 X_TR_OU_START_DT in DATE,
60 X_DISCIPLINE_GROUP_CD in VARCHAR2,
61 X_GOVT_DISCIPLINE_GROUP_CD in VARCHAR2,
62 X_INDUSTRIAL_IND in VARCHAR2,
63 X_EFTSU in NUMBER,
64 X_UNIT_COMPLETION_STATUS in NUMBER,
65 X_CRV_VERSION_NUMBER in NUMBER,
66 X_UV_VERSION_NUMBER in NUMBER,
67 X_MODE in VARCHAR2 default 'R',
68 X_UNIT_CLASS in VARCHAR2,
69 X_SUA_LOCATION_CD in varchar2
70 );
71 procedure ADD_ROW (
72 X_ROWID in out NOCOPY VARCHAR2,
73 X_SUBMISSION_YR in NUMBER,
74 X_SUBMISSION_NUMBER in NUMBER,
75 X_PERSON_ID in NUMBER,
76 X_COURSE_CD in VARCHAR2,
77 X_GOVT_SEMESTER in NUMBER,
78 X_UNIT_CD in VARCHAR2,
79 X_SUA_CAL_TYPE in VARCHAR2,
80 X_SUA_CI_SEQUENCE_NUMBER in NUMBER,
81 X_TR_ORG_UNIT_CD in VARCHAR2,
82 X_TR_OU_START_DT in DATE,
83 X_DISCIPLINE_GROUP_CD in VARCHAR2,
84 X_GOVT_DISCIPLINE_GROUP_CD in VARCHAR2,
85 X_INDUSTRIAL_IND in VARCHAR2,
86 X_EFTSU in NUMBER,
87 X_UNIT_COMPLETION_STATUS in NUMBER,
88 X_CRV_VERSION_NUMBER in NUMBER,
89 X_UV_VERSION_NUMBER in NUMBER,
90 X_MODE in VARCHAR2 default 'R',
91 X_UNIT_CLASS in VARCHAR2,
92 X_SUA_LOCATION_CD in varchar2
93 );
94 procedure DELETE_ROW (
95 X_ROWID in VARCHAR2
96 );
97
98 FUNCTION Get_PK_For_Validation (
99 x_submission_yr IN NUMBER,
100 x_submission_number IN NUMBER,
101 x_person_id IN NUMBER,
102 x_course_cd IN VARCHAR2,
103 x_govt_semester IN NUMBER,
104 x_unit_cd IN VARCHAR2,
105 x_sua_cal_type IN VARCHAR2,
106 x_sua_ci_sequence_number IN NUMBER,
107 x_tr_org_unit_cd IN VARCHAR2,
108 x_tr_ou_start_dt IN DATE,
109 x_discipline_group_cd IN VARCHAR2,
110 x_govt_discipline_group_cd IN VARCHAR2
111 )
112 RETURN BOOLEAN;
113
114 PROCEDURE GET_FK_IGS_ST_GOVT_SEMESTER (
115 x_submission_yr IN NUMBER,
116 x_submission_number IN NUMBER,
117 x_govt_semester IN NUMBER
118 );
119
120 -- added to take care of check constraints
121 PROCEDURE CHECK_CONSTRAINTS(
122 column_name IN VARCHAR2 DEFAULT NULL,
123 column_value IN VARCHAR2 DEFAULT NULL
124 );
125
126 PROCEDURE Before_DML (
127 p_action IN VARCHAR2,
128 x_rowid IN VARCHAR2 DEFAULT NULL,
129 x_submission_yr IN NUMBER DEFAULT NULL,
130 x_submission_number IN NUMBER DEFAULT NULL,
131 x_person_id IN NUMBER DEFAULT NULL,
132 x_course_cd IN VARCHAR2 DEFAULT NULL,
133 x_crv_version_number IN NUMBER DEFAULT NULL,
134 x_govt_semester IN NUMBER DEFAULT NULL,
135 x_unit_cd IN VARCHAR2 DEFAULT NULL,
136 x_uv_version_number IN NUMBER DEFAULT NULL,
137 x_sua_cal_type IN VARCHAR2 DEFAULT NULL,
138 x_sua_ci_sequence_number IN NUMBER DEFAULT NULL,
139 x_tr_org_unit_cd IN VARCHAR2 DEFAULT NULL,
140 x_tr_ou_start_dt IN DATE DEFAULT NULL,
141 x_discipline_group_cd IN VARCHAR2 DEFAULT NULL,
142 x_govt_discipline_group_cd IN VARCHAR2 DEFAULT NULL,
143 x_industrial_ind IN VARCHAR2 DEFAULT NULL,
144 x_eftsu IN NUMBER DEFAULT NULL,
145 x_unit_completion_status IN NUMBER DEFAULT NULL,
146 x_creation_date IN DATE DEFAULT NULL,
147 x_created_by IN NUMBER DEFAULT NULL,
148 x_last_update_date IN DATE DEFAULT NULL,
149 x_last_updated_by IN NUMBER DEFAULT NULL,
150 x_last_update_login IN NUMBER DEFAULT NULL,
151 x_unit_class IN VARCHAR2 DEFAULT NULL,
152 x_sua_location_cd IN VARCHAR2 DEFAULT NULL
153 );
154 end IGS_ST_GVT_STDNTLOAD_PKG;