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_SEGMENTS_PKG dependencies on FND_ID_FLEX_SEGMENTS

Line 1: package body FND_ID_FLEX_SEGMENTS_PKG as

1: package body FND_ID_FLEX_SEGMENTS_PKG as
2: /* $Header: AFFFSEGB.pls 120.1.12010000.1 2008/07/25 14:14:17 appldev ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_APPLICATION_ID in NUMBER,

Line 34: cursor C is select ROWID from FND_ID_FLEX_SEGMENTS

30: X_LAST_UPDATE_DATE in DATE,
31: X_LAST_UPDATED_BY in NUMBER,
32: X_LAST_UPDATE_LOGIN in NUMBER
33: ) is
34: cursor C is select ROWID from FND_ID_FLEX_SEGMENTS
35: where APPLICATION_ID = X_APPLICATION_ID
36: and ID_FLEX_CODE = X_ID_FLEX_CODE
37: and ID_FLEX_NUM = X_ID_FLEX_NUM
38: and APPLICATION_COLUMN_NAME = X_APPLICATION_COLUMN_NAME

Line 41: insert into FND_ID_FLEX_SEGMENTS (

37: and ID_FLEX_NUM = X_ID_FLEX_NUM
38: and APPLICATION_COLUMN_NAME = X_APPLICATION_COLUMN_NAME
39: ;
40: begin
41: insert into FND_ID_FLEX_SEGMENTS (
42: ADDITIONAL_WHERE_CLAUSE,
43: APPLICATION_ID,
44: ID_FLEX_CODE,
45: ID_FLEX_NUM,

Line 95: insert into FND_ID_FLEX_SEGMENTS_TL (

91: X_LAST_UPDATED_BY,
92: X_LAST_UPDATE_LOGIN
93: );
94:
95: insert into FND_ID_FLEX_SEGMENTS_TL (
96: APPLICATION_ID,
97: ID_FLEX_CODE,
98: ID_FLEX_NUM,
99: APPLICATION_COLUMN_NAME,

Line 129: from FND_ID_FLEX_SEGMENTS_TL T

125: from FND_LANGUAGES L
126: where L.INSTALLED_FLAG in ('I', 'B')
127: and not exists
128: (select NULL
129: from FND_ID_FLEX_SEGMENTS_TL T
130: where T.APPLICATION_ID = X_APPLICATION_ID
131: and T.ID_FLEX_CODE = X_ID_FLEX_CODE
132: and T.ID_FLEX_NUM = X_ID_FLEX_NUM
133: and T.APPLICATION_COLUMN_NAME = X_APPLICATION_COLUMN_NAME

Line 188: from FND_ID_FLEX_SEGMENTS

184: RANGE_CODE,
185: DEFAULT_TYPE,
186: DEFAULT_VALUE,
187: RUNTIME_PROPERTY_FUNCTION
188: from FND_ID_FLEX_SEGMENTS
189: where APPLICATION_ID = X_APPLICATION_ID
190: and ID_FLEX_CODE = X_ID_FLEX_CODE
191: and ID_FLEX_NUM = X_ID_FLEX_NUM
192: and APPLICATION_COLUMN_NAME = X_APPLICATION_COLUMN_NAME

Line 201: from FND_ID_FLEX_SEGMENTS_TL

197: FORM_LEFT_PROMPT,
198: FORM_ABOVE_PROMPT,
199: DESCRIPTION,
200: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
201: from FND_ID_FLEX_SEGMENTS_TL
202: where APPLICATION_ID = X_APPLICATION_ID
203: and ID_FLEX_CODE = X_ID_FLEX_CODE
204: and ID_FLEX_NUM = X_ID_FLEX_NUM
205: and APPLICATION_COLUMN_NAME = X_APPLICATION_COLUMN_NAME

Line 292: update FND_ID_FLEX_SEGMENTS set

288: X_LAST_UPDATED_BY in NUMBER,
289: X_LAST_UPDATE_LOGIN in NUMBER
290: ) is
291: begin
292: update FND_ID_FLEX_SEGMENTS set
293: ADDITIONAL_WHERE_CLAUSE = X_ADDITIONAL_WHERE_CLAUSE,
294: SEGMENT_NAME = X_SEGMENT_NAME,
295: SEGMENT_NUM = X_SEGMENT_NUM,
296: APPLICATION_COLUMN_INDEX_FLAG = X_APPLICATION_COLUMN_INDEX_FLA,

Line 321: update FND_ID_FLEX_SEGMENTS_TL set

317: if (sql%notfound) then
318: raise no_data_found;
319: end if;
320:
321: update FND_ID_FLEX_SEGMENTS_TL set
322: FORM_LEFT_PROMPT = X_FORM_LEFT_PROMPT,
323: FORM_ABOVE_PROMPT = X_FORM_ABOVE_PROMPT,
324: DESCRIPTION = X_DESCRIPTION,
325: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 347: delete from FND_ID_FLEX_SEGMENTS_TL

343: X_ID_FLEX_NUM in NUMBER,
344: X_APPLICATION_COLUMN_NAME in VARCHAR2
345: ) is
346: begin
347: delete from FND_ID_FLEX_SEGMENTS_TL
348: where APPLICATION_ID = X_APPLICATION_ID
349: and ID_FLEX_CODE = X_ID_FLEX_CODE
350: and ID_FLEX_NUM = X_ID_FLEX_NUM
351: and APPLICATION_COLUMN_NAME = X_APPLICATION_COLUMN_NAME;

Line 357: delete from FND_ID_FLEX_SEGMENTS

353: if (sql%notfound) then
354: raise no_data_found;
355: end if;
356:
357: delete from FND_ID_FLEX_SEGMENTS
358: where APPLICATION_ID = X_APPLICATION_ID
359: and ID_FLEX_CODE = X_ID_FLEX_CODE
360: and ID_FLEX_NUM = X_ID_FLEX_NUM
361: and APPLICATION_COLUMN_NAME = X_APPLICATION_COLUMN_NAME;

Line 391: delete from FND_ID_FLEX_SEGMENTS_TL T

387: /* as a quick workaround to fix the time-consuming table handler issue */
388: /* Eventually we'll need to turn them into a separate fix_language procedure */
389: /*
390:
391: delete from FND_ID_FLEX_SEGMENTS_TL T
392: where not exists
393: (select NULL
394: from FND_ID_FLEX_SEGMENTS B
395: where B.APPLICATION_ID = T.APPLICATION_ID

Line 394: from FND_ID_FLEX_SEGMENTS B

390:
391: delete from FND_ID_FLEX_SEGMENTS_TL T
392: where not exists
393: (select NULL
394: from FND_ID_FLEX_SEGMENTS B
395: where B.APPLICATION_ID = T.APPLICATION_ID
396: and B.ID_FLEX_CODE = T.ID_FLEX_CODE
397: and B.ID_FLEX_NUM = T.ID_FLEX_NUM
398: and B.APPLICATION_COLUMN_NAME = T.APPLICATION_COLUMN_NAME

Line 401: update FND_ID_FLEX_SEGMENTS_TL T set (

397: and B.ID_FLEX_NUM = T.ID_FLEX_NUM
398: and B.APPLICATION_COLUMN_NAME = T.APPLICATION_COLUMN_NAME
399: );
400:
401: update FND_ID_FLEX_SEGMENTS_TL T set (
402: FORM_LEFT_PROMPT,
403: FORM_ABOVE_PROMPT,
404: DESCRIPTION
405: ) = (select

Line 409: from FND_ID_FLEX_SEGMENTS_TL B

405: ) = (select
406: B.FORM_LEFT_PROMPT,
407: B.FORM_ABOVE_PROMPT,
408: B.DESCRIPTION
409: from FND_ID_FLEX_SEGMENTS_TL B
410: where B.APPLICATION_ID = T.APPLICATION_ID
411: and B.ID_FLEX_CODE = T.ID_FLEX_CODE
412: and B.ID_FLEX_NUM = T.ID_FLEX_NUM
413: and B.APPLICATION_COLUMN_NAME = T.APPLICATION_COLUMN_NAME

Line 427: from FND_ID_FLEX_SEGMENTS_TL SUBB, FND_ID_FLEX_SEGMENTS_TL SUBT

423: SUBT.ID_FLEX_CODE,
424: SUBT.ID_FLEX_NUM,
425: SUBT.APPLICATION_COLUMN_NAME,
426: SUBT.LANGUAGE
427: from FND_ID_FLEX_SEGMENTS_TL SUBB, FND_ID_FLEX_SEGMENTS_TL SUBT
428: where SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
429: and SUBB.ID_FLEX_CODE = SUBT.ID_FLEX_CODE
430: and SUBB.ID_FLEX_NUM = SUBT.ID_FLEX_NUM
431: and SUBB.APPLICATION_COLUMN_NAME = SUBT.APPLICATION_COLUMN_NAME

Line 441: insert into FND_ID_FLEX_SEGMENTS_TL (

437: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
438: ));
439: */
440:
441: insert into FND_ID_FLEX_SEGMENTS_TL (
442: APPLICATION_ID,
443: ID_FLEX_CODE,
444: ID_FLEX_NUM,
445: APPLICATION_COLUMN_NAME,

Line 471: from FND_ID_FLEX_SEGMENTS_TL B, FND_LANGUAGES L

467: B.FORM_ABOVE_PROMPT,
468: B.DESCRIPTION,
469: L.LANGUAGE_CODE,
470: B.SOURCE_LANG
471: from FND_ID_FLEX_SEGMENTS_TL B, FND_LANGUAGES L
472: where L.INSTALLED_FLAG in ('I', 'B')
473: and B.LANGUAGE = userenv('LANG')
474: and not exists
475: (select NULL

Line 476: from FND_ID_FLEX_SEGMENTS_TL T

472: where L.INSTALLED_FLAG in ('I', 'B')
473: and B.LANGUAGE = userenv('LANG')
474: and not exists
475: (select NULL
476: from FND_ID_FLEX_SEGMENTS_TL T
477: where T.APPLICATION_ID = B.APPLICATION_ID
478: and T.ID_FLEX_CODE = B.ID_FLEX_CODE
479: and T.ID_FLEX_NUM = B.ID_FLEX_NUM
480: and T.APPLICATION_COLUMN_NAME = B.APPLICATION_COLUMN_NAME

Line 542: fnd_id_flex_segments_pkg.update_row

538: WHERE flex_value_set_name = x_flex_value_set_name;
539: END IF;
540:
541: BEGIN
542: fnd_id_flex_segments_pkg.update_row
543: (X_APPLICATION_ID => l_application_id,
544: X_ID_FLEX_CODE => l_id_flex_code,
545: X_ID_FLEX_NUM => l_id_flex_num,
546: X_APPLICATION_COLUMN_NAME => x_application_column_name,

Line 571: fnd_id_flex_segments_pkg.insert_row

567: X_LAST_UPDATED_BY => x_who.last_updated_by,
568: X_LAST_UPDATE_LOGIN => x_who.last_update_login);
569: EXCEPTION
570: WHEN no_data_found THEN
571: fnd_id_flex_segments_pkg.insert_row
572: (X_ROWID => l_rowid,
573: X_APPLICATION_ID => l_application_id,
574: X_ID_FLEX_CODE => l_id_flex_code,
575: X_ID_FLEX_NUM => l_id_flex_num,

Line 615: UPDATE fnd_id_flex_segments_tl SET

611: x_form_above_prompt IN VARCHAR2,
612: x_description IN VARCHAR2)
613: IS
614: BEGIN
615: UPDATE fnd_id_flex_segments_tl SET
616: form_left_prompt = Nvl(x_form_left_prompt, form_left_prompt),
617: form_above_prompt = Nvl(x_form_above_prompt, form_above_prompt),
618: description = Nvl(x_description, description),
619: last_update_date = x_who.last_update_date,

Line 636: end FND_ID_FLEX_SEGMENTS_PKG;

632: AND application_column_name = x_application_column_name
633: AND userenv('LANG') in (language, source_lang);
634: END translate_row;
635:
636: end FND_ID_FLEX_SEGMENTS_PKG;