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_RU_CALL_RULE_PKG dependencies on IGS_RU_CALL_RULE

Line 1: package body IGS_RU_CALL_RULE_PKG as

1: package body IGS_RU_CALL_RULE_PKG as
2: /* $Header: IGSUI02B.pls 115.7 2002/11/29 04:24:58 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_RU_CALL_RULE%RowType;
5: new_references IGS_RU_CALL_RULE%RowType;

Line 4: old_references IGS_RU_CALL_RULE%RowType;

1: package body IGS_RU_CALL_RULE_PKG as
2: /* $Header: IGSUI02B.pls 115.7 2002/11/29 04:24:58 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_RU_CALL_RULE%RowType;
5: new_references IGS_RU_CALL_RULE%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_RU_CALL_RULE%RowType;

1: package body IGS_RU_CALL_RULE_PKG as
2: /* $Header: IGSUI02B.pls 115.7 2002/11/29 04:24:58 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_RU_CALL_RULE%RowType;
5: new_references IGS_RU_CALL_RULE%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 ,

Line 20: FROM IGS_RU_CALL_RULE

16: x_last_update_login IN NUMBER ) as
17:
18: CURSOR cur_old_ref_values IS
19: SELECT *
20: FROM IGS_RU_CALL_RULE
21: WHERE rowid = x_rowid;
22:
23: BEGIN
24:

Line 34: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_CALL_RULE : P_ACTION INSERT, VALIDATE_INSERT : IGSUI02B.PLS');

30: Fetch cur_old_ref_values INTO old_references;
31: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
32: Close cur_old_ref_values;
33: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
34: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_CALL_RULE : P_ACTION INSERT, VALIDATE_INSERT : IGSUI02B.PLS');
35: IGS_GE_MSG_STACK.ADD;
36: App_Exception.Raise_Exception;
37: Return;
38: END IF;

Line 62: FROM IGS_RU_CALL_RULE

58: x_nr_rul_sequence_number IN NUMBER
59: ) RETURN BOOLEAN AS
60: CURSOR cur_rowid IS
61: SELECT rowid
62: FROM IGS_RU_CALL_RULE
63: WHERE nr_rul_sequence_number = x_nr_rul_sequence_number
64: AND ((l_rowid IS NULL) OR (rowid <> l_rowid))
65: FOR UPDATE NOWAIT;
66:

Line 105: FROM IGS_RU_CALL_RULE

101: )RETURN BOOLEAN as
102:
103: CURSOR cur_rowid IS
104: SELECT rowid
105: FROM IGS_RU_CALL_RULE
106: WHERE called_rule_cd = x_called_rule_cd
107: FOR UPDATE NOWAIT;
108:
109: lv_rowid cur_rowid%RowType;

Line 131: FROM IGS_RU_CALL_RULE

127: ) as
128:
129: CURSOR cur_rowid IS
130: SELECT rowid
131: FROM IGS_RU_CALL_RULE
132: WHERE nr_rul_sequence_number = x_rul_sequence_number ;
133:
134: lv_rowid cur_rowid%RowType;
135:

Line 270: cursor C is select ROWID from IGS_RU_CALL_RULE

266: X_CALLED_RULE_CD in VARCHAR2,
267: X_NR_RUL_SEQUENCE_NUMBER in NUMBER,
268: X_MODE in VARCHAR2
269: ) as
270: cursor C is select ROWID from IGS_RU_CALL_RULE
271: where CALLED_RULE_CD = X_CALLED_RULE_CD;
272: X_LAST_UPDATE_DATE DATE;
273: X_LAST_UPDATED_BY NUMBER;
274: X_LAST_UPDATE_LOGIN NUMBER;

Line 307: insert into IGS_RU_CALL_RULE (

303: x_last_updated_by =>X_LAST_UPDATED_BY,
304: x_last_update_login=> X_LAST_UPDATE_LOGIN
305: );
306:
307: insert into IGS_RU_CALL_RULE (
308: CALLED_RULE_CD,
309: NR_RUL_SEQUENCE_NUMBER,
310: CREATION_DATE,
311: CREATED_BY,

Line 346: from IGS_RU_CALL_RULE

342: X_NR_RUL_SEQUENCE_NUMBER in NUMBER
343: ) as
344: cursor c1 is select
345: NR_RUL_SEQUENCE_NUMBER
346: from IGS_RU_CALL_RULE
347: where ROWID = X_ROWID
348: for update nowait;
349: tlinfo c1%rowtype;
350:

Line 357: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_CALL_RULE : P_ACTION LOCK_ROW : IGSUI02B.PLS');

353: fetch c1 into tlinfo;
354: if (c1%notfound) then
355: close c1;
356: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
357: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_CALL_RULE : P_ACTION LOCK_ROW : IGSUI02B.PLS');
358: IGS_GE_MSG_STACK.ADD;
359: app_exception.raise_exception;
360: return;
361: end if;

Line 369: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_CALL_RULE : P_ACTION LOCK_ROW FORM_RECORD_CHANGED : IGSUI02B.PLS');

365: ) then
366: null;
367: else
368: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
369: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_CALL_RULE : P_ACTION LOCK_ROW FORM_RECORD_CHANGED : IGSUI02B.PLS');
370: IGS_GE_MSG_STACK.ADD;
371: app_exception.raise_exception;
372: end if;
373: return;

Line 417: update IGS_RU_CALL_RULE set

413: x_last_updated_by =>X_LAST_UPDATED_BY,
414: x_last_update_login=> X_LAST_UPDATE_LOGIN
415: );
416:
417: update IGS_RU_CALL_RULE set
418: NR_RUL_SEQUENCE_NUMBER = NEW_REFERENCES.NR_RUL_SEQUENCE_NUMBER,
419: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
420: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
421: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 440: cursor c1 is select rowid from IGS_RU_CALL_RULE

436: X_CALLED_RULE_CD in VARCHAR2,
437: X_NR_RUL_SEQUENCE_NUMBER in NUMBER,
438: X_MODE in VARCHAR2
439: ) as
440: cursor c1 is select rowid from IGS_RU_CALL_RULE
441: where CALLED_RULE_CD = X_CALLED_RULE_CD
442: ;
443: begin
444: open c1;

Line 472: delete from IGS_RU_CALL_RULE

468: p_action => 'DELETE',
469: x_rowid => X_ROWID
470: );
471:
472: delete from IGS_RU_CALL_RULE
473: where ROWID = X_ROWID;
474: if (sql%notfound) then
475: raise no_data_found;
476: end if;

Line 483: end IGS_RU_CALL_RULE_PKG;

479: x_rowid => X_ROWID
480: );
481: end DELETE_ROW;
482:
483: end IGS_RU_CALL_RULE_PKG;