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_USEC_GRD_SCHM_PKG dependencies on IGS_PS_USEC_GRD_SCHM

Line 1: PACKAGE BODY igs_ps_usec_grd_schm_pkg AS

1: PACKAGE BODY igs_ps_usec_grd_schm_pkg AS
2: /* $Header: IGSPI0NB.pls 120.0 2005/06/01 22:09:49 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_usec_grd_schm%RowType;
5: new_references igs_ps_usec_grd_schm%RowType;

Line 4: old_references igs_ps_usec_grd_schm%RowType;

1: PACKAGE BODY igs_ps_usec_grd_schm_pkg AS
2: /* $Header: IGSPI0NB.pls 120.0 2005/06/01 22:09:49 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_usec_grd_schm%RowType;
5: new_references igs_ps_usec_grd_schm%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_ps_usec_grd_schm%RowType;

1: PACKAGE BODY igs_ps_usec_grd_schm_pkg AS
2: /* $Header: IGSPI0NB.pls 120.0 2005/06/01 22:09:49 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_usec_grd_schm%RowType;
5: new_references igs_ps_usec_grd_schm%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2,

Line 35: FROM IGS_PS_USEC_GRD_SCHM

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

Line 175: IGS_EN_SU_ATTEMPT_PKG.GET_UFK_IGS_PS_USEC_GRD_SCHM ( old_references.grading_schema_code,

171:
172: PROCEDURE Check_Child_Existance
173: AS
174: BEGIN
175: IGS_EN_SU_ATTEMPT_PKG.GET_UFK_IGS_PS_USEC_GRD_SCHM ( old_references.grading_schema_code,
176: old_references.grd_schm_version_number,
177: old_references.uoo_id
178: );
179:

Line 199: FROM igs_ps_usec_grd_schm

195: ***************************************************************/
196:
197: CURSOR cur_rowid IS
198: SELECT rowid
199: FROM igs_ps_usec_grd_schm
200: WHERE unit_section_grading_schema_id = x_unit_section_grad_schema_id
201: FOR UPDATE NOWAIT;
202:
203: lv_rowid cur_rowid%RowType;

Line 237: FROM igs_ps_usec_grd_schm

233: ***************************************************************/
234:
235: CURSOR cur_rowid IS
236: SELECT rowid
237: FROM igs_ps_usec_grd_schm
238: WHERE grading_schema_code = x_grading_schema_code
239: AND grd_schm_version_number = x_grd_schm_version_number
240: AND uoo_id = x_uoo_id and ((l_rowid is null) or (rowid <> l_rowid))
241:

Line 276: FROM igs_ps_usec_grd_schm

272: ***************************************************************/
273:
274: CURSOR cur_rowid IS
275: SELECT rowid
276: FROM igs_ps_usec_grd_schm
277: WHERE grading_schema_code = x_grading_schema_cd
278: AND grd_schm_version_number = x_version_number ;
279:
280: lv_rowid cur_rowid%RowType;

Line 314: FROM igs_ps_usec_grd_schm

310: ***************************************************************/
311:
312: CURSOR cur_rowid IS
313: SELECT rowid
314: FROM igs_ps_usec_grd_schm
315: WHERE uoo_id = x_uoo_id ;
316:
317: lv_rowid cur_rowid%RowType;
318:

Line 468: cursor C is select ROWID from IGS_PS_USEC_GRD_SCHM

464:
465: (reverse chronological order - newest change first)
466: ***************************************************************/
467:
468: cursor C is select ROWID from IGS_PS_USEC_GRD_SCHM
469: where UNIT_SECTION_GRADING_SCHEMA_ID= X_UNIT_SECTION_GRAD_SCHEMA_ID
470: ;
471: X_LAST_UPDATE_DATE DATE ;
472: X_LAST_UPDATED_BY NUMBER ;

Line 493: SELECT IGS_PS_USEC_GRD_SCHM_S.nextval into X_UNIT_SECTION_GRAD_SCHEMA_ID from dual;

489: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
490: IGS_GE_MSG_STACK.ADD;
491: app_exception.raise_exception;
492: end if;
493: SELECT IGS_PS_USEC_GRD_SCHM_S.nextval into X_UNIT_SECTION_GRAD_SCHEMA_ID from dual;
494:
495: Before_DML(
496: p_action=>'INSERT',
497: x_rowid=>X_ROWID,

Line 508: insert into IGS_PS_USEC_GRD_SCHM (

504: x_created_by=>X_LAST_UPDATED_BY,
505: x_last_update_date=>X_LAST_UPDATE_DATE,
506: x_last_updated_by=>X_LAST_UPDATED_BY,
507: x_last_update_login=>X_LAST_UPDATE_LOGIN);
508: insert into IGS_PS_USEC_GRD_SCHM (
509: UNIT_SECTION_GRADING_SCHEMA_ID
510: ,UOO_ID
511: ,GRADING_SCHEMA_CODE
512: ,GRD_SCHM_VERSION_NUMBER

Line 567: from IGS_PS_USEC_GRD_SCHM

563: UOO_ID
564: , GRADING_SCHEMA_CODE
565: , GRD_SCHM_VERSION_NUMBER
566: , DEFAULT_FLAG
567: from IGS_PS_USEC_GRD_SCHM
568: where ROWID = X_ROWID
569: for update nowait;
570: tlinfo c1%rowtype;
571: begin

Line 652: update IGS_PS_USEC_GRD_SCHM set

648: x_created_by=>X_LAST_UPDATED_BY,
649: x_last_update_date=>X_LAST_UPDATE_DATE,
650: x_last_updated_by=>X_LAST_UPDATED_BY,
651: x_last_update_login=>X_LAST_UPDATE_LOGIN);
652: update IGS_PS_USEC_GRD_SCHM set
653: UOO_ID = NEW_REFERENCES.UOO_ID,
654: GRADING_SCHEMA_CODE = NEW_REFERENCES.GRADING_SCHEMA_CODE,
655: GRD_SCHM_VERSION_NUMBER = NEW_REFERENCES.GRD_SCHM_VERSION_NUMBER,
656: DEFAULT_FLAG = NEW_REFERENCES.DEFAULT_FLAG,

Line 692: cursor c1 is select ROWID from IGS_PS_USEC_GRD_SCHM

688:
689: (reverse chronological order - newest change first)
690: ***************************************************************/
691:
692: cursor c1 is select ROWID from IGS_PS_USEC_GRD_SCHM
693: where UNIT_SECTION_GRADING_SCHEMA_ID= X_UNIT_SECTION_GRAD_SCHEMA_ID
694: ;
695: BEGIN
696: open c1;

Line 740: delete from IGS_PS_USEC_GRD_SCHM

736: Before_DML (
737: p_action => 'DELETE',
738: x_rowid => X_ROWID
739: );
740: delete from IGS_PS_USEC_GRD_SCHM
741: where ROWID = X_ROWID;
742: if (sql%notfound) then
743: raise no_data_found;
744: end if;

Line 751: END igs_ps_usec_grd_schm_pkg;

747: x_rowid => X_ROWID
748: );
749: END DELETE_ROW;
750:
751: END igs_ps_usec_grd_schm_pkg;