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_REF_PKG dependencies on IGS_PS_USEC_REF

Line 1: PACKAGE BODY igs_ps_usec_ref_pkg AS

1: PACKAGE BODY igs_ps_usec_ref_pkg AS
2: /* $Header: IGSPI1GB.pls 115.11 2003/01/10 11:23:46 smvk ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_usec_ref%RowType;
5: new_references igs_ps_usec_ref%RowType;

Line 4: old_references igs_ps_usec_ref%RowType;

1: PACKAGE BODY igs_ps_usec_ref_pkg AS
2: /* $Header: IGSPI1GB.pls 115.11 2003/01/10 11:23:46 smvk ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_usec_ref%RowType;
5: new_references igs_ps_usec_ref%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_ps_usec_ref%RowType;

1: PACKAGE BODY igs_ps_usec_ref_pkg AS
2: /* $Header: IGSPI1GB.pls 115.11 2003/01/10 11:23:46 smvk ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_usec_ref%RowType;
5: new_references igs_ps_usec_ref%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 61: FROM IGS_PS_USEC_REF

57: ***************************************************************/
58:
59: CURSOR cur_old_ref_values IS
60: SELECT *
61: FROM IGS_PS_USEC_REF
62: WHERE rowid = x_rowid;
63:
64: BEGIN
65:

Line 240: Igs_Ps_Usec_Ref_Cd_Pkg.Get_FK_Igs_Ps_Usec_Ref (

236: ***************************************************************/
237:
238: BEGIN
239:
240: Igs_Ps_Usec_Ref_Cd_Pkg.Get_FK_Igs_Ps_Usec_Ref (
241: old_references.unit_section_reference_id
242: );
243:
244: igs_ps_us_req_ref_cd_pkg.Get_FK_Igs_Ps_Usec_Ref (

Line 244: igs_ps_us_req_ref_cd_pkg.Get_FK_Igs_Ps_Usec_Ref (

240: Igs_Ps_Usec_Ref_Cd_Pkg.Get_FK_Igs_Ps_Usec_Ref (
241: old_references.unit_section_reference_id
242: );
243:
244: igs_ps_us_req_ref_cd_pkg.Get_FK_Igs_Ps_Usec_Ref (
245: old_references.unit_section_reference_id
246: );
247:
248: END Check_Child_Existance;

Line 267: FROM igs_ps_usec_ref

263: ***************************************************************/
264:
265: CURSOR cur_rowid IS
266: SELECT rowid
267: FROM igs_ps_usec_ref
268: WHERE unit_section_reference_id = x_unit_section_reference_id
269: FOR UPDATE NOWAIT;
270:
271: lv_rowid cur_rowid%RowType;

Line 303: FROM igs_ps_usec_ref

299: ***************************************************************/
300:
301: CURSOR cur_rowid IS
302: SELECT rowid
303: FROM igs_ps_usec_ref
304: WHERE uoo_id = x_uoo_id and ((l_rowid is null) or (rowid <> l_rowid))
305:
306: ;
307: lv_rowid cur_rowid%RowType;

Line 338: FROM igs_ps_usec_ref

334: ***************************************************************/
335:
336: CURSOR cur_rowid IS
337: SELECT rowid
338: FROM igs_ps_usec_ref
339: WHERE uoo_id = x_uoo_id ;
340:
341: lv_rowid cur_rowid%RowType;
342:

Line 572: cursor C is select ROWID from IGS_PS_USEC_REF

568:
569: (reverse chronological order - newest change first)
570: ***************************************************************/
571:
572: cursor C is select ROWID from IGS_PS_USEC_REF
573: where UNIT_SECTION_REFERENCE_ID= X_UNIT_SECTION_REFERENCE_ID
574: ;
575: X_LAST_UPDATE_DATE DATE ;
576: X_LAST_UPDATED_BY NUMBER ;

Line 597: SELECT IGS_PS_USEC_REF_S.nextval

593: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
594: IGS_GE_MSG_STACK.ADD;
595: app_exception.raise_exception;
596: end if;
597: SELECT IGS_PS_USEC_REF_S.nextval
598: INTO x_unit_section_reference_id
599: FROM dual;
600: Before_DML(
601: p_action=>'INSERT',

Line 639: insert into IGS_PS_USEC_REF (

635: x_created_by=>X_LAST_UPDATED_BY,
636: x_last_update_date=>X_LAST_UPDATE_DATE,
637: x_last_updated_by=>X_LAST_UPDATED_BY,
638: x_last_update_login=>X_LAST_UPDATE_LOGIN);
639: insert into IGS_PS_USEC_REF (
640: UNIT_SECTION_REFERENCE_ID
641: ,UOO_ID
642: ,SHORT_TITLE
643: ,SUBTITLE_MODIFIABLE_FLAG

Line 794: from IGS_PS_USEC_REF

790: , ATTRIBUTE20
791: , RECORD_EXCLUSION_FLAG
792: , TITLE
793: , SUBTITLE_ID
794: from IGS_PS_USEC_REF
795: where ROWID = X_ROWID
796: for update nowait;
797: tlinfo c1%rowtype;
798: begin

Line 1007: update IGS_PS_USEC_REF set

1003: x_created_by=>X_LAST_UPDATED_BY,
1004: x_last_update_date=>X_LAST_UPDATE_DATE,
1005: x_last_updated_by=>X_LAST_UPDATED_BY,
1006: x_last_update_login=>X_LAST_UPDATE_LOGIN);
1007: update IGS_PS_USEC_REF set
1008: UOO_ID = NEW_REFERENCES.UOO_ID,
1009: SHORT_TITLE = NEW_REFERENCES.SHORT_TITLE,
1010: SUBTITLE_MODIFIABLE_FLAG = NEW_REFERENCES.SUBTITLE_MODIFIABLE_FLAG,
1011: CLASS_SCHEDULE_EXCLUSION_FLAG = NEW_REFERENCES.CLASS_SCHEDULE_EXCLUSION_FLAG,

Line 1095: cursor c1 is select ROWID from IGS_PS_USEC_REF

1091:
1092: (reverse chronological order - newest change first)
1093: ***************************************************************/
1094:
1095: cursor c1 is select ROWID from IGS_PS_USEC_REF
1096: where UNIT_SECTION_REFERENCE_ID= X_UNIT_SECTION_REFERENCE_ID
1097: ;
1098: begin
1099: open c1;

Line 1194: delete from IGS_PS_USEC_REF

1190: Before_DML (
1191: p_action => 'DELETE',
1192: x_rowid => X_ROWID
1193: );
1194: delete from IGS_PS_USEC_REF
1195: where ROWID = X_ROWID;
1196: if (sql%notfound) then
1197: raise no_data_found;
1198: end if;

Line 1204: END igs_ps_usec_ref_pkg;

1200: p_action => 'DELETE',
1201: x_rowid => X_ROWID
1202: );
1203: end DELETE_ROW;
1204: END igs_ps_usec_ref_pkg;