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.

[Home] [Help]

APPS.IGS_RU_GROUP_ITEM_PKG dependencies on IGS_RU_GROUP_ITEM

Line 1: package body IGS_RU_GROUP_ITEM_PKG as

1: package body IGS_RU_GROUP_ITEM_PKG as
2: /* $Header: IGSUI05B.pls 115.7 2002/11/29 04:25:59 nsidana ship $ */
3:
4:
5: l_rowid VARCHAR2(25);

Line 6: old_references IGS_RU_GROUP_ITEM%RowType;

2: /* $Header: IGSUI05B.pls 115.7 2002/11/29 04:25:59 nsidana ship $ */
3:
4:
5: l_rowid VARCHAR2(25);
6: old_references IGS_RU_GROUP_ITEM%RowType;
7: new_references IGS_RU_GROUP_ITEM%RowType;
8:
9: PROCEDURE Set_Column_Values (
10: p_action IN VARCHAR2,

Line 7: new_references IGS_RU_GROUP_ITEM%RowType;

3:
4:
5: l_rowid VARCHAR2(25);
6: old_references IGS_RU_GROUP_ITEM%RowType;
7: new_references IGS_RU_GROUP_ITEM%RowType;
8:
9: PROCEDURE Set_Column_Values (
10: p_action IN VARCHAR2,
11: x_rowid IN VARCHAR2 ,

Line 24: FROM IGS_RU_GROUP_ITEM

20: ) as
21:
22: CURSOR cur_old_ref_values IS
23: SELECT *
24: FROM IGS_RU_GROUP_ITEM
25: WHERE rowid = x_rowid;
26:
27: BEGIN
28:

Line 37: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_GROUP_ITEM : P_ACTION INSERT VALIDATE_INSERT : IGSUI05B.PLS');

33: Open cur_old_ref_values;
34: Fetch cur_old_ref_values INTO old_references;
35: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
36: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
37: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_GROUP_ITEM : P_ACTION INSERT VALIDATE_INSERT : IGSUI05B.PLS');
38: IGS_GE_MSG_STACK.ADD;
39: App_Exception.Raise_Exception;
40: Close cur_old_ref_values;
41: Return;

Line 65: -- ON IGS_RU_GROUP_ITEM

61:
62: -- Trigger description :-
63: -- "OSS_TST".trg_rgi_br_iud
64: -- BEFORE INSERT OR DELETE OR UPDATE
65: -- ON IGS_RU_GROUP_ITEM
66: -- FOR EACH ROW
67:
68: PROCEDURE BeforeRowInsertUpdateDelete1(
69: p_inserting IN BOOLEAN ,

Line 101: -- ON IGS_RU_GROUP_ITEM

97:
98: -- Trigger description :-
99: -- "OSS_TST".trg_rgi_as_iud
100: -- AFTER INSERT OR DELETE OR UPDATE
101: -- ON IGS_RU_GROUP_ITEM
102:
103: PROCEDURE AfterStmtInsertUpdateDelete2(
104: p_inserting IN BOOLEAN ,
105: p_updating IN BOOLEAN ,

Line 118: -- populate IGS_RU_GROUP_SET, trigger ancestor groups in IGS_RU_GROUP_ITEM

114: Fnd_Message.Set_Name('IGS',v_message_name);
115: IGS_GE_MSG_STACK.ADD;
116: App_Exception.Raise_Exception;
117: END IF;
118: -- populate IGS_RU_GROUP_SET, trigger ancestor groups in IGS_RU_GROUP_ITEM
119: IGS_RU_VAL_RGI.rulp_ins_rgi;
120:
121:
122: END AfterStmtInsertUpdateDelete2;

Line 201: FROM IGS_RU_GROUP_ITEM

197: as
198:
199: CURSOR cur_rowid IS
200: SELECT rowid
201: FROM IGS_RU_GROUP_ITEM
202: WHERE rug_sequence_number = x_rug_sequence_number
203: AND description_number = x_description_number
204: AND description_type = x_description_type
205: FOR UPDATE NOWAIT;

Line 229: FROM IGS_RU_GROUP_ITEM

225: ) as
226:
227: CURSOR cur_rowid IS
228: SELECT rowid
229: FROM IGS_RU_GROUP_ITEM
230: WHERE rug_sequence_number = x_sequence_number ;
231:
232: lv_rowid cur_rowid%RowType;
233:

Line 342: cursor C is select ROWID from IGS_RU_GROUP_ITEM

338: X_DESCRIPTION_NUMBER in NUMBER,
339: X_DESCRIPTION_TYPE in VARCHAR2,
340: X_MODE in VARCHAR2
341: ) as
342: cursor C is select ROWID from IGS_RU_GROUP_ITEM
343: where RUG_SEQUENCE_NUMBER = X_RUG_SEQUENCE_NUMBER
344: and DESCRIPTION_NUMBER = X_DESCRIPTION_NUMBER
345: and DESCRIPTION_TYPE = X_DESCRIPTION_TYPE;
346: X_LAST_UPDATE_DATE DATE;

Line 381: insert into IGS_RU_GROUP_ITEM (

377: x_last_update_date=>X_LAST_UPDATE_DATE,
378: x_last_updated_by=>X_LAST_UPDATED_BY,
379: x_last_update_login=>X_LAST_UPDATE_LOGIN
380: );
381: insert into IGS_RU_GROUP_ITEM (
382: RUG_SEQUENCE_NUMBER,
383: DESCRIPTION_NUMBER,
384: DESCRIPTION_TYPE,
385: CREATION_DATE,

Line 422: from IGS_RU_GROUP_ITEM

418: X_DESCRIPTION_NUMBER in NUMBER,
419: X_DESCRIPTION_TYPE in VARCHAR2
420: ) as
421: cursor c1 is select ROWID
422: from IGS_RU_GROUP_ITEM
423: where ROWID = X_ROWID for update nowait;
424: tlinfo c1%rowtype;
425:
426: begin

Line 431: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_GROUP_ITEM : P_ACTION LOCK_ROW : IGSUI05B.PLS');

427: open c1;
428: fetch c1 into tlinfo;
429: if (c1%notfound) then
430: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
431: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_GROUP_ITEM : P_ACTION LOCK_ROW : IGSUI05B.PLS');
432: IGS_GE_MSG_STACK.ADD;
433: app_exception.raise_exception;
434: close c1;
435: return;

Line 484: update IGS_RU_GROUP_ITEM set

480: x_last_updated_by=>X_LAST_UPDATED_BY,
481: x_last_update_login=>X_LAST_UPDATE_LOGIN
482: );
483:
484: update IGS_RU_GROUP_ITEM set
485: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
486: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
487: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
488: where ROWID = X_ROWID;

Line 508: delete from IGS_RU_GROUP_ITEM

504: Before_DML (
505: p_action => 'DELETE',
506: x_rowid => X_ROWID);
507:
508: delete from IGS_RU_GROUP_ITEM
509: where ROWID = X_ROWID;
510: if (sql%notfound) then
511: raise no_data_found;
512: end if;

Line 520: end IGS_RU_GROUP_ITEM_PKG;

516: x_rowid => X_ROWID);
517:
518: end DELETE_ROW;
519:
520: end IGS_RU_GROUP_ITEM_PKG;