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_NAMED_RULE_PKG dependencies on IGS_RU_NAMED_RULE

Line 1: package body IGS_RU_NAMED_RULE_PKG as

1: package body IGS_RU_NAMED_RULE_PKG as
2: /* $Header: IGSUI09B.pls 115.9 2003/01/06 07:59:40 nshee ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_RU_NAMED_RULE%RowType;

Line 5: old_references IGS_RU_NAMED_RULE%RowType;

1: package body IGS_RU_NAMED_RULE_PKG as
2: /* $Header: IGSUI09B.pls 115.9 2003/01/06 07:59:40 nshee ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_RU_NAMED_RULE%RowType;
6: new_references IGS_RU_NAMED_RULE%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_RU_NAMED_RULE%RowType;

2: /* $Header: IGSUI09B.pls 115.9 2003/01/06 07:59:40 nshee ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_RU_NAMED_RULE%RowType;
6: new_references IGS_RU_NAMED_RULE%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 25: FROM IGS_RU_NAMED_RULE

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

Line 38: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_NAMED_RULE : P_ACTION INSERT VALIDATE_INSERT : IGSUI09B.PLS');

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

Line 184: IGS_RU_ITEM_PKG.GET_FK_IGS_RU_NAMED_RULE (

180:
181: PROCEDURE Check_Child_Existance IS
182: BEGIN
183:
184: IGS_RU_ITEM_PKG.GET_FK_IGS_RU_NAMED_RULE (
185: old_references.rul_sequence_number
186: );
187:
188: IGS_RU_CALL_RULE_PKG.GET_FK_IGS_RU_NAMED_RULE (

Line 188: IGS_RU_CALL_RULE_PKG.GET_FK_IGS_RU_NAMED_RULE (

184: IGS_RU_ITEM_PKG.GET_FK_IGS_RU_NAMED_RULE (
185: old_references.rul_sequence_number
186: );
187:
188: IGS_RU_CALL_RULE_PKG.GET_FK_IGS_RU_NAMED_RULE (
189: old_references.rul_sequence_number
190: );
191:
192: IGS_RU_CALL_PKG.GET_FK_IGS_RU_NAMED_RULE (

Line 192: IGS_RU_CALL_PKG.GET_FK_IGS_RU_NAMED_RULE (

188: IGS_RU_CALL_RULE_PKG.GET_FK_IGS_RU_NAMED_RULE (
189: old_references.rul_sequence_number
190: );
191:
192: IGS_RU_CALL_PKG.GET_FK_IGS_RU_NAMED_RULE (
193: old_references.rul_sequence_number
194: );
195:
196: END Check_Child_Existance;

Line 204: FROM IGS_RU_NAMED_RULE

200: ) RETURN BOOLEAN
201: IS
202: CURSOR cur_rowid IS
203: SELECT rowid
204: FROM IGS_RU_NAMED_RULE
205: WHERE rul_sequence_number = x_rul_sequence_number
206: FOR UPDATE NOWAIT;
207:
208: lv_rowid cur_rowid%RowType;

Line 230: FROM IGS_RU_NAMED_RULE

226: ) IS
227:
228: CURSOR cur_rowid IS
229: SELECT rowid
230: FROM IGS_RU_NAMED_RULE
231: WHERE rud_sequence_number = x_sequence_number ;
232:
233: lv_rowid cur_rowid%RowType;
234:

Line 256: FROM IGS_RU_NAMED_RULE

252: ) IS
253:
254: CURSOR cur_rowid IS
255: SELECT rowid
256: FROM IGS_RU_NAMED_RULE
257: WHERE rug_sequence_number = x_sequence_number ;
258:
259: lv_rowid cur_rowid%RowType;
260:

Line 282: FROM IGS_RU_NAMED_RULE

278: ) IS
279:
280: CURSOR cur_rowid IS
281: SELECT rowid
282: FROM IGS_RU_NAMED_RULE
283: WHERE rul_sequence_number = x_sequence_number
284: OR message_rule = x_sequence_number ;
285:
286: lv_rowid cur_rowid%RowType;

Line 386: cursor C is select ROWID from IGS_RU_NAMED_RULE

382: X_RUG_SEQUENCE_NUMBER in NUMBER,
383: X_RULE_TEXT in VARCHAR2,
384: X_MODE in VARCHAR2
385: ) is
386: cursor C is select ROWID from IGS_RU_NAMED_RULE
387: where RUL_SEQUENCE_NUMBER = X_RUL_SEQUENCE_NUMBER;
388: X_LAST_UPDATE_DATE DATE;
389: X_LAST_UPDATED_BY NUMBER;
390: X_LAST_UPDATE_LOGIN NUMBER;

Line 427: insert into IGS_RU_NAMED_RULE (

423: x_last_updated_by=>X_LAST_UPDATED_BY,
424: x_last_update_login=>X_LAST_UPDATE_LOGIN
425: );
426:
427: insert into IGS_RU_NAMED_RULE (
428: RUL_SEQUENCE_NUMBER,
429: RUD_SEQUENCE_NUMBER,
430: MESSAGE_RULE,
431: RUG_SEQUENCE_NUMBER,

Line 478: from IGS_RU_NAMED_RULE

474: RUD_SEQUENCE_NUMBER,
475: MESSAGE_RULE,
476: RUG_SEQUENCE_NUMBER,
477: RULE_TEXT
478: from IGS_RU_NAMED_RULE
479: where ROWID = X_ROWID for update nowait;
480: tlinfo c1%rowtype;
481:
482: begin

Line 487: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_NAMED_RULE : P_ACTION LOCK_ROW message_rule : IGSUI09B.PLS');

483: open c1;
484: fetch c1 into tlinfo;
485: if (c1%notfound) then
486: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
487: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_NAMED_RULE : P_ACTION LOCK_ROW message_rule : IGSUI09B.PLS');
488: IGS_GE_MSG_STACK.ADD;
489: app_exception.raise_exception;
490: close c1;
491: return;

Line 507: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_NAMED_RULE : P_ACTION LOCK_ROW FORM_RECORD_CHANGED : IGSUI09B.PLS');

503: ) then
504: null;
505: else
506: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
507: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_NAMED_RULE : P_ACTION LOCK_ROW FORM_RECORD_CHANGED : IGSUI09B.PLS');
508: IGS_GE_MSG_STACK.ADD;
509: app_exception.raise_exception;
510: end if;
511: return;

Line 562: update IGS_RU_NAMED_RULE set

558: x_last_updated_by=>X_LAST_UPDATED_BY,
559: x_last_update_login=>X_LAST_UPDATE_LOGIN
560: );
561:
562: update IGS_RU_NAMED_RULE set
563: RUD_SEQUENCE_NUMBER = NEW_REFERENCES.RUD_SEQUENCE_NUMBER,
564: MESSAGE_RULE = NEW_REFERENCES.MESSAGE_RULE,
565: RUG_SEQUENCE_NUMBER = NEW_REFERENCES.RUG_SEQUENCE_NUMBER,
566: RULE_TEXT = NEW_REFERENCES.RULE_TEXT,

Line 592: cursor c1 is select rowid from IGS_RU_NAMED_RULE

588: X_RUG_SEQUENCE_NUMBER in NUMBER,
589: X_RULE_TEXT in VARCHAR2,
590: X_MODE in VARCHAR2
591: ) is
592: cursor c1 is select rowid from IGS_RU_NAMED_RULE
593: where RUL_SEQUENCE_NUMBER = X_RUL_SEQUENCE_NUMBER
594: ;
595: begin
596: open c1;

Line 630: delete from IGS_RU_NAMED_RULE

626: Before_DML (
627: p_action => 'DELETE',
628: x_rowid => X_ROWID);
629:
630: delete from IGS_RU_NAMED_RULE
631: where ROWID = X_ROWID;
632: if (sql%notfound) then
633: raise no_data_found;
634: end if;

Line 642: end IGS_RU_NAMED_RULE_PKG;

638: x_rowid => X_ROWID);
639:
640: end DELETE_ROW;
641:
642: end IGS_RU_NAMED_RULE_PKG;