DBA Data[Home] [Help]

APPS.PQP_OSS_DFF_UTILS dependencies on FND_DESCR_FLEX_COLUMN_USAGES

Line 17: fnd_descr_flex_column_usages.flex_value_set_id%TYPE) IS

13: RETURN Varchar2 IS
14:
15: -- Cursor to check if the passed segment is a Date Field
16: CURSOR csr_get_valset_name (c_val_set_id IN
17: fnd_descr_flex_column_usages.flex_value_set_id%TYPE) IS
18: SELECT flex_value_set_name
19: FROM fnd_flex_value_sets
20: WHERE flex_value_set_id = c_val_set_id;
21:

Line 71: FROM fnd_descr_flex_column_usages

67: CURSOR csr_get_segments(c_ddf_name IN Varchar2
68: ,c_context_value IN Varchar2
69: ,c_app_id IN Number) IS
70: SELECT application_column_name, flex_value_set_id
71: FROM fnd_descr_flex_column_usages
72: WHERE descriptive_flexfield_name = c_ddf_name
73: AND descriptive_flex_context_code IN ('Global Data Elements', c_context_value)
74: AND enabled_flag = 'Y'
75: AND display_flag = 'Y'

Line 87: l_dff_ctx_val fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE;

83:
84: l_func_name CONSTANT Varchar2(150):= g_pkg ||'pqp_oss_get_concat_ddfsegs';
85:
86: l_delimiter fnd_descriptive_flexs.concatenated_segment_delimiter%TYPE;
87: l_dff_ctx_val fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE;
88:
89: l_delim_ctx_rec t_delim_contxt;
90: l_seg_val_rec t_seg_valsetid;
91: