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_OR_UNIT_REL_PKG dependencies on IGS_OR_UNIT_REL

Line 1: package body IGS_OR_UNIT_REL_PKG AS

1: package body IGS_OR_UNIT_REL_PKG AS
2: /* $Header: IGSOI14B.pls 115.9 2003/03/27 06:41:35 kpadiyar ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_OR_UNIT_REL%RowType;
5: new_references IGS_OR_UNIT_REL%RowType;

Line 4: old_references IGS_OR_UNIT_REL%RowType;

1: package body IGS_OR_UNIT_REL_PKG AS
2: /* $Header: IGSOI14B.pls 115.9 2003/03/27 06:41:35 kpadiyar ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_OR_UNIT_REL%RowType;
5: new_references IGS_OR_UNIT_REL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_OR_UNIT_REL%RowType;

1: package body IGS_OR_UNIT_REL_PKG AS
2: /* $Header: IGSOI14B.pls 115.9 2003/03/27 06:41:35 kpadiyar ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_OR_UNIT_REL%RowType;
5: new_references IGS_OR_UNIT_REL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 24: FROM IGS_OR_UNIT_REL

20: x_last_update_login IN NUMBER DEFAULT NULL
21: ) AS
22: CURSOR cur_old_ref_values IS
23: SELECT *
24: FROM IGS_OR_UNIT_REL
25: WHERE rowid = x_rowid;
26: BEGIN
27: l_rowid := x_rowid;
28: -- Code for setting the Old and New Reference Values.

Line 62: -- ON IGS_OR_UNIT_REL

58: END Set_Column_Values;
59: -- Trigger description :-
60: -- "OSS_TST".trg_our_ar_i
61: -- AFTER INSERT
62: -- ON IGS_OR_UNIT_REL
63: -- FOR EACH ROW
64:
65: PROCEDURE BeforeRowInsert1(
66: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 73: FROM IGS_OR_UNIT_REL

69: ) AS
70: v_message_name VARCHAR2(30);
71: CURSOR c_exists IS
72: SELECT 'Y'
73: FROM IGS_OR_UNIT_REL
74: WHERE parent_org_unit_cd = new_references.parent_org_unit_cd
75: AND child_org_unit_cd = new_references.child_org_unit_cd
76: AND logical_delete_dt IS NULL;
77: l_exists VARCHAR(1) := 'N';

Line 118: -- ON IGS_OR_UNIT_REL

114: END AfterRowInsert1;
115: -- Trigger description :-
116: -- "OSS_TST".trg_our_as_i
117: -- AFTER INSERT
118: -- ON IGS_OR_UNIT_REL
119:
120: PROCEDURE Check_Parent_Existance AS
121: BEGIN
122: IF (((old_references.child_org_unit_cd = new_references.child_org_unit_cd) AND

Line 157: IGS_OR_REL_PS_TYPE_PKG.GET_FK_IGS_OR_UNIT_REL (

153: END Check_Parent_Existance;
154:
155: PROCEDURE Check_Child_Existance AS
156: BEGIN
157: IGS_OR_REL_PS_TYPE_PKG.GET_FK_IGS_OR_UNIT_REL (
158: old_references.parent_org_unit_cd,
159: old_references.parent_start_dt,
160: old_references.child_org_unit_cd,
161: old_references.child_start_dt,

Line 191: FROM IGS_OR_UNIT_REL

187: x_create_dt IN DATE
188: ) RETURN BOOLEAN AS
189: CURSOR cur_rowid IS
190: SELECT rowid
191: FROM IGS_OR_UNIT_REL
192: WHERE parent_org_unit_cd = x_parent_org_unit_cd
193: AND parent_start_dt = x_parent_start_dt
194: AND child_org_unit_cd = x_child_org_unit_cd
195: AND child_start_dt = x_child_start_dt

Line 217: FROM IGS_OR_UNIT_REL

213: x_start_dt IN DATE
214: ) AS
215: CURSOR cur_rowid IS
216: SELECT rowid
217: FROM IGS_OR_UNIT_REL
218: WHERE ( (child_org_unit_cd = x_org_unit_cd AND child_start_dt = x_start_dt)
219: OR (parent_org_unit_cd = x_org_unit_cd AND parent_start_dt = x_start_dt)) ;
220: lv_rowid cur_rowid%RowType;
221: BEGIN

Line 314: cursor C is select ROWID from IGS_OR_UNIT_REL

310: X_CREATE_DT in out NOCOPY DATE,
311: X_LOGICAL_DELETE_DT in DATE,
312: X_MODE in VARCHAR2 default 'R'
313: ) AS
314: cursor C is select ROWID from IGS_OR_UNIT_REL
315: where PARENT_ORG_UNIT_CD = X_PARENT_ORG_UNIT_CD
316: and PARENT_START_DT = X_PARENT_START_DT
317: and CHILD_ORG_UNIT_CD = X_CHILD_ORG_UNIT_CD
318: and CHILD_START_DT = X_CHILD_START_DT

Line 357: insert into IGS_OR_UNIT_REL (

353: x_last_update_date=>X_LAST_UPDATE_DATE,
354: x_last_updated_by=>X_LAST_UPDATED_BY,
355: x_last_update_login=>X_LAST_UPDATE_LOGIN
356: );
357: insert into IGS_OR_UNIT_REL (
358: PARENT_ORG_UNIT_CD,
359: PARENT_START_DT,
360: CHILD_ORG_UNIT_CD,
361: CHILD_START_DT,

Line 406: from IGS_OR_UNIT_REL

402: X_LOGICAL_DELETE_DT in DATE
403: ) AS
404: cursor c1 is select
405: LOGICAL_DELETE_DT
406: from IGS_OR_UNIT_REL
407: where ROWID = X_ROWID
408: for update nowait ;
409: tlinfo c1%rowtype;
410: begin

Line 479: update IGS_OR_UNIT_REL set

475: x_last_update_date=>X_LAST_UPDATE_DATE,
476: x_last_updated_by=>X_LAST_UPDATED_BY,
477: x_last_update_login=>X_LAST_UPDATE_LOGIN
478: );
479: update IGS_OR_UNIT_REL set
480: LOGICAL_DELETE_DT = NEW_REFERENCES.LOGICAL_DELETE_DT,
481: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
482: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
483: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 504: cursor c1 is select rowid from IGS_OR_UNIT_REL

500: X_CREATE_DT in out NOCOPY DATE,
501: X_LOGICAL_DELETE_DT in DATE,
502: X_MODE in VARCHAR2 default 'R'
503: ) AS
504: cursor c1 is select rowid from IGS_OR_UNIT_REL
505: where PARENT_ORG_UNIT_CD = X_PARENT_ORG_UNIT_CD
506: and PARENT_START_DT = X_PARENT_START_DT
507: and CHILD_ORG_UNIT_CD = X_CHILD_ORG_UNIT_CD
508: and CHILD_START_DT = X_CHILD_START_DT

Line 547: delete from IGS_OR_UNIT_REL

543: Before_DML(
544: p_action=>'DELETE',
545: x_rowid=>X_ROWID
546: );
547: delete from IGS_OR_UNIT_REL
548: where ROWID = X_ROWID ;
549: if (sql%notfound) then
550: raise no_data_found;
551: end if;

Line 581: end IGS_OR_UNIT_REL_PKG;

577: END IF ;
578:
579: END Check_Constraints ;
580:
581: end IGS_OR_UNIT_REL_PKG;