APPS.IGS_AS_NON_ENR_STDOT_PKG dependencies on IGS_AS_NON_ENR_STDOT_ALL

Line 4: old_references IGS_AS_NON_ENR_STDOT_ALL%RowType;

1: package body IGS_AS_NON_ENR_STDOT_PKG AS
2: /* $Header: IGSDI17B.pls 115.7 2002/11/28 23:14:38 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AS_NON_ENR_STDOT_ALL%RowType;
5: new_references IGS_AS_NON_ENR_STDOT_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_AS_NON_ENR_STDOT_ALL%RowType;

1: package body IGS_AS_NON_ENR_STDOT_PKG AS
2: /* $Header: IGSDI17B.pls 115.7 2002/11/28 23:14:38 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AS_NON_ENR_STDOT_ALL%RowType;
5: new_references IGS_AS_NON_ENR_STDOT_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 36: FROM IGS_AS_NON_ENR_STDOT_ALL

32: ) AS
33:
34: CURSOR cur_old_ref_values IS
35: SELECT *
36: FROM IGS_AS_NON_ENR_STDOT_ALL
37: WHERE rowid = x_rowid;
38:
39: BEGIN
40:

Line 230: FROM IGS_AS_NON_ENR_STDOT_ALL

226: ) RETURN BOOLEAN AS
227:
228: CURSOR cur_rowid IS
229: SELECT rowid
230: FROM IGS_AS_NON_ENR_STDOT_ALL
231: WHERE person_id = x_person_id
232: AND unit_cd = x_unit_cd
233: AND version_number = x_version_number
234: AND cal_type = x_cal_type

Line 262: FROM IGS_AS_NON_ENR_STDOT_ALL

258: ) AS
259:
260: CURSOR cur_rowid IS
261: SELECT rowid
262: FROM IGS_AS_NON_ENR_STDOT_ALL
263: WHERE grading_schema_cd = x_grading_schema_cd
264: AND gs_version_number = x_version_number
265: AND grade = x_grade ;
266:

Line 291: FROM IGS_AS_NON_ENR_STDOT_ALL

287: ) AS
288:
289: CURSOR cur_rowid IS
290: SELECT rowid
291: FROM IGS_AS_NON_ENR_STDOT_ALL
292: WHERE person_id = x_person_id ;
293:
294: lv_rowid cur_rowid%RowType;
295:

Line 318: FROM IGS_AS_NON_ENR_STDOT_ALL

314: ) AS
315:
316: CURSOR cur_rowid IS
317: SELECT rowid
318: FROM IGS_AS_NON_ENR_STDOT_ALL
319: WHERE s_grade_creation_method_type = x_s_grade_creation_method_type ;
320:
321: lv_rowid cur_rowid%RowType;
322:

Line 348: FROM IGS_AS_NON_ENR_STDOT_ALL

344: ) AS
345:
346: CURSOR cur_rowid IS
347: SELECT rowid
348: FROM IGS_AS_NON_ENR_STDOT_ALL
349: WHERE unit_cd = x_unit_cd
350: AND version_number = x_version_number
351: AND cal_type = x_cal_type
352: AND ci_sequence_number = x_ci_sequence_number ;

Line 378: FROM IGS_AS_NON_ENR_STDOT_ALL

374: ) AS
375:
376: CURSOR cur_rowid IS
377: SELECT rowid
378: FROM IGS_AS_NON_ENR_STDOT_ALL
379: WHERE course_cd = x_course_cd ;
380:
381: lv_rowid cur_rowid%RowType;
382:

Line 526: cursor C is select ROWID from IGS_AS_NON_ENR_STDOT_ALL

522: X_RESOLVED_IND in VARCHAR2,
523: X_COMMENTS in VARCHAR2,
524: X_MODE in VARCHAR2 default 'R'
525: ) AS
526: cursor C is select ROWID from IGS_AS_NON_ENR_STDOT_ALL
527: where PERSON_ID = X_PERSON_ID
528: and UNIT_CD = X_UNIT_CD
529: and VERSION_NUMBER = X_VERSION_NUMBER
530: and CAL_TYPE = X_CAL_TYPE

Line 599: insert into IGS_AS_NON_ENR_STDOT_ALL (

595: x_last_updated_by=>X_LAST_UPDATED_BY,
596: x_last_update_login=>X_LAST_UPDATE_LOGIN
597: );
598:
599: insert into IGS_AS_NON_ENR_STDOT_ALL (
600: ORG_ID,
601: PERSON_ID,
602: UNIT_CD,
603: VERSION_NUMBER,

Line 696: from IGS_AS_NON_ENR_STDOT_ALL

692: GRADE,
693: MARK,
694: RESOLVED_IND,
695: COMMENTS
696: from IGS_AS_NON_ENR_STDOT_ALL
697: where ROWID = X_ROWID for update nowait;
698: tlinfo c1%rowtype;
699:
700: begin

Line 842: update IGS_AS_NON_ENR_STDOT_ALL set

838: end if;
839: end if;
840:
841:
842: update IGS_AS_NON_ENR_STDOT_ALL set
843: COURSE_CD = NEW_REFERENCES.COURSE_CD,
844: LOCATION_CD = NEW_REFERENCES.LOCATION_CD,
845: UNIT_MODE = NEW_REFERENCES.UNIT_MODE,
846: UNIT_CLASS = NEW_REFERENCES.UNIT_CLASS,

Line 890: cursor c1 is select rowid from IGS_AS_NON_ENR_STDOT_ALL

886: X_RESOLVED_IND in VARCHAR2,
887: X_COMMENTS in VARCHAR2,
888: X_MODE in VARCHAR2 default 'R'
889: ) AS
890: cursor c1 is select rowid from IGS_AS_NON_ENR_STDOT_ALL
891: where PERSON_ID = X_PERSON_ID
892: and UNIT_CD = X_UNIT_CD
893: and VERSION_NUMBER = X_VERSION_NUMBER
894: and CAL_TYPE = X_CAL_TYPE

Line 953: delete from IGS_AS_NON_ENR_STDOT_ALL

949: Before_DML(
950: p_action => 'DELETE',
951: x_rowid => X_ROWID
952: );
953: delete from IGS_AS_NON_ENR_STDOT_ALL
954: where ROWID = X_ROWID;
955: if (sql%notfound) then
956: raise no_data_found;
957: end if;