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.FND_CONC_STATE_LOOKUP_TYPES_PG dependencies on FND_CONC_STATE_LOOKUP_TYPES

Line 1: package body FND_CONC_STATE_LOOKUP_TYPES_PG as

1: package body FND_CONC_STATE_LOOKUP_TYPES_PG as
2: /* $Header: AFCPSC6B.pls 120.2 2005/08/19 11:36:55 ddhulla ship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,

Line 19: cursor C is select ROWID from FND_CONC_STATE_LOOKUP_TYPES

15: X_LAST_UPDATE_DATE in DATE,
16: X_LAST_UPDATED_BY in NUMBER,
17: X_LAST_UPDATE_LOGIN in NUMBER
18: ) is
19: cursor C is select ROWID from FND_CONC_STATE_LOOKUP_TYPES
20: where LOOKUP_TYPE_ID = X_LOOKUP_TYPE_ID
21: ;
22: begin
23: insert into FND_CONC_STATE_LOOKUP_TYPES (

Line 23: insert into FND_CONC_STATE_LOOKUP_TYPES (

19: cursor C is select ROWID from FND_CONC_STATE_LOOKUP_TYPES
20: where LOOKUP_TYPE_ID = X_LOOKUP_TYPE_ID
21: ;
22: begin
23: insert into FND_CONC_STATE_LOOKUP_TYPES (
24: LOOKUP_TYPE_ID,
25: LOOKUP_TYPE_NAME,
26: ENABLED_FLAG,
27: START_DATE_ACTIVE,

Line 47: insert into FND_CONC_STATE_LOOKUP_TYPES_TL (

43: X_LAST_UPDATED_BY,
44: X_LAST_UPDATE_LOGIN
45: );
46:
47: insert into FND_CONC_STATE_LOOKUP_TYPES_TL (
48: LOOKUP_TYPE_ID,
49: USER_LOOKUP_TYPE_NAME,
50: DESCRIPTION,
51: LAST_UPDATE_DATE,

Line 73: from FND_CONC_STATE_LOOKUP_TYPES_TL T

69: from FND_LANGUAGES L
70: where L.INSTALLED_FLAG in ('I', 'B')
71: and not exists
72: (select NULL
73: from FND_CONC_STATE_LOOKUP_TYPES_TL T
74: where T.LOOKUP_TYPE_ID = X_LOOKUP_TYPE_ID
75: and T.LANGUAGE = L.LANGUAGE_CODE);
76:
77: open c;

Line 101: from FND_CONC_STATE_LOOKUP_TYPES

97: LOOKUP_TYPE_NAME,
98: ENABLED_FLAG,
99: START_DATE_ACTIVE,
100: END_DATE_ACTIVE
101: from FND_CONC_STATE_LOOKUP_TYPES
102: where LOOKUP_TYPE_ID = X_LOOKUP_TYPE_ID
103: for update of LOOKUP_TYPE_ID nowait;
104: recinfo c%rowtype;
105:

Line 109: from FND_CONC_STATE_LOOKUP_TYPES_TL

105:
106: cursor c1 is select
107: USER_LOOKUP_TYPE_NAME,
108: DESCRIPTION
109: from FND_CONC_STATE_LOOKUP_TYPES_TL
110: where LOOKUP_TYPE_ID = X_LOOKUP_TYPE_ID
111: and LANGUAGE = userenv('LANG')
112: for update of LOOKUP_TYPE_ID nowait;
113: tlinfo c1%rowtype;

Line 170: update FND_CONC_STATE_LOOKUP_TYPES set

166: X_LAST_UPDATED_BY in NUMBER,
167: X_LAST_UPDATE_LOGIN in NUMBER
168: ) is
169: begin
170: update FND_CONC_STATE_LOOKUP_TYPES set
171: LOOKUP_TYPE_NAME = X_LOOKUP_TYPE_NAME,
172: ENABLED_FLAG = X_ENABLED_FLAG,
173: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
174: END_DATE_ACTIVE = X_END_DATE_ACTIVE,

Line 184: update FND_CONC_STATE_LOOKUP_TYPES_TL set

180: if (sql%notfound) then
181: raise no_data_found;
182: end if;
183:
184: update FND_CONC_STATE_LOOKUP_TYPES_TL set
185: USER_LOOKUP_TYPE_NAME = X_USER_LOOKUP_TYPE_NAME,
186: DESCRIPTION = X_DESCRIPTION,
187: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
188: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 203: delete from FND_CONC_STATE_LOOKUP_TYPES

199: procedure DELETE_ROW (
200: X_LOOKUP_TYPE_ID in NUMBER
201: ) is
202: begin
203: delete from FND_CONC_STATE_LOOKUP_TYPES
204: where LOOKUP_TYPE_ID = X_LOOKUP_TYPE_ID;
205:
206: if (sql%notfound) then
207: raise no_data_found;

Line 210: delete from FND_CONC_STATE_LOOKUP_TYPES_TL

206: if (sql%notfound) then
207: raise no_data_found;
208: end if;
209:
210: delete from FND_CONC_STATE_LOOKUP_TYPES_TL
211: where LOOKUP_TYPE_ID = X_LOOKUP_TYPE_ID;
212:
213: if (sql%notfound) then
214: raise no_data_found;

Line 228: delete from FND_CONC_STATE_LOOKUP_TYPES_TL T

224: /* as a quick workaround to fix the time-consuming table handler issue */
225: /* Eventually we'll need to turn them into a separate fix_language procedure */
226: /*
227:
228: delete from FND_CONC_STATE_LOOKUP_TYPES_TL T
229: where not exists
230: (select NULL
231: from FND_CONC_STATE_LOOKUP_TYPES B
232: where B.LOOKUP_TYPE_ID = T.LOOKUP_TYPE_ID

Line 231: from FND_CONC_STATE_LOOKUP_TYPES B

227:
228: delete from FND_CONC_STATE_LOOKUP_TYPES_TL T
229: where not exists
230: (select NULL
231: from FND_CONC_STATE_LOOKUP_TYPES B
232: where B.LOOKUP_TYPE_ID = T.LOOKUP_TYPE_ID
233: );
234:
235: update FND_CONC_STATE_LOOKUP_TYPES_TL T set (

Line 235: update FND_CONC_STATE_LOOKUP_TYPES_TL T set (

231: from FND_CONC_STATE_LOOKUP_TYPES B
232: where B.LOOKUP_TYPE_ID = T.LOOKUP_TYPE_ID
233: );
234:
235: update FND_CONC_STATE_LOOKUP_TYPES_TL T set (
236: USER_LOOKUP_TYPE_NAME,
237: DESCRIPTION
238: ) = (select
239: B.USER_LOOKUP_TYPE_NAME,

Line 241: from FND_CONC_STATE_LOOKUP_TYPES_TL B

237: DESCRIPTION
238: ) = (select
239: B.USER_LOOKUP_TYPE_NAME,
240: B.DESCRIPTION
241: from FND_CONC_STATE_LOOKUP_TYPES_TL B
242: where B.LOOKUP_TYPE_ID = T.LOOKUP_TYPE_ID
243: and B.LANGUAGE = T.SOURCE_LANG)
244: where (
245: T.LOOKUP_TYPE_ID,

Line 250: from FND_CONC_STATE_LOOKUP_TYPES_TL SUBB, FND_CONC_STATE_LOOKUP_TYPES_TL SUBT

246: T.LANGUAGE
247: ) in (select
248: SUBT.LOOKUP_TYPE_ID,
249: SUBT.LANGUAGE
250: from FND_CONC_STATE_LOOKUP_TYPES_TL SUBB, FND_CONC_STATE_LOOKUP_TYPES_TL SUBT
251: where SUBB.LOOKUP_TYPE_ID = SUBT.LOOKUP_TYPE_ID
252: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
253: and (SUBB.USER_LOOKUP_TYPE_NAME <> SUBT.USER_LOOKUP_TYPE_NAME
254: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 260: insert into FND_CONC_STATE_LOOKUP_TYPES_TL (

256: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
257: ));
258: */
259:
260: insert into FND_CONC_STATE_LOOKUP_TYPES_TL (
261: LOOKUP_TYPE_ID,
262: USER_LOOKUP_TYPE_NAME,
263: DESCRIPTION,
264: LAST_UPDATE_DATE,

Line 282: from FND_CONC_STATE_LOOKUP_TYPES_TL B, FND_LANGUAGES L

278: B.CREATION_DATE,
279: B.CREATED_BY,
280: L.LANGUAGE_CODE,
281: B.SOURCE_LANG
282: from FND_CONC_STATE_LOOKUP_TYPES_TL B, FND_LANGUAGES L
283: where L.INSTALLED_FLAG in ('I', 'B')
284: and B.LANGUAGE = userenv('LANG')
285: and not exists
286: (select NULL

Line 287: from FND_CONC_STATE_LOOKUP_TYPES_TL T

283: where L.INSTALLED_FLAG in ('I', 'B')
284: and B.LANGUAGE = userenv('LANG')
285: and not exists
286: (select NULL
287: from FND_CONC_STATE_LOOKUP_TYPES_TL T
288: where T.LOOKUP_TYPE_ID = B.LOOKUP_TYPE_ID
289: and T.LANGUAGE = L.LANGUAGE_CODE);
290: end ADD_LANGUAGE;
291:

Line 292: end FND_CONC_STATE_LOOKUP_TYPES_PG;

288: where T.LOOKUP_TYPE_ID = B.LOOKUP_TYPE_ID
289: and T.LANGUAGE = L.LANGUAGE_CODE);
290: end ADD_LANGUAGE;
291:
292: end FND_CONC_STATE_LOOKUP_TYPES_PG;