106: (p_template_item_id => p_template_item_id
107: ,p_template_tab_page_id => p_template_tab_page_id
108: )
109: loop
110: hr_tcp_api.create_tcp
111: (p_effective_date => p_effective_date
112: ,p_template_item_context_id => l_template_item_context.template_item_context_id
113: ,p_template_tab_page_id => p_template_tab_page_id
114: ,p_template_item_context_page_i => l_template_item_context_page_i
274: for l_template_item_context_page in csr_template_item_context_page
275: (p_template_item_tab_page_id => p_template_item_tab_page_id
276: )
277: loop
278: hr_tcp_api.delete_tcp
279: (p_template_item_context_page_i => l_template_item_context_page.template_item_context_page_id
280: ,p_object_version_number => l_template_item_context_page.object_version_number
281: );
282: end loop;