APPS.HR_TEMPLATE_DATA_GROUPS_API dependencies on HR_TEMPLATE_ITEMS

Line 30: -- Bug # 3648566. Modified the cursor text to use base table hr_template_items_b

26: SELECT tdg.form_data_group_id
27: FROM hr_template_data_groups tdg
28: WHERE tdg.template_data_group_id = p_template_data_group_id_from;
29:
30: -- Bug # 3648566. Modified the cursor text to use base table hr_template_items_b
31: -- instead of view hr_template_items.
32: CURSOR cur_tmplt_item
33: IS
34: SELECT tit1.template_item_id

Line 31: -- instead of view hr_template_items.

27: FROM hr_template_data_groups tdg
28: WHERE tdg.template_data_group_id = p_template_data_group_id_from;
29:
30: -- Bug # 3648566. Modified the cursor text to use base table hr_template_items_b
31: -- instead of view hr_template_items.
32: CURSOR cur_tmplt_item
33: IS
34: SELECT tit1.template_item_id
35: FROM hr_template_items_b tit2

Line 35: FROM hr_template_items_b tit2

31: -- instead of view hr_template_items.
32: CURSOR cur_tmplt_item
33: IS
34: SELECT tit1.template_item_id
35: FROM hr_template_items_b tit2
36: ,hr_template_items_b tit1
37: ,hr_template_data_groups tdg
38: WHERE tit2.template_item_id IS NULL
39: AND tit2.form_template_id (+) = p_form_template_id

Line 36: ,hr_template_items_b tit1

32: CURSOR cur_tmplt_item
33: IS
34: SELECT tit1.template_item_id
35: FROM hr_template_items_b tit2
36: ,hr_template_items_b tit1
37: ,hr_template_data_groups tdg
38: WHERE tit2.template_item_id IS NULL
39: AND tit2.form_template_id (+) = p_form_template_id
40: AND tit2.form_item_id (+) = tit1.form_item_id

Line 136: hr_template_items_api.copy_template_item(

132:
133: hr_utility.set_location('At:'|| l_proc, 30);
134:
135: FOR cur_rec in cur_tmplt_item LOOP
136: hr_template_items_api.copy_template_item(
137: p_effective_date => TRUNC(p_effective_date)
138: ,p_language_code => l_language_code
139: ,p_template_item_id_from => cur_rec.template_item_id
140: ,p_form_template_id => p_form_template_id

Line 227: FROM hr_template_items tit

223:
224: CURSOR cur_form_item
225: IS
226: SELECT fit.form_item_id
227: FROM hr_template_items tit
228: ,hr_form_items fit
229: ,hr_form_data_group_items fgi
230: WHERE tit.template_item_id IS NULL
231: AND tit.form_template_id (+) = p_form_template_id

Line 308: hr_template_items_api.create_template_item(

304:
305: hr_utility.set_location('At:'|| l_proc, 25);
306:
307: FOR cur_rec in cur_form_item LOOP
308: hr_template_items_api.create_template_item(
309: p_effective_date => TRUNC(p_effective_date)
310: ,p_form_template_id => p_form_template_id
311: ,p_form_item_id => cur_rec.form_item_id
312: ,p_template_item_id => l_template_item_id

Line 396: FROM hr_template_items tit

392: CURSOR cur_tmplt_item
393: IS
394: SELECT tit.template_item_id
395: ,tit.object_version_number
396: FROM hr_template_items tit
397: ,hr_form_data_group_items fgi
398: ,hr_template_data_groups tdg
399: WHERE tit.form_template_id = tdg.form_template_id
400: AND tit.form_item_id = fgi.form_item_id

Line 406: FROM hr_template_items tit

402: AND tdg.template_data_group_id = p_template_data_group_id
403: MINUS
404: SELECT tit.template_item_id
405: ,tit.object_version_number
406: FROM hr_template_items tit
407: ,hr_form_data_group_items fgi
408: ,hr_template_data_groups tdg2
409: ,hr_template_data_groups tdg1
410: WHERE tit.form_template_id = tdg2.form_template_id

Line 477: hr_template_items_api.delete_template_item(

473:
474: hr_utility.set_location('At:'|| l_proc, 25);
475:
476: FOR cur_rec in cur_tmplt_item LOOP
477: hr_template_items_api.delete_template_item(
478: p_template_item_id => cur_rec.template_item_id
479: ,p_object_version_number => cur_rec.object_version_number);
480: END LOOP;
481: