eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_DESCR_FLEX_INFO dependencies on FND_DESCRIPTIVE_FLEXS

Line 8: g_descriptive_flexfield_name1 fnd_descriptive_flexs.descriptive_flexfield_name%TYPE;

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;
12: g_application_id2 fnd_descriptive_flexs.application_id%TYPE;

Line 10: g_default_context_field_name fnd_descriptive_flexs.default_context_field_name%TYPE;

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;
12: g_application_id2 fnd_descriptive_flexs.application_id%TYPE;
13: g_descriptive_flexfield_name2 fnd_descriptive_flexs.descriptive_flexfield_name%TYPE;
14: g_segments t_segments := t_segments();

Line 11: g_context_column_name fnd_descriptive_flexs.context_column_name%TYPE;

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;
12: g_application_id2 fnd_descriptive_flexs.application_id%TYPE;
13: g_descriptive_flexfield_name2 fnd_descriptive_flexs.descriptive_flexfield_name%TYPE;
14: g_segments t_segments := t_segments();
15: --

Line 12: g_application_id2 fnd_descriptive_flexs.application_id%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;
12: g_application_id2 fnd_descriptive_flexs.application_id%TYPE;
13: g_descriptive_flexfield_name2 fnd_descriptive_flexs.descriptive_flexfield_name%TYPE;
14: g_segments t_segments := t_segments();
15: --
16: -- -----------------------------------------------------------------------------

Line 13: g_descriptive_flexfield_name2 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;
12: g_application_id2 fnd_descriptive_flexs.application_id%TYPE;
13: g_descriptive_flexfield_name2 fnd_descriptive_flexs.descriptive_flexfield_name%TYPE;
14: g_segments t_segments := t_segments();
15: --
16: -- -----------------------------------------------------------------------------
17: -- |-----------------------< default_context_field_name >----------------------|

Line 21: ,p_descriptive_flexfield_name IN fnd_descriptive_flexs.descriptive_flexfield_name%TYPE

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
25: IS

Line 24: RETURN fnd_descriptive_flexs.default_context_field_name%TYPE

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
25: IS
26: --
27: -- Local cursors
28: --

Line 31: ,p_descriptive_flexfield_name IN fnd_descriptive_flexs.descriptive_flexfield_name%TYPE

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
35: ,dfl.context_column_name

Line 36: FROM fnd_descriptive_flexs dfl

32: )
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;

Line 91: ,p_descriptive_flexfield_name IN fnd_descriptive_flexs.descriptive_flexfield_name%TYPE

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
95: IS

Line 94: RETURN fnd_descriptive_flexs.context_column_name%TYPE

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
95: IS
96: --
97: -- Local cursors
98: --

Line 101: ,p_descriptive_flexfield_name IN fnd_descriptive_flexs.descriptive_flexfield_name%TYPE

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
105: ,dfl.context_column_name

Line 106: FROM fnd_descriptive_flexs dfl

102: )
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;

Line 160: (p_application_id IN fnd_descriptive_flexs.application_id%TYPE

156: -- -----------------------------------------------------------------------------
157: -- |--------------------------------< segments >-------------------------------|
158: -- -----------------------------------------------------------------------------
159: FUNCTION segments
160: (p_application_id IN fnd_descriptive_flexs.application_id%TYPE
161: ,p_descriptive_flexfield_name IN fnd_descriptive_flexs.descriptive_flexfield_name%TYPE
162: )
163: RETURN t_segments
164: IS

Line 161: ,p_descriptive_flexfield_name IN fnd_descriptive_flexs.descriptive_flexfield_name%TYPE

157: -- |--------------------------------< segments >-------------------------------|
158: -- -----------------------------------------------------------------------------
159: FUNCTION segments
160: (p_application_id IN fnd_descriptive_flexs.application_id%TYPE
161: ,p_descriptive_flexfield_name IN fnd_descriptive_flexs.descriptive_flexfield_name%TYPE
162: )
163: RETURN t_segments
164: IS
165: --

Line 169: (p_application_id IN fnd_descriptive_flexs.application_id%TYPE

165: --
166: -- Local cursors
167: --
168: CURSOR csr_columns
169: (p_application_id IN fnd_descriptive_flexs.application_id%TYPE
170: ,p_descriptive_flexfield_name IN fnd_descriptive_flexs.descriptive_flexfield_name%TYPE
171: )
172: IS
173: SELECT col.column_name

Line 170: ,p_descriptive_flexfield_name IN fnd_descriptive_flexs.descriptive_flexfield_name%TYPE

166: -- Local cursors
167: --
168: CURSOR csr_columns
169: (p_application_id IN fnd_descriptive_flexs.application_id%TYPE
170: ,p_descriptive_flexfield_name IN fnd_descriptive_flexs.descriptive_flexfield_name%TYPE
171: )
172: IS
173: SELECT col.column_name
174: FROM fnd_columns col

Line 176: ,fnd_descriptive_flexs flx

172: IS
173: SELECT col.column_name
174: FROM fnd_columns col
175: ,fnd_tables tbl
176: ,fnd_descriptive_flexs flx
177: WHERE col.flexfield_usage_code = 'D'
178: AND col.flexfield_application_id = flx.application_id
179: AND col.flexfield_name = flx.descriptive_flexfield_name
180: AND col.table_id = tbl.table_id