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_ID_FLEX_STRUCTURES_PKG dependencies on FND_ID_FLEX_STRUCTURES

Line 1: package body FND_ID_FLEX_STRUCTURES_PKG as

1: package body FND_ID_FLEX_STRUCTURES_PKG as
2: /* $Header: AFFFSTRB.pls 120.4.12010000.1 2008/07/25 14:14:21 appldev ship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out nocopy VARCHAR2,

Line 28: cursor C is select ROWID from FND_ID_FLEX_STRUCTURES

24: X_LAST_UPDATE_DATE in DATE,
25: X_LAST_UPDATED_BY in NUMBER,
26: X_LAST_UPDATE_LOGIN in NUMBER
27: ) is
28: cursor C is select ROWID from FND_ID_FLEX_STRUCTURES
29: where APPLICATION_ID = X_APPLICATION_ID
30: and ID_FLEX_CODE = X_ID_FLEX_CODE
31: and ID_FLEX_NUM = X_ID_FLEX_NUM
32: ;

Line 34: insert into FND_ID_FLEX_STRUCTURES (

30: and ID_FLEX_CODE = X_ID_FLEX_CODE
31: and ID_FLEX_NUM = X_ID_FLEX_NUM
32: ;
33: begin
34: insert into FND_ID_FLEX_STRUCTURES (
35: APPLICATION_ID,
36: ID_FLEX_CODE,
37: ID_FLEX_NUM,
38: ID_FLEX_STRUCTURE_CODE,

Line 74: insert into FND_ID_FLEX_STRUCTURES_TL (

70: X_LAST_UPDATED_BY,
71: X_LAST_UPDATE_LOGIN
72: );
73:
74: insert into FND_ID_FLEX_STRUCTURES_TL (
75: APPLICATION_ID,
76: ID_FLEX_CODE,
77: ID_FLEX_NUM,
78: LAST_UPDATE_DATE,

Line 106: from FND_ID_FLEX_STRUCTURES_TL T

102: from FND_LANGUAGES L
103: where L.INSTALLED_FLAG in ('I', 'B')
104: and not exists
105: (select NULL
106: from FND_ID_FLEX_STRUCTURES_TL T
107: where T.APPLICATION_ID = X_APPLICATION_ID
108: and T.ID_FLEX_CODE = X_ID_FLEX_CODE
109: and T.ID_FLEX_NUM = X_ID_FLEX_NUM
110: and T.LANGUAGE = L.LANGUAGE_CODE);

Line 151: from FND_ID_FLEX_STRUCTURES

147: FREEZE_STRUCTURED_HIER_FLAG,
148: SHORTHAND_ENABLED_FLAG,
149: SHORTHAND_LENGTH,
150: STRUCTURE_VIEW_NAME
151: from FND_ID_FLEX_STRUCTURES
152: where APPLICATION_ID = X_APPLICATION_ID
153: and ID_FLEX_CODE = X_ID_FLEX_CODE
154: and ID_FLEX_NUM = X_ID_FLEX_NUM
155: for update of APPLICATION_ID nowait;

Line 163: from FND_ID_FLEX_STRUCTURES_TL

159: ID_FLEX_STRUCTURE_NAME,
160: DESCRIPTION,
161: SHORTHAND_PROMPT,
162: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
163: from FND_ID_FLEX_STRUCTURES_TL
164: where APPLICATION_ID = X_APPLICATION_ID
165: and ID_FLEX_CODE = X_ID_FLEX_CODE
166: and ID_FLEX_NUM = X_ID_FLEX_NUM
167: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)

Line 237: update FND_ID_FLEX_STRUCTURES set

233: X_LAST_UPDATED_BY in NUMBER,
234: X_LAST_UPDATE_LOGIN in NUMBER
235: ) is
236: begin
237: update FND_ID_FLEX_STRUCTURES set
238: ID_FLEX_STRUCTURE_CODE = X_ID_FLEX_STRUCTURE_CODE,
239: CONCATENATED_SEGMENT_DELIMITER = X_CONCATENATED_SEGMENT_DELIMIT,
240: CROSS_SEGMENT_VALIDATION_FLAG = X_CROSS_SEGMENT_VALIDATION_FLA,
241: DYNAMIC_INSERTS_ALLOWED_FLAG = X_DYNAMIC_INSERTS_ALLOWED_FLAG,

Line 259: update FND_ID_FLEX_STRUCTURES_TL set

255: if (sql%notfound) then
256: raise no_data_found;
257: end if;
258:
259: update FND_ID_FLEX_STRUCTURES_TL set
260: ID_FLEX_STRUCTURE_NAME = X_ID_FLEX_STRUCTURE_NAME,
261: DESCRIPTION = X_DESCRIPTION,
262: SHORTHAND_PROMPT = X_SHORTHAND_PROMPT,
263: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 283: delete from FND_ID_FLEX_STRUCTURES_TL

279: X_ID_FLEX_CODE in VARCHAR2,
280: X_ID_FLEX_NUM in NUMBER
281: ) is
282: begin
283: delete from FND_ID_FLEX_STRUCTURES_TL
284: where APPLICATION_ID = X_APPLICATION_ID
285: and ID_FLEX_CODE = X_ID_FLEX_CODE
286: and ID_FLEX_NUM = X_ID_FLEX_NUM;
287:

Line 292: delete from FND_ID_FLEX_STRUCTURES

288: if (sql%notfound) then
289: raise no_data_found;
290: end if;
291:
292: delete from FND_ID_FLEX_STRUCTURES
293: where APPLICATION_ID = X_APPLICATION_ID
294: and ID_FLEX_CODE = X_ID_FLEX_CODE
295: and ID_FLEX_NUM = X_ID_FLEX_NUM;
296:

Line 311: delete from FND_ID_FLEX_STRUCTURES_TL T

307: /* as a quick workaround to fix the time-consuming table handler issue */
308: /* Eventually we'll need to turn them into a separate fix_language procedure */
309: /*
310:
311: delete from FND_ID_FLEX_STRUCTURES_TL T
312: where not exists
313: (select NULL
314: from FND_ID_FLEX_STRUCTURES B
315: where B.APPLICATION_ID = T.APPLICATION_ID

Line 314: from FND_ID_FLEX_STRUCTURES B

310:
311: delete from FND_ID_FLEX_STRUCTURES_TL T
312: where not exists
313: (select NULL
314: from FND_ID_FLEX_STRUCTURES B
315: where B.APPLICATION_ID = T.APPLICATION_ID
316: and B.ID_FLEX_CODE = T.ID_FLEX_CODE
317: and B.ID_FLEX_NUM = T.ID_FLEX_NUM
318: );

Line 320: update FND_ID_FLEX_STRUCTURES_TL T set (

316: and B.ID_FLEX_CODE = T.ID_FLEX_CODE
317: and B.ID_FLEX_NUM = T.ID_FLEX_NUM
318: );
319:
320: update FND_ID_FLEX_STRUCTURES_TL T set (
321: ID_FLEX_STRUCTURE_NAME,
322: DESCRIPTION,
323: SHORTHAND_PROMPT
324: ) = (select

Line 328: from FND_ID_FLEX_STRUCTURES_TL B

324: ) = (select
325: B.ID_FLEX_STRUCTURE_NAME,
326: B.DESCRIPTION,
327: B.SHORTHAND_PROMPT
328: from FND_ID_FLEX_STRUCTURES_TL B
329: where B.APPLICATION_ID = T.APPLICATION_ID
330: and B.ID_FLEX_CODE = T.ID_FLEX_CODE
331: and B.ID_FLEX_NUM = T.ID_FLEX_NUM
332: and B.LANGUAGE = T.SOURCE_LANG)

Line 343: from FND_ID_FLEX_STRUCTURES_TL SUBB, FND_ID_FLEX_STRUCTURES_TL SUBT

339: SUBT.APPLICATION_ID,
340: SUBT.ID_FLEX_CODE,
341: SUBT.ID_FLEX_NUM,
342: SUBT.LANGUAGE
343: from FND_ID_FLEX_STRUCTURES_TL SUBB, FND_ID_FLEX_STRUCTURES_TL SUBT
344: where SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
345: and SUBB.ID_FLEX_CODE = SUBT.ID_FLEX_CODE
346: and SUBB.ID_FLEX_NUM = SUBT.ID_FLEX_NUM
347: and SUBB.LANGUAGE = SUBT.SOURCE_LANG

Line 358: insert into FND_ID_FLEX_STRUCTURES_TL (

354: or (SUBB.SHORTHAND_PROMPT is not null and SUBT.SHORTHAND_PROMPT is null)
355: ));
356: */
357:
358: insert into FND_ID_FLEX_STRUCTURES_TL (
359: APPLICATION_ID,
360: ID_FLEX_CODE,
361: ID_FLEX_NUM,
362: LAST_UPDATE_DATE,

Line 386: from FND_ID_FLEX_STRUCTURES_TL B, FND_LANGUAGES L

382: B.DESCRIPTION,
383: B.SHORTHAND_PROMPT,
384: L.LANGUAGE_CODE,
385: B.SOURCE_LANG
386: from FND_ID_FLEX_STRUCTURES_TL B, FND_LANGUAGES L
387: where L.INSTALLED_FLAG in ('I', 'B')
388: and B.LANGUAGE = userenv('LANG')
389: and not exists
390: (select NULL

Line 391: from FND_ID_FLEX_STRUCTURES_TL T

387: where L.INSTALLED_FLAG in ('I', 'B')
388: and B.LANGUAGE = userenv('LANG')
389: and not exists
390: (select NULL
391: from FND_ID_FLEX_STRUCTURES_TL T
392: where T.APPLICATION_ID = B.APPLICATION_ID
393: and T.ID_FLEX_CODE = B.ID_FLEX_CODE
394: and T.ID_FLEX_NUM = B.ID_FLEX_NUM
395: and T.LANGUAGE = L.LANGUAGE_CODE);

Line 435: FROM fnd_id_flex_structures

431:
432: BEGIN
433: SELECT id_flex_num
434: INTO l_id_flex_num
435: FROM fnd_id_flex_structures
436: WHERE application_id = l_application_id
437: AND id_flex_code = l_id_flex_code
438: AND id_flex_structure_code = x_id_flex_structure_code;
439:

Line 440: fnd_id_flex_structures_pkg.update_row

436: WHERE application_id = l_application_id
437: AND id_flex_code = l_id_flex_code
438: AND id_flex_structure_code = x_id_flex_structure_code;
439:
440: fnd_id_flex_structures_pkg.update_row
441: (X_APPLICATION_ID => l_application_id,
442: X_ID_FLEX_CODE => l_id_flex_code,
443: X_ID_FLEX_NUM => l_id_flex_num,
444: X_ID_FLEX_STRUCTURE_CODE => x_id_flex_structure_code,

Line 462: SELECT fnd_id_flex_structures_s.NEXTVAL

458: X_LAST_UPDATED_BY => x_who.last_updated_by,
459: X_LAST_UPDATE_LOGIN => x_who.last_update_login);
460: EXCEPTION
461: WHEN no_data_found THEN
462: SELECT fnd_id_flex_structures_s.NEXTVAL
463: INTO l_id_flex_num
464: FROM dual;
465:
466: fnd_id_flex_structures_pkg.insert_row

Line 466: fnd_id_flex_structures_pkg.insert_row

462: SELECT fnd_id_flex_structures_s.NEXTVAL
463: INTO l_id_flex_num
464: FROM dual;
465:
466: fnd_id_flex_structures_pkg.insert_row
467: (X_ROWID => l_rowid,
468: X_APPLICATION_ID => l_application_id,
469: X_ID_FLEX_CODE => l_id_flex_code,
470: X_ID_FLEX_NUM => l_id_flex_num,

Line 502: UPDATE fnd_id_flex_structures_tl SET

498: x_description IN VARCHAR2,
499: x_shorthand_prompt IN VARCHAR2)
500: IS
501: BEGIN
502: UPDATE fnd_id_flex_structures_tl SET
503: id_flex_structure_name = Nvl(x_id_flex_structure_name,
504: id_flex_structure_name),
505: description = Nvl(x_description, description),
506: shorthand_prompt = Nvl(x_shorthand_prompt, shorthand_prompt),

Line 513: FROM fnd_id_flex_structures

509: last_update_login = x_who.last_update_login,
510: source_lang = userenv('LANG')
511: WHERE ((application_id, id_flex_code, id_flex_num) =
512: (SELECT application_id, id_flex_code, id_flex_num
513: FROM fnd_id_flex_structures
514: WHERE (application_id =
515: (SELECT application_id
516: FROM fnd_application
517: WHERE application_short_name = x_application_short_name))

Line 523: end FND_ID_FLEX_STRUCTURES_PKG;

519: AND id_flex_structure_code = x_id_flex_structure_code))
520: AND userenv('LANG') in (language, source_lang);
521: END translate_row;
522:
523: end FND_ID_FLEX_STRUCTURES_PKG;