APPS.IGS_PS_UNIT_CAT_PKG dependencies on IGS_PS_UNIT_CAT

Line 1: package body IGS_PS_UNIT_CAT_PKG as

1: package body IGS_PS_UNIT_CAT_PKG as
2: /* $Header: IGSPI74B.pls 115.4 2002/11/29 02:37:01 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PS_UNIT_CAT%RowType;
5: new_references IGS_PS_UNIT_CAT%RowType;

Line 4: old_references IGS_PS_UNIT_CAT%RowType;

1: package body IGS_PS_UNIT_CAT_PKG as
2: /* $Header: IGSPI74B.pls 115.4 2002/11/29 02:37:01 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PS_UNIT_CAT%RowType;
5: new_references IGS_PS_UNIT_CAT%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_PS_UNIT_CAT%RowType;

1: package body IGS_PS_UNIT_CAT_PKG as
2: /* $Header: IGSPI74B.pls 115.4 2002/11/29 02:37:01 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PS_UNIT_CAT%RowType;
5: new_references IGS_PS_UNIT_CAT%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 22: FROM IGS_PS_UNIT_CAT

18: ) AS
19:
20: CURSOR cur_old_ref_values IS
21: SELECT *
22: FROM IGS_PS_UNIT_CAT
23: WHERE rowid = x_rowid;
24:
25: BEGIN
26:

Line 95: IGS_PS_UNIT_CATEGORY_PKG.GET_FK_IGS_PS_UNIT_CAT (

91:
92: PROCEDURE Check_Child_Existance AS
93: BEGIN
94:
95: IGS_PS_UNIT_CATEGORY_PKG.GET_FK_IGS_PS_UNIT_CAT (
96: old_references.unit_cat
97: );
98: IGS_PS_USEC_CATEGORY_PKG.GET_FK_IGS_PS_UNIT_CAT (
99: old_references.unit_cat

Line 98: IGS_PS_USEC_CATEGORY_PKG.GET_FK_IGS_PS_UNIT_CAT (

94:
95: IGS_PS_UNIT_CATEGORY_PKG.GET_FK_IGS_PS_UNIT_CAT (
96: old_references.unit_cat
97: );
98: IGS_PS_USEC_CATEGORY_PKG.GET_FK_IGS_PS_UNIT_CAT (
99: old_references.unit_cat
100: );
101:
102: END Check_Child_Existance;

Line 110: FROM IGS_PS_UNIT_CAT

106: ) RETURN BOOLEAN AS
107:
108: CURSOR cur_rowid IS
109: SELECT rowid
110: FROM IGS_PS_UNIT_CAT
111: WHERE unit_cat = x_unit_cat
112: FOR UPDATE NOWAIT;
113:
114: lv_rowid cur_rowid%RowType;

Line 204: cursor C is select ROWID from IGS_PS_UNIT_CAT

200: X_DESCRIPTION in VARCHAR2,
201: X_CLOSED_IND in VARCHAR2,
202: X_MODE in VARCHAR2 default 'R'
203: ) AS
204: cursor C is select ROWID from IGS_PS_UNIT_CAT
205: where UNIT_CAT = X_UNIT_CAT;
206: X_LAST_UPDATE_DATE DATE;
207: X_LAST_UPDATED_BY NUMBER;
208: X_LAST_UPDATE_LOGIN NUMBER;

Line 242: insert into IGS_PS_UNIT_CAT (

238: x_last_updated_by => X_LAST_UPDATED_BY,
239: x_last_update_login => X_LAST_UPDATE_LOGIN
240: );
241:
242: insert into IGS_PS_UNIT_CAT (
243: UNIT_CAT,
244: DESCRIPTION,
245: CLOSED_IND,
246: CREATION_DATE,

Line 284: from IGS_PS_UNIT_CAT

280: ) AS
281: cursor c1 is select
282: DESCRIPTION,
283: CLOSED_IND
284: from IGS_PS_UNIT_CAT
285: where ROWID = X_ROWID
286: for update nowait;
287: tlinfo c1%rowtype;
288:

Line 354: update IGS_PS_UNIT_CAT set

350: x_last_update_date => X_LAST_UPDATE_DATE,
351: x_last_updated_by => X_LAST_UPDATED_BY,
352: x_last_update_login => X_LAST_UPDATE_LOGIN
353: );
354: update IGS_PS_UNIT_CAT set
355: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
356: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
357: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
358: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 378: cursor c1 is select rowid from IGS_PS_UNIT_CAT

374: X_DESCRIPTION in VARCHAR2,
375: X_CLOSED_IND in VARCHAR2,
376: X_MODE in VARCHAR2 default 'R'
377: ) AS
378: cursor c1 is select rowid from IGS_PS_UNIT_CAT
379: where UNIT_CAT = X_UNIT_CAT
380: ;
381: begin
382: open c1;

Line 411: delete from IGS_PS_UNIT_CAT

407: Before_DML(
408: p_action => 'DELETE',
409: x_rowid => X_ROWID
410: );
411: delete from IGS_PS_UNIT_CAT
412: where ROWID = X_ROWID;
413: if (sql%notfound) then
414: raise no_data_found;
415: end if;

Line 423: end IGS_PS_UNIT_CAT_PKG;

419: x_rowid => X_ROWID
420: );
421: end DELETE_ROW;
422:
423: end IGS_PS_UNIT_CAT_PKG;