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_RET_TYPE_PKG dependencies on IGS_RU_RET_TYPE

Line 1: package body IGS_RU_RET_TYPE_PKG as

1: package body IGS_RU_RET_TYPE_PKG as
2: /* $Header: IGSUI10B.pls 120.1 2005/09/16 06:18:48 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_RU_RET_TYPE%RowType;

Line 5: old_references IGS_RU_RET_TYPE%RowType;

1: package body IGS_RU_RET_TYPE_PKG as
2: /* $Header: IGSUI10B.pls 120.1 2005/09/16 06:18:48 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_RU_RET_TYPE%RowType;
6: new_references IGS_RU_RET_TYPE%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_RU_RET_TYPE%RowType;

2: /* $Header: IGSUI10B.pls 120.1 2005/09/16 06:18:48 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_RU_RET_TYPE%RowType;
6: new_references IGS_RU_RET_TYPE%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 22: FROM IGS_RU_RET_TYPE

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

Line 35: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_RET_TYPE : P_ACTION INSERT VALIDATE_INSERT : IGSUI10B.PLS');

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

Line 95: IGS_RU_NAMED_RULE_GR_Pkg.Get_FK_IGS_RU_RET_TYPE (

91: END Check_Constraints;
92:
93: PROCEDURE Check_Child_Existance as
94: BEGIN
95: IGS_RU_NAMED_RULE_GR_Pkg.Get_FK_IGS_RU_RET_TYPE (
96: old_references.s_return_type
97: );
98: IGS_RU_DESCRIPTION_PKG.GET_FK_IGS_RU_RET_TYPE (
99: old_references.s_return_type

Line 98: IGS_RU_DESCRIPTION_PKG.GET_FK_IGS_RU_RET_TYPE (

94: BEGIN
95: IGS_RU_NAMED_RULE_GR_Pkg.Get_FK_IGS_RU_RET_TYPE (
96: old_references.s_return_type
97: );
98: IGS_RU_DESCRIPTION_PKG.GET_FK_IGS_RU_RET_TYPE (
99: old_references.s_return_type
100: );
101:
102: END Check_Child_Existance;

Line 111: FROM IGS_RU_RET_TYPE

107: RETURN BOOLEAN
108: AS
109: CURSOR cur_rowid IS
110: SELECT rowid
111: FROM IGS_RU_RET_TYPE
112: WHERE s_return_type = x_s_return_type
113: FOR UPDATE;
114:
115: lv_rowid cur_rowid%RowType;

Line 204: cursor C is select ROWID from IGS_RU_RET_TYPE

200: X_S_RETURN_TYPE in VARCHAR2,
201: X_FUNCTION_RETURN_IND in VARCHAR2,
202: X_MODE in VARCHAR2
203: ) as
204: cursor C is select ROWID from IGS_RU_RET_TYPE
205: where S_RETURN_TYPE = X_S_RETURN_TYPE;
206: X_LAST_UPDATE_DATE DATE;
207: X_LAST_UPDATED_BY NUMBER;
208: X_LAST_UPDATE_LOGIN NUMBER;

Line 241: insert into IGS_RU_RET_TYPE (

237: x_last_updated_by=>X_LAST_UPDATED_BY,
238: x_last_update_login=>X_LAST_UPDATE_LOGIN
239: );
240:
241: insert into IGS_RU_RET_TYPE (
242: S_RETURN_TYPE,
243: FUNCTION_RETURN_IND,
244: CREATION_DATE,
245: CREATED_BY,

Line 280: from IGS_RU_RET_TYPE

276: X_FUNCTION_RETURN_IND in VARCHAR2
277: ) as
278: cursor c1 is select
279: FUNCTION_RETURN_IND
280: from IGS_RU_RET_TYPE
281: where ROWID = X_ROWID for update nowait;
282: tlinfo c1%rowtype;
283:
284: begin

Line 289: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_RET_TYPE : LOCK_ROW : IGSUI10B.PLS');

285: open c1;
286: fetch c1 into tlinfo;
287: if (c1%notfound) then
288: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
289: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_RET_TYPE : LOCK_ROW : IGSUI10B.PLS');
290: IGS_GE_MSG_STACK.ADD;
291: app_exception.raise_exception;
292: close c1;
293: return;

Line 304: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_RET_TYPE : LOCK_ROW FORM_RECORD_CHANGED : IGSUI10B.PLS');

300: ) then
301: null;
302: else
303: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
304: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_RET_TYPE : LOCK_ROW FORM_RECORD_CHANGED : IGSUI10B.PLS');
305: IGS_GE_MSG_STACK.ADD;
306: app_exception.raise_exception;
307: end if;
308: return;

Line 352: update IGS_RU_RET_TYPE set

348: x_last_updated_by=>X_LAST_UPDATED_BY,
349: x_last_update_login=>X_LAST_UPDATE_LOGIN
350: );
351:
352: update IGS_RU_RET_TYPE set
353: FUNCTION_RETURN_IND = NEW_REFERENCES.FUNCTION_RETURN_IND,
354: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
355: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
356: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 375: cursor c1 is select rowid from IGS_RU_RET_TYPE

371: X_S_RETURN_TYPE in VARCHAR2,
372: X_FUNCTION_RETURN_IND in VARCHAR2,
373: X_MODE in VARCHAR2
374: ) as
375: cursor c1 is select rowid from IGS_RU_RET_TYPE
376: where S_RETURN_TYPE = X_S_RETURN_TYPE
377: ;
378: begin
379: open c1;

Line 407: delete from IGS_RU_RET_TYPE

403: Before_DML (
404: p_action => 'DELETE',
405: x_rowid => X_ROWID);
406:
407: delete from IGS_RU_RET_TYPE
408: where ROWID = X_ROWID;
409: if (sql%notfound) then
410: raise no_data_found;
411: end if;

Line 419: end IGS_RU_RET_TYPE_PKG;

415: x_rowid => X_ROWID);
416:
417: end DELETE_ROW;
418:
419: end IGS_RU_RET_TYPE_PKG;