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_DESCRIPTION_PKG dependencies on IGS_RU_DESCRIPTION

Line 1: package body IGS_RU_DESCRIPTION_PKG as

1: package body IGS_RU_DESCRIPTION_PKG as
2: /* $Header: IGSUI03B.pls 115.14 2003/01/29 12:01:40 nshee ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_RU_DESCRIPTION%RowType;

Line 5: old_references IGS_RU_DESCRIPTION%RowType;

1: package body IGS_RU_DESCRIPTION_PKG as
2: /* $Header: IGSUI03B.pls 115.14 2003/01/29 12:01:40 nshee ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_RU_DESCRIPTION%RowType;
6: new_references IGS_RU_DESCRIPTION%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_RU_DESCRIPTION%RowType;

2: /* $Header: IGSUI03B.pls 115.14 2003/01/29 12:01:40 nshee ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_RU_DESCRIPTION%RowType;
6: new_references IGS_RU_DESCRIPTION%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 26: FROM IGS_RU_DESCRIPTION

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

Line 40: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_DESCRIPTION : P_ACTION INSERT, VALIDATE_INSERT : IGSUI03B.PLS');

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

Line 261: IGS_RU_NAMED_RULE_PKG.GET_FK_IGS_RU_DESCRIPTION (

257:
258: PROCEDURE Check_Child_Existance as
259: BEGIN
260:
261: IGS_RU_NAMED_RULE_PKG.GET_FK_IGS_RU_DESCRIPTION (
262: old_references.sequence_number
263: );
264:
265: IGS_RU_GROUP_SET_PKG.GET_FK_IGS_RU_DESCRIPTION (

Line 265: IGS_RU_GROUP_SET_PKG.GET_FK_IGS_RU_DESCRIPTION (

261: IGS_RU_NAMED_RULE_PKG.GET_FK_IGS_RU_DESCRIPTION (
262: old_references.sequence_number
263: );
264:
265: IGS_RU_GROUP_SET_PKG.GET_FK_IGS_RU_DESCRIPTION (
266: old_references.sequence_number
267: );
268:
269: IGS_RU_CALL_PKG.GET_FK_IGS_RU_DESCRIPTION (

Line 269: IGS_RU_CALL_PKG.GET_FK_IGS_RU_DESCRIPTION (

265: IGS_RU_GROUP_SET_PKG.GET_FK_IGS_RU_DESCRIPTION (
266: old_references.sequence_number
267: );
268:
269: IGS_RU_CALL_PKG.GET_FK_IGS_RU_DESCRIPTION (
270: old_references.sequence_number
271: );
272:
273: IGS_RU_TURIN_FNC_PKG.GET_FK_IGS_RU_DESCRIPTION (

Line 273: IGS_RU_TURIN_FNC_PKG.GET_FK_IGS_RU_DESCRIPTION (

269: IGS_RU_CALL_PKG.GET_FK_IGS_RU_DESCRIPTION (
270: old_references.sequence_number
271: );
272:
273: IGS_RU_TURIN_FNC_PKG.GET_FK_IGS_RU_DESCRIPTION (
274: old_references.sequence_number
275: );
276:
277: END Check_Child_Existance;

Line 298: FROM IGS_RU_DESCRIPTION

294: as
295:
296: CURSOR cur_rowid IS
297: SELECT rowid
298: FROM IGS_RU_DESCRIPTION
299: WHERE sequence_number = x_sequence_number
300: FOR UPDATE NOWAIT;
301:
302: lv_rowid cur_rowid%RowType;

Line 327: FROM IGS_RU_DESCRIPTION

323: ) RETURN BOOLEAN as
324:
325: CURSOR cur_rowid IS
326: SELECT rowid
327: FROM IGS_RU_DESCRIPTION
328: WHERE s_return_type = x_s_return_type
329: AND rule_description = x_rule_description
330: AND (l_rowid is null or rowid <> l_rowid)
331: FOR UPDATE NOWAIT;

Line 356: FROM IGS_RU_DESCRIPTION

352: ) as
353:
354: CURSOR cur_rowid IS
355: SELECT rowid
356: FROM IGS_RU_DESCRIPTION
357: WHERE s_return_type = x_s_return_type ;
358:
359: lv_rowid cur_rowid%RowType;
360:

Line 382: FROM IGS_RU_DESCRIPTION

378: ) as
379:
380: CURSOR cur_rowid IS
381: SELECT rowid
382: FROM IGS_RU_DESCRIPTION
383: WHERE s_turin_function = x_s_turin_function ;
384:
385: lv_rowid cur_rowid%RowType;
386:

Line 518: cursor C is select ROWID from IGS_RU_DESCRIPTION

514: -- rnirwani - 15-Mar-02 - 2233951 the cursor has been changed to do a select for update
515: -- so that parallel processing can be prevented.
516: -------------------------------------------------------------------
517: l_sequence_number NUMBER;
518: cursor C is select ROWID from IGS_RU_DESCRIPTION
519: where SEQUENCE_NUMBER = L_SEQUENCE_NUMBER;
520: CURSOR cur_max_plus_one IS
521: SELECT (a.sequence_number + 1) sequence_number
522: FROM igs_ru_description a

Line 522: FROM igs_ru_description a

518: cursor C is select ROWID from IGS_RU_DESCRIPTION
519: where SEQUENCE_NUMBER = L_SEQUENCE_NUMBER;
520: CURSOR cur_max_plus_one IS
521: SELECT (a.sequence_number + 1) sequence_number
522: FROM igs_ru_description a
523: WHERE a.sequence_number = (SELECT MAX(b.sequence_number) FROM igs_ru_description b
524: WHERE b.sequence_number < 499999) FOR UPDATE OF a.sequence_number NOWAIT;
525: X_LAST_UPDATE_DATE DATE;
526: X_LAST_UPDATED_BY NUMBER;

Line 523: WHERE a.sequence_number = (SELECT MAX(b.sequence_number) FROM igs_ru_description b

519: where SEQUENCE_NUMBER = L_SEQUENCE_NUMBER;
520: CURSOR cur_max_plus_one IS
521: SELECT (a.sequence_number + 1) sequence_number
522: FROM igs_ru_description a
523: WHERE a.sequence_number = (SELECT MAX(b.sequence_number) FROM igs_ru_description b
524: WHERE b.sequence_number < 499999) FOR UPDATE OF a.sequence_number NOWAIT;
525: X_LAST_UPDATE_DATE DATE;
526: X_LAST_UPDATED_BY NUMBER;
527: X_LAST_UPDATE_LOGIN NUMBER;

Line 590: insert into IGS_RU_DESCRIPTION (

586: END IF;
587: ELSE
588: l_sequence_number := NEW_REFERENCES.SEQUENCE_NUMBER;
589: END IF;
590: insert into IGS_RU_DESCRIPTION (
591: SEQUENCE_NUMBER,
592: S_RETURN_TYPE,
593: RULE_DESCRIPTION,
594: DESCRIPTION,

Line 645: from IGS_RU_DESCRIPTION

641: RULE_DESCRIPTION,
642: DESCRIPTION,
643: S_TURIN_FUNCTION,
644: PARENTHESIS_IND
645: from IGS_RU_DESCRIPTION
646: where ROWID = X_ROWID for update nowait;
647: tlinfo c1%rowtype;
648:
649: begin

Line 655: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_DESCRIPTION : P_ACTION LOCK_ROW : IGSUI03B.PLS');

651: fetch c1 into tlinfo;
652: if (c1%notfound) then
653: close c1;
654: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
655: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_DESCRIPTION : P_ACTION LOCK_ROW : IGSUI03B.PLS');
656: IGS_GE_MSG_STACK.ADD;
657: app_exception.raise_exception;
658: return;
659: end if;

Line 677: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_DESCRIPTION : P_ACTION LOCK_ROW FORM_RECORD_CHANGED : IGSUI03B.PLS');

673: ) then
674: null;
675: else
676: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
677: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_DESCRIPTION : P_ACTION LOCK_ROW FORM_RECORD_CHANGED : IGSUI03B.PLS');
678: IGS_GE_MSG_STACK.ADD;
679: app_exception.raise_exception;
680: end if;
681: return;

Line 733: update IGS_RU_DESCRIPTION set

729: x_last_updated_by=>X_LAST_UPDATED_BY,
730: x_last_update_login=>X_LAST_UPDATE_LOGIN
731: );
732:
733: update IGS_RU_DESCRIPTION set
734: S_RETURN_TYPE = NEW_REFERENCES.S_RETURN_TYPE,
735: RULE_DESCRIPTION = NEW_REFERENCES.RULE_DESCRIPTION,
736: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
737: S_TURIN_FUNCTION = NEW_REFERENCES.S_TURIN_FUNCTION,

Line 764: cursor c1 is select rowid from IGS_RU_DESCRIPTION

760: X_S_TURIN_FUNCTION in VARCHAR2,
761: X_PARENTHESIS_IND in VARCHAR2,
762: X_MODE in VARCHAR2
763: )as
764: cursor c1 is select rowid from IGS_RU_DESCRIPTION
765: where SEQUENCE_NUMBER = X_SEQUENCE_NUMBER
766: ;
767: begin
768: open c1;

Line 804: delete from IGS_RU_DESCRIPTION

800: Before_DML (
801: p_action => 'DELETE',
802: x_rowid => X_ROWID);
803:
804: delete from IGS_RU_DESCRIPTION
805: where ROWID = X_ROWID;
806: if (sql%notfound) then
807: raise no_data_found;
808: end if;

Line 816: end IGS_RU_DESCRIPTION_PKG;

812: x_rowid => X_ROWID);
813:
814: end DELETE_ROW;
815:
816: end IGS_RU_DESCRIPTION_PKG;