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_FLEX_DIAGNOSE dependencies on FND_COLUMNS

Line 15: SUBTYPE col_type IS fnd_columns%ROWTYPE;

11: g_newline VARCHAR2(10);
12:
13: SUBTYPE app_type IS fnd_application%ROWTYPE;
14: SUBTYPE tbl_type IS fnd_tables%ROWTYPE;
15: SUBTYPE col_type IS fnd_columns%ROWTYPE;
16: SUBTYPE rsp_type IS fnd_responsibility%ROWTYPE;
17:
18: SUBTYPE vst_set_type IS fnd_flex_value_sets%ROWTYPE;
19: SUBTYPE vst_tbl_type IS fnd_flex_validation_tables%ROWTYPE;

Line 90: -- Updates flexfield info in fnd_columns.

86: RETURN(Substr(p_in, 1, g_text_size));
87: END text_return;
88:
89: -- ---------------------------------------------------------------------------
90: -- Updates flexfield info in fnd_columns.
91: --
92: FUNCTION update_fnd_columns(p_col IN col_type,
93: p_flexfield_usage_code IN VARCHAR2,
94: p_flexfield_application_id IN NUMBER,

Line 92: FUNCTION update_fnd_columns(p_col IN col_type,

88:
89: -- ---------------------------------------------------------------------------
90: -- Updates flexfield info in fnd_columns.
91: --
92: FUNCTION update_fnd_columns(p_col IN col_type,
93: p_flexfield_usage_code IN VARCHAR2,
94: p_flexfield_application_id IN NUMBER,
95: p_flexfield_name IN VARCHAR2,
96: x_message OUT nocopy VARCHAR2)

Line 100: UPDATE fnd_columns SET

96: x_message OUT nocopy VARCHAR2)
97: RETURN BOOLEAN
98: IS
99: BEGIN
100: UPDATE fnd_columns SET
101: flexfield_usage_code = p_flexfield_usage_code,
102: flexfield_application_id = p_flexfield_application_id,
103: flexfield_name = p_flexfield_name,
104: last_update_date = Sysdate,

Line 113: x_message := 'Unable to update FND_COLUMNS. ' || Sqlerrm;

109: x_message := SQL%rowcount || ' row(s) updated.';
110: RETURN (TRUE);
111: EXCEPTION
112: WHEN OTHERS THEN
113: x_message := 'Unable to update FND_COLUMNS. ' || Sqlerrm;
114: RETURN(FALSE);
115: END update_fnd_columns;
116:
117: -- ---------------------------------------------------------------------------

Line 115: END update_fnd_columns;

111: EXCEPTION
112: WHEN OTHERS THEN
113: x_message := 'Unable to update FND_COLUMNS. ' || Sqlerrm;
114: RETURN(FALSE);
115: END update_fnd_columns;
116:
117: -- ---------------------------------------------------------------------------
118: -- Returns 'Unable to select from...' error.
119: --

Line 201: FROM fnd_columns

197: IS
198: BEGIN
199: SELECT *
200: INTO x_col
201: FROM fnd_columns
202: WHERE application_id = p_tbl.application_id
203: AND table_id = p_tbl.table_id
204: AND column_name = p_column_name;
205: RETURN(TRUE);

Line 208: x_message := msg_uts('FND_COLUMNS',

204: AND column_name = p_column_name;
205: RETURN(TRUE);
206: EXCEPTION
207: WHEN OTHERS THEN
208: x_message := msg_uts('FND_COLUMNS',
209: 'application_id', p_tbl.application_id,
210: 'table_id', p_tbl.table_id,
211: 'column_name', p_column_name);
212: RETURN(FALSE);

Line 947: FROM fnd_columns

943: flexfield_usage_code || '/' ||
944: Nvl(To_char(flexfield_application_id), '') || '/' ||
945: Nvl(flexfield_name, '')
946: INTO l_return
947: FROM fnd_columns
948: WHERE ((application_id, table_id) =
949: (SELECT application_id, table_id
950: FROM fnd_tables
951: WHERE application_id = p_application_id

Line 2577: FROM fnd_columns fc, fnd_tables ft, fnd_descriptive_flexs df

2573: fc.flexfield_usage_code || '/' ||
2574: Nvl(To_char(fc.flexfield_application_id), '') || '/' ||
2575: Nvl(fc.flexfield_name, '')
2576: INTO l_return
2577: FROM fnd_columns fc, fnd_tables ft, fnd_descriptive_flexs df
2578: WHERE df.application_id = p_application_id
2579: AND df.descriptive_flexfield_name = p_descriptive_flexfield_name
2580: AND ft.application_id = df.table_application_id
2581: AND ft.table_name = df.application_table_name

Line 2763: IF (update_fnd_columns(l_col,

2759: x_message := 'Context column is properly registered. No need to fix.';
2760: GOTO return_error;
2761: END IF;
2762:
2763: IF (update_fnd_columns(l_col,
2764: 'C',
2765: l_dff_flx.application_id,
2766: l_dff_flx.descriptive_flexfield_name,
2767: x_message)) THEN

Line 3265: IF (update_fnd_columns(l_col,

3261: x_message := 'Segment column is registered properly. No need to fix.';
3262: GOTO return_error;
3263: END IF;
3264:
3265: IF (update_fnd_columns(l_col,
3266: 'D',
3267: l_dff_flx.application_id,
3268: l_dff_flx.descriptive_flexfield_name,
3269: x_message)) THEN

Line 3431: IF (update_fnd_columns(l_col, 'N', NULL, NULL, x_message)) THEN

3427: GOTO return_error;
3428: END IF;
3429: END IF;
3430:
3431: IF (update_fnd_columns(l_col, 'N', NULL, NULL, x_message)) THEN
3432: GOTO return_success;
3433: ELSE
3434: GOTO return_error;
3435: END IF;

Line 3461: IF (update_fnd_columns(l_col, 'N', NULL, NULL, x_message)) THEN

3457: GOTO return_error;
3458: END IF;
3459: END IF;
3460:
3461: IF (update_fnd_columns(l_col, 'N', NULL, NULL, x_message)) THEN
3462: GOTO return_success;
3463: ELSE
3464: GOTO return_error;
3465: END IF;

Line 3754: FROM fnd_columns fc, fnd_tables ft, fnd_id_flexs idf

3750: fc.flexfield_usage_code || '/' ||
3751: Nvl(To_char(fc.flexfield_application_id), '') || '/' ||
3752: Nvl(fc.flexfield_name, '')
3753: INTO l_return
3754: FROM fnd_columns fc, fnd_tables ft, fnd_id_flexs idf
3755: WHERE idf.application_id = p_application_id
3756: AND idf.id_flex_code = p_id_flex_code
3757: AND ft.application_id = idf.table_application_id
3758: AND ft.table_name = idf.application_table_name

Line 4240: IF (update_fnd_columns(l_col,

4236: x_message := 'CCID column is properly registered. No need to fix.';
4237: GOTO return_error;
4238: END IF;
4239:
4240: IF (update_fnd_columns(l_col,
4241: 'I',
4242: NULL, -- l_kff_flx.application_id,
4243: NULL, -- l_kff_flx.id_flex_code,
4244: x_message)) THEN

Line 4279: IF (update_fnd_columns(l_col,

4275: x_message := 'Structure column is properly registered. No need to fix.';
4276: GOTO return_error;
4277: END IF;
4278:
4279: IF (update_fnd_columns(l_col,
4280: 'S',
4281: NULL, -- l_kff_flx.application_id,
4282: NULL, -- l_kff_flx.id_flex_code,
4283: x_message)) THEN

Line 4658: IF (update_fnd_columns(l_col,

4654: x_message := 'Segment column is properly registered. No need to fix.';
4655: GOTO return_error;
4656: END IF;
4657:
4658: IF (update_fnd_columns(l_col,
4659: 'K',
4660: NULL, -- l_kff_flx.application_id,
4661: NULL, -- l_kff_flx.id_flex_code,
4662: x_message)) THEN

Line 5680: IF (update_fnd_columns(l_col,

5676: x_message := 'Qualifier column is properly registered. No need to fix.';
5677: GOTO return_error;
5678: END IF;
5679:
5680: IF (update_fnd_columns(l_col,
5681: 'Q',
5682: NULL, -- l_kff_flx.application_id,
5683: NULL, -- l_kff_flx.id_flex_code,
5684: x_message)) THEN

Line 5857: IF (update_fnd_columns(l_col, 'N', NULL, NULL, x_message)) THEN

5853: x_message := 'Unable to select from FND_ID_FLEXS. ' || Sqlerrm;
5854: GOTO return_error;
5855: END;
5856:
5857: IF (update_fnd_columns(l_col, 'N', NULL, NULL, x_message)) THEN
5858: GOTO return_success;
5859: ELSE
5860: GOTO return_error;
5861: END IF;

Line 5893: IF (update_fnd_columns(l_col, 'N', NULL, NULL, x_message)) THEN

5889: x_message := 'Unable to select from FND_ID_FLEXS. ' || Sqlerrm;
5890: GOTO return_error;
5891: END;
5892:
5893: IF (update_fnd_columns(l_col, 'N', NULL, NULL, x_message)) THEN
5894: GOTO return_success;
5895: ELSE
5896: GOTO return_error;
5897: END IF;

Line 5928: IF (update_fnd_columns(l_col, 'N', NULL, NULL, x_message)) THEN

5924: x_message := 'Unable to select from FND_ID_FLEXS. ' || Sqlerrm;
5925: GOTO return_error;
5926: END;
5927:
5928: IF (update_fnd_columns(l_col, 'N', NULL, NULL, x_message)) THEN
5929: GOTO return_success;
5930: ELSE
5931: GOTO return_error;
5932: END IF;

Line 5981: IF (update_fnd_columns(l_col, 'N', NULL, NULL, x_message)) THEN

5977: x_message := 'Unable to select from FND_ID_FLEXS. ' || Sqlerrm;
5978: GOTO return_error;
5979: END;
5980:
5981: IF (update_fnd_columns(l_col, 'N', NULL, NULL, x_message)) THEN
5982: GOTO return_success;
5983: ELSE
5984: GOTO return_error;
5985: END IF;