APPS.IGS_EN_ST_SNAPSHOT_PKG dependencies on IGS_EN_ST_SNAPSHOT

Line 1: package body IGS_EN_ST_SNAPSHOT_PKG as

1: package body IGS_EN_ST_SNAPSHOT_PKG as
2: /* $Header: IGSEI08B.pls 115.3 2002/11/28 23:33:02 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_EN_ST_SNAPSHOT%RowType;

Line 5: old_references IGS_EN_ST_SNAPSHOT%RowType;

1: package body IGS_EN_ST_SNAPSHOT_PKG as
2: /* $Header: IGSEI08B.pls 115.3 2002/11/28 23:33:02 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_EN_ST_SNAPSHOT%RowType;
6: new_references IGS_EN_ST_SNAPSHOT%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_EN_ST_SNAPSHOT%RowType;

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

Line 60: FROM IGS_EN_ST_SNAPSHOT

56: ) AS
57:
58: CURSOR cur_old_ref_values IS
59: SELECT *
60: FROM IGS_EN_ST_SNAPSHOT
61: WHERE rowid = x_rowid;
62:
63: BEGIN
64:

Line 161: FROM IGS_EN_ST_SNAPSHOT

157: ) AS
158:
159: CURSOR cur_rowid IS
160: SELECT rowid
161: FROM IGS_EN_ST_SNAPSHOT
162: WHERE snapshot_dt_time = x_snapshot_dt_time ;
163:
164: lv_rowid cur_rowid%RowType;
165:

Line 187: FROM IGS_EN_ST_SNAPSHOT

183: ) RETURN BOOLEAN as
184:
185: CURSOR cur_rowid IS
186: SELECT rowid
187: FROM IGS_EN_ST_SNAPSHOT
188: WHERE ESS_ID = x_ESS_ID
189: FOR UPDATE NOWAIT;
190:
191: lv_rowid cur_rowid%RowType;

Line 408: cursor C is select ROWID from IGS_EN_ST_SNAPSHOT

404: X_UNIT_INT_COURSE_LEVEL_CD in VARCHAR2,
405: X_GOVT_REPORTABLE_IND in VARCHAR2,
406: X_MODE in VARCHAR2 default 'R'
407: ) AS
408: cursor C is select ROWID from IGS_EN_ST_SNAPSHOT
409: where ESS_ID = X_ESS_ID;
410: X_LAST_UPDATE_DATE DATE;
411: X_LAST_UPDATED_BY NUMBER;
412: X_LAST_UPDATE_LOGIN NUMBER;

Line 451: SELECT IGS_EN_ST_SNAPSHOT_ESS_ID_S.Nextval

447: IGS_GE_MSG_STACK.ADD;
448: app_exception.raise_exception;
449: end if;
450:
451: SELECT IGS_EN_ST_SNAPSHOT_ESS_ID_S.Nextval
452: INTO X_ESS_ID
453: FROM DUAL;
454:
455: Before_DML(

Line 505: insert into IGS_EN_ST_SNAPSHOT (

501: x_last_updated_by=>X_LAST_UPDATED_BY,
502: x_last_update_login=>X_LAST_UPDATE_LOGIN
503: );
504:
505: insert into IGS_EN_ST_SNAPSHOT (
506: ESS_ID,
507: SNAPSHOT_DT_TIME,
508: CI_CAL_TYPE,
509: CI_SEQUENCE_NUMBER,

Line 703: from IGS_EN_ST_SNAPSHOT

699: EFTSU,
700: WEFTSU,
701: UNIT_INT_COURSE_LEVEL_CD,
702: GOVT_REPORTABLE_IND
703: from IGS_EN_ST_SNAPSHOT
704: where rowid = x_rowid for update nowait;
705: tlinfo c1%rowtype;
706:
707: begin

Line 921: update IGS_EN_ST_SNAPSHOT set

917: x_program_update_date := SYSDATE;
918: end if;
919: end if;
920:
921: update IGS_EN_ST_SNAPSHOT set
922: SNAPSHOT_DT_TIME = new_references.SNAPSHOT_DT_TIME,
923: CI_CAL_TYPE = new_references.CI_CAL_TYPE,
924: CI_SEQUENCE_NUMBER = new_references.CI_SEQUENCE_NUMBER,
925: PERSON_ID = new_references.PERSON_ID,

Line 1026: cursor c1 is select rowid from IGS_EN_ST_SNAPSHOT

1022: X_UNIT_INT_COURSE_LEVEL_CD in VARCHAR2,
1023: X_GOVT_REPORTABLE_IND in VARCHAR2,
1024: X_MODE in VARCHAR2 default 'R'
1025: ) AS
1026: cursor c1 is select rowid from IGS_EN_ST_SNAPSHOT
1027: where ESS_ID = X_ESS_ID;
1028:
1029: begin
1030: open c1;

Line 1132: delete from IGS_EN_ST_SNAPSHOT

1128: Before_DML(
1129: p_action => 'DELETE',
1130: x_rowid => X_ROWID
1131: );
1132: delete from IGS_EN_ST_SNAPSHOT
1133: where ROWID = X_ROWID;
1134: if (sql%notfound) then
1135: raise no_data_found;
1136: end if;

Line 1145: end IGS_EN_ST_SNAPSHOT_PKG;

1141: );
1142:
1143: end DELETE_ROW;
1144:
1145: end IGS_EN_ST_SNAPSHOT_PKG;