APPS.IGS_OR_UNIT_LOC_PKG dependencies on IGS_OR_UNIT_LOC

Line 1: package body IGS_OR_UNIT_LOC_PKG AS

1: package body IGS_OR_UNIT_LOC_PKG AS
2: /* $Header: IGSOI13B.pls 115.7 2003/10/30 13:29:48 rghosh ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_OR_UNIT_LOC%RowType;
5: new_references IGS_OR_UNIT_LOC%RowType;

Line 4: old_references IGS_OR_UNIT_LOC%RowType;

1: package body IGS_OR_UNIT_LOC_PKG AS
2: /* $Header: IGSOI13B.pls 115.7 2003/10/30 13:29:48 rghosh ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_OR_UNIT_LOC%RowType;
5: new_references IGS_OR_UNIT_LOC%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_OR_UNIT_LOC%RowType;

1: package body IGS_OR_UNIT_LOC_PKG AS
2: /* $Header: IGSOI13B.pls 115.7 2003/10/30 13:29:48 rghosh ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_OR_UNIT_LOC%RowType;
5: new_references IGS_OR_UNIT_LOC%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 21: FROM IGS_OR_UNIT_LOC

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

Line 55: -- ON IGS_OR_UNIT_LOC

51: END Set_Column_Values;
52: -- Trigger description :-
53: -- "OSS_TST".trg_oul_br_iu
54: -- BEFORE INSERT OR UPDATE
55: -- ON IGS_OR_UNIT_LOC
56: -- FOR EACH ROW
57:
58: PROCEDURE BeforeRowInsertUpdate1(
59: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 117: FROM IGS_OR_UNIT_LOC

113: x_location_cd IN VARCHAR2
114: ) RETURN BOOLEAN AS
115: CURSOR cur_rowid IS
116: SELECT rowid
117: FROM IGS_OR_UNIT_LOC
118: WHERE org_unit_cd = x_org_unit_cd
119: AND start_dt = x_start_dt
120: AND location_cd = x_location_cd
121: FOR UPDATE NOWAIT;

Line 140: FROM IGS_OR_UNIT_LOC

136: x_location_cd IN VARCHAR2
137: ) AS
138: CURSOR cur_rowid IS
139: SELECT rowid
140: FROM IGS_OR_UNIT_LOC
141: WHERE location_cd = x_location_cd ;
142: lv_rowid cur_rowid%RowType;
143: BEGIN
144: Open cur_rowid;

Line 162: FROM IGS_OR_UNIT_LOC

158: x_start_dt IN DATE
159: ) AS
160: CURSOR cur_rowid IS
161: SELECT rowid
162: FROM IGS_OR_UNIT_LOC
163: WHERE org_unit_cd = x_org_unit_cd
164: AND start_dt = x_start_dt ;
165: lv_rowid cur_rowid%RowType;
166: BEGIN

Line 268: cursor C is select ROWID from IGS_OR_UNIT_LOC

264: X_START_DT in DATE,
265: X_LOCATION_CD in VARCHAR2,
266: X_MODE in VARCHAR2 default 'R'
267: ) AS
268: cursor C is select ROWID from IGS_OR_UNIT_LOC
269: where ORG_UNIT_CD = X_ORG_UNIT_CD
270: and START_DT = X_START_DT
271: and LOCATION_CD = X_LOCATION_CD;
272: X_LAST_UPDATE_DATE DATE;

Line 306: insert into IGS_OR_UNIT_LOC (

302: x_last_update_date=>X_LAST_UPDATE_DATE,
303: x_last_updated_by=>X_LAST_UPDATED_BY,
304: x_last_update_login=>X_LAST_UPDATE_LOGIN
305: );
306: insert into IGS_OR_UNIT_LOC (
307: ORG_UNIT_CD,
308: START_DT,
309: LOCATION_CD,
310: CREATION_DATE,

Line 345: from IGS_OR_UNIT_LOC

341: X_START_DT in DATE,
342: X_LOCATION_CD in VARCHAR2
343: ) AS
344: cursor c1 is select rowid
345: from IGS_OR_UNIT_LOC
346: where ROWID = X_ROWID
347: for update nowait ;
348: tlinfo c1%rowtype;
349: begin

Line 370: delete from IGS_OR_UNIT_LOC

366: Before_DML(
367: p_action=>'DELETE',
368: x_rowid=>X_ROWID
369: );
370: delete from IGS_OR_UNIT_LOC
371: where ROWID = X_ROWID ;
372: if (sql%notfound) then
373: raise no_data_found;
374: end if;

Line 416: end IGS_OR_UNIT_LOC_PKG;

412: END IF ;
413:
414: end Check_Constraints ;
415:
416: end IGS_OR_UNIT_LOC_PKG;