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_PKG dependencies on IGS_RU_GROUP

Line 1: package body IGS_RU_GROUP_PKG as

1: package body IGS_RU_GROUP_PKG as
2: /* $Header: IGSUI04B.pls 120.0 2005/06/01 21:30:58 appldev noship $ */
3:
4:
5: l_rowid VARCHAR2(25);

Line 6: old_references IGS_RU_GROUP%RowType;

2: /* $Header: IGSUI04B.pls 120.0 2005/06/01 21:30:58 appldev noship $ */
3:
4:
5: l_rowid VARCHAR2(25);
6: old_references IGS_RU_GROUP%RowType;
7: new_references IGS_RU_GROUP%RowType;
8:
9: PROCEDURE Set_Column_Values (
10: p_action IN VARCHAR2,

Line 7: new_references IGS_RU_GROUP%RowType;

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

Line 23: FROM IGS_RU_GROUP

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

Line 36: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_GROUP : P_ACTION INSERT VALIDATE_INSERT : IGSUI04B.PLS');

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

Line 97: IGS_RU_NAMED_RULE_PKG.GET_FK_IGS_RU_GROUP (

93:
94: PROCEDURE Check_Child_Existance as
95: BEGIN
96:
97: IGS_RU_NAMED_RULE_PKG.GET_FK_IGS_RU_GROUP (
98: old_references.sequence_number
99: );
100: IGS_RU_NAMED_RULE_GR_Pkg.Get_FK_Igs_Ru_Group_msg (
101: old_references.sequence_number

Line 100: IGS_RU_NAMED_RULE_GR_Pkg.Get_FK_Igs_Ru_Group_msg (

96:
97: IGS_RU_NAMED_RULE_PKG.GET_FK_IGS_RU_GROUP (
98: old_references.sequence_number
99: );
100: IGS_RU_NAMED_RULE_GR_Pkg.Get_FK_Igs_Ru_Group_msg (
101: old_references.sequence_number
102: );
103:
104: IGS_RU_NAMED_RULE_GR_Pkg.Get_FK_Igs_Ru_Group_seq (

Line 104: IGS_RU_NAMED_RULE_GR_Pkg.Get_FK_Igs_Ru_Group_seq (

100: IGS_RU_NAMED_RULE_GR_Pkg.Get_FK_Igs_Ru_Group_msg (
101: old_references.sequence_number
102: );
103:
104: IGS_RU_NAMED_RULE_GR_Pkg.Get_FK_Igs_Ru_Group_seq (
105: old_references.sequence_number
106: );
107:
108: IGS_RU_NAMED_RULE_GR_Pkg.Get_FK_Igs_Ru_Group_sg(

Line 108: IGS_RU_NAMED_RULE_GR_Pkg.Get_FK_Igs_Ru_Group_sg(

104: IGS_RU_NAMED_RULE_GR_Pkg.Get_FK_Igs_Ru_Group_seq (
105: old_references.sequence_number
106: );
107:
108: IGS_RU_NAMED_RULE_GR_Pkg.Get_FK_Igs_Ru_Group_sg(
109: old_references.sequence_number
110: );
111:
112: IGS_RU_GROUP_ITEM_PKG.GET_FK_IGS_RU_GROUP (

Line 112: IGS_RU_GROUP_ITEM_PKG.GET_FK_IGS_RU_GROUP (

108: IGS_RU_NAMED_RULE_GR_Pkg.Get_FK_Igs_Ru_Group_sg(
109: old_references.sequence_number
110: );
111:
112: IGS_RU_GROUP_ITEM_PKG.GET_FK_IGS_RU_GROUP (
113: old_references.sequence_number
114: );
115:
116: IGS_RU_GROUP_SET_PKG.GET_FK_IGS_RU_GROUP (

Line 116: IGS_RU_GROUP_SET_PKG.GET_FK_IGS_RU_GROUP (

112: IGS_RU_GROUP_ITEM_PKG.GET_FK_IGS_RU_GROUP (
113: old_references.sequence_number
114: );
115:
116: IGS_RU_GROUP_SET_PKG.GET_FK_IGS_RU_GROUP (
117: old_references.sequence_number
118: );
119:
120: IGS_RU_CALL_PKG.GET_FK_IGS_RU_GROUP_SG (

Line 120: IGS_RU_CALL_PKG.GET_FK_IGS_RU_GROUP_SG (

116: IGS_RU_GROUP_SET_PKG.GET_FK_IGS_RU_GROUP (
117: old_references.sequence_number
118: );
119:
120: IGS_RU_CALL_PKG.GET_FK_IGS_RU_GROUP_SG (
121: old_references.sequence_number
122: );
123:
124: IGS_RU_CALL_PKG.GET_FK_IGS_RU_GROUP_SEQ (

Line 124: IGS_RU_CALL_PKG.GET_FK_IGS_RU_GROUP_SEQ (

120: IGS_RU_CALL_PKG.GET_FK_IGS_RU_GROUP_SG (
121: old_references.sequence_number
122: );
123:
124: IGS_RU_CALL_PKG.GET_FK_IGS_RU_GROUP_SEQ (
125: old_references.sequence_number
126: );
127: IGS_RU_TURIN_RULE_GR_Pkg.Get_FK_IGS_RU_Group (
128: old_references.sequence_number

Line 127: IGS_RU_TURIN_RULE_GR_Pkg.Get_FK_IGS_RU_Group (

123:
124: IGS_RU_CALL_PKG.GET_FK_IGS_RU_GROUP_SEQ (
125: old_references.sequence_number
126: );
127: IGS_RU_TURIN_RULE_GR_Pkg.Get_FK_IGS_RU_Group (
128: old_references.sequence_number
129: );
130: END Check_Child_Existance;
131:

Line 139: FROM IGS_RU_GROUP

135: as
136:
137: CURSOR cur_rowid IS
138: SELECT rowid
139: FROM IGS_RU_GROUP
140: WHERE sequence_number = x_sequence_number
141: FOR UPDATE NOWAIT;
142:
143: lv_rowid cur_rowid%RowType;

Line 166: FROM IGS_RU_GROUP

162: RETURN BOOLEAN as
163:
164: CURSOR cur_rowid IS
165: SELECT rowid
166: FROM IGS_RU_GROUP
167: WHERE group_name = x_group_name
168: AND ((l_rowid IS NULL) OR (rowid <> l_rowid)) ;
169:
170: lv_rowid cur_rowid%RowType;

Line 267: cursor C is select ROWID from IGS_RU_GROUP

263: X_SEQUENCE_NUMBER in NUMBER,
264: X_GROUP_NAME in VARCHAR2,
265: X_MODE in VARCHAR2
266: )as
267: cursor C is select ROWID from IGS_RU_GROUP
268: where SEQUENCE_NUMBER = X_SEQUENCE_NUMBER;
269: X_LAST_UPDATE_DATE DATE;
270: X_LAST_UPDATED_BY NUMBER;
271: X_LAST_UPDATE_LOGIN NUMBER;

Line 304: insert into IGS_RU_GROUP (

300: x_last_updated_by=>X_LAST_UPDATED_BY,
301: x_last_update_login=>X_LAST_UPDATE_LOGIN
302: );
303:
304: insert into IGS_RU_GROUP (
305: SEQUENCE_NUMBER,
306: GROUP_NAME,
307: CREATION_DATE,
308: CREATED_BY,

Line 343: from IGS_RU_GROUP

339: X_GROUP_NAME in VARCHAR2
340: )as
341: cursor c1 is select
342: GROUP_NAME
343: from IGS_RU_GROUP
344: where ROWID = X_ROWID for update nowait;
345: tlinfo c1%rowtype;
346:
347: begin

Line 352: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_GROUP : P_ACTION LOCK_ROW : IGSUI04B.PLS');

348: open c1;
349: fetch c1 into tlinfo;
350: if (c1%notfound) then
351: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
352: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_GROUP : P_ACTION LOCK_ROW : IGSUI04B.PLS');
353: IGS_GE_MSG_STACK.ADD;
354: app_exception.raise_exception;
355: close c1;
356: return;

Line 367: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_GROUP : P_ACTION LOCK_ROW FORM_RECORD_CHANGED : IGSUI04B.PLS');

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

Line 415: update IGS_RU_GROUP set

411: x_last_updated_by=>X_LAST_UPDATED_BY,
412: x_last_update_login=>X_LAST_UPDATE_LOGIN
413: );
414:
415: update IGS_RU_GROUP set
416: GROUP_NAME = NEW_REFERENCES.GROUP_NAME,
417: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
418: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
419: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 438: cursor c1 is select rowid from IGS_RU_GROUP

434: X_SEQUENCE_NUMBER in NUMBER,
435: X_GROUP_NAME in VARCHAR2,
436: X_MODE in VARCHAR2
437: )as
438: cursor c1 is select rowid from IGS_RU_GROUP
439: where SEQUENCE_NUMBER = X_SEQUENCE_NUMBER
440: ;
441: begin
442: open c1;

Line 470: delete from IGS_RU_GROUP

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

Line 482: end IGS_RU_GROUP_PKG;

478: x_rowid => X_ROWID);
479:
480: end DELETE_ROW;
481:
482: end IGS_RU_GROUP_PKG;