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_FORM_TEMPLATE_INFO dependencies on HR_FORM_TEMPLATES

Line 7: g_form_template_id hr_form_templates_b.form_template_id%TYPE;

3: AS
4: --
5: -- Global variables
6: --
7: g_form_template_id hr_form_templates_b.form_template_id%TYPE;
8: g_form_template t_form_template;
9: --
10: -- -----------------------------------------------------------------------------
11: -- |-----------------------------< form_template >-----------------------------|

Line 14: (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE

10: -- -----------------------------------------------------------------------------
11: -- |-----------------------------< form_template >-----------------------------|
12: -- -----------------------------------------------------------------------------
13: FUNCTION form_template
14: (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE
15: )
16: RETURN t_form_template
17: IS
18: --

Line 20: (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE

16: RETURN t_form_template
17: IS
18: --
19: CURSOR csr_form_templates
20: (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE
21: )
22: IS
23: SELECT tmp.form_template_id
24: ,tmp.application_id

Line 61: FROM hr_form_templates tmp

57: ,tmp.information27
58: ,tmp.information28
59: ,tmp.information29
60: ,tmp.information30
61: FROM hr_form_templates tmp
62: WHERE tmp.form_template_id = p_form_template_id;
63: --
64: l_proc VARCHAR2(61) := 'form_template (1)';
65: l_form_template t_form_template;

Line 120: ,p_template_name IN hr_form_templates_b.template_name%TYPE

116: -- -----------------------------------------------------------------------------
117: FUNCTION form_template
118: (p_application_id IN fnd_application.application_id%TYPE
119: ,p_form_id IN fnd_form.form_id%TYPE
120: ,p_template_name IN hr_form_templates_b.template_name%TYPE
121: ,p_legislation_code IN hr_form_templates_b.legislation_code%TYPE
122: )
123: RETURN t_form_template
124: IS

Line 121: ,p_legislation_code IN hr_form_templates_b.legislation_code%TYPE

117: FUNCTION form_template
118: (p_application_id IN fnd_application.application_id%TYPE
119: ,p_form_id IN fnd_form.form_id%TYPE
120: ,p_template_name IN hr_form_templates_b.template_name%TYPE
121: ,p_legislation_code IN hr_form_templates_b.legislation_code%TYPE
122: )
123: RETURN t_form_template
124: IS
125: --

Line 127: (p_application_id IN hr_form_templates_b.application_id%TYPE

123: RETURN t_form_template
124: IS
125: --
126: CURSOR csr_form_templates
127: (p_application_id IN hr_form_templates_b.application_id%TYPE
128: ,p_form_id IN hr_form_templates_b.form_id%TYPE
129: ,p_template_name IN hr_form_templates_b.template_name%TYPE
130: ,p_legislation_code IN hr_form_templates_b.legislation_code%TYPE
131: )

Line 128: ,p_form_id IN hr_form_templates_b.form_id%TYPE

124: IS
125: --
126: CURSOR csr_form_templates
127: (p_application_id IN hr_form_templates_b.application_id%TYPE
128: ,p_form_id IN hr_form_templates_b.form_id%TYPE
129: ,p_template_name IN hr_form_templates_b.template_name%TYPE
130: ,p_legislation_code IN hr_form_templates_b.legislation_code%TYPE
131: )
132: IS

Line 129: ,p_template_name IN hr_form_templates_b.template_name%TYPE

125: --
126: CURSOR csr_form_templates
127: (p_application_id IN hr_form_templates_b.application_id%TYPE
128: ,p_form_id IN hr_form_templates_b.form_id%TYPE
129: ,p_template_name IN hr_form_templates_b.template_name%TYPE
130: ,p_legislation_code IN hr_form_templates_b.legislation_code%TYPE
131: )
132: IS
133: SELECT tmp.form_template_id

Line 130: ,p_legislation_code IN hr_form_templates_b.legislation_code%TYPE

126: CURSOR csr_form_templates
127: (p_application_id IN hr_form_templates_b.application_id%TYPE
128: ,p_form_id IN hr_form_templates_b.form_id%TYPE
129: ,p_template_name IN hr_form_templates_b.template_name%TYPE
130: ,p_legislation_code IN hr_form_templates_b.legislation_code%TYPE
131: )
132: IS
133: SELECT tmp.form_template_id
134: FROM hr_form_templates_b tmp

Line 134: FROM hr_form_templates_b tmp

130: ,p_legislation_code IN hr_form_templates_b.legislation_code%TYPE
131: )
132: IS
133: SELECT tmp.form_template_id
134: FROM hr_form_templates_b tmp
135: WHERE tmp.application_id = p_application_id
136: AND tmp.form_id = p_form_id
137: AND tmp.template_name = p_template_name
138: AND ( tmp.legislation_code = p_legislation_code

Line 142: (p_application_id IN hr_form_templates_b.application_id%TYPE

138: AND ( tmp.legislation_code = p_legislation_code
139: OR ( tmp.legislation_code IS NULL
140: AND p_legislation_code IS NULL));
141: CURSOR csr_form_templates2
142: (p_application_id IN hr_form_templates_b.application_id%TYPE
143: ,p_form_id IN hr_form_templates_b.form_id%TYPE
144: ,p_template_name IN hr_form_templates_b.template_name%TYPE
145: )
146: IS

Line 143: ,p_form_id IN hr_form_templates_b.form_id%TYPE

139: OR ( tmp.legislation_code IS NULL
140: AND p_legislation_code IS NULL));
141: CURSOR csr_form_templates2
142: (p_application_id IN hr_form_templates_b.application_id%TYPE
143: ,p_form_id IN hr_form_templates_b.form_id%TYPE
144: ,p_template_name IN hr_form_templates_b.template_name%TYPE
145: )
146: IS
147: SELECT tmp.form_template_id

Line 144: ,p_template_name IN hr_form_templates_b.template_name%TYPE

140: AND p_legislation_code IS NULL));
141: CURSOR csr_form_templates2
142: (p_application_id IN hr_form_templates_b.application_id%TYPE
143: ,p_form_id IN hr_form_templates_b.form_id%TYPE
144: ,p_template_name IN hr_form_templates_b.template_name%TYPE
145: )
146: IS
147: SELECT tmp.form_template_id
148: FROM hr_form_templates_b tmp

Line 148: FROM hr_form_templates_b tmp

144: ,p_template_name IN hr_form_templates_b.template_name%TYPE
145: )
146: IS
147: SELECT tmp.form_template_id
148: FROM hr_form_templates_b tmp
149: WHERE tmp.application_id = p_application_id
150: AND tmp.form_id = p_form_id
151: AND tmp.template_name = p_template_name
152: AND tmp.legislation_code IS NULL;

Line 218: ,p_template_name IN hr_form_templates_b.template_name%TYPE

214: -- |-----------------------------< form_template >-----------------------------|
215: -- -----------------------------------------------------------------------------
216: FUNCTION form_template
217: (p_function_name IN fnd_form_functions.function_name%TYPE
218: ,p_template_name IN hr_form_templates_b.template_name%TYPE
219: ,p_legislation_code IN hr_form_templates_b.legislation_code%TYPE
220: )
221: RETURN t_form_template
222: IS

Line 219: ,p_legislation_code IN hr_form_templates_b.legislation_code%TYPE

215: -- -----------------------------------------------------------------------------
216: FUNCTION form_template
217: (p_function_name IN fnd_form_functions.function_name%TYPE
218: ,p_template_name IN hr_form_templates_b.template_name%TYPE
219: ,p_legislation_code IN hr_form_templates_b.legislation_code%TYPE
220: )
221: RETURN t_form_template
222: IS
223: --

Line 267: (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE

263: -- -----------------------------------------------------------------------------
264: -- |-----------------------------< application_id >----------------------------|
265: -- -----------------------------------------------------------------------------
266: FUNCTION application_id
267: (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE
268: )
269: RETURN hr_form_templates_b.application_id%TYPE
270: IS
271: --

Line 269: RETURN hr_form_templates_b.application_id%TYPE

265: -- -----------------------------------------------------------------------------
266: FUNCTION application_id
267: (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE
268: )
269: RETURN hr_form_templates_b.application_id%TYPE
270: IS
271: --
272: l_form_template t_form_template;
273: --

Line 288: (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE

284: -- -----------------------------------------------------------------------------
285: -- |--------------------------------< form_id >--------------------------------|
286: -- -----------------------------------------------------------------------------
287: FUNCTION form_id
288: (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE
289: )
290: RETURN hr_form_templates_b.form_id%TYPE
291: IS
292: --

Line 290: RETURN hr_form_templates_b.form_id%TYPE

286: -- -----------------------------------------------------------------------------
287: FUNCTION form_id
288: (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE
289: )
290: RETURN hr_form_templates_b.form_id%TYPE
291: IS
292: --
293: l_form_template t_form_template;
294: --