APPS.IGS_AS_MSHT_SU_ATMPT_PKG dependencies on IGS_AS_MSHT_SU_ATMPT

Line 1: package body IGS_AS_MSHT_SU_ATMPT_PKG AS

1: package body IGS_AS_MSHT_SU_ATMPT_PKG AS
2: /* $Header: IGSDI16B.pls 115.5 2003/04/30 05:51:32 svanukur ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AS_MSHT_SU_ATMPT%RowType;
5: new_references IGS_AS_MSHT_SU_ATMPT%RowType;

Line 4: old_references IGS_AS_MSHT_SU_ATMPT%RowType;

1: package body IGS_AS_MSHT_SU_ATMPT_PKG AS
2: /* $Header: IGSDI16B.pls 115.5 2003/04/30 05:51:32 svanukur ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AS_MSHT_SU_ATMPT%RowType;
5: new_references IGS_AS_MSHT_SU_ATMPT%RowType;
6: PROCEDURE Set_Column_Values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 5: new_references IGS_AS_MSHT_SU_ATMPT%RowType;

1: package body IGS_AS_MSHT_SU_ATMPT_PKG AS
2: /* $Header: IGSDI16B.pls 115.5 2003/04/30 05:51:32 svanukur ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AS_MSHT_SU_ATMPT%RowType;
5: new_references IGS_AS_MSHT_SU_ATMPT%RowType;
6: PROCEDURE Set_Column_Values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2 DEFAULT NULL,
9: x_sheet_number IN NUMBER DEFAULT NULL,

Line 28: FROM IGS_AS_MSHT_SU_ATMPT

24: x_uoo_id IN NUMBER DEFAULT NULL
25: ) AS
26: CURSOR cur_old_ref_values IS
27: SELECT *
28: FROM IGS_AS_MSHT_SU_ATMPT
29: WHERE rowid = x_rowid;
30: BEGIN
31: l_rowid := x_rowid;
32: -- Code for setting the Old and New Reference Values.

Line 111: FROM IGS_AS_MSHT_SU_ATMPT

107: x_uoo_id IN NUMBER
108: ) RETURN BOOLEAN AS
109: CURSOR cur_rowid IS
110: SELECT rowid
111: FROM IGS_AS_MSHT_SU_ATMPT
112: WHERE sheet_number = x_sheet_number
113: AND course_cd = x_course_cd
114: AND person_id = x_person_id
115: AND uoo_id = x_uoo_id

Line 134: FROM IGS_AS_MSHT_SU_ATMPT

130: x_sheet_number IN NUMBER
131: ) AS
132: CURSOR cur_rowid IS
133: SELECT rowid
134: FROM IGS_AS_MSHT_SU_ATMPT
135: WHERE sheet_number = x_sheet_number ;
136: lv_rowid cur_rowid%RowType;
137: BEGIN
138: Open cur_rowid;

Line 158: FROM IGS_AS_MSHT_SU_ATMPT

154: x_uoo_id IN NUMBER
155: ) AS
156: CURSOR cur_rowid IS
157: SELECT rowid
158: FROM IGS_AS_MSHT_SU_ATMPT
159: WHERE person_id = x_person_id
160: AND course_cd = x_course_cd
161: AND uoo_id = x_uoo_id;
162:

Line 277: cursor C is select ROWID from IGS_AS_MSHT_SU_ATMPT

273: X_STUDENT_SEQUENCE in NUMBER,
274: X_MODE in VARCHAR2 default 'R',
275: X_UOO_ID in NUMBER
276: ) AS
277: cursor C is select ROWID from IGS_AS_MSHT_SU_ATMPT
278: where SHEET_NUMBER = X_SHEET_NUMBER
279: and PERSON_ID = X_PERSON_ID
280: and COURSE_CD = X_COURSE_CD
281: and UOO_ID = X_UOO_ID;

Line 340: insert into IGS_AS_MSHT_SU_ATMPT (

336: x_last_updated_by=>X_LAST_UPDATED_BY,
337: x_last_update_login=>X_LAST_UPDATE_LOGIN,
338: x_uoo_id=>X_UOO_ID
339: );
340: insert into IGS_AS_MSHT_SU_ATMPT (
341: SHEET_NUMBER,
342: PERSON_ID,
343: COURSE_CD,
344: UNIT_CD,

Line 411: from IGS_AS_MSHT_SU_ATMPT

407: LOCATION_CD,
408: UNIT_MODE,
409: UNIT_CLASS,
410: STUDENT_SEQUENCE
411: from IGS_AS_MSHT_SU_ATMPT
412: where ROWID = X_ROWID for update nowait;
413: tlinfo c1%rowtype;
414: begin
415: open c1;

Line 512: update IGS_AS_MSHT_SU_ATMPT set

508: else
509: X_PROGRAM_UPDATE_DATE := SYSDATE;
510: end if;
511: end if;
512: update IGS_AS_MSHT_SU_ATMPT set
513: LOCATION_CD = NEW_REFERENCES.LOCATION_CD,
514: UNIT_MODE = NEW_REFERENCES.UNIT_MODE,
515: UNIT_CLASS = NEW_REFERENCES.UNIT_CLASS,
516: STUDENT_SEQUENCE = NEW_REFERENCES.STUDENT_SEQUENCE,

Line 545: cursor c1 is select rowid from IGS_AS_MSHT_SU_ATMPT

541: X_STUDENT_SEQUENCE in NUMBER,
542: X_MODE in VARCHAR2 default 'R',
543: X_UOO_ID in NUMBER
544: ) AS
545: cursor c1 is select rowid from IGS_AS_MSHT_SU_ATMPT
546: where SHEET_NUMBER = X_SHEET_NUMBER
547: and PERSON_ID = X_PERSON_ID
548: and COURSE_CD = X_COURSE_CD
549: and UOO_ID = X_UOO_ID ;

Line 594: delete from IGS_AS_MSHT_SU_ATMPT

590: Before_DML(
591: p_action => 'DELETE',
592: x_rowid => X_ROWID
593: );
594: delete from IGS_AS_MSHT_SU_ATMPT
595: where ROWID = X_ROWID;
596: if (sql%notfound) then
597: raise no_data_found;
598: end if;

Line 653: end IGS_AS_MSHT_SU_ATMPT_PKG;

649: END IF;
650: END Check_Constraints;
651:
652:
653: end IGS_AS_MSHT_SU_ATMPT_PKG;