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_NAMED_RULE_GR_PKG dependencies on IGS_RU_NAMED_RULE_GR

Line 1: PACKAGE BODY igs_ru_named_rule_gr_pkg AS

1: PACKAGE BODY igs_ru_named_rule_gr_pkg AS
2: /* $Header: IGSUI17B.pls 115.10 2002/11/29 04:29:29 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ru_named_rule_gr%RowType;
5: new_references igs_ru_named_rule_gr%RowType;

Line 4: old_references igs_ru_named_rule_gr%RowType;

1: PACKAGE BODY igs_ru_named_rule_gr_pkg AS
2: /* $Header: IGSUI17B.pls 115.10 2002/11/29 04:29:29 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ru_named_rule_gr%RowType;
5: new_references igs_ru_named_rule_gr%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_ru_named_rule_gr%RowType;

1: PACKAGE BODY igs_ru_named_rule_gr_pkg AS
2: /* $Header: IGSUI17B.pls 115.10 2002/11/29 04:29:29 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ru_named_rule_gr%RowType;
5: new_references igs_ru_named_rule_gr%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 ,

Line 37: FROM IGS_RU_NAMED_RULE_GR

33: ***************************************************************/
34:
35: CURSOR cur_old_ref_values IS
36: SELECT *
37: FROM IGS_RU_NAMED_RULE_GR
38: WHERE rowid = x_rowid;
39:
40: BEGIN
41:

Line 51: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_NAMED_RULE_GR : P_ACTION INSERT, VALIDATE_INSERT : IGSUI17B.PLS');

47: Fetch cur_old_ref_values INTO old_references;
48: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
49: Close cur_old_ref_values;
50: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
51: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_NAMED_RULE_GR : P_ACTION INSERT, VALIDATE_INSERT : IGSUI17B.PLS');
52: IGS_GE_MSG_STACK.ADD;
53: App_Exception.Raise_Exception;
54: Return;
55: END IF;

Line 239: FROM igs_ru_named_rule_gr

235: ***************************************************************/
236:
237: CURSOR cur_rowid IS
238: SELECT rowid
239: FROM igs_ru_named_rule_gr
240: WHERE group_cd = x_group_cd
241: AND name_cd = x_name_cd
242: FOR UPDATE NOWAIT;
243:

Line 276: FROM igs_ru_named_rule_gr

272: ***************************************************************/
273:
274: CURSOR cur_rowid IS
275: SELECT rowid
276: FROM igs_ru_named_rule_gr
277: WHERE s_return_type = x_s_return_type ;
278:
279: lv_rowid cur_rowid%RowType;
280:

Line 313: FROM igs_ru_named_rule_gr

309: ***************************************************************/
310:
311: CURSOR cur_rowid IS
312: SELECT rowid
313: FROM igs_ru_named_rule_gr
314: WHERE group_cd = x_group_cd ;
315:
316: lv_rowid cur_rowid%RowType;
317:

Line 350: FROM igs_ru_named_rule_gr

346: ***************************************************************/
347:
348: CURSOR cur_rowid IS
349: SELECT rowid
350: FROM igs_ru_named_rule_gr
351: WHERE message_group = x_sequence_number ;
352:
353: lv_rowid cur_rowid%RowType;
354:

Line 387: FROM igs_ru_named_rule_gr

383: ***************************************************************/
384:
385: CURSOR cur_rowid IS
386: SELECT rowid
387: FROM igs_ru_named_rule_gr
388: WHERE rug_sequence_number = x_sequence_number ;
389:
390: lv_rowid cur_rowid%RowType;
391:

Line 424: FROM igs_ru_named_rule_gr

420: ***************************************************************/
421:
422: CURSOR cur_rowid IS
423: SELECT rowid
424: FROM igs_ru_named_rule_gr
425: WHERE select_group = x_sequence_number ;
426:
427: lv_rowid cur_rowid%RowType;
428:

Line 585: cursor C is select ROWID from IGS_RU_NAMED_RULE_GR

581:
582: (reverse chronological order - newest change first)
583: ***************************************************************/
584:
585: cursor C is select ROWID from IGS_RU_NAMED_RULE_GR
586: where GROUP_CD= X_GROUP_CD
587: and NAME_CD = X_NAME_CD
588: ;
589: X_LAST_UPDATE_DATE DATE ;

Line 626: insert into IGS_RU_NAMED_RULE_GR (

622: x_created_by=>X_LAST_UPDATED_BY,
623: x_last_update_date=>X_LAST_UPDATE_DATE,
624: x_last_updated_by=>X_LAST_UPDATED_BY,
625: x_last_update_login=>X_LAST_UPDATE_LOGIN);
626: insert into IGS_RU_NAMED_RULE_GR (
627: GROUP_CD
628: ,NAME_CD
629: ,DESCRIPTION
630: ,S_RETURN_TYPE

Line 691: from IGS_RU_NAMED_RULE_GR

687: , S_RETURN_TYPE
688: , RUG_SEQUENCE_NUMBER
689: , SELECT_GROUP
690: , MESSAGE_GROUP
691: from IGS_RU_NAMED_RULE_GR
692: where ROWID = X_ROWID
693: for update nowait;
694: tlinfo c1%rowtype;
695: begin

Line 700: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_NAMED_RULE_GR : P_ACTION LOCK_ROW : IGSUI17B.PLS');

696: open c1;
697: fetch c1 into tlinfo;
698: if (c1%notfound) then
699: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
700: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_NAMED_RULE_GR : P_ACTION LOCK_ROW : IGSUI17B.PLS');
701: IGS_GE_MSG_STACK.ADD;
702: close c1;
703: app_exception.raise_exception;
704: return;

Line 718: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_NAMED_RULE_GR : P_ACTION LOCK_ROW FORM_RECORD_CHANGED : IGSUI17B.PLS');

714: ) then
715: null;
716: else
717: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
718: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_NAMED_RULE_GR : P_ACTION LOCK_ROW FORM_RECORD_CHANGED : IGSUI17B.PLS');
719: IGS_GE_MSG_STACK.ADD;
720: app_exception.raise_exception;
721: end if;
722: return;

Line 784: update IGS_RU_NAMED_RULE_GR set

780: x_created_by=>X_LAST_UPDATED_BY,
781: x_last_update_date=>X_LAST_UPDATE_DATE,
782: x_last_updated_by=>X_LAST_UPDATED_BY,
783: x_last_update_login=>X_LAST_UPDATE_LOGIN);
784: update IGS_RU_NAMED_RULE_GR set
785: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
786: S_RETURN_TYPE = NEW_REFERENCES.S_RETURN_TYPE,
787: RUG_SEQUENCE_NUMBER = NEW_REFERENCES.RUG_SEQUENCE_NUMBER,
788: SELECT_GROUP = NEW_REFERENCES.SELECT_GROUP,

Line 826: cursor c1 is select ROWID from IGS_RU_NAMED_RULE_GR

822:
823: (reverse chronological order - newest change first)
824: ***************************************************************/
825:
826: cursor c1 is select ROWID from IGS_RU_NAMED_RULE_GR
827: where GROUP_CD= X_GROUP_CD
828: and NAME_CD = X_NAME_CD
829: ;
830: begin

Line 879: delete from IGS_RU_NAMED_RULE_GR

875: Before_DML (
876: p_action => 'DELETE',
877: x_rowid => X_ROWID
878: );
879: delete from IGS_RU_NAMED_RULE_GR
880: where ROWID = X_ROWID;
881: if (sql%notfound) then
882: raise no_data_found;
883: end if;

Line 889: END igs_ru_named_rule_gr_pkg;

885: p_action => 'DELETE',
886: x_rowid => X_ROWID
887: );
888: end DELETE_ROW;
889: END igs_ru_named_rule_gr_pkg;