eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.IGS_AS_NON_ENR_STDOT_PKG

Source


1 package IGS_AS_NON_ENR_STDOT_PKG AUTHID CURRENT_USER AS
2  /* $Header: IGSDI17S.pls 115.4 2002/11/28 23:14:46 nsidana ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_ORG_ID in NUMBER,
6   X_PERSON_ID in NUMBER,
7   X_UNIT_CD in VARCHAR2,
8   X_VERSION_NUMBER in NUMBER,
9   X_CAL_TYPE in VARCHAR2,
10   X_CI_SEQUENCE_NUMBER in NUMBER,
11   X_COURSE_CD in VARCHAR2,
12   X_LOCATION_CD in VARCHAR2,
13   X_UNIT_MODE in VARCHAR2,
14   X_UNIT_CLASS in VARCHAR2,
15   X_s_grade_creation_method_type in VARCHAR2,
16   X_GRADING_SCHEMA_CD in VARCHAR2,
17   X_GS_VERSION_NUMBER in NUMBER,
18   X_GRADE in VARCHAR2,
19   X_MARK in NUMBER,
20   X_RESOLVED_IND in VARCHAR2,
21   X_COMMENTS in VARCHAR2,
22   X_MODE in VARCHAR2 default 'R'
23   );
24 procedure LOCK_ROW (
25   X_ROWID in VARCHAR2,
26   X_PERSON_ID in NUMBER,
27   X_UNIT_CD in VARCHAR2,
28   X_VERSION_NUMBER in NUMBER,
29   X_CAL_TYPE in VARCHAR2,
30   X_CI_SEQUENCE_NUMBER in NUMBER,
31   X_COURSE_CD in VARCHAR2,
32   X_LOCATION_CD in VARCHAR2,
33   X_UNIT_MODE in VARCHAR2,
34   X_UNIT_CLASS in VARCHAR2,
35   X_s_grade_creation_method_type in VARCHAR2,
36   X_GRADING_SCHEMA_CD in VARCHAR2,
37   X_GS_VERSION_NUMBER in NUMBER,
38   X_GRADE in VARCHAR2,
39   X_MARK in NUMBER,
40   X_RESOLVED_IND in VARCHAR2,
41   X_COMMENTS in VARCHAR2
42 );
43 procedure UPDATE_ROW (
44   X_ROWID in VARCHAR2,
45   X_PERSON_ID in NUMBER,
46   X_UNIT_CD in VARCHAR2,
47   X_VERSION_NUMBER in NUMBER,
48   X_CAL_TYPE in VARCHAR2,
49   X_CI_SEQUENCE_NUMBER in NUMBER,
50   X_COURSE_CD in VARCHAR2,
51   X_LOCATION_CD in VARCHAR2,
52   X_UNIT_MODE in VARCHAR2,
53   X_UNIT_CLASS in VARCHAR2,
54   X_s_grade_creation_method_type in VARCHAR2,
55   X_GRADING_SCHEMA_CD in VARCHAR2,
56   X_GS_VERSION_NUMBER in NUMBER,
57   X_GRADE in VARCHAR2,
58   X_MARK in NUMBER,
59   X_RESOLVED_IND in VARCHAR2,
60   X_COMMENTS in VARCHAR2,
61   X_MODE in VARCHAR2 default 'R'
62   );
63 procedure ADD_ROW (
64   X_ROWID in out NOCOPY VARCHAR2,
65   X_ORG_ID in NUMBER,
66   X_PERSON_ID in NUMBER,
67   X_UNIT_CD in VARCHAR2,
68   X_VERSION_NUMBER in NUMBER,
69   X_CAL_TYPE in VARCHAR2,
70   X_CI_SEQUENCE_NUMBER in NUMBER,
71   X_COURSE_CD in VARCHAR2,
72   X_LOCATION_CD in VARCHAR2,
73   X_UNIT_MODE in VARCHAR2,
74   X_UNIT_CLASS in VARCHAR2,
75   X_s_grade_creation_method_type in VARCHAR2,
76   X_GRADING_SCHEMA_CD in VARCHAR2,
77   X_GS_VERSION_NUMBER in NUMBER,
78   X_GRADE in VARCHAR2,
79   X_MARK in NUMBER,
80   X_RESOLVED_IND in VARCHAR2,
81   X_COMMENTS in VARCHAR2,
82   X_MODE in VARCHAR2 default 'R'
83   );
84 procedure DELETE_ROW (
85   X_ROWID in VARCHAR2
86   );
87   FUNCTION Get_PK_For_Validation (
88     x_person_id IN NUMBER,
89     x_unit_cd IN VARCHAR2,
90     x_version_number IN NUMBER,
91     x_cal_type IN VARCHAR2,
92     x_ci_sequence_number IN NUMBER
93     )RETURN BOOLEAN;
94   PROCEDURE GET_FK_IGS_AS_GRD_SCH_GRADE (
95     x_grading_schema_cd IN VARCHAR2,
96     x_version_number IN NUMBER,
97     x_grade IN VARCHAR2
98     );
99   PROCEDURE GET_FK_IGS_PE_PERSON (
100     x_person_id IN NUMBER
101     );
102   PROCEDURE GET_FK_IGS_LOOKUPS_VIEW(
103     X_s_grade_creation_method_type IN VARCHAR2
104     );
105   PROCEDURE GET_FK_IGS_PS_UNIT_OFR_PAT (
106     x_unit_cd IN VARCHAR2,
107     x_version_number IN NUMBER,
108     x_cal_type IN VARCHAR2,
109     x_ci_sequence_number IN NUMBER
110     );
111   PROCEDURE GET_FK_IGS_PS_COURSE (
112     x_course_cd IN VARCHAR2
113     );
114 
115 
116 	PROCEDURE Check_Constraints (
117 
118 
119 	Column_Name	IN	VARCHAR2	DEFAULT NULL,
120 
121 
122 	Column_Value 	IN	VARCHAR2	DEFAULT NULL
123 
124 
125 	);
126 
127 
128 
129 
130 
131  PROCEDURE Before_DML (
132 
133 
134     p_action IN VARCHAR2,
135 
136 
137     x_rowid IN  VARCHAR2 DEFAULT NULL,
138     x_org_id in NUMBER DEFAULT NULL,
139 
140     x_person_id IN NUMBER DEFAULT NULL,
141 
142 
143     x_unit_cd IN VARCHAR2 DEFAULT NULL,
144 
145 
146     x_version_number IN NUMBER DEFAULT NULL,
147 
148 
149     x_cal_type IN VARCHAR2 DEFAULT NULL,
150 
151 
152     x_ci_sequence_number IN NUMBER DEFAULT NULL,
153 
154 
155     x_course_cd IN VARCHAR2 DEFAULT NULL,
156 
157 
158     x_location_cd IN VARCHAR2 DEFAULT NULL,
159 
160 
161     x_unit_mode IN VARCHAR2 DEFAULT NULL,
162 
163 
164     x_unit_class IN VARCHAR2 DEFAULT NULL,
165 
166 
167     x_s_grade_creation_method_type IN VARCHAR2 DEFAULT NULL,
168 
169 
170     x_grading_schema_cd IN VARCHAR2 DEFAULT NULL,
171 
172 
173     x_gs_version_number IN NUMBER DEFAULT NULL,
174 
175 
176     x_grade IN VARCHAR2 DEFAULT NULL,
177 
178 
179     x_mark IN NUMBER DEFAULT NULL,
180 
181 
182     x_resolved_ind IN VARCHAR2 DEFAULT NULL,
183 
184 
185     x_comments IN VARCHAR2 DEFAULT NULL,
186 
187 
188     x_creation_date IN DATE DEFAULT NULL,
189 
190 
191     x_created_by IN NUMBER DEFAULT NULL,
192 
193 
194     x_last_update_date IN DATE DEFAULT NULL,
195 
196 
197     x_last_updated_by IN NUMBER DEFAULT NULL,
198 
199 
200     x_last_update_login IN NUMBER DEFAULT NULL
201 
202 
203   ) ;
204 end IGS_AS_NON_ENR_STDOT_PKG;