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_REF_CD_PKG dependencies on IGS_PS_UNIT_REF_CD

Line 1: package body IGS_PS_UNIT_REF_CD_PKG as

1: package body IGS_PS_UNIT_REF_CD_PKG as
2: /* $Header: IGSPI88B.pls 115.10 2003/05/09 06:51:56 sarakshi ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_UNIT_REF_CD%RowType;

Line 5: old_references IGS_PS_UNIT_REF_CD%RowType;

1: package body IGS_PS_UNIT_REF_CD_PKG as
2: /* $Header: IGSPI88B.pls 115.10 2003/05/09 06:51:56 sarakshi ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_UNIT_REF_CD%RowType;
6: new_references IGS_PS_UNIT_REF_CD%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PS_UNIT_REF_CD%RowType;

2: /* $Header: IGSPI88B.pls 115.10 2003/05/09 06:51:56 sarakshi ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_UNIT_REF_CD%RowType;
6: new_references IGS_PS_UNIT_REF_CD%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 25: FROM IGS_PS_UNIT_REF_CD

21: ) AS
22:
23: CURSOR cur_old_ref_values IS
24: SELECT *
25: FROM IGS_PS_UNIT_REF_CD
26: WHERE rowid = x_rowid;
27:
28: BEGIN
29:

Line 69: v_unit_cd IGS_PS_UNIT_REF_CD.unit_cd%TYPE;

65: p_inserting IN BOOLEAN DEFAULT FALSE,
66: p_updating IN BOOLEAN DEFAULT FALSE,
67: p_deleting IN BOOLEAN DEFAULT FALSE
68: ) AS
69: v_unit_cd IGS_PS_UNIT_REF_CD.unit_cd%TYPE;
70: v_version_number IGS_PS_UNIT_REF_CD.version_number%TYPE;
71: v_description IGS_PS_UNIT_REF_CD.description%TYPE;
72: v_message_name Varchar2(20);
73: BEGIN

Line 70: v_version_number IGS_PS_UNIT_REF_CD.version_number%TYPE;

66: p_updating IN BOOLEAN DEFAULT FALSE,
67: p_deleting IN BOOLEAN DEFAULT FALSE
68: ) AS
69: v_unit_cd IGS_PS_UNIT_REF_CD.unit_cd%TYPE;
70: v_version_number IGS_PS_UNIT_REF_CD.version_number%TYPE;
71: v_description IGS_PS_UNIT_REF_CD.description%TYPE;
72: v_message_name Varchar2(20);
73: BEGIN
74: -- Set variables.

Line 71: v_description IGS_PS_UNIT_REF_CD.description%TYPE;

67: p_deleting IN BOOLEAN DEFAULT FALSE
68: ) AS
69: v_unit_cd IGS_PS_UNIT_REF_CD.unit_cd%TYPE;
70: v_version_number IGS_PS_UNIT_REF_CD.version_number%TYPE;
71: v_description IGS_PS_UNIT_REF_CD.description%TYPE;
72: v_message_name Varchar2(20);
73: BEGIN
74: -- Set variables.
75: IF p_deleting THEN

Line 205: FROM IGS_PS_UNIT_REF_CD

201: )RETURN BOOLEAN AS
202:
203: CURSOR cur_rowid IS
204: SELECT rowid
205: FROM IGS_PS_UNIT_REF_CD
206: WHERE unit_cd = x_unit_cd
207: AND version_number = x_version_number
208: AND reference_cd_type = x_reference_cd_type
209: AND (l_rowid IS NULL OR rowid <> l_rowid)

Line 311: FROM IGS_PS_UNIT_REF_CD

307: ) RETURN BOOLEAN AS
308:
309: CURSOR cur_rowid IS
310: SELECT rowid
311: FROM IGS_PS_UNIT_REF_CD
312: WHERE unit_cd = x_unit_cd
313: AND version_number = x_version_number
314: AND reference_cd_type = x_reference_cd_type
315: AND reference_cd = x_reference_cd

Line 340: FROM IGS_PS_UNIT_REF_CD

336: ) AS
337:
338: CURSOR cur_rowid IS
339: SELECT rowid
340: FROM IGS_PS_UNIT_REF_CD
341: WHERE reference_cd_type = x_reference_cd_type ;
342:
343: lv_rowid cur_rowid%RowType;
344:

Line 378: FROM igs_ps_unit_ref_cd

374: ***************************************************************/
375:
376: CURSOR cur_rowid IS
377: SELECT ROWID
378: FROM igs_ps_unit_ref_cd
379: WHERE reference_cd_type = x_reference_cd_type
380: AND reference_cd = x_reference_cd ;
381:
382: lv_rowid cur_rowid%ROWTYPE;

Line 407: FROM IGS_PS_UNIT_REF_CD

403: ) AS
404:
405: CURSOR cur_rowid IS
406: SELECT rowid
407: FROM IGS_PS_UNIT_REF_CD
408: WHERE unit_cd = x_unit_cd
409: AND version_number = x_version_number ;
410:
411: lv_rowid cur_rowid%RowType;

Line 522: cursor C is select ROWID from IGS_PS_UNIT_REF_CD

518: X_REFERENCE_CD in VARCHAR2,
519: X_DESCRIPTION in VARCHAR2,
520: X_MODE in VARCHAR2 default 'R'
521: ) AS
522: cursor C is select ROWID from IGS_PS_UNIT_REF_CD
523: where UNIT_CD = X_UNIT_CD
524: and REFERENCE_CD_TYPE = X_REFERENCE_CD_TYPE
525: and VERSION_NUMBER = X_VERSION_NUMBER
526: and REFERENCE_CD = X_REFERENCE_CD;

Line 565: insert into IGS_PS_UNIT_REF_CD (

561: x_last_updated_by => X_LAST_UPDATED_BY,
562: x_last_update_login => X_LAST_UPDATE_LOGIN
563: );
564:
565: insert into IGS_PS_UNIT_REF_CD (
566: UNIT_CD,
567: VERSION_NUMBER,
568: REFERENCE_CD_TYPE,
569: REFERENCE_CD,

Line 614: from IGS_PS_UNIT_REF_CD

610: X_DESCRIPTION in VARCHAR2
611: ) AS
612: cursor c1 is select
613: DESCRIPTION
614: from IGS_PS_UNIT_REF_CD
615: where ROWID = X_ROWID for update nowait;
616: tlinfo c1%rowtype;
617:
618: begin

Line 690: update IGS_PS_UNIT_REF_CD set

686: x_last_updated_by => X_LAST_UPDATED_BY,
687: x_last_update_login => X_LAST_UPDATE_LOGIN
688: );
689:
690: update IGS_PS_UNIT_REF_CD set
691: UNIT_CD = NEW_REFERENCES.UNIT_CD,
692: VERSION_NUMBER = NEW_REFERENCES.VERSION_NUMBER,
693: REFERENCE_CD_TYPE = NEW_REFERENCES.REFERENCE_CD_TYPE,
694: REFERENCE_CD= NEW_REFERENCES.REFERENCE_CD,

Line 719: cursor c1 is select rowid from IGS_PS_UNIT_REF_CD

715: X_REFERENCE_CD in VARCHAR2,
716: X_DESCRIPTION in VARCHAR2,
717: X_MODE in VARCHAR2 default 'R'
718: ) AS
719: cursor c1 is select rowid from IGS_PS_UNIT_REF_CD
720: where UNIT_CD = X_UNIT_CD
721: and REFERENCE_CD_TYPE = X_REFERENCE_CD_TYPE
722: and VERSION_NUMBER = X_VERSION_NUMBER
723: and REFERENCE_CD = X_REFERENCE_CD

Line 759: delete from IGS_PS_UNIT_REF_CD

755: Before_DML (
756: p_action => 'DELETE',
757: x_rowid => X_ROWID
758: );
759: delete from IGS_PS_UNIT_REF_CD
760: where ROWID = X_ROWID
761: ;
762: if (sql%notfound) then
763: raise no_data_found;

Line 772: end IGS_PS_UNIT_REF_CD_PKG;

768: );
769:
770: end DELETE_ROW;
771:
772: end IGS_PS_UNIT_REF_CD_PKG;