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

Line 1: package body IGS_RU_CALL_PKG AS

1: package body IGS_RU_CALL_PKG AS
2: /* $Header: IGSUI01B.pls 115.11 2002/11/29 04:24:40 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_RU_CALL%RowType;
5: new_references IGS_RU_CALL%RowType;

Line 4: old_references IGS_RU_CALL%RowType;

1: package body IGS_RU_CALL_PKG AS
2: /* $Header: IGSUI01B.pls 115.11 2002/11/29 04:24:40 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_RU_CALL%RowType;
5: new_references IGS_RU_CALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_RU_CALL%RowType;

1: package body IGS_RU_CALL_PKG AS
2: /* $Header: IGSUI01B.pls 115.11 2002/11/29 04:24:40 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_RU_CALL%RowType;
5: new_references IGS_RU_CALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 ,

Line 26: FROM IGS_RU_CALL

22: x_last_update_login IN NUMBER ) AS
23:
24: CURSOR cur_old_ref_values IS
25: SELECT *
26: FROM IGS_RU_CALL
27: WHERE rowid = x_rowid;
28:
29: BEGIN
30:

Line 40: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_CALL : P_ACTION Insert, validate Insert : IGSUI01B.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_CALL : P_ACTION Insert, validate Insert : IGSUI01B.PLS');
41: IGS_GE_MSG_STACK.ADD;
42: App_Exception.Raise_Exception;
43: Return;
44: END IF;

Line 147: IGS_RU_ITEM_PKG.GET_UFK_IGS_RU_CALL(

143: (old_references.rud_sequence_number IS NULL)
144: THEN
145: NULL;
146: ELSE
147: IGS_RU_ITEM_PKG.GET_UFK_IGS_RU_CALL(
148: old_references.rud_sequence_number
149: );
150: END IF;
151:

Line 162: FROM IGS_RU_CALL

158: RETURN BOOLEAN AS
159:
160: CURSOR cur_rowid IS
161: SELECT rowid
162: FROM IGS_RU_CALL
163: WHERE s_rule_call_cd = x_s_rule_call_cd
164: FOR UPDATE NOWAIT;
165:
166: lv_rowid cur_rowid%RowType;

Line 190: FROM IGS_RU_CALL

186: )
187: RETURN BOOLEAN AS
188: CURSOR cur_rowid IS
189: SELECT rowid
190: FROM IGS_RU_CALL
191: WHERE rud_sequence_number = x_rud_sequence_number
192: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
193:
194:

Line 215: FROM IGS_RU_CALL

211: ) AS
212:
213: CURSOR cur_rowid IS
214: SELECT rowid
215: FROM IGS_RU_CALL
216: WHERE default_rule = x_rul_sequence_number ;
217:
218: lv_rowid cur_rowid%RowType;
219:

Line 241: FROM IGS_RU_CALL

237: ) AS
238:
239: CURSOR cur_rowid IS
240: SELECT rowid
241: FROM IGS_RU_CALL
242: WHERE rud_sequence_number = x_sequence_number ;
243:
244: lv_rowid cur_rowid%RowType;
245:

Line 268: FROM IGS_RU_CALL

264: ) AS
265:
266: CURSOR cur_rowid IS
267: SELECT rowid
268: FROM IGS_RU_CALL
269: WHERE rug_sequence_number = x_sequence_number
270: OR select_group = x_sequence_number ;
271:
272: lv_rowid cur_rowid%RowType;

Line 295: FROM igs_ru_call

291: ) AS
292:
293: CURSOR cur_rowid IS
294: SELECT rowid
295: FROM igs_ru_call
296: WHERE rug_sequence_number = x_sequence_number ;
297:
298: lv_rowid cur_rowid%RowType;
299:

Line 463: cursor C is select ROWID from IGS_RU_CALL

459: X_DEFAULT_RULE in NUMBER,
460: X_RUG_SEQUENCE_NUMBER in NUMBER,
461: X_MODE in VARCHAR2
462: ) AS
463: cursor C is select ROWID from IGS_RU_CALL
464: where S_RULE_CALL_CD = X_S_RULE_CALL_CD;
465: X_LAST_UPDATE_DATE DATE;
466: X_LAST_UPDATED_BY NUMBER;
467: X_LAST_UPDATE_LOGIN NUMBER;

Line 506: insert into IGS_RU_CALL (

502: x_last_updated_by =>X_LAST_UPDATED_BY,
503: x_last_update_login=> X_LAST_UPDATE_LOGIN
504: );
505:
506: insert into IGS_RU_CALL (
507: S_RULE_TYPE_CD,
508: S_RULE_CALL_CD,
509: RUD_SEQUENCE_NUMBER,
510: SELECT_GROUP,

Line 571: from IGS_RU_CALL

567: TRUE_MESSAGE,
568: FALSE_MESSAGE,
569: DEFAULT_RULE,
570: RUG_SEQUENCE_NUMBER
571: from IGS_RU_CALL
572: where ROWID = X_ROWID
573: for update nowait;
574: tlinfo c1%rowtype;
575:

Line 582: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_CALL : P_ACTION LOCK_ROW : IGSUI01B.PLS');

578: fetch c1 into tlinfo;
579: if (c1%notfound) then
580: close c1;
581: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
582: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_CALL : P_ACTION LOCK_ROW : IGSUI01B.PLS');
583: IGS_GE_MSG_STACK.ADD;
584: app_exception.raise_exception;
585: return;
586: end if;

Line 608: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_CALL : P_ACTION LOCK_ROW FORM_RECORD_CHANGED : IGSUI01B.PLS');

604: ) then
605: null;
606: else
607: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
608: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_CALL : P_ACTION LOCK_ROW FORM_RECORD_CHANGED : IGSUI01B.PLS');
609: IGS_GE_MSG_STACK.ADD;
610: app_exception.raise_exception;
611: end if;
612: return;

Line 668: update IGS_RU_CALL set

664: x_last_updated_by =>X_LAST_UPDATED_BY,
665: x_last_update_login=> X_LAST_UPDATE_LOGIN
666: );
667:
668: update IGS_RU_CALL set
669: S_RULE_TYPE_CD = NEW_REFERENCES.S_RULE_TYPE_CD,
670: RUD_SEQUENCE_NUMBER = NEW_REFERENCES.RUD_SEQUENCE_NUMBER,
671: SELECT_GROUP = NEW_REFERENCES.SELECT_GROUP,
672: TRUE_MESSAGE = NEW_REFERENCES.TRUE_MESSAGE,

Line 702: cursor c1 is select rowid from IGS_RU_CALL

698: X_DEFAULT_RULE in NUMBER,
699: X_RUG_SEQUENCE_NUMBER in NUMBER,
700: X_MODE in VARCHAR2
701: ) AS
702: cursor c1 is select rowid from IGS_RU_CALL
703: where S_RULE_CALL_CD = X_S_RULE_CALL_CD
704: ;
705: begin
706: open c1;

Line 747: delete from IGS_RU_CALL

743: p_action => 'DELETE',
744: x_rowid => X_ROWID
745: );
746:
747: delete from IGS_RU_CALL
748: where ROWID = X_ROWID;
749: if (sql%notfound) then
750: raise no_data_found;
751: end if;

Line 841: end IGS_RU_CALL_PKG;

837:
838: END IF ;
839: END Check_Constraints;
840:
841: end IGS_RU_CALL_PKG;