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 1703: from hr_form_templates_b hft

1699: if ltrim(rtrim(x_template_name)) is not null then
1700:
1701: select hti.template_item_id
1702: into x_template_item_id
1703: from hr_form_templates_b hft
1704: ,hr_template_items_b hti
1705: where hti.form_item_id = x_form_item_id
1706: and hti.form_template_id = hft.form_template_id
1707: and hft.form_id = x_form_id

Line 2190: from hr_form_templates_b hft

2186: if ltrim(rtrim(x_template_name)) is not null then
2187:
2188: select hti.template_item_id
2189: into x_template_item_id
2190: from hr_form_templates_b hft
2191: ,hr_template_items_b hti
2192: where hti.form_item_id = x_form_item_id
2193: and hti.form_template_id = hft.form_template_id
2194: and hft.form_id = x_form_id

Line 2217: from hr_form_templates_b hft

2213: null;
2214: ELSE --identifiers different, recalculate global variables
2215: select hft.form_template_id
2216: into g_form_template_id
2217: from hr_form_templates_b hft
2218: where hft.form_id = g_form_id --x_form_id
2219: and hft.application_id = g_application_id --x_application_id
2220: and hft.template_name = x_template_name
2221: and ( (hft.legislation_code is null and x_territory_short_name is null)

Line 2478: from hr_form_templates_b hft

2474: if ltrim(rtrim(x_template_name)) is not null then
2475:
2476: select hti.template_item_id
2477: into x_template_item_id
2478: from hr_form_templates_b hft
2479: ,hr_template_items_b hti
2480: where hti.form_item_id = x_form_item_id
2481: and hti.form_template_id = hft.form_template_id
2482: and hft.form_id = x_form_id

Line 2505: from hr_form_templates_b hft

2501: null;
2502: ELSE --identifiers different, recalculate global variables
2503: select hft.form_template_id
2504: into g_form_template_id
2505: from hr_form_templates_b hft
2506: where hft.form_id = g_form_id --x_form_id
2507: and hft.application_id = g_application_id --x_application_id
2508: and hft.template_name = x_template_name
2509: and ( (hft.legislation_code is null and x_territory_short_name is null)