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_TURIN_FNC_PKG dependencies on IGS_RU_TURIN_FNC

Line 1: package body IGS_RU_TURIN_FNC_PKG as

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

Line 5: old_references IGS_RU_TURIN_FNC%RowType;

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

Line 6: new_references IGS_RU_TURIN_FNC%RowType;

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

Line 23: FROM IGS_RU_TURIN_FNC

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

Line 36: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_TURIN_FNC : P_ACTION INSERT, VALIDATE_INSERT : IGSUI14B.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_TURIN_FNC : P_ACTION INSERT, VALIDATE_INSERT : IGSUI14B.PLS');
37: IGS_GE_MSG_STACK.ADD;
38: App_Exception.Raise_Exception;
39: Close cur_old_ref_values;
40: Return;

Line 114: IGS_RU_DESCRIPTION_PKG.GET_FK_IGS_RU_TURIN_FNC (

110:
111: PROCEDURE Check_Child_Existance as
112: BEGIN
113:
114: IGS_RU_DESCRIPTION_PKG.GET_FK_IGS_RU_TURIN_FNC (
115: old_references.s_turin_function
116: );
117:
118: IGS_RU_ITEM_PKG.GET_FK_IGS_RU_TURIN_FNC (

Line 118: IGS_RU_ITEM_PKG.GET_FK_IGS_RU_TURIN_FNC (

114: IGS_RU_DESCRIPTION_PKG.GET_FK_IGS_RU_TURIN_FNC (
115: old_references.s_turin_function
116: );
117:
118: IGS_RU_ITEM_PKG.GET_FK_IGS_RU_TURIN_FNC (
119: old_references.s_turin_function
120: );
121:
122: END Check_Child_Existance;

Line 130: FROM IGS_RU_TURIN_FNC

126: )return BOOLEAN as
127:
128: CURSOR cur_rowid IS
129: SELECT rowid
130: FROM IGS_RU_TURIN_FNC
131: WHERE s_turin_function = x_s_turin_function
132: FOR UPDATE;
133:
134: lv_rowid cur_rowid%RowType;

Line 156: FROM IGS_RU_TURIN_FNC

152: ) as
153:
154: CURSOR cur_rowid IS
155: SELECT rowid
156: FROM IGS_RU_TURIN_FNC
157: WHERE rud_sequence_number = x_sequence_number ;
158:
159: lv_rowid cur_rowid%RowType;
160:

Line 253: cursor C is select ROWID from IGS_RU_TURIN_FNC

249: X_RUD_SEQUENCE_NUMBER in NUMBER,
250: X_PARENTHESIS_IND in VARCHAR2,
251: X_MODE in VARCHAR2
252: ) as
253: cursor C is select ROWID from IGS_RU_TURIN_FNC
254: where S_TURIN_FUNCTION = X_S_TURIN_FUNCTION;
255: X_LAST_UPDATE_DATE DATE;
256: X_LAST_UPDATED_BY NUMBER;
257: X_LAST_UPDATE_LOGIN NUMBER;

Line 291: insert into IGS_RU_TURIN_FNC (

287: x_last_updated_by=>X_LAST_UPDATED_BY,
288: x_last_update_login=>X_LAST_UPDATE_LOGIN
289: );
290:
291: insert into IGS_RU_TURIN_FNC (
292: S_TURIN_FUNCTION,
293: RUD_SEQUENCE_NUMBER,
294: PARENTHESIS_IND,
295: CREATION_DATE,

Line 334: from IGS_RU_TURIN_FNC

330: ) as
331: cursor c1 is select
332: RUD_SEQUENCE_NUMBER,
333: PARENTHESIS_IND
334: from IGS_RU_TURIN_FNC
335: where ROWID = X_ROWID for update nowait;
336: tlinfo c1%rowtype;
337:
338: begin

Line 343: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_TURIN_FNC : P_ACTION LOCK_ROW : IGSUI14B.PLS');

339: open c1;
340: fetch c1 into tlinfo;
341: if (c1%notfound) then
342: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
343: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_TURIN_FNC : P_ACTION LOCK_ROW : IGSUI14B.PLS');
344: IGS_GE_MSG_STACK.ADD;
345: app_exception.raise_exception;
346: close c1;
347: return;

Line 359: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_TURIN_FNC : P_ACTION LOCK_ROW FORM_RECORD_CHANGED : IGSUI14B.PLS');

355: ) then
356: null;
357: else
358: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
359: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_TURIN_FNC : P_ACTION LOCK_ROW FORM_RECORD_CHANGED : IGSUI14B.PLS');
360: IGS_GE_MSG_STACK.ADD;
361: app_exception.raise_exception;
362: end if;
363: return;

Line 409: update IGS_RU_TURIN_FNC set

405: x_last_updated_by=>X_LAST_UPDATED_BY,
406: x_last_update_login=>X_LAST_UPDATE_LOGIN
407: );
408:
409: update IGS_RU_TURIN_FNC set
410: RUD_SEQUENCE_NUMBER = NEW_REFERENCES.RUD_SEQUENCE_NUMBER,
411: PARENTHESIS_IND = NEW_REFERENCES.PARENTHESIS_IND,
412: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
413: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 434: cursor c1 is select rowid from IGS_RU_TURIN_FNC

430: X_RUD_SEQUENCE_NUMBER in NUMBER,
431: X_PARENTHESIS_IND in VARCHAR2,
432: X_MODE in VARCHAR2
433: ) as
434: cursor c1 is select rowid from IGS_RU_TURIN_FNC
435: where S_TURIN_FUNCTION = X_S_TURIN_FUNCTION
436: ;
437: begin
438: open c1;

Line 468: delete from IGS_RU_TURIN_FNC

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

Line 480: end IGS_RU_TURIN_FNC_PKG;

476: x_rowid => X_ROWID);
477:
478: end DELETE_ROW;
479:
480: end IGS_RU_TURIN_FNC_PKG;