APPS.IGS_AS_MARK_SHEET_PKG dependencies on IGS_AS_MARK_SHEET_ALL

Line 5: old_references IGS_AS_MARK_SHEET_ALL%RowType;

1: package body IGS_AS_MARK_SHEET_PKG as
2: /* $Header: IGSDI44B.pls 115.9 2002/11/28 23:21:35 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_MARK_SHEET_ALL%RowType;
6: new_references IGS_AS_MARK_SHEET_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_AS_MARK_SHEET_ALL%RowType;

2: /* $Header: IGSDI44B.pls 115.9 2002/11/28 23:21:35 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_MARK_SHEET_ALL%RowType;
6: new_references IGS_AS_MARK_SHEET_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 32: FROM IGS_AS_MARK_SHEET_ALL

28: ) as
29:
30: CURSOR cur_old_ref_values IS
31: SELECT *
32: FROM IGS_AS_MARK_SHEET_ALL
33: WHERE rowid = x_rowid;
34:
35: BEGIN
36:

Line 188: FROM IGS_AS_MARK_SHEET_ALL

184: x_sheet_number IN NUMBER
185: ) RETURN BOOLEAN AS
186: CURSOR cur_rowid IS
187: SELECT rowid
188: FROM IGS_AS_MARK_SHEET_ALL
189: WHERE sheet_number = x_sheet_number
190: FOR UPDATE NOWAIT;
191:
192: lv_rowid cur_rowid%RowType;

Line 217: FROM IGS_AS_MARK_SHEET_ALL

213: ) as
214:
215: CURSOR cur_rowid IS
216: SELECT rowid
217: FROM IGS_AS_MARK_SHEET_ALL
218: WHERE unit_cd = x_unit_cd
219: AND version_number = x_version_number
220: AND cal_type = x_cal_type
221: AND ci_sequence_number = x_ci_sequence_number ;

Line 341: cursor C is select ROWID from IGS_AS_MARK_SHEET_ALL

337: X_DUPLICATE_IND in VARCHAR2,
338: X_MODE in VARCHAR2 default 'R',
339: X_GRADING_PERIOD_CD in VARCHAR2
340: ) as
341: cursor C is select ROWID from IGS_AS_MARK_SHEET_ALL
342: where SHEET_NUMBER = X_SHEET_NUMBER;
343: X_LAST_UPDATE_DATE DATE;
344: X_LAST_UPDATED_BY NUMBER;
345: X_LAST_UPDATE_LOGIN NUMBER;

Line 404: insert into IGS_AS_MARK_SHEET_ALL(

400: x_last_update_login=>X_LAST_UPDATE_LOGIN,
401: x_grading_period_cd=>X_GRADING_PERIOD_CD
402: );
403:
404: insert into IGS_AS_MARK_SHEET_ALL(
405: ORG_ID,
406: SHEET_NUMBER,
407: GROUP_SEQUENCE_NUMBER,
408: UNIT_CD,

Line 485: from IGS_AS_MARK_SHEET_ALL

481: UNIT_MODE,
482: PRODUCTION_DT,
483: DUPLICATE_IND,
484: GRADING_PERIOD_CD
485: from IGS_AS_MARK_SHEET_ALL
486: where ROWID = X_ROWID for update nowait;
487: tlinfo c1%rowtype;
488:
489: begin

Line 597: update IGS_AS_MARK_SHEET_ALL set

593: X_PROGRAM_UPDATE_DATE := SYSDATE;
594: end if;
595: end if;
596:
597: update IGS_AS_MARK_SHEET_ALL set
598: GROUP_SEQUENCE_NUMBER = NEW_REFERENCES.GROUP_SEQUENCE_NUMBER,
599: UNIT_CD = NEW_REFERENCES.UNIT_CD,
600: VERSION_NUMBER = NEW_REFERENCES.VERSION_NUMBER,
601: CAL_TYPE = NEW_REFERENCES.CAL_TYPE,

Line 639: cursor c1 is select rowid from IGS_AS_MARK_SHEET_ALL

635: X_DUPLICATE_IND in VARCHAR2,
636: X_MODE in VARCHAR2 default 'R',
637: X_GRADING_PERIOD_CD in VARCHAR2
638: ) as
639: cursor c1 is select rowid from IGS_AS_MARK_SHEET_ALL
640: where SHEET_NUMBER = X_SHEET_NUMBER
641: ;
642: begin
643: open c1;

Line 688: delete from IGS_AS_MARK_SHEET_ALL

684: Before_DML(
685: p_action => 'DELETE',
686: x_rowid => X_ROWID
687: );
688: delete from IGS_AS_MARK_SHEET_ALL
689: where ROWID = X_ROWID;
690: if (sql%notfound) then
691: raise no_data_found;
692: end if;