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_FLD_STDY_PKG dependencies on IGS_PS_UNIT_FLD_STDY

Line 1: PACKAGE BODY igs_ps_unit_fld_stdy_pkg AS

1: PACKAGE BODY igs_ps_unit_fld_stdy_pkg AS
2: /* $Header: IGSPI0GB.pls 115.7 2003/03/21 07:58:28 sarakshi ship $ */
3: /*************************************************************
4: Created By : kdande@in
5: Date Created By :2000/05/11

Line 14: old_references igs_ps_unit_fld_stdy%RowType;

10:
11: (reverse chronological order - newest change first)
12: ***************************************************************/
13: l_rowid VARCHAR2(25);
14: old_references igs_ps_unit_fld_stdy%RowType;
15: new_references igs_ps_unit_fld_stdy%RowType;
16:
17: PROCEDURE Set_Column_Values (
18: p_action IN VARCHAR2,

Line 15: new_references igs_ps_unit_fld_stdy%RowType;

11: (reverse chronological order - newest change first)
12: ***************************************************************/
13: l_rowid VARCHAR2(25);
14: old_references igs_ps_unit_fld_stdy%RowType;
15: new_references igs_ps_unit_fld_stdy%RowType;
16:
17: PROCEDURE Set_Column_Values (
18: p_action IN VARCHAR2,
19: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 43: FROM IGS_PS_UNIT_FLD_STDY

39: ***************************************************************/
40:
41: CURSOR cur_old_ref_values IS
42: SELECT *
43: FROM IGS_PS_UNIT_FLD_STDY
44: WHERE rowid = x_rowid;
45:
46: BEGIN
47:

Line 149: FROM igs_ps_unit_fld_stdy

145: ***************************************************************/
146:
147: CURSOR cur_rowid IS
148: SELECT rowid
149: FROM igs_ps_unit_fld_stdy
150: WHERE unit_field_of_study_id = x_unit_field_of_study_id
151: FOR UPDATE NOWAIT;
152:
153: lv_rowid cur_rowid%RowType;

Line 186: FROM igs_ps_unit_fld_stdy

182: ***************************************************************/
183:
184: CURSOR cur_rowid IS
185: SELECT rowid
186: FROM igs_ps_unit_fld_stdy
187: WHERE field_of_study = x_field_of_study
188: AND unit_code = x_unit_code
189: AND version_number = x_version_number
190: AND ((l_rowid is null) or (rowid <> l_rowid));

Line 223: FROM igs_ps_unit_fld_stdy

219: ***************************************************************/
220:
221: CURSOR cur_rowid IS
222: SELECT rowid
223: FROM igs_ps_unit_fld_stdy
224: WHERE field_of_study = x_field_of_study;
225:
226: lv_rowid cur_rowid%RowType;
227:

Line 260: FROM igs_ps_unit_fld_stdy

256: ***************************************************************/
257:
258: CURSOR cur_rowid IS
259: SELECT rowid
260: FROM igs_ps_unit_fld_stdy
261: WHERE unit_code = x_unit_cd
262: AND version_number = x_version_number ;
263:
264: lv_rowid cur_rowid%RowType;

Line 409: cursor C is select ROWID from IGS_PS_UNIT_FLD_STDY

405:
406: (reverse chronological order - newest change first)
407: ***************************************************************/
408:
409: cursor C is select ROWID from IGS_PS_UNIT_FLD_STDY
410: where UNIT_FIELD_OF_STUDY_ID= X_UNIT_FIELD_OF_STUDY_ID;
411: X_LAST_UPDATE_DATE DATE ;
412: X_LAST_UPDATED_BY NUMBER ;
413: X_LAST_UPDATE_LOGIN NUMBER ;

Line 433: SELECT igs_ps_unit_fld_stdy_s.nextval

429: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
430: IGS_GE_MSG_STACK.ADD;
431: app_exception.raise_exception;
432: end if;
433: SELECT igs_ps_unit_fld_stdy_s.nextval
434: INTO x_unit_field_of_study_id
435: FROM dual;
436: Before_DML(
437: p_action=>'INSERT',

Line 448: insert into IGS_PS_UNIT_FLD_STDY (

444: x_created_by=>X_LAST_UPDATED_BY,
445: x_last_update_date=>X_LAST_UPDATE_DATE,
446: x_last_updated_by=>X_LAST_UPDATED_BY,
447: x_last_update_login=>X_LAST_UPDATE_LOGIN);
448: insert into IGS_PS_UNIT_FLD_STDY (
449: UNIT_FIELD_OF_STUDY_ID
450: ,UNIT_CODE
451: ,VERSION_NUMBER
452: ,FIELD_OF_STUDY

Line 490: from IGS_PS_UNIT_FLD_STDY

486: cursor c1 is select
487: UNIT_CODE
488: , VERSION_NUMBER
489: , FIELD_OF_STUDY
490: from IGS_PS_UNIT_FLD_STDY
491: where ROWID = X_ROWID
492: for update nowait;
493: tlinfo c1%rowtype;
494: begin

Line 570: update IGS_PS_UNIT_FLD_STDY set

566: x_created_by=>X_LAST_UPDATED_BY,
567: x_last_update_date=>X_LAST_UPDATE_DATE,
568: x_last_updated_by=>X_LAST_UPDATED_BY,
569: x_last_update_login=>X_LAST_UPDATE_LOGIN);
570: update IGS_PS_UNIT_FLD_STDY set
571: UNIT_CODE = NEW_REFERENCES.UNIT_CODE,
572: VERSION_NUMBER = NEW_REFERENCES.VERSION_NUMBER,
573: FIELD_OF_STUDY = NEW_REFERENCES.FIELD_OF_STUDY,
574: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 606: cursor c1 is select ROWID from IGS_PS_UNIT_FLD_STDY

602: Who When What
603:
604: (reverse chronological order - newest change first)
605: ***************************************************************/
606: cursor c1 is select ROWID from IGS_PS_UNIT_FLD_STDY
607: where UNIT_FIELD_OF_STUDY_ID= X_UNIT_FIELD_OF_STUDY_ID ;
608: begin
609: open c1;
610: fetch c1 into X_ROWID;

Line 650: delete from IGS_PS_UNIT_FLD_STDY

646: Before_DML (
647: p_action => 'DELETE',
648: x_rowid => X_ROWID
649: );
650: delete from IGS_PS_UNIT_FLD_STDY
651: where ROWID = X_ROWID;
652: if (sql%notfound) then
653: raise no_data_found;
654: end if;

Line 661: END igs_ps_unit_fld_stdy_pkg;

657: x_rowid => X_ROWID
658: );
659: END DELETE_ROW;
660:
661: END igs_ps_unit_fld_stdy_pkg;