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_INFO dependencies on FND_ID_FLEXS

Line 8: g_id_flex_code1 fnd_id_flexs.id_flex_code%TYPE;

4: --
5: -- Global variables
6: --
7: g_application_short_name1 fnd_application.application_short_name%TYPE;
8: g_id_flex_code1 fnd_id_flexs.id_flex_code%TYPE;
9: g_set_defining_column_name fnd_id_flexs.set_defining_column_name%TYPE;
10: g_application_id2 fnd_id_flexs.application_id%TYPE;
11: g_id_flex_code2 fnd_id_flexs.id_flex_code%TYPE;
12: g_segments t_segments := t_segments();

Line 9: g_set_defining_column_name fnd_id_flexs.set_defining_column_name%TYPE;

5: -- Global variables
6: --
7: g_application_short_name1 fnd_application.application_short_name%TYPE;
8: g_id_flex_code1 fnd_id_flexs.id_flex_code%TYPE;
9: g_set_defining_column_name fnd_id_flexs.set_defining_column_name%TYPE;
10: g_application_id2 fnd_id_flexs.application_id%TYPE;
11: g_id_flex_code2 fnd_id_flexs.id_flex_code%TYPE;
12: g_segments t_segments := t_segments();
13: --

Line 10: g_application_id2 fnd_id_flexs.application_id%TYPE;

6: --
7: g_application_short_name1 fnd_application.application_short_name%TYPE;
8: g_id_flex_code1 fnd_id_flexs.id_flex_code%TYPE;
9: g_set_defining_column_name fnd_id_flexs.set_defining_column_name%TYPE;
10: g_application_id2 fnd_id_flexs.application_id%TYPE;
11: g_id_flex_code2 fnd_id_flexs.id_flex_code%TYPE;
12: g_segments t_segments := t_segments();
13: --
14: -- -----------------------------------------------------------------------------

Line 11: g_id_flex_code2 fnd_id_flexs.id_flex_code%TYPE;

7: g_application_short_name1 fnd_application.application_short_name%TYPE;
8: g_id_flex_code1 fnd_id_flexs.id_flex_code%TYPE;
9: g_set_defining_column_name fnd_id_flexs.set_defining_column_name%TYPE;
10: g_application_id2 fnd_id_flexs.application_id%TYPE;
11: g_id_flex_code2 fnd_id_flexs.id_flex_code%TYPE;
12: g_segments t_segments := t_segments();
13: --
14: -- -----------------------------------------------------------------------------
15: -- |--------------------------< defining_column_name >-------------------------|

Line 19: ,p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE

15: -- |--------------------------< defining_column_name >-------------------------|
16: -- -----------------------------------------------------------------------------
17: FUNCTION defining_column_name
18: (p_application_short_name IN fnd_application.application_short_name%TYPE
19: ,p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE
20: )
21: RETURN fnd_id_flexs.set_defining_column_name%TYPE
22: IS
23: --

Line 21: RETURN fnd_id_flexs.set_defining_column_name%TYPE

17: FUNCTION defining_column_name
18: (p_application_short_name IN fnd_application.application_short_name%TYPE
19: ,p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE
20: )
21: RETURN fnd_id_flexs.set_defining_column_name%TYPE
22: IS
23: --
24: -- Local cursors
25: --

Line 28: ,p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE

24: -- Local cursors
25: --
26: CURSOR csr_id_flexs
27: (p_application_short_name IN fnd_application.application_short_name%TYPE
28: ,p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE
29: )
30: IS
31: SELECT kfl.set_defining_column_name
32: FROM fnd_id_flexs kfl

Line 32: FROM fnd_id_flexs kfl

28: ,p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE
29: )
30: IS
31: SELECT kfl.set_defining_column_name
32: FROM fnd_id_flexs kfl
33: ,fnd_application app
34: WHERE kfl.application_id = app.application_id
35: AND app.application_short_name = p_application_short_name
36: AND kfl.id_flex_code = p_id_flex_code;

Line 74: (p_application_id IN fnd_id_flexs.application_id%TYPE

70: -- -----------------------------------------------------------------------------
71: -- |--------------------------------< segments >-------------------------------|
72: -- -----------------------------------------------------------------------------
73: FUNCTION segments
74: (p_application_id IN fnd_id_flexs.application_id%TYPE
75: ,p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE
76: )
77: RETURN t_segments
78: IS

Line 75: ,p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE

71: -- |--------------------------------< segments >-------------------------------|
72: -- -----------------------------------------------------------------------------
73: FUNCTION segments
74: (p_application_id IN fnd_id_flexs.application_id%TYPE
75: ,p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE
76: )
77: RETURN t_segments
78: IS
79: --

Line 83: (p_application_id IN fnd_id_flexs.application_id%TYPE

79: --
80: -- Local cursors
81: --
82: CURSOR csr_columns
83: (p_application_id IN fnd_id_flexs.application_id%TYPE
84: ,p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE
85: )
86: IS
87: SELECT col.column_name

Line 84: ,p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE

80: -- Local cursors
81: --
82: CURSOR csr_columns
83: (p_application_id IN fnd_id_flexs.application_id%TYPE
84: ,p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE
85: )
86: IS
87: SELECT col.column_name
88: FROM fnd_columns col

Line 90: ,fnd_id_flexs flx

86: IS
87: SELECT col.column_name
88: FROM fnd_columns col
89: ,fnd_tables tbl
90: ,fnd_id_flexs flx
91: WHERE col.flexfield_usage_code = 'K'
92: AND col.table_id = tbl.table_id
93: AND col.application_id = tbl.application_id
94: AND tbl.application_id = flx.table_application_id