APPS.FND_FLEX_WORKFLOW_APIS dependencies on FND_ID_FLEX_SEGMENTS

Line 473: l_segment_name fnd_id_flex_segments.segment_name%TYPE;

469: p_segment_identifier IN VARCHAR2,
470: x_segment_index OUT nocopy NUMBER)
471: RETURN BOOLEAN
472: IS
473: l_segment_name fnd_id_flex_segments.segment_name%TYPE;
474: l_segment_index NUMBER;
475: l_segment_num NUMBER;
476: BEGIN
477: --

Line 510: FROM fnd_id_flex_segments s,

506: l_segment_name := g_cache_value.varchar2_1;
507: ELSE
508: SELECT s.segment_name
509: INTO l_segment_name
510: FROM fnd_id_flex_segments s,
511: fnd_segment_attribute_values sav,
512: fnd_segment_attribute_types sat
513: WHERE s.application_id = p_application_id
514: AND s.id_flex_code = p_id_flex_code

Line 573: FROM fnd_id_flex_segments

569: l_segment_index := g_cache_value.number_2;
570: ELSE
571: SELECT segment_num
572: INTO l_segment_num
573: FROM fnd_id_flex_segments
574: WHERE application_id = p_application_id
575: AND id_flex_code = p_id_flex_code
576: AND id_flex_num = p_id_flex_num
577: AND segment_name = l_segment_name

Line 586: FROM fnd_id_flex_segments

582: -- segments. Convert it into the segment index.
583: --
584: SELECT count(segment_num)
585: INTO l_segment_index
586: FROM fnd_id_flex_segments
587: WHERE application_id = p_application_id
588: AND id_flex_code = p_id_flex_code
589: AND id_flex_num = p_id_flex_num
590: AND enabled_flag = 'Y'

Line 1536: FROM fnd_id_flex_segments

1532: CURSOR cur(p_application_id IN NUMBER,
1533: p_id_flex_code IN VARCHAR2,
1534: p_id_flex_num IN NUMBER) IS
1535: SELECT required_flag
1536: FROM fnd_id_flex_segments
1537: WHERE application_id = p_application_id
1538: AND id_flex_code = p_id_flex_code
1539: AND id_flex_num = p_id_flex_num
1540: AND enabled_flag = 'Y'