DBA Data[Home] [Help]

APPS.FND_DFLEX dependencies on FND_DESCRIPTIVE_FLEXS_VL

Line 65: flexfield_name IN fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE,

61: END;
62:
63: /* returns information about the flexfield */
64: PROCEDURE get_flexfield(appl_short_name IN fnd_application.application_short_name%TYPE,
65: flexfield_name IN fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE,
66: flexfield OUT nocopy dflex_r,
67: flexinfo OUT nocopy dflex_dr)
68: IS
69: ffld dflex_r;

Line 75: FROM fnd_application_vl a, fnd_descriptive_flexs_vl df

71: BEGIN
72: SELECT /* $Header: AFFFDDUB.pls 120.2.12010000.1 2008/07/25 14:13:42 appldev ship $ */
73: a.application_id, df.descriptive_flexfield_name
74: INTO ffld
75: FROM fnd_application_vl a, fnd_descriptive_flexs_vl df
76: WHERE a.application_short_name = appl_short_name
77: AND a.application_id = df.application_id
78: AND df.descriptive_flexfield_name = flexfield_name;
79:

Line 87: FROM fnd_application_vl a, fnd_descriptive_flexs_vl df

83: df.default_context_field_name, df.default_context_value,
84: protected_flag,
85: form_context_prompt, context_column_name
86: INTO dflex
87: FROM fnd_application_vl a, fnd_descriptive_flexs_vl df
88: WHERE df.application_id = ffld.application_id
89: AND df.descriptive_flexfield_name = ffld.flexfield_name
90: AND a.application_id = df.table_application_id;
91: flexfield := ffld;