DBA Data[Home] [Help]

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 6575: fnd_descriptive_flexs_pkg.translate_row

6571:
6572: IF (g_debug_on) THEN
6573: debug(l_func_name, 'Translating DESC_FLEX.(MLS)');
6574: END IF;
6575: fnd_descriptive_flexs_pkg.translate_row
6576: (x_application_short_name => p_application_short_name,
6577: x_descriptive_flexfield_name => l_descriptive_flexfield_name,
6578: x_who => l_file_who,
6579: x_title => l_title,

Line 6712: fnd_descriptive_flexs_pkg.load_row

6708:
6709: IF (g_debug_on) THEN
6710: debug(l_func_name, 'Uploading DESC_FLEX.(MLS)');
6711: END IF;
6712: fnd_descriptive_flexs_pkg.load_row
6713: (x_application_short_name => p_application_short_name,
6714: x_descriptive_flexfield_name => l_descriptive_flexfield_name,
6715: x_who => l_file_who,
6716: x_table_application_short_name => p_table_application_short_name,

Line 7159: l_descriptive_flexfield_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE;

7155: l_dff_flx dff_flx_type;
7156: l_dff_ctx dff_ctx_type;
7157: l_dff_ctx_tl dff_ctx_tl_type;
7158: l_file_who who_type;
7159: l_descriptive_flexfield_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE;
7160: BEGIN
7161: l_func_name := g_api_name || 'up_dff_context()';
7162: l_descriptive_flexfield_name := p_descriptive_flexfield_name;
7163:

Line 7356: l_descriptive_flexfield_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE;

7352: l_dff_seg_tl dff_seg_tl_type;
7353: l_vst_set vst_set_type;
7354: l_col col_type;
7355: l_file_who who_type;
7356: l_descriptive_flexfield_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE;
7357: BEGIN
7358: l_func_name := g_api_name || 'up_dff_segment()';
7359: l_descriptive_flexfield_name := p_descriptive_flexfield_name;
7360: