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_PRV_GRAD_PKG dependencies on IGS_PS_USEC_PRV_GRAD

Line 1: PACKAGE BODY igs_ps_usec_prv_grad_pkg AS

1: PACKAGE BODY igs_ps_usec_prv_grad_pkg AS
2: /* $Header: IGSPI0JB.pls 115.8 2002/11/29 01:57:23 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_usec_prv_grad%RowType;
5: new_references igs_ps_usec_prv_grad%RowType;

Line 4: old_references igs_ps_usec_prv_grad%RowType;

1: PACKAGE BODY igs_ps_usec_prv_grad_pkg AS
2: /* $Header: IGSPI0JB.pls 115.8 2002/11/29 01:57:23 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_usec_prv_grad%RowType;
5: new_references igs_ps_usec_prv_grad%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_ps_usec_prv_grad%RowType;

1: PACKAGE BODY igs_ps_usec_prv_grad_pkg AS
2: /* $Header: IGSPI0JB.pls 115.8 2002/11/29 01:57:23 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_usec_prv_grad%RowType;
5: new_references igs_ps_usec_prv_grad%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 35: FROM IGS_PS_USEC_PRV_GRAD

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

Line 185: FROM igs_ps_usec_prv_grad

181: ***************************************************************/
182:
183: CURSOR cur_rowid IS
184: SELECT rowid
185: FROM igs_ps_usec_prv_grad
186: WHERE unit_section_prev_grade_id = x_unit_section_prev_grade_id
187: FOR UPDATE NOWAIT;
188:
189: lv_rowid cur_rowid%RowType;

Line 224: FROM igs_ps_usec_prv_grad

220: ***************************************************************/
221:
222: CURSOR cur_rowid IS
223: SELECT rowid
224: FROM igs_ps_usec_prv_grad
225: WHERE grading_schema_value = x_grading_schema_value
226: AND grading_schema_version_number = x_grad_schema_version_number
227: AND uoo_id = x_uoo_id
228: AND grading_schema_code = x_grading_schema_code and ((l_rowid is null) or (rowid <> l_rowid))

Line 262: FROM igs_ps_usec_prv_grad

258: ***************************************************************/
259:
260: CURSOR cur_rowid IS
261: SELECT rowid
262: FROM igs_ps_usec_prv_grad
263: WHERE uoo_id = x_uoo_id ;
264:
265: lv_rowid cur_rowid%RowType;
266:

Line 301: FROM igs_ps_usec_prv_grad

297: ***************************************************************/
298:
299: CURSOR cur_rowid IS
300: SELECT rowid
301: FROM igs_ps_usec_prv_grad
302: WHERE grading_schema_code = x_grading_schema_cd
303: AND grading_schema_version_number = x_version_number
304: AND grading_schema_value = x_grade ;
305:

Line 457: cursor C is select ROWID from IGS_PS_USEC_PRV_GRAD

453:
454: (reverse chronological order - newest change first)
455: ***************************************************************/
456:
457: cursor C is select ROWID from IGS_PS_USEC_PRV_GRAD
458: where UNIT_SECTION_PREV_GRADE_ID= X_UNIT_SECTION_PREV_GRADE_ID
459: ;
460: X_LAST_UPDATE_DATE DATE ;
461: X_LAST_UPDATED_BY NUMBER ;

Line 482: select igs_ps_usec_prv_grad_s.nextval into x_unit_section_prev_grade_id from dual;

478: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
479: IGS_GE_MSG_STACK.ADD;
480: app_exception.raise_exception;
481: end if;
482: select igs_ps_usec_prv_grad_s.nextval into x_unit_section_prev_grade_id from dual;
483: Before_DML(
484: p_action=>'INSERT',
485: x_rowid=>X_ROWID,
486: x_unit_section_prev_grade_id=>X_UNIT_SECTION_PREV_GRADE_ID,

Line 496: insert into IGS_PS_USEC_PRV_GRAD (

492: x_created_by=>X_LAST_UPDATED_BY,
493: x_last_update_date=>X_LAST_UPDATE_DATE,
494: x_last_updated_by=>X_LAST_UPDATED_BY,
495: x_last_update_login=>X_LAST_UPDATE_LOGIN);
496: insert into IGS_PS_USEC_PRV_GRAD (
497: UNIT_SECTION_PREV_GRADE_ID
498: ,UOO_ID
499: ,GRADING_SCHEMA_CODE
500: ,GRADING_SCHEMA_VERSION_NUMBER

Line 553: from IGS_PS_USEC_PRV_GRAD

549: UOO_ID
550: , GRADING_SCHEMA_CODE
551: , GRADING_SCHEMA_VERSION_NUMBER
552: , GRADING_SCHEMA_VALUE
553: from IGS_PS_USEC_PRV_GRAD
554: where ROWID = X_ROWID
555: for update nowait;
556: tlinfo c1%rowtype;
557: begin

Line 636: update IGS_PS_USEC_PRV_GRAD set

632: x_created_by=>X_LAST_UPDATED_BY,
633: x_last_update_date=>X_LAST_UPDATE_DATE,
634: x_last_updated_by=>X_LAST_UPDATED_BY,
635: x_last_update_login=>X_LAST_UPDATE_LOGIN);
636: update IGS_PS_USEC_PRV_GRAD set
637: UOO_ID = NEW_REFERENCES.UOO_ID,
638: GRADING_SCHEMA_CODE = NEW_REFERENCES.GRADING_SCHEMA_CODE,
639: GRADING_SCHEMA_VERSION_NUMBER = NEW_REFERENCES.GRADING_SCHEMA_VERSION_NUMBER,
640: GRADING_SCHEMA_VALUE = NEW_REFERENCES.GRADING_SCHEMA_VALUE,

Line 674: cursor c1 is select ROWID from IGS_PS_USEC_PRV_GRAD

670:
671: (reverse chronological order - newest change first)
672: ***************************************************************/
673:
674: cursor c1 is select ROWID from IGS_PS_USEC_PRV_GRAD
675: where UNIT_SECTION_PREV_GRADE_ID= X_UNIT_SECTION_PREV_GRADE_ID
676: ;
677: begin
678: open c1;

Line 721: delete from IGS_PS_USEC_PRV_GRAD

717: Before_DML (
718: p_action => 'DELETE',
719: x_rowid => X_ROWID
720: );
721: delete from IGS_PS_USEC_PRV_GRAD
722: where ROWID = X_ROWID;
723: if (sql%notfound) then
724: raise no_data_found;
725: end if;

Line 731: END igs_ps_usec_prv_grad_pkg;

727: p_action => 'DELETE',
728: x_rowid => X_ROWID
729: );
730: end DELETE_ROW;
731: END igs_ps_usec_prv_grad_pkg;