APPS.HR_TEMPLATE_CANVASES_API dependencies on HR_TEMPLATE_TAB_PAGES

Line 33: FROM hr_template_tab_pages ttp

29:
30: CURSOR cur_tmplt_tab
31: IS
32: SELECT ttp.template_tab_page_id
33: FROM hr_template_tab_pages ttp
34: WHERE ttp.template_canvas_id = p_template_canvas_id_from;
35:
36: l_temp number;
37:

Line 139: hr_template_tab_pages_api.copy_template_tab_page(

135:
136: hr_utility.set_location('At:'|| l_proc, 35);
137:
138: FOR cur_rec IN cur_tmplt_tab LOOP
139: hr_template_tab_pages_api.copy_template_tab_page(
140: p_effective_date => TRUNC(p_effective_date)
141: ,p_template_tab_page_id_from => cur_rec.template_tab_page_id
142: ,p_template_canvas_id => l_template_canvas_id_to
143: ,p_template_tab_page_id_to => l_template_tab_page_id_to

Line 559: FROM hr_template_tab_pages

555: CURSOR cur_tmplt_tab
556: IS
557: SELECT template_tab_page_id
558: ,object_version_number
559: FROM hr_template_tab_pages
560: WHERE template_canvas_id = p_template_canvas_id;
561:
562: l_temp number;
563:

Line 626: hr_template_tab_pages_api.delete_template_tab_page(

622: IF p_delete_children_flag = 'Y' THEN
623:
624: FOR cur_rec IN cur_tmplt_tab LOOP
625:
626: hr_template_tab_pages_api.delete_template_tab_page(
627: p_template_tab_page_id => cur_rec.template_tab_page_id
628: ,p_object_version_number => cur_rec.object_version_number
629: ,p_delete_children_flag => p_delete_children_flag);
630: END LOOP;