APPS.HR_DESCR_FLEX_INFO dependencies on FND_APPLICATION

Line 7: g_application_short_name1 fnd_application.application_short_name%TYPE;

3: AS
4: --
5: -- Global variables
6: --
7: g_application_short_name1 fnd_application.application_short_name%TYPE;
8: g_descriptive_flexfield_name1 fnd_descriptive_flexs.descriptive_flexfield_name%TYPE;
9: g_field_name_prefix VARCHAR2(30);
10: g_default_context_field_name fnd_descriptive_flexs.default_context_field_name%TYPE;
11: g_context_column_name fnd_descriptive_flexs.context_column_name%TYPE;

Line 20: (p_application_short_name IN fnd_application.application_short_name%TYPE

16: -- -----------------------------------------------------------------------------
17: -- |-----------------------< default_context_field_name >----------------------|
18: -- -----------------------------------------------------------------------------
19: FUNCTION default_context_field_name
20: (p_application_short_name IN fnd_application.application_short_name%TYPE
21: ,p_descriptive_flexfield_name IN fnd_descriptive_flexs.descriptive_flexfield_name%TYPE
22: ,p_field_name_prefix IN VARCHAR2 DEFAULT NULL
23: )
24: RETURN fnd_descriptive_flexs.default_context_field_name%TYPE

Line 30: (p_application_short_name IN fnd_application.application_short_name%TYPE

26: --
27: -- Local cursors
28: --
29: CURSOR csr_descriptive_flexs
30: (p_application_short_name IN fnd_application.application_short_name%TYPE
31: ,p_descriptive_flexfield_name IN fnd_descriptive_flexs.descriptive_flexfield_name%TYPE
32: )
33: IS
34: SELECT dfl.default_context_field_name

Line 37: ,fnd_application app

33: IS
34: SELECT dfl.default_context_field_name
35: ,dfl.context_column_name
36: FROM fnd_descriptive_flexs dfl
37: ,fnd_application app
38: WHERE dfl.application_id = app.application_id
39: AND app.application_short_name = p_application_short_name
40: AND dfl.descriptive_flexfield_name = p_descriptive_flexfield_name;
41: l_descriptive_flex csr_descriptive_flexs%ROWTYPE;

Line 90: (p_application_short_name IN fnd_application.application_short_name%TYPE

86: -- -----------------------------------------------------------------------------
87: -- |--------------------------< context_column_name >--------------------------|
88: -- -----------------------------------------------------------------------------
89: FUNCTION context_column_name
90: (p_application_short_name IN fnd_application.application_short_name%TYPE
91: ,p_descriptive_flexfield_name IN fnd_descriptive_flexs.descriptive_flexfield_name%TYPE
92: ,p_field_name_prefix IN VARCHAR2 DEFAULT NULL
93: )
94: RETURN fnd_descriptive_flexs.context_column_name%TYPE

Line 100: (p_application_short_name IN fnd_application.application_short_name%TYPE

96: --
97: -- Local cursors
98: --
99: CURSOR csr_descriptive_flexs
100: (p_application_short_name IN fnd_application.application_short_name%TYPE
101: ,p_descriptive_flexfield_name IN fnd_descriptive_flexs.descriptive_flexfield_name%TYPE
102: )
103: IS
104: SELECT dfl.default_context_field_name

Line 107: ,fnd_application app

103: IS
104: SELECT dfl.default_context_field_name
105: ,dfl.context_column_name
106: FROM fnd_descriptive_flexs dfl
107: ,fnd_application app
108: WHERE dfl.application_id = app.application_id
109: AND app.application_short_name = p_application_short_name
110: AND dfl.descriptive_flexfield_name = p_descriptive_flexfield_name;
111: l_descriptive_flex csr_descriptive_flexs%ROWTYPE;