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_CROS_REF_PKG dependencies on IGS_PS_UNIT_CROS_REF

Line 1: PACKAGE BODY igs_ps_unit_cros_ref_pkg AS

1: PACKAGE BODY igs_ps_unit_cros_ref_pkg AS
2: /* $Header: IGSPI0CB.pls 115.7 2002/11/29 01:55:29 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_unit_cros_ref%RowType;
5: new_references igs_ps_unit_cros_ref%RowType;

Line 4: old_references igs_ps_unit_cros_ref%RowType;

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

Line 5: new_references igs_ps_unit_cros_ref%RowType;

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

Line 35: FROM IGS_PS_UNIT_CROS_REF

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

Line 185: FROM igs_ps_unit_cros_ref

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

Line 224: FROM igs_ps_unit_cros_ref

220: ***************************************************************/
221:
222: CURSOR cur_rowid IS
223: SELECT rowid
224: FROM igs_ps_unit_cros_ref
225: WHERE child_unit_code = x_child_unit_code
226: AND child_unit_version_number = x_child_unit_version_number
227: AND parent_unit_code = x_parent_unit_code
228: AND parent_unit_version_number = x_parent_unit_version_number and ((l_rowid is null) or (rowid <> l_rowid))

Line 263: FROM igs_ps_unit_cros_ref

259: ***************************************************************/
260:
261: CURSOR cur_rowid IS
262: SELECT rowid
263: FROM igs_ps_unit_cros_ref
264: WHERE (child_unit_code = x_unit_cd
265: AND child_unit_version_number = x_version_number)
266: OR (parent_unit_code = x_unit_cd
267: AND parent_unit_version_number = x_version_number);

Line 420: cursor C is select ROWID from IGS_PS_UNIT_CROS_REF

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

Line 446: SELECT IGS_PS_UNIT_CROS_REF_S.NEXTVAL INTO X_UNIT_CROSS_REFERENCE_ID FROM DUAL;

442: IGS_GE_MSG_STACK.ADD;
443: app_exception.raise_exception;
444: end if;
445:
446: SELECT IGS_PS_UNIT_CROS_REF_S.NEXTVAL INTO X_UNIT_CROSS_REFERENCE_ID FROM DUAL;
447:
448:
449: Before_DML(
450: p_action=>'INSERT',

Line 462: insert into IGS_PS_UNIT_CROS_REF (

458: x_created_by=>X_LAST_UPDATED_BY,
459: x_last_update_date=>X_LAST_UPDATE_DATE,
460: x_last_updated_by=>X_LAST_UPDATED_BY,
461: x_last_update_login=>X_LAST_UPDATE_LOGIN);
462: insert into IGS_PS_UNIT_CROS_REF (
463: UNIT_CROSS_REFERENCE_ID
464: ,PARENT_UNIT_CODE
465: ,PARENT_UNIT_VERSION_NUMBER
466: ,CHILD_UNIT_CODE

Line 519: from IGS_PS_UNIT_CROS_REF

515: PARENT_UNIT_CODE
516: , PARENT_UNIT_VERSION_NUMBER
517: , CHILD_UNIT_CODE
518: , CHILD_UNIT_VERSION_NUMBER
519: from IGS_PS_UNIT_CROS_REF
520: where ROWID = X_ROWID
521: for update nowait;
522: tlinfo c1%rowtype;
523: begin

Line 602: update IGS_PS_UNIT_CROS_REF set

598: x_created_by=>X_LAST_UPDATED_BY,
599: x_last_update_date=>X_LAST_UPDATE_DATE,
600: x_last_updated_by=>X_LAST_UPDATED_BY,
601: x_last_update_login=>X_LAST_UPDATE_LOGIN);
602: update IGS_PS_UNIT_CROS_REF set
603: PARENT_UNIT_CODE = NEW_REFERENCES.PARENT_UNIT_CODE,
604: PARENT_UNIT_VERSION_NUMBER = NEW_REFERENCES.PARENT_UNIT_VERSION_NUMBER,
605: CHILD_UNIT_CODE = NEW_REFERENCES.CHILD_UNIT_CODE,
606: CHILD_UNIT_VERSION_NUMBER = NEW_REFERENCES.CHILD_UNIT_VERSION_NUMBER,

Line 640: cursor c1 is select ROWID from IGS_PS_UNIT_CROS_REF

636:
637: (reverse chronological order - newest change first)
638: ***************************************************************/
639:
640: cursor c1 is select ROWID from IGS_PS_UNIT_CROS_REF
641: where UNIT_CROSS_REFERENCE_ID= X_UNIT_CROSS_REFERENCE_ID
642: ;
643: begin
644: open c1;

Line 687: delete from IGS_PS_UNIT_CROS_REF

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

Line 697: END igs_ps_unit_cros_ref_pkg;

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