APPS.IGS_PS_UNIT_CATEGORY_PKG dependencies on IGS_PS_UNIT_CATEGORY_ALL

Line 4: old_references IGS_PS_UNIT_CATEGORY_ALL%RowType;

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

Line 5: new_references IGS_PS_UNIT_CATEGORY_ALL%RowType;

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

Line 23: FROM IGS_PS_UNIT_CATEGORY_ALL

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

Line 66: v_unit_cd IGS_PS_UNIT_CATEGORY_ALL.unit_cd%TYPE;

62: p_inserting IN BOOLEAN DEFAULT FALSE,
63: p_updating IN BOOLEAN DEFAULT FALSE,
64: p_deleting IN BOOLEAN DEFAULT FALSE
65: ) AS
66: v_unit_cd IGS_PS_UNIT_CATEGORY_ALL.unit_cd%TYPE;
67: v_version_number IGS_PS_UNIT_CATEGORY_ALL.version_number%TYPE;
68: v_message_name VARCHAR2(30);
69: BEGIN
70: -- Set variables.

Line 67: v_version_number IGS_PS_UNIT_CATEGORY_ALL.version_number%TYPE;

63: p_updating IN BOOLEAN DEFAULT FALSE,
64: p_deleting IN BOOLEAN DEFAULT FALSE
65: ) AS
66: v_unit_cd IGS_PS_UNIT_CATEGORY_ALL.unit_cd%TYPE;
67: v_version_number IGS_PS_UNIT_CATEGORY_ALL.version_number%TYPE;
68: v_message_name VARCHAR2(30);
69: BEGIN
70: -- Set variables.
71: IF p_deleting THEN

Line 175: FROM IGS_PS_UNIT_CATEGORY_ALL

171: ) RETURN BOOLEAN AS
172:
173: CURSOR cur_rowid IS
174: SELECT rowid
175: FROM IGS_PS_UNIT_CATEGORY_ALL
176: WHERE unit_cd = x_unit_cd
177: AND version_number = x_version_number
178: AND unit_cat = x_unit_cat
179: FOR UPDATE NOWAIT;

Line 203: FROM IGS_PS_UNIT_CATEGORY_ALL

199: ) AS
200:
201: CURSOR cur_rowid IS
202: SELECT rowid
203: FROM IGS_PS_UNIT_CATEGORY_ALL
204: WHERE unit_cat = x_unit_cat ;
205:
206: lv_rowid cur_rowid%RowType;
207:

Line 230: FROM IGS_PS_UNIT_CATEGORY_ALL

226: ) AS
227:
228: CURSOR cur_rowid IS
229: SELECT rowid
230: FROM IGS_PS_UNIT_CATEGORY_ALL
231: WHERE unit_cd = x_unit_cd
232: AND version_number = x_version_number ;
233:
234: lv_rowid cur_rowid%RowType;

Line 336: cursor C is select ROWID from IGS_PS_UNIT_CATEGORY_ALL

332: X_UNIT_CAT in VARCHAR2,
333: X_MODE in VARCHAR2 default 'R',
334: x_ORG_ID in NUMBER
335: ) AS
336: cursor C is select ROWID from IGS_PS_UNIT_CATEGORY_ALL
337: where UNIT_CD = X_UNIT_CD
338: and VERSION_NUMBER = X_VERSION_NUMBER
339: and UNIT_CAT = X_UNIT_CAT;
340: X_LAST_UPDATE_DATE DATE;

Line 376: insert into IGS_PS_UNIT_CATEGORY_ALL (

372: x_last_update_login => X_LAST_UPDATE_LOGIN,
373: x_org_id => igs_ge_gen_003.get_org_id
374: );
375:
376: insert into IGS_PS_UNIT_CATEGORY_ALL (
377: UNIT_CD,
378: VERSION_NUMBER,
379: UNIT_CAT,
380: CREATION_DATE,

Line 420: from IGS_PS_UNIT_CATEGORY_ALL

416: X_UNIT_CAT in VARCHAR2
417:
418: ) AS
419: cursor c1 is select ROWID
420: from IGS_PS_UNIT_CATEGORY_ALL
421: where ROWID = X_ROWID
422: for update nowait;
423: tlinfo c1%rowtype;
424:

Line 448: delete from IGS_PS_UNIT_CATEGORY_ALL

444: Before_DML (
445: p_action => 'DELETE',
446: x_rowid => X_ROWID
447: );
448: delete from IGS_PS_UNIT_CATEGORY_ALL
449: where ROWID = X_ROWID;
450: if (sql%notfound) then
451: raise no_data_found;
452: end if;