APPS.BIS_VG_UTIL dependencies on FND_DESCRIPTIVE_FLEXS_TL

Line 1525: , p_desc_flex_name IN fnd_descriptive_flexs_tl.descriptive_flexfield_name%TYPE

1521: AND application_column_name = p_app_column
1522: AND language = UPPER(p_language);
1523:
1524: CURSOR l_get_desc_ctxt_prmpt_cur(p_app_id IN NUMBER
1525: , p_desc_flex_name IN fnd_descriptive_flexs_tl.descriptive_flexfield_name%TYPE
1526: ) IS
1527: SELECT form_context_prompt
1528: FROM fnd_descriptive_flexs_tl
1529: WHERE application_id = p_app_id

Line 1528: FROM fnd_descriptive_flexs_tl

1524: CURSOR l_get_desc_ctxt_prmpt_cur(p_app_id IN NUMBER
1525: , p_desc_flex_name IN fnd_descriptive_flexs_tl.descriptive_flexfield_name%TYPE
1526: ) IS
1527: SELECT form_context_prompt
1528: FROM fnd_descriptive_flexs_tl
1529: WHERE application_id = p_app_id
1530: AND descriptive_flexfield_name = p_desc_flex_name
1531: AND language = UPPER(p_language);
1532:

Line 1534: , p_desc_flex_name IN fnd_descriptive_flexs_tl.descriptive_flexfield_name%TYPE

1530: AND descriptive_flexfield_name = p_desc_flex_name
1531: AND language = UPPER(p_language);
1532:
1533: CURSOR l_get_desc_seg_prmpt_cur(p_app_id IN NUMBER
1534: , p_desc_flex_name IN fnd_descriptive_flexs_tl.descriptive_flexfield_name%TYPE
1535: , p_context_code IN fnd_descr_flex_col_usage_tl.descriptive_flex_context_code%TYPE
1536: , p_app_column IN VARCHAR2
1537: ) IS
1538: SELECT form_above_prompt

Line 1561: l_desc_flex_name fnd_descriptive_flexs_tl.descriptive_flexfield_name%TYPE;

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:
1565: BEGIN