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_LOADER_APIS dependencies on FND_DESCRIPTIVE_FLEXS

Line 81: SUBTYPE dff_flx_type IS fnd_descriptive_flexs%ROWTYPE;

77: SUBTYPE vst_val_type IS fnd_flex_values%ROWTYPE;
78: SUBTYPE vst_val_tl_type IS fnd_flex_values_tl%ROWTYPE;
79: SUBTYPE vst_vlh_type IS fnd_flex_value_norm_hierarchy%ROWTYPE;
80:
81: SUBTYPE dff_flx_type IS fnd_descriptive_flexs%ROWTYPE;
82: SUBTYPE dff_flx_tl_type IS fnd_descriptive_flexs_tl%ROWTYPE;
83: SUBTYPE dff_ref_type IS fnd_default_context_fields%ROWTYPE;
84: SUBTYPE dff_ctx_type IS fnd_descr_flex_contexts%ROWTYPE;
85: SUBTYPE dff_ctx_tl_type IS fnd_descr_flex_contexts_tl%ROWTYPE;

Line 82: SUBTYPE dff_flx_tl_type IS fnd_descriptive_flexs_tl%ROWTYPE;

78: SUBTYPE vst_val_tl_type IS fnd_flex_values_tl%ROWTYPE;
79: SUBTYPE vst_vlh_type IS fnd_flex_value_norm_hierarchy%ROWTYPE;
80:
81: SUBTYPE dff_flx_type IS fnd_descriptive_flexs%ROWTYPE;
82: SUBTYPE dff_flx_tl_type IS fnd_descriptive_flexs_tl%ROWTYPE;
83: SUBTYPE dff_ref_type IS fnd_default_context_fields%ROWTYPE;
84: SUBTYPE dff_ctx_type IS fnd_descr_flex_contexts%ROWTYPE;
85: SUBTYPE dff_ctx_tl_type IS fnd_descr_flex_contexts_tl%ROWTYPE;
86: SUBTYPE dff_seg_type IS fnd_descr_flex_column_usages%ROWTYPE;

Line 1941: FROM fnd_descriptive_flexs

1937: get_app(p_application_short_name, l_app);
1938:
1939: SELECT *
1940: INTO x_dff_flx
1941: FROM fnd_descriptive_flexs
1942: WHERE application_id = l_app.application_id
1943: AND descriptive_flexfield_name = p_descriptive_flexfield_name;
1944: RETURN TRUE;
1945: EXCEPTION

Line 1988: FROM fnd_descriptive_flexs_tl

1984: BEGIN
1985: l_func_name := g_api_name || 'get_dff_flx_tl(F)';
1986: SELECT *
1987: INTO x_dff_flx_tl
1988: FROM fnd_descriptive_flexs_tl
1989: WHERE application_id = p_dff_flx.application_id
1990: AND descriptive_flexfield_name = p_dff_flx.descriptive_flexfield_name
1991: AND language = p_language;
1992: RETURN TRUE;

Line 5881: FROM fnd_descriptive_flexs

5877:
5878: get_app(p_application_short_name, l_app);
5879:
5880: DELETE
5881: FROM fnd_descriptive_flexs
5882: WHERE application_id = l_app.application_id
5883: AND descriptive_flexfield_name = p_descriptive_flexfield_name;
5884:
5885: DELETE

Line 5886: FROM fnd_descriptive_flexs_tl

5882: WHERE application_id = l_app.application_id
5883: AND descriptive_flexfield_name = p_descriptive_flexfield_name;
5884:
5885: DELETE
5886: FROM fnd_descriptive_flexs_tl
5887: WHERE application_id = l_app.application_id
5888: AND descriptive_flexfield_name = p_descriptive_flexfield_name;
5889:
5890: DELETE

Line 5929: UPDATE fnd_descriptive_flexs

5925: l_func_name := g_api_name || 'rename_srs_loader_flex()';
5926:
5927: get_app(p_application_short_name, l_app);
5928:
5929: UPDATE fnd_descriptive_flexs
5930: SET descriptive_flexfield_name = p_descriptive_flexfield_name
5931: WHERE application_id = l_app.application_id
5932: AND descriptive_flexfield_name = g_srs_loader_flex_name;
5933:

Line 5934: UPDATE fnd_descriptive_flexs_tl

5930: SET descriptive_flexfield_name = p_descriptive_flexfield_name
5931: WHERE application_id = l_app.application_id
5932: AND descriptive_flexfield_name = g_srs_loader_flex_name;
5933:
5934: UPDATE fnd_descriptive_flexs_tl
5935: SET descriptive_flexfield_name = p_descriptive_flexfield_name,
5936: title = p_title
5937: WHERE application_id = l_app.application_id
5938: AND descriptive_flexfield_name = g_srs_loader_flex_name;

Line 6507: l_descriptive_flexfield_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE;

6503: l_dff_ctx dff_ctx_type;
6504: l_vst_set vst_set_type;
6505: l_app app_type;
6506: l_file_who who_type;
6507: l_descriptive_flexfield_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE;
6508: l_title fnd_descriptive_flexs_vl.title%TYPE;
6509: l_concatenated_segs_view_name fnd_descriptive_flexs_vl.concatenated_segs_view_name%TYPE;
6510: l_context_synchronization_flag fnd_descriptive_flexs.context_synchronization_flag%TYPE;
6511: BEGIN

Line 6508: l_title fnd_descriptive_flexs_vl.title%TYPE;

6504: l_vst_set vst_set_type;
6505: l_app app_type;
6506: l_file_who who_type;
6507: l_descriptive_flexfield_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE;
6508: l_title fnd_descriptive_flexs_vl.title%TYPE;
6509: l_concatenated_segs_view_name fnd_descriptive_flexs_vl.concatenated_segs_view_name%TYPE;
6510: l_context_synchronization_flag fnd_descriptive_flexs.context_synchronization_flag%TYPE;
6511: BEGIN
6512: l_func_name := g_api_name || 'up_desc_flex()';

Line 6509: l_concatenated_segs_view_name fnd_descriptive_flexs_vl.concatenated_segs_view_name%TYPE;

6505: l_app app_type;
6506: l_file_who who_type;
6507: l_descriptive_flexfield_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE;
6508: l_title fnd_descriptive_flexs_vl.title%TYPE;
6509: l_concatenated_segs_view_name fnd_descriptive_flexs_vl.concatenated_segs_view_name%TYPE;
6510: l_context_synchronization_flag fnd_descriptive_flexs.context_synchronization_flag%TYPE;
6511: BEGIN
6512: l_func_name := g_api_name || 'up_desc_flex()';
6513: l_descriptive_flexfield_name := p_descriptive_flexfield_name;

Line 6510: l_context_synchronization_flag fnd_descriptive_flexs.context_synchronization_flag%TYPE;

6506: l_file_who who_type;
6507: l_descriptive_flexfield_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE;
6508: l_title fnd_descriptive_flexs_vl.title%TYPE;
6509: l_concatenated_segs_view_name fnd_descriptive_flexs_vl.concatenated_segs_view_name%TYPE;
6510: l_context_synchronization_flag fnd_descriptive_flexs.context_synchronization_flag%TYPE;
6511: BEGIN
6512: l_func_name := g_api_name || 'up_desc_flex()';
6513: l_descriptive_flexfield_name := p_descriptive_flexfield_name;
6514: l_title := p_title;

Line 6581: fnd_descriptive_flexs_pkg.translate_row

6577:
6578: IF (g_debug_on) THEN
6579: debug(l_func_name, 'Translating DESC_FLEX.(MLS)');
6580: END IF;
6581: fnd_descriptive_flexs_pkg.translate_row
6582: (x_application_short_name => p_application_short_name,
6583: x_descriptive_flexfield_name => l_descriptive_flexfield_name,
6584: x_who => l_file_who,
6585: x_title => l_title,

Line 6718: fnd_descriptive_flexs_pkg.load_row

6714:
6715: IF (g_debug_on) THEN
6716: debug(l_func_name, 'Uploading DESC_FLEX.(MLS)');
6717: END IF;
6718: fnd_descriptive_flexs_pkg.load_row
6719: (x_application_short_name => p_application_short_name,
6720: x_descriptive_flexfield_name => l_descriptive_flexfield_name,
6721: x_who => l_file_who,
6722: x_table_application_short_name => p_table_application_short_name,

Line 7165: l_descriptive_flexfield_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE;

7161: l_dff_flx dff_flx_type;
7162: l_dff_ctx dff_ctx_type;
7163: l_dff_ctx_tl dff_ctx_tl_type;
7164: l_file_who who_type;
7165: l_descriptive_flexfield_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE;
7166: BEGIN
7167: l_func_name := g_api_name || 'up_dff_context()';
7168: l_descriptive_flexfield_name := p_descriptive_flexfield_name;
7169:

Line 7362: l_descriptive_flexfield_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE;

7358: l_dff_seg_tl dff_seg_tl_type;
7359: l_vst_set vst_set_type;
7360: l_col col_type;
7361: l_file_who who_type;
7362: l_descriptive_flexfield_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE;
7363: BEGIN
7364: l_func_name := g_api_name || 'up_dff_segment()';
7365: l_descriptive_flexfield_name := p_descriptive_flexfield_name;
7366:

Line 10936: l_descriptive_flexfield_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE;

10932: l_dff_ctx dff_ctx_type;
10933: l_vst_set vst_set_type;
10934: l_app app_type;
10935: l_file_who who_type;
10936: l_descriptive_flexfield_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE;
10937: l_title fnd_descriptive_flexs_vl.title%TYPE;
10938: l_concatenated_segs_view_name fnd_descriptive_flexs_vl.concatenated_segs_view_name%TYPE;
10939: l_context_synchronization_flag fnd_descriptive_flexs.context_synchronization_flag%TYPE;
10940: BEGIN

Line 10937: l_title fnd_descriptive_flexs_vl.title%TYPE;

10933: l_vst_set vst_set_type;
10934: l_app app_type;
10935: l_file_who who_type;
10936: l_descriptive_flexfield_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE;
10937: l_title fnd_descriptive_flexs_vl.title%TYPE;
10938: l_concatenated_segs_view_name fnd_descriptive_flexs_vl.concatenated_segs_view_name%TYPE;
10939: l_context_synchronization_flag fnd_descriptive_flexs.context_synchronization_flag%TYPE;
10940: BEGIN
10941: l_func_name := g_api_name || 'up_desc_flex_nls()';

Line 10938: l_concatenated_segs_view_name fnd_descriptive_flexs_vl.concatenated_segs_view_name%TYPE;

10934: l_app app_type;
10935: l_file_who who_type;
10936: l_descriptive_flexfield_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE;
10937: l_title fnd_descriptive_flexs_vl.title%TYPE;
10938: l_concatenated_segs_view_name fnd_descriptive_flexs_vl.concatenated_segs_view_name%TYPE;
10939: l_context_synchronization_flag fnd_descriptive_flexs.context_synchronization_flag%TYPE;
10940: BEGIN
10941: l_func_name := g_api_name || 'up_desc_flex_nls()';
10942: l_descriptive_flexfield_name := p_descriptive_flexfield_name;

Line 10939: l_context_synchronization_flag fnd_descriptive_flexs.context_synchronization_flag%TYPE;

10935: l_file_who who_type;
10936: l_descriptive_flexfield_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE;
10937: l_title fnd_descriptive_flexs_vl.title%TYPE;
10938: l_concatenated_segs_view_name fnd_descriptive_flexs_vl.concatenated_segs_view_name%TYPE;
10939: l_context_synchronization_flag fnd_descriptive_flexs.context_synchronization_flag%TYPE;
10940: BEGIN
10941: l_func_name := g_api_name || 'up_desc_flex_nls()';
10942: l_descriptive_flexfield_name := p_descriptive_flexfield_name;
10943: l_title := p_title;

Line 10990: fnd_descriptive_flexs_pkg.translate_row

10986: IF (g_debug_on) THEN
10987: debug(l_func_name, 'Translating DESC_FLEX.(MLS)');
10988: END IF;
10989:
10990: fnd_descriptive_flexs_pkg.translate_row
10991: (x_application_short_name => p_application_short_name,
10992: x_descriptive_flexfield_name => l_descriptive_flexfield_name,
10993: x_who => l_file_who,
10994: x_title => l_title,