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_CONTEXT_INFO dependencies on FND_DESCR_FLEX_CONTEXTS

Line 6: (application_id fnd_descr_flex_contexts.application_id%TYPE

2: /* $Header: hrdfcinf.pkb 115.2 2002/12/10 08:56:25 hjonnala ship $ */
3: AS
4: --
5: TYPE t_segment_header IS RECORD
6: (application_id fnd_descr_flex_contexts.application_id%TYPE
7: ,descriptive_flexfield_name fnd_descr_flex_contexts.descriptive_flexfield_name%TYPE
8: ,descr_flex_context_code fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE
9: ,effective_date DATE
10: ,first_index_number NUMBER

Line 7: ,descriptive_flexfield_name fnd_descr_flex_contexts.descriptive_flexfield_name%TYPE

3: AS
4: --
5: TYPE t_segment_header IS RECORD
6: (application_id fnd_descr_flex_contexts.application_id%TYPE
7: ,descriptive_flexfield_name fnd_descr_flex_contexts.descriptive_flexfield_name%TYPE
8: ,descr_flex_context_code fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE
9: ,effective_date DATE
10: ,first_index_number NUMBER
11: ,last_index_number NUMBER

Line 8: ,descr_flex_context_code fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE

4: --
5: TYPE t_segment_header IS RECORD
6: (application_id fnd_descr_flex_contexts.application_id%TYPE
7: ,descriptive_flexfield_name fnd_descr_flex_contexts.descriptive_flexfield_name%TYPE
8: ,descr_flex_context_code fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE
9: ,effective_date DATE
10: ,first_index_number NUMBER
11: ,last_index_number NUMBER
12: );

Line 15: g_application_id1 fnd_descr_flex_contexts.application_id%TYPE;

11: ,last_index_number NUMBER
12: );
13: TYPE t_segment_headers IS TABLE OF t_segment_header;
14: --
15: g_application_id1 fnd_descr_flex_contexts.application_id%TYPE;
16: g_descriptive_flexfield_name1 fnd_descr_flex_contexts.descriptive_flexfield_name%TYPE;
17: g_descr_flex_context_code1 fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;
18: g_effective_date1 DATE;
19: g_segments1 t_segments := t_segments();

Line 16: g_descriptive_flexfield_name1 fnd_descr_flex_contexts.descriptive_flexfield_name%TYPE;

12: );
13: TYPE t_segment_headers IS TABLE OF t_segment_header;
14: --
15: g_application_id1 fnd_descr_flex_contexts.application_id%TYPE;
16: g_descriptive_flexfield_name1 fnd_descr_flex_contexts.descriptive_flexfield_name%TYPE;
17: g_descr_flex_context_code1 fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;
18: g_effective_date1 DATE;
19: g_segments1 t_segments := t_segments();
20: g_application_id2 fnd_descr_flex_contexts.application_id%TYPE;

Line 17: g_descr_flex_context_code1 fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;

13: TYPE t_segment_headers IS TABLE OF t_segment_header;
14: --
15: g_application_id1 fnd_descr_flex_contexts.application_id%TYPE;
16: g_descriptive_flexfield_name1 fnd_descr_flex_contexts.descriptive_flexfield_name%TYPE;
17: g_descr_flex_context_code1 fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;
18: g_effective_date1 DATE;
19: g_segments1 t_segments := t_segments();
20: g_application_id2 fnd_descr_flex_contexts.application_id%TYPE;
21: g_descriptive_flexfield_name2 fnd_descr_flex_contexts.descriptive_flexfield_name%TYPE;

Line 20: g_application_id2 fnd_descr_flex_contexts.application_id%TYPE;

16: g_descriptive_flexfield_name1 fnd_descr_flex_contexts.descriptive_flexfield_name%TYPE;
17: g_descr_flex_context_code1 fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;
18: g_effective_date1 DATE;
19: g_segments1 t_segments := t_segments();
20: g_application_id2 fnd_descr_flex_contexts.application_id%TYPE;
21: g_descriptive_flexfield_name2 fnd_descr_flex_contexts.descriptive_flexfield_name%TYPE;
22: g_descr_flex_context_code2 fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;
23: g_effective_date2 DATE;
24: g_segments2 t_segments := t_segments();

Line 21: g_descriptive_flexfield_name2 fnd_descr_flex_contexts.descriptive_flexfield_name%TYPE;

17: g_descr_flex_context_code1 fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;
18: g_effective_date1 DATE;
19: g_segments1 t_segments := t_segments();
20: g_application_id2 fnd_descr_flex_contexts.application_id%TYPE;
21: g_descriptive_flexfield_name2 fnd_descr_flex_contexts.descriptive_flexfield_name%TYPE;
22: g_descr_flex_context_code2 fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;
23: g_effective_date2 DATE;
24: g_segments2 t_segments := t_segments();
25: g_application_short_name3 fnd_application.application_short_name%TYPE;

Line 22: g_descr_flex_context_code2 fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;

18: g_effective_date1 DATE;
19: g_segments1 t_segments := t_segments();
20: g_application_id2 fnd_descr_flex_contexts.application_id%TYPE;
21: g_descriptive_flexfield_name2 fnd_descr_flex_contexts.descriptive_flexfield_name%TYPE;
22: g_descr_flex_context_code2 fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;
23: g_effective_date2 DATE;
24: g_segments2 t_segments := t_segments();
25: g_application_short_name3 fnd_application.application_short_name%TYPE;
26: g_application_id3 fnd_application.application_id%TYPE;

Line 35: (p_application_id IN fnd_descr_flex_contexts.application_id%TYPE

31: -- -----------------------------------------------------------------------------
32: -- |------------------------------< add_segments >-----------------------------|
33: -- -----------------------------------------------------------------------------
34: PROCEDURE add_segments
35: (p_application_id IN fnd_descr_flex_contexts.application_id%TYPE
36: ,p_descriptive_flexfield_name IN fnd_descr_flex_contexts.descriptive_flexfield_name%TYPE
37: ,p_descr_flex_context_code IN fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE
38: ,p_effective_date IN DATE
39: ,p_segments IN t_segments

Line 36: ,p_descriptive_flexfield_name IN fnd_descr_flex_contexts.descriptive_flexfield_name%TYPE

32: -- |------------------------------< add_segments >-----------------------------|
33: -- -----------------------------------------------------------------------------
34: PROCEDURE add_segments
35: (p_application_id IN fnd_descr_flex_contexts.application_id%TYPE
36: ,p_descriptive_flexfield_name IN fnd_descr_flex_contexts.descriptive_flexfield_name%TYPE
37: ,p_descr_flex_context_code IN fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE
38: ,p_effective_date IN DATE
39: ,p_segments IN t_segments
40: )

Line 37: ,p_descr_flex_context_code IN fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE

33: -- -----------------------------------------------------------------------------
34: PROCEDURE add_segments
35: (p_application_id IN fnd_descr_flex_contexts.application_id%TYPE
36: ,p_descriptive_flexfield_name IN fnd_descr_flex_contexts.descriptive_flexfield_name%TYPE
37: ,p_descr_flex_context_code IN fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE
38: ,p_effective_date IN DATE
39: ,p_segments IN t_segments
40: )
41: IS

Line 71: (p_application_id IN fnd_descr_flex_contexts.application_id%TYPE

67: -- -----------------------------------------------------------------------------
68: -- |------------------------------< get_segments >-----------------------------|
69: -- -----------------------------------------------------------------------------
70: PROCEDURE get_segments
71: (p_application_id IN fnd_descr_flex_contexts.application_id%TYPE
72: ,p_descriptive_flexfield_name IN fnd_descr_flex_contexts.descriptive_flexfield_name%TYPE
73: ,p_descr_flex_context_code IN fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE
74: ,p_effective_date IN DATE
75: ,p_segments OUT NOCOPY t_segments

Line 72: ,p_descriptive_flexfield_name IN fnd_descr_flex_contexts.descriptive_flexfield_name%TYPE

68: -- |------------------------------< get_segments >-----------------------------|
69: -- -----------------------------------------------------------------------------
70: PROCEDURE get_segments
71: (p_application_id IN fnd_descr_flex_contexts.application_id%TYPE
72: ,p_descriptive_flexfield_name IN fnd_descr_flex_contexts.descriptive_flexfield_name%TYPE
73: ,p_descr_flex_context_code IN fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE
74: ,p_effective_date IN DATE
75: ,p_segments OUT NOCOPY t_segments
76: ,p_segments_exist OUT NOCOPY BOOLEAN

Line 73: ,p_descr_flex_context_code IN fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE

69: -- -----------------------------------------------------------------------------
70: PROCEDURE get_segments
71: (p_application_id IN fnd_descr_flex_contexts.application_id%TYPE
72: ,p_descriptive_flexfield_name IN fnd_descr_flex_contexts.descriptive_flexfield_name%TYPE
73: ,p_descr_flex_context_code IN fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE
74: ,p_effective_date IN DATE
75: ,p_segments OUT NOCOPY t_segments
76: ,p_segments_exist OUT NOCOPY BOOLEAN
77: )

Line 153: (p_application_id IN fnd_descr_flex_contexts.application_id%TYPE

149: --
150: -- {End of Comments}
151: -- -----------------------------------------------------------------------------
152: FUNCTION used_segments
153: (p_application_id IN fnd_descr_flex_contexts.application_id%TYPE
154: ,p_descriptive_flexfield_name IN fnd_descr_flex_contexts.descriptive_flexfield_name%TYPE
155: ,p_descr_flex_context_code IN fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE
156: ,p_effective_date IN DATE
157: )

Line 154: ,p_descriptive_flexfield_name IN fnd_descr_flex_contexts.descriptive_flexfield_name%TYPE

150: -- {End of Comments}
151: -- -----------------------------------------------------------------------------
152: FUNCTION used_segments
153: (p_application_id IN fnd_descr_flex_contexts.application_id%TYPE
154: ,p_descriptive_flexfield_name IN fnd_descr_flex_contexts.descriptive_flexfield_name%TYPE
155: ,p_descr_flex_context_code IN fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE
156: ,p_effective_date IN DATE
157: )
158: RETURN t_segments

Line 155: ,p_descr_flex_context_code IN fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE

151: -- -----------------------------------------------------------------------------
152: FUNCTION used_segments
153: (p_application_id IN fnd_descr_flex_contexts.application_id%TYPE
154: ,p_descriptive_flexfield_name IN fnd_descr_flex_contexts.descriptive_flexfield_name%TYPE
155: ,p_descr_flex_context_code IN fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE
156: ,p_effective_date IN DATE
157: )
158: RETURN t_segments
159: IS

Line 164: (p_application_id IN fnd_descr_flex_contexts.application_id%TYPE

160: --
161: -- Local cursors
162: --
163: CURSOR csr_column_usages
164: (p_application_id IN fnd_descr_flex_contexts.application_id%TYPE
165: ,p_descriptive_flexfield_name IN fnd_descr_flex_contexts.descriptive_flexfield_name%TYPE
166: ,p_descr_flex_context_code IN fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE
167: )
168: IS

Line 165: ,p_descriptive_flexfield_name IN fnd_descr_flex_contexts.descriptive_flexfield_name%TYPE

161: -- Local cursors
162: --
163: CURSOR csr_column_usages
164: (p_application_id IN fnd_descr_flex_contexts.application_id%TYPE
165: ,p_descriptive_flexfield_name IN fnd_descr_flex_contexts.descriptive_flexfield_name%TYPE
166: ,p_descr_flex_context_code IN fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE
167: )
168: IS
169: SELECT fcu.application_column_name

Line 166: ,p_descr_flex_context_code IN fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE

162: --
163: CURSOR csr_column_usages
164: (p_application_id IN fnd_descr_flex_contexts.application_id%TYPE
165: ,p_descriptive_flexfield_name IN fnd_descr_flex_contexts.descriptive_flexfield_name%TYPE
166: ,p_descr_flex_context_code IN fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE
167: )
168: IS
169: SELECT fcu.application_column_name
170: ,fcu.column_seq_num

Line 184: ,fnd_descr_flex_contexts_vl ctx

180: ,fcu.form_left_prompt
181: ,fcu.maximum_description_len
182: ,fcu.required_flag
183: FROM fnd_descr_flex_col_usage_vl fcu
184: ,fnd_descr_flex_contexts_vl ctx
185: WHERE fcu.application_id = ctx.application_id
186: AND fcu.descriptive_flexfield_name = ctx.descriptive_flexfield_name
187: AND fcu.descriptive_flex_context_code = ctx.descriptive_flex_context_code
188: AND ctx.application_id = p_application_id

Line 208: ,fnd_descr_flex_contexts_vl ctx

204: ,fcu.form_left_prompt
205: ,fcu.maximum_description_len
206: ,fcu.required_flag
207: FROM fnd_descr_flex_col_usage_vl fcu
208: ,fnd_descr_flex_contexts_vl ctx
209: WHERE fcu.application_id = ctx.application_id
210: AND fcu.descriptive_flexfield_name = ctx.descriptive_flexfield_name
211: AND fcu.descriptive_flex_context_code = ctx.descriptive_flex_context_code
212: AND ctx.application_id = p_application_id

Line 218: ,fnd_descr_flex_contexts_vl cx1

214: AND ctx.global_flag = 'Y'
215: AND ctx.enabled_flag = 'Y'
216: AND NOT EXISTS (SELECT NULL
217: FROM fnd_descr_flex_col_usage_vl cu1
218: ,fnd_descr_flex_contexts_vl cx1
219: WHERE cu1.application_id = cx1.application_id
220: AND cu1.descriptive_flexfield_name = cx1.descriptive_flexfield_name
221: AND cu1.descriptive_flex_context_code = cx1.descriptive_flex_context_code
222: AND cu1.application_column_name = fcu.application_column_name

Line 299: (p_application_id IN fnd_descr_flex_contexts.application_id%TYPE

295: -- -----------------------------------------------------------------------------
296: -- |--------------------------------< segments >-------------------------------|
297: -- -----------------------------------------------------------------------------
298: FUNCTION segments
299: (p_application_id IN fnd_descr_flex_contexts.application_id%TYPE
300: ,p_descriptive_flexfield_name IN fnd_descr_flex_contexts.descriptive_flexfield_name%TYPE
301: ,p_descr_flex_context_code IN fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE
302: ,p_effective_date IN DATE
303: )

Line 300: ,p_descriptive_flexfield_name IN fnd_descr_flex_contexts.descriptive_flexfield_name%TYPE

296: -- |--------------------------------< segments >-------------------------------|
297: -- -----------------------------------------------------------------------------
298: FUNCTION segments
299: (p_application_id IN fnd_descr_flex_contexts.application_id%TYPE
300: ,p_descriptive_flexfield_name IN fnd_descr_flex_contexts.descriptive_flexfield_name%TYPE
301: ,p_descr_flex_context_code IN fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE
302: ,p_effective_date IN DATE
303: )
304: RETURN t_segments

Line 301: ,p_descr_flex_context_code IN fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE

297: -- -----------------------------------------------------------------------------
298: FUNCTION segments
299: (p_application_id IN fnd_descr_flex_contexts.application_id%TYPE
300: ,p_descriptive_flexfield_name IN fnd_descr_flex_contexts.descriptive_flexfield_name%TYPE
301: ,p_descr_flex_context_code IN fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE
302: ,p_effective_date IN DATE
303: )
304: RETURN t_segments
305: IS

Line 440: ,p_descriptive_flexfield_name IN fnd_descr_flex_contexts.descriptive_flexfield_name%TYPE

436: -- |------------------------------< segments_pst >-----------------------------|
437: -- -----------------------------------------------------------------------------
438: FUNCTION segments_pst
439: (p_application_short_name IN fnd_application.application_short_name%TYPE
440: ,p_descriptive_flexfield_name IN fnd_descr_flex_contexts.descriptive_flexfield_name%TYPE
441: ,p_descr_flex_context_code IN fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE
442: ,p_effective_date IN DATE
443: )
444: RETURN t_segments_pst

Line 441: ,p_descr_flex_context_code IN fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE

437: -- -----------------------------------------------------------------------------
438: FUNCTION segments_pst
439: (p_application_short_name IN fnd_application.application_short_name%TYPE
440: ,p_descriptive_flexfield_name IN fnd_descr_flex_contexts.descriptive_flexfield_name%TYPE
441: ,p_descr_flex_context_code IN fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE
442: ,p_effective_date IN DATE
443: )
444: RETURN t_segments_pst
445: IS