APPS.BIS_VG_UTIL dependencies on FND_ID_FLEX_SEGMENTS

Line 1512: , p_flex_code IN fnd_id_flex_segments_tl.id_flex_code%TYPE

1508: AND owner = UPPER(p_view_owner)
1509: AND column_name = UPPER(p_column_name);
1510:
1511: CURSOR l_get_key_prmpt_cur(p_app_id IN NUMBER
1512: , p_flex_code IN fnd_id_flex_segments_tl.id_flex_code%TYPE
1513: , p_struc_num IN fnd_id_flex_segments_tl.id_flex_num%TYPE
1514: , p_app_column IN VARCHAR2
1515: ) IS
1516: SELECT form_above_prompt

Line 1513: , p_struc_num IN fnd_id_flex_segments_tl.id_flex_num%TYPE

1509: AND column_name = UPPER(p_column_name);
1510:
1511: CURSOR l_get_key_prmpt_cur(p_app_id IN NUMBER
1512: , p_flex_code IN fnd_id_flex_segments_tl.id_flex_code%TYPE
1513: , p_struc_num IN fnd_id_flex_segments_tl.id_flex_num%TYPE
1514: , p_app_column IN VARCHAR2
1515: ) IS
1516: SELECT form_above_prompt
1517: FROM fnd_id_flex_segments_tl

Line 1517: FROM fnd_id_flex_segments_tl

1513: , p_struc_num IN fnd_id_flex_segments_tl.id_flex_num%TYPE
1514: , p_app_column IN VARCHAR2
1515: ) IS
1516: SELECT form_above_prompt
1517: FROM fnd_id_flex_segments_tl
1518: WHERE application_id = p_app_id
1519: AND id_flex_code = p_flex_code
1520: AND id_flex_num = p_struc_num
1521: AND application_column_name = p_app_column

Line 1557: l_flex_code fnd_id_flex_segments_tl.id_flex_code%TYPE;

1553: l_prompt VARCHAR2(80) :='';
1554: l_comma_pointer_1 NUMBER;
1555: l_comma_pointer_2 NUMBER;
1556: l_app_id NUMBER;
1557: l_flex_code fnd_id_flex_segments_tl.id_flex_code%TYPE;
1558: l_struc_num fnd_id_flex_segments_tl.id_flex_num%TYPE;
1559: l_app_column VARCHAR2(30);
1560: l_seg_name fnd_id_flex_segments.segment_name%TYPE;
1561: l_desc_flex_name fnd_descriptive_flexs_tl.descriptive_flexfield_name%TYPE;

Line 1558: l_struc_num fnd_id_flex_segments_tl.id_flex_num%TYPE;

1554: l_comma_pointer_1 NUMBER;
1555: l_comma_pointer_2 NUMBER;
1556: l_app_id NUMBER;
1557: l_flex_code fnd_id_flex_segments_tl.id_flex_code%TYPE;
1558: l_struc_num fnd_id_flex_segments_tl.id_flex_num%TYPE;
1559: l_app_column VARCHAR2(30);
1560: l_seg_name fnd_id_flex_segments.segment_name%TYPE;
1561: l_desc_flex_name fnd_descriptive_flexs_tl.descriptive_flexfield_name%TYPE;
1562: l_context_code fnd_descr_flex_col_usage_tl.descriptive_flex_context_code%TYPE;

Line 1560: l_seg_name fnd_id_flex_segments.segment_name%TYPE;

1556: l_app_id NUMBER;
1557: l_flex_code fnd_id_flex_segments_tl.id_flex_code%TYPE;
1558: l_struc_num fnd_id_flex_segments_tl.id_flex_num%TYPE;
1559: l_app_column VARCHAR2(30);
1560: l_seg_name fnd_id_flex_segments.segment_name%TYPE;
1561: l_desc_flex_name fnd_descriptive_flexs_tl.descriptive_flexfield_name%TYPE;
1562: l_context_code fnd_descr_flex_col_usage_tl.descriptive_flex_context_code%TYPE;
1563: --v_debug VARCHAR2(100);
1564: