DBA Data[Home] [Help]

APPS.WSH_FLEXFIELD_UTILS dependencies on FND_DESCRIPTIVE_FLEXS_VL

Line 56: flexfield_name IN fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE,

52: --
53: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_FLEXFIELD_UTILS';
54: --
55: PROCEDURE get_flexfield(appl_short_name IN fnd_application.application_short_name%TYPE,
56: flexfield_name IN fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE,
57: flexfield OUT NOCOPY fnd_dflex.dflex_r,
58: flexinfo OUT NOCOPY wsh_flexfield_utils.dflex_dr)
59: IS
60: ffld fnd_dflex.dflex_r;

Line 66: FROM fnd_application_vl a, fnd_descriptive_flexs_vl df

62:
63: CURSOR c_get_flexname IS
64: SELECT /* $Header: WSHFFUTB.pls 120.1.12000000.3 2007/03/30 09:36:11 nchellam ship $ */
65: a.application_id, df.descriptive_flexfield_name
66: FROM fnd_application_vl a, fnd_descriptive_flexs_vl df
67: WHERE a.application_short_name = appl_short_name
68: AND a.application_id = df.application_id
69: AND df.descriptive_flexfield_name = flexfield_name;
70:

Line 79: FROM fnd_application_vl a, fnd_descriptive_flexs_vl df

75: df.description, df.concatenated_segment_delimiter,
76: df.default_context_field_name, df.default_context_value,
77: protected_flag,
78: form_context_prompt, context_column_name, df.context_required_flag
79: FROM fnd_application_vl a, fnd_descriptive_flexs_vl df
80: WHERE df.application_id = ffld.application_id
81: AND df.descriptive_flexfield_name = ffld.flexfield_name
82: AND a.application_id = df.table_application_id;
83: