DBA Data[Home] [Help]

APPS.FND_FLEX_SERVER dependencies on FND_FLEX_KEY_API

Line 6256: l_flextype FND_FLEX_KEY_API.FLEXFIELD_TYPE;

6252: l_nsegments NUMBER;
6253: l_message VARCHAR2(1000);
6254: l_validation_type VARCHAR2(1000);
6255: l_format_type VARCHAR2(1000);
6256: l_flextype FND_FLEX_KEY_API.FLEXFIELD_TYPE;
6257: l_strctype FND_FLEX_KEY_API.STRUCTURE_TYPE;
6258: l_segtype FND_FLEX_KEY_API.SEGMENT_TYPE;
6259: l_seglist FND_FLEX_KEY_API.SEGMENT_LIST;
6260: l_vset_r FND_VSET.VALUESET_R;

Line 6257: l_strctype FND_FLEX_KEY_API.STRUCTURE_TYPE;

6253: l_message VARCHAR2(1000);
6254: l_validation_type VARCHAR2(1000);
6255: l_format_type VARCHAR2(1000);
6256: l_flextype FND_FLEX_KEY_API.FLEXFIELD_TYPE;
6257: l_strctype FND_FLEX_KEY_API.STRUCTURE_TYPE;
6258: l_segtype FND_FLEX_KEY_API.SEGMENT_TYPE;
6259: l_seglist FND_FLEX_KEY_API.SEGMENT_LIST;
6260: l_vset_r FND_VSET.VALUESET_R;
6261: l_vset_dr FND_VSET.VALUESET_DR;

Line 6258: l_segtype FND_FLEX_KEY_API.SEGMENT_TYPE;

6254: l_validation_type VARCHAR2(1000);
6255: l_format_type VARCHAR2(1000);
6256: l_flextype FND_FLEX_KEY_API.FLEXFIELD_TYPE;
6257: l_strctype FND_FLEX_KEY_API.STRUCTURE_TYPE;
6258: l_segtype FND_FLEX_KEY_API.SEGMENT_TYPE;
6259: l_seglist FND_FLEX_KEY_API.SEGMENT_LIST;
6260: l_vset_r FND_VSET.VALUESET_R;
6261: l_vset_dr FND_VSET.VALUESET_DR;
6262:

Line 6259: l_seglist FND_FLEX_KEY_API.SEGMENT_LIST;

6255: l_format_type VARCHAR2(1000);
6256: l_flextype FND_FLEX_KEY_API.FLEXFIELD_TYPE;
6257: l_strctype FND_FLEX_KEY_API.STRUCTURE_TYPE;
6258: l_segtype FND_FLEX_KEY_API.SEGMENT_TYPE;
6259: l_seglist FND_FLEX_KEY_API.SEGMENT_LIST;
6260: l_vset_r FND_VSET.VALUESET_R;
6261: l_vset_dr FND_VSET.VALUESET_DR;
6262:
6263: PROCEDURE compute_segment_warnings (p_application_column_name IN VARCHAR2)

Line 6270: l_segtype := fnd_flex_key_api.find_segment(l_flextype, l_strctype, p_application_column_name);

6266: l_num_binds NUMBER;
6267: i NUMBER;
6268: BEGIN
6269:
6270: l_segtype := fnd_flex_key_api.find_segment(l_flextype, l_strctype, p_application_column_name);
6271:
6272: if (l_segtype.value_set_id is not null) then
6273:
6274: fnd_vset.get_valueset(l_segtype.value_set_id, l_vset_r, l_vset_dr);

Line 6371: fnd_flex_key_api.set_session_mode(session_mode => 'customer_data');

6367: BEGIN
6368:
6369: g_non_forms_warnings_count := 0;
6370:
6371: fnd_flex_key_api.set_session_mode(session_mode => 'customer_data');
6372:
6373: select application_short_name, application_name
6374: into l_application_short_name, l_application_name
6375: from fnd_application_vl

Line 6384: l_flextype := fnd_flex_key_api.find_flexfield(appl_short_name => l_application_short_name, flex_code => p_id_flex_code);

6380: where application_id=p_application_id
6381: and id_flex_code=p_id_flex_code
6382: and id_flex_num=p_id_flex_num;
6383:
6384: l_flextype := fnd_flex_key_api.find_flexfield(appl_short_name => l_application_short_name, flex_code => p_id_flex_code);
6385:
6386: l_strctype := fnd_flex_key_api.find_structure(l_flextype, l_id_flex_structure_code);
6387:
6388: fnd_flex_key_api.get_segments(l_flextype, l_strctype, TRUE, l_nsegments, l_seglist);

Line 6386: l_strctype := fnd_flex_key_api.find_structure(l_flextype, l_id_flex_structure_code);

6382: and id_flex_num=p_id_flex_num;
6383:
6384: l_flextype := fnd_flex_key_api.find_flexfield(appl_short_name => l_application_short_name, flex_code => p_id_flex_code);
6385:
6386: l_strctype := fnd_flex_key_api.find_structure(l_flextype, l_id_flex_structure_code);
6387:
6388: fnd_flex_key_api.get_segments(l_flextype, l_strctype, TRUE, l_nsegments, l_seglist);
6389:
6390: for i in 1..l_nsegments loop

Line 6388: fnd_flex_key_api.get_segments(l_flextype, l_strctype, TRUE, l_nsegments, l_seglist);

6384: l_flextype := fnd_flex_key_api.find_flexfield(appl_short_name => l_application_short_name, flex_code => p_id_flex_code);
6385:
6386: l_strctype := fnd_flex_key_api.find_structure(l_flextype, l_id_flex_structure_code);
6387:
6388: fnd_flex_key_api.get_segments(l_flextype, l_strctype, TRUE, l_nsegments, l_seglist);
6389:
6390: for i in 1..l_nsegments loop
6391:
6392: compute_segment_warnings(l_seglist(i));