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_UNT_REPT_FMLY_PKG dependencies on IGS_PS_UNT_REPT_FMLY

Line 1: PACKAGE BODY igs_ps_unt_rept_fmly_pkg AS

1: PACKAGE BODY igs_ps_unt_rept_fmly_pkg AS
2: /* $Header: IGSPI0AB.pls 115.7 2002/11/29 01:54:52 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_unt_rept_fmly%RowType;
5: new_references igs_ps_unt_rept_fmly%RowType;

Line 4: old_references igs_ps_unt_rept_fmly%RowType;

1: PACKAGE BODY igs_ps_unt_rept_fmly_pkg AS
2: /* $Header: IGSPI0AB.pls 115.7 2002/11/29 01:54:52 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_unt_rept_fmly%RowType;
5: new_references igs_ps_unt_rept_fmly%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_ps_unt_rept_fmly%RowType;

1: PACKAGE BODY igs_ps_unt_rept_fmly_pkg AS
2: /* $Header: IGSPI0AB.pls 115.7 2002/11/29 01:54:52 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_unt_rept_fmly%RowType;
5: new_references igs_ps_unt_rept_fmly%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 35: FROM IGS_PS_UNT_REPT_FMLY

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

Line 185: FROM igs_ps_unt_rept_fmly

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

Line 224: FROM igs_ps_unt_rept_fmly

220: ***************************************************************/
221:
222: CURSOR cur_rowid IS
223: SELECT rowid
224: FROM igs_ps_unt_rept_fmly
225: WHERE repeat_fmly_unit_code = x_repeat_fmly_unit_code
226: AND repeat_fmly_unit_version_num = x_repeat_fmly_unit_version_num
227: AND unit_code = x_unit_code
228: AND unit_version_number = x_unit_version_number and ((l_rowid is null) or (rowid <> l_rowid))

Line 263: FROM igs_ps_unt_rept_fmly

259: ***************************************************************/
260:
261: CURSOR cur_rowid IS
262: SELECT rowid
263: FROM igs_ps_unt_rept_fmly
264: WHERE (unit_code = x_unit_cd
265: AND unit_version_number = x_version_number)
266: OR (repeat_fmly_unit_code = x_unit_cd
267: AND repeat_fmly_unit_version_num = x_version_number);

Line 420: cursor C is select ROWID from IGS_PS_UNT_REPT_FMLY

416:
417: (reverse chronological order - newest change first)
418: ***************************************************************/
419:
420: cursor C is select ROWID from IGS_PS_UNT_REPT_FMLY
421: where UNIT_REPEAT_FAMILY_ID= X_UNIT_REPEAT_FAMILY_ID
422: ;
423: X_LAST_UPDATE_DATE DATE ;
424: X_LAST_UPDATED_BY NUMBER ;

Line 445: SELECT IGS_PS_UNT_REPT_FMLY_S.NEXTVAL

441: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
442: IGS_GE_MSG_STACK.ADD;
443: app_exception.raise_exception;
444: end if;
445: SELECT IGS_PS_UNT_REPT_FMLY_S.NEXTVAL
446: INTO X_UNIT_REPEAT_FAMILY_ID
447: FROM dual;
448: Before_DML(
449: p_action=>'INSERT',

Line 461: insert into IGS_PS_UNT_REPT_FMLY (

457: x_created_by=>X_LAST_UPDATED_BY,
458: x_last_update_date=>X_LAST_UPDATE_DATE,
459: x_last_updated_by=>X_LAST_UPDATED_BY,
460: x_last_update_login=>X_LAST_UPDATE_LOGIN);
461: insert into IGS_PS_UNT_REPT_FMLY (
462: UNIT_REPEAT_FAMILY_ID
463: ,UNIT_CODE
464: ,UNIT_VERSION_NUMBER
465: ,REPEAT_FMLY_UNIT_CODE

Line 518: from IGS_PS_UNT_REPT_FMLY

514: UNIT_CODE
515: , UNIT_VERSION_NUMBER
516: , REPEAT_FMLY_UNIT_CODE
517: , REPEAT_FMLY_UNIT_VERSION_NUM
518: from IGS_PS_UNT_REPT_FMLY
519: where ROWID = X_ROWID
520: for update nowait;
521: tlinfo c1%rowtype;
522: begin

Line 601: update IGS_PS_UNT_REPT_FMLY set

597: x_created_by=>X_LAST_UPDATED_BY,
598: x_last_update_date=>X_LAST_UPDATE_DATE,
599: x_last_updated_by=>X_LAST_UPDATED_BY,
600: x_last_update_login=>X_LAST_UPDATE_LOGIN);
601: update IGS_PS_UNT_REPT_FMLY set
602: UNIT_CODE = NEW_REFERENCES.UNIT_CODE,
603: UNIT_VERSION_NUMBER = NEW_REFERENCES.UNIT_VERSION_NUMBER,
604: REPEAT_FMLY_UNIT_CODE = NEW_REFERENCES.REPEAT_FMLY_UNIT_CODE,
605: REPEAT_FMLY_UNIT_VERSION_NUM = NEW_REFERENCES.REPEAT_FMLY_UNIT_VERSION_NUM,

Line 639: cursor c1 is select ROWID from IGS_PS_UNT_REPT_FMLY

635:
636: (reverse chronological order - newest change first)
637: ***************************************************************/
638:
639: cursor c1 is select ROWID from IGS_PS_UNT_REPT_FMLY
640: where UNIT_REPEAT_FAMILY_ID= X_UNIT_REPEAT_FAMILY_ID
641: ;
642: begin
643: open c1;

Line 686: delete from IGS_PS_UNT_REPT_FMLY

682: Before_DML (
683: p_action => 'DELETE',
684: x_rowid => X_ROWID
685: );
686: delete from IGS_PS_UNT_REPT_FMLY
687: where ROWID = X_ROWID;
688: if (sql%notfound) then
689: raise no_data_found;
690: end if;

Line 696: END igs_ps_unt_rept_fmly_pkg;

692: p_action => 'DELETE',
693: x_rowid => X_ROWID
694: );
695: end DELETE_ROW;
696: END igs_ps_unt_rept_fmly_pkg;