APPS.HR_ITEM_PROPERTIES_PKG dependencies on HR_FORM_TEMPLATES_B

Line 11: g_form_template_id hr_form_templates_b.form_template_id%type;

7: g_application_id fnd_application.application_id%TYPE;
8: g_application_short_name fnd_application.application_short_name%type;
9: g_form_id fnd_form.form_id%TYPE;
10: g_form_name fnd_form.form_name%type;
11: g_form_template_id hr_form_templates_b.form_template_id%type;
12: g_template_name hr_form_templates_b.template_name%type;
13: g_legislation_code hr_form_templates_b.legislation_code%type;
14:
15:

Line 12: g_template_name hr_form_templates_b.template_name%type;

8: g_application_short_name fnd_application.application_short_name%type;
9: g_form_id fnd_form.form_id%TYPE;
10: g_form_name fnd_form.form_name%type;
11: g_form_template_id hr_form_templates_b.form_template_id%type;
12: g_template_name hr_form_templates_b.template_name%type;
13: g_legislation_code hr_form_templates_b.legislation_code%type;
14:
15:
16: -- -----------------------------------------------------------------------------

Line 13: g_legislation_code hr_form_templates_b.legislation_code%type;

9: g_form_id fnd_form.form_id%TYPE;
10: g_form_name fnd_form.form_name%type;
11: g_form_template_id hr_form_templates_b.form_template_id%type;
12: g_template_name hr_form_templates_b.template_name%type;
13: g_legislation_code hr_form_templates_b.legislation_code%type;
14:
15:
16: -- -----------------------------------------------------------------------------
17: -- |-----------------------------< update_copies >-----------------------------|

Line 1789: from hr_form_templates_b hft

1785: if ltrim(rtrim(x_template_name)) is not null then
1786:
1787: select hti.template_item_id
1788: into x_template_item_id
1789: from hr_form_templates_b hft
1790: ,hr_template_items_b hti
1791: where hti.form_item_id = x_form_item_id
1792: and hti.form_template_id = hft.form_template_id
1793: and hft.form_id = x_form_id

Line 2276: from hr_form_templates_b hft

2272: if ltrim(rtrim(x_template_name)) is not null then
2273:
2274: select hti.template_item_id
2275: into x_template_item_id
2276: from hr_form_templates_b hft
2277: ,hr_template_items_b hti
2278: where hti.form_item_id = x_form_item_id
2279: and hti.form_template_id = hft.form_template_id
2280: and hft.form_id = x_form_id

Line 2303: from hr_form_templates_b hft

2299: null;
2300: ELSE --identifiers different, recalculate global variables
2301: select hft.form_template_id
2302: into g_form_template_id
2303: from hr_form_templates_b hft
2304: where hft.form_id = g_form_id --x_form_id
2305: and hft.application_id = g_application_id --x_application_id
2306: and hft.template_name = x_template_name
2307: and ( (hft.legislation_code is null and x_territory_short_name is null)

Line 2564: from hr_form_templates_b hft

2560: if ltrim(rtrim(x_template_name)) is not null then
2561:
2562: select hti.template_item_id
2563: into x_template_item_id
2564: from hr_form_templates_b hft
2565: ,hr_template_items_b hti
2566: where hti.form_item_id = x_form_item_id
2567: and hti.form_template_id = hft.form_template_id
2568: and hft.form_id = x_form_id

Line 2591: from hr_form_templates_b hft

2587: null;
2588: ELSE --identifiers different, recalculate global variables
2589: select hft.form_template_id
2590: into g_form_template_id
2591: from hr_form_templates_b hft
2592: where hft.form_id = g_form_id --x_form_id
2593: and hft.application_id = g_application_id --x_application_id
2594: and hft.template_name = x_template_name
2595: and ( (hft.legislation_code is null and x_territory_short_name is null)