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_ID_FLEX_STRUCTURE_INFO dependencies on FND_ID_FLEX_STRUCTURES

Line 6: (application_id fnd_id_flex_structures.application_id%TYPE

2: /* $Header: hrkfsinf.pkb 115.2 2002/12/11 14:27:51 hjonnala ship $ */
3: AS
4: --
5: TYPE t_segment_header IS RECORD
6: (application_id fnd_id_flex_structures.application_id%TYPE
7: ,id_flex_code fnd_id_flex_structures.id_flex_code%TYPE
8: ,id_flex_num fnd_id_flex_structures.id_flex_num%TYPE
9: ,effective_date DATE
10: ,first_index_number NUMBER

Line 7: ,id_flex_code fnd_id_flex_structures.id_flex_code%TYPE

3: AS
4: --
5: TYPE t_segment_header IS RECORD
6: (application_id fnd_id_flex_structures.application_id%TYPE
7: ,id_flex_code fnd_id_flex_structures.id_flex_code%TYPE
8: ,id_flex_num fnd_id_flex_structures.id_flex_num%TYPE
9: ,effective_date DATE
10: ,first_index_number NUMBER
11: ,last_index_number NUMBER

Line 8: ,id_flex_num fnd_id_flex_structures.id_flex_num%TYPE

4: --
5: TYPE t_segment_header IS RECORD
6: (application_id fnd_id_flex_structures.application_id%TYPE
7: ,id_flex_code fnd_id_flex_structures.id_flex_code%TYPE
8: ,id_flex_num fnd_id_flex_structures.id_flex_num%TYPE
9: ,effective_date DATE
10: ,first_index_number NUMBER
11: ,last_index_number NUMBER
12: );

Line 15: g_application_id1 fnd_id_flex_structures.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_id_flex_structures.application_id%TYPE;
16: g_id_flex_code1 fnd_id_flex_structures.id_flex_code%TYPE;
17: g_id_flex_num1 fnd_id_flex_structures.id_flex_num%TYPE;
18: g_effective_date1 DATE;
19: g_segments1 t_segments := t_segments();

Line 16: g_id_flex_code1 fnd_id_flex_structures.id_flex_code%TYPE;

12: );
13: TYPE t_segment_headers IS TABLE OF t_segment_header;
14: --
15: g_application_id1 fnd_id_flex_structures.application_id%TYPE;
16: g_id_flex_code1 fnd_id_flex_structures.id_flex_code%TYPE;
17: g_id_flex_num1 fnd_id_flex_structures.id_flex_num%TYPE;
18: g_effective_date1 DATE;
19: g_segments1 t_segments := t_segments();
20: g_application_id2 fnd_id_flex_structures.application_id%TYPE;

Line 17: g_id_flex_num1 fnd_id_flex_structures.id_flex_num%TYPE;

13: TYPE t_segment_headers IS TABLE OF t_segment_header;
14: --
15: g_application_id1 fnd_id_flex_structures.application_id%TYPE;
16: g_id_flex_code1 fnd_id_flex_structures.id_flex_code%TYPE;
17: g_id_flex_num1 fnd_id_flex_structures.id_flex_num%TYPE;
18: g_effective_date1 DATE;
19: g_segments1 t_segments := t_segments();
20: g_application_id2 fnd_id_flex_structures.application_id%TYPE;
21: g_id_flex_code2 fnd_id_flex_structures.id_flex_code%TYPE;

Line 20: g_application_id2 fnd_id_flex_structures.application_id%TYPE;

16: g_id_flex_code1 fnd_id_flex_structures.id_flex_code%TYPE;
17: g_id_flex_num1 fnd_id_flex_structures.id_flex_num%TYPE;
18: g_effective_date1 DATE;
19: g_segments1 t_segments := t_segments();
20: g_application_id2 fnd_id_flex_structures.application_id%TYPE;
21: g_id_flex_code2 fnd_id_flex_structures.id_flex_code%TYPE;
22: g_id_flex_num2 fnd_id_flex_structures.id_flex_num%TYPE;
23: g_effective_date2 DATE;
24: g_segments2 t_segments := t_segments();

Line 21: g_id_flex_code2 fnd_id_flex_structures.id_flex_code%TYPE;

17: g_id_flex_num1 fnd_id_flex_structures.id_flex_num%TYPE;
18: g_effective_date1 DATE;
19: g_segments1 t_segments := t_segments();
20: g_application_id2 fnd_id_flex_structures.application_id%TYPE;
21: g_id_flex_code2 fnd_id_flex_structures.id_flex_code%TYPE;
22: g_id_flex_num2 fnd_id_flex_structures.id_flex_num%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_id_flex_num2 fnd_id_flex_structures.id_flex_num%TYPE;

18: g_effective_date1 DATE;
19: g_segments1 t_segments := t_segments();
20: g_application_id2 fnd_id_flex_structures.application_id%TYPE;
21: g_id_flex_code2 fnd_id_flex_structures.id_flex_code%TYPE;
22: g_id_flex_num2 fnd_id_flex_structures.id_flex_num%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_id_flex_structures.application_id%TYPE

31: -- -----------------------------------------------------------------------------
32: -- |------------------------------< add_segments >-----------------------------|
33: -- -----------------------------------------------------------------------------
34: PROCEDURE add_segments
35: (p_application_id IN fnd_id_flex_structures.application_id%TYPE
36: ,p_id_flex_code IN fnd_id_flex_structures.id_flex_code%TYPE
37: ,p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE
38: ,p_effective_date IN DATE
39: ,p_segments IN t_segments

Line 36: ,p_id_flex_code IN fnd_id_flex_structures.id_flex_code%TYPE

32: -- |------------------------------< add_segments >-----------------------------|
33: -- -----------------------------------------------------------------------------
34: PROCEDURE add_segments
35: (p_application_id IN fnd_id_flex_structures.application_id%TYPE
36: ,p_id_flex_code IN fnd_id_flex_structures.id_flex_code%TYPE
37: ,p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE
38: ,p_effective_date IN DATE
39: ,p_segments IN t_segments
40: )

Line 37: ,p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE

33: -- -----------------------------------------------------------------------------
34: PROCEDURE add_segments
35: (p_application_id IN fnd_id_flex_structures.application_id%TYPE
36: ,p_id_flex_code IN fnd_id_flex_structures.id_flex_code%TYPE
37: ,p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE
38: ,p_effective_date IN DATE
39: ,p_segments IN t_segments
40: )
41: IS

Line 71: (p_application_id IN fnd_id_flex_structures.application_id%TYPE

67: -- -----------------------------------------------------------------------------
68: -- |------------------------------< get_segments >-----------------------------|
69: -- -----------------------------------------------------------------------------
70: PROCEDURE get_segments
71: (p_application_id IN fnd_id_flex_structures.application_id%TYPE
72: ,p_id_flex_code IN fnd_id_flex_structures.id_flex_code%TYPE
73: ,p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE
74: ,p_effective_date IN DATE
75: ,p_segments OUT NOCOPY t_segments

Line 72: ,p_id_flex_code IN fnd_id_flex_structures.id_flex_code%TYPE

68: -- |------------------------------< get_segments >-----------------------------|
69: -- -----------------------------------------------------------------------------
70: PROCEDURE get_segments
71: (p_application_id IN fnd_id_flex_structures.application_id%TYPE
72: ,p_id_flex_code IN fnd_id_flex_structures.id_flex_code%TYPE
73: ,p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE
74: ,p_effective_date IN DATE
75: ,p_segments OUT NOCOPY t_segments
76: ,p_segments_exist OUT NOCOPY BOOLEAN

Line 73: ,p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE

69: -- -----------------------------------------------------------------------------
70: PROCEDURE get_segments
71: (p_application_id IN fnd_id_flex_structures.application_id%TYPE
72: ,p_id_flex_code IN fnd_id_flex_structures.id_flex_code%TYPE
73: ,p_id_flex_num IN fnd_id_flex_structures.id_flex_num%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_id_flex_structures.application_id%TYPE

149: --
150: -- {End of Comments}
151: -- -----------------------------------------------------------------------------
152: FUNCTION used_segments
153: (p_application_id IN fnd_id_flex_structures.application_id%TYPE
154: ,p_id_flex_code IN fnd_id_flex_structures.id_flex_code%TYPE
155: ,p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE
156: ,p_effective_date IN DATE
157: )

Line 154: ,p_id_flex_code IN fnd_id_flex_structures.id_flex_code%TYPE

150: -- {End of Comments}
151: -- -----------------------------------------------------------------------------
152: FUNCTION used_segments
153: (p_application_id IN fnd_id_flex_structures.application_id%TYPE
154: ,p_id_flex_code IN fnd_id_flex_structures.id_flex_code%TYPE
155: ,p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE
156: ,p_effective_date IN DATE
157: )
158: RETURN t_segments

Line 155: ,p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE

151: -- -----------------------------------------------------------------------------
152: FUNCTION used_segments
153: (p_application_id IN fnd_id_flex_structures.application_id%TYPE
154: ,p_id_flex_code IN fnd_id_flex_structures.id_flex_code%TYPE
155: ,p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE
156: ,p_effective_date IN DATE
157: )
158: RETURN t_segments
159: IS

Line 184: ,fnd_id_flex_structures fst

180: ,ifs.maximum_description_len
181: ,ifs.required_flag
182: ,ifs.segment_name
183: FROM fnd_id_flex_segments_vl ifs
184: ,fnd_id_flex_structures fst
185: WHERE ifs.application_id = fst.application_id
186: AND ifs.id_flex_code = fst.id_flex_code
187: AND ifs.id_flex_num = fst.id_flex_num
188: AND fst.application_id = p_application_id

Line 263: (p_application_id IN fnd_id_flex_structures.application_id%TYPE

259: -- -----------------------------------------------------------------------------
260: -- |--------------------------------< segments >-------------------------------|
261: -- -----------------------------------------------------------------------------
262: FUNCTION segments
263: (p_application_id IN fnd_id_flex_structures.application_id%TYPE
264: ,p_id_flex_code IN fnd_id_flex_structures.id_flex_code%TYPE
265: ,p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE
266: ,p_effective_date IN DATE
267: )

Line 264: ,p_id_flex_code IN fnd_id_flex_structures.id_flex_code%TYPE

260: -- |--------------------------------< segments >-------------------------------|
261: -- -----------------------------------------------------------------------------
262: FUNCTION segments
263: (p_application_id IN fnd_id_flex_structures.application_id%TYPE
264: ,p_id_flex_code IN fnd_id_flex_structures.id_flex_code%TYPE
265: ,p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE
266: ,p_effective_date IN DATE
267: )
268: RETURN t_segments

Line 265: ,p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE

261: -- -----------------------------------------------------------------------------
262: FUNCTION segments
263: (p_application_id IN fnd_id_flex_structures.application_id%TYPE
264: ,p_id_flex_code IN fnd_id_flex_structures.id_flex_code%TYPE
265: ,p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE
266: ,p_effective_date IN DATE
267: )
268: RETURN t_segments
269: IS

Line 403: ,p_id_flex_code IN fnd_id_flex_structures.id_flex_code%TYPE

399: -- |------------------------------< segments_pst >-----------------------------|
400: -- -----------------------------------------------------------------------------
401: FUNCTION segments_pst
402: (p_application_short_name IN fnd_application.application_short_name%TYPE
403: ,p_id_flex_code IN fnd_id_flex_structures.id_flex_code%TYPE
404: ,p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE
405: ,p_effective_date IN DATE
406: )
407: RETURN t_segments_pst

Line 404: ,p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE

400: -- -----------------------------------------------------------------------------
401: FUNCTION segments_pst
402: (p_application_short_name IN fnd_application.application_short_name%TYPE
403: ,p_id_flex_code IN fnd_id_flex_structures.id_flex_code%TYPE
404: ,p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE
405: ,p_effective_date IN DATE
406: )
407: RETURN t_segments_pst
408: IS