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.

APPS.IGS_PS_UNIT_GRD_SCHM_PKG dependencies on IGS_PS_UNIT_GRD_SCHM

Line 1: PACKAGE BODY igs_ps_unit_grd_schm_pkg AS

1: PACKAGE BODY igs_ps_unit_grd_schm_pkg AS
2: /* $Header: IGSPI99B.pls 115.12 2002/11/29 02:44:02 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_unit_grd_schm%RowType;
5: new_references igs_ps_unit_grd_schm%RowType;

Line 4: old_references igs_ps_unit_grd_schm%RowType;

1: PACKAGE BODY igs_ps_unit_grd_schm_pkg AS
2: /* $Header: IGSPI99B.pls 115.12 2002/11/29 02:44:02 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_unit_grd_schm%RowType;
5: new_references igs_ps_unit_grd_schm%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_ps_unit_grd_schm%RowType;

1: PACKAGE BODY igs_ps_unit_grd_schm_pkg AS
2: /* $Header: IGSPI99B.pls 115.12 2002/11/29 02:44:02 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_unit_grd_schm%RowType;
5: new_references igs_ps_unit_grd_schm%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 ,

Line 36: FROM IGS_PS_UNIT_GRD_SCHM

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

Line 181: IGS_EN_SU_ATTEMPT_PKG.GET_UFK_IGS_PS_UNIT_GRD_SCHM (old_references.unit_version_number,

177:
178: PROCEDURE Check_Child_Existance
179: AS
180: BEGIN
181: IGS_EN_SU_ATTEMPT_PKG.GET_UFK_IGS_PS_UNIT_GRD_SCHM (old_references.unit_version_number,
182: old_references.grading_schema_code,
183: old_references.grd_schm_version_number,
184: old_references.unit_code
185: ) ;

Line 208: FROM igs_ps_unit_grd_schm

204: ***************************************************************/
205:
206: CURSOR cur_rowid IS
207: SELECT rowid
208: FROM igs_ps_unit_grd_schm
209: WHERE unit_grading_schema_id = x_unit_grading_schema_id
210: FOR UPDATE NOWAIT;
211:
212: lv_rowid cur_rowid%RowType;

Line 247: FROM igs_ps_unit_grd_schm

243: ***************************************************************/
244:
245: CURSOR cur_rowid IS
246: SELECT rowid
247: FROM igs_ps_unit_grd_schm
248: WHERE unit_version_number = x_unit_version_number
249: AND grading_schema_code = x_grading_schema_code
250: AND grd_schm_version_number = x_grd_schm_version_number
251: AND unit_code = x_unit_code and ((l_rowid is null) or (rowid <> l_rowid))

Line 286: FROM igs_ps_unit_grd_schm

282: ***************************************************************/
283:
284: CURSOR cur_rowid IS
285: SELECT rowid
286: FROM igs_ps_unit_grd_schm
287: WHERE unit_code = x_unit_cd
288: AND unit_version_number = x_version_number ;
289:
290: lv_rowid cur_rowid%RowType;

Line 325: FROM igs_ps_unit_grd_schm

321: ***************************************************************/
322:
323: CURSOR cur_rowid IS
324: SELECT rowid
325: FROM igs_ps_unit_grd_schm
326: WHERE grading_schema_code = x_grading_schema_cd
327: AND grd_schm_version_number = x_version_number ;
328:
329: lv_rowid cur_rowid%RowType;

Line 482: cursor C is select ROWID from IGS_PS_UNIT_GRD_SCHM

478:
479: (reverse chronological order - newest change first)
480: ***************************************************************/
481:
482: cursor C is select ROWID from IGS_PS_UNIT_GRD_SCHM
483: where UNIT_GRADING_SCHEMA_ID= X_UNIT_GRADING_SCHEMA_ID
484: ;
485: X_LAST_UPDATE_DATE DATE ;
486: X_LAST_UPDATED_BY NUMBER ;

Line 507: select igs_ps_unit_grd_schm_s.nextval

503: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
504: IGS_GE_MSG_STACK.ADD;
505: app_exception.raise_exception;
506: end if;
507: select igs_ps_unit_grd_schm_s.nextval
508: into x_unit_grading_schema_id
509: from dual;
510: Before_DML(
511: p_action=>'INSERT',

Line 524: insert into IGS_PS_UNIT_GRD_SCHM (

520: x_created_by=>X_LAST_UPDATED_BY,
521: x_last_update_date=>X_LAST_UPDATE_DATE,
522: x_last_updated_by=>X_LAST_UPDATED_BY,
523: x_last_update_login=>X_LAST_UPDATE_LOGIN);
524: insert into IGS_PS_UNIT_GRD_SCHM (
525: UNIT_GRADING_SCHEMA_ID
526: ,UNIT_CODE
527: ,UNIT_VERSION_NUMBER
528: ,GRADING_SCHEMA_CODE

Line 585: from IGS_PS_UNIT_GRD_SCHM

581: , UNIT_VERSION_NUMBER
582: , GRADING_SCHEMA_CODE
583: , GRD_SCHM_VERSION_NUMBER
584: , DEFAULT_FLAG
585: from IGS_PS_UNIT_GRD_SCHM
586: where ROWID = X_ROWID
587: for update nowait;
588: tlinfo c1%rowtype;
589: begin

Line 671: update IGS_PS_UNIT_GRD_SCHM set

667: x_created_by=>X_LAST_UPDATED_BY,
668: x_last_update_date=>X_LAST_UPDATE_DATE,
669: x_last_updated_by=>X_LAST_UPDATED_BY,
670: x_last_update_login=>X_LAST_UPDATE_LOGIN);
671: update IGS_PS_UNIT_GRD_SCHM set
672: UNIT_CODE = NEW_REFERENCES.UNIT_CODE,
673: UNIT_VERSION_NUMBER = NEW_REFERENCES.UNIT_VERSION_NUMBER,
674: GRADING_SCHEMA_CODE = NEW_REFERENCES.GRADING_SCHEMA_CODE,
675: GRD_SCHM_VERSION_NUMBER = NEW_REFERENCES.GRD_SCHM_VERSION_NUMBER,

Line 711: cursor c1 is select ROWID from IGS_PS_UNIT_GRD_SCHM

707:
708: (reverse chronological order - newest change first)
709: ***************************************************************/
710:
711: cursor c1 is select ROWID from IGS_PS_UNIT_GRD_SCHM
712: where UNIT_GRADING_SCHEMA_ID= X_UNIT_GRADING_SCHEMA_ID
713: ;
714: begin
715: open c1;

Line 761: delete from IGS_PS_UNIT_GRD_SCHM

757: Before_DML (
758: p_action => 'DELETE',
759: x_rowid => X_ROWID
760: );
761: delete from IGS_PS_UNIT_GRD_SCHM
762: where ROWID = X_ROWID;
763: if (sql%notfound) then
764: raise no_data_found;
765: end if;

Line 774: END igs_ps_unit_grd_schm_pkg;

770: END DELETE_ROW;
771:
772:
773:
774: END igs_ps_unit_grd_schm_pkg;