APPS.HR_TEMPLATE_ITEMS_API dependencies on HR_TEMPLATE_ITEM_TAB_PAGES

Line 626: ,hr_template_item_tab_pages tip

622: FROM hr_template_tab_pages ttp2
623: ,hr_template_canvases tcn
624: ,hr_template_windows twn
625: ,hr_template_tab_pages ttp1
626: ,hr_template_item_tab_pages tip
627: WHERE ttp2.form_tab_page_id = ttp1.form_tab_page_id
628: AND ttp2.template_canvas_id = tcn.template_canvas_id
629: AND tcn.template_window_id = twn.template_window_id
630: AND twn.form_template_id = p_form_template_id

Line 751: hr_template_item_tab_pages_api.create_template_item_tab_page(

747: hr_utility.set_location('Entering:'|| l_proc, 35);
748:
749: FOR cur_rec in cur_tab_page LOOP
750:
751: hr_template_item_tab_pages_api.create_template_item_tab_page(
752: p_effective_date => TRUNC(p_effective_date)
753: ,p_template_item_id => l_template_item_id_to
754: ,p_template_tab_page_id => cur_rec.template_tab_page_id
755: ,p_template_item_tab_page_id => l_template_item_tab_page_id

Line 1191: hr_template_item_tab_pages_api.create_template_item_tab_page(

1187:
1188: hr_utility.set_location('Entering:'|| l_proc, 45);
1189:
1190: IF p_template_tab_page_id is not null THEN
1191: hr_template_item_tab_pages_api.create_template_item_tab_page(
1192: p_effective_date => TRUNC(p_effective_date)
1193: ,p_template_item_id => l_template_item_id
1194: ,p_template_tab_page_id => p_template_tab_page_id
1195: ,p_template_item_tab_page_id => l_template_item_tab_page_id

Line 1360: FROM hr_template_item_tab_pages

1356: CURSOR cur_tab_page
1357: IS
1358: SELECT template_item_tab_page_id
1359: ,object_version_number
1360: FROM hr_template_item_tab_pages
1361: WHERE template_item_id = p_template_item_id;
1362:
1363: l_temp number;
1364:

Line 1446: hr_template_item_tab_pages_api.delete_template_item_tab_page(

1442:
1443: hr_utility.set_location('Entering:'|| l_proc, 30);
1444:
1445: FOR cur_rec IN cur_tab_page LOOP
1446: hr_template_item_tab_pages_api.delete_template_item_tab_page(
1447: p_template_item_tab_page_id => cur_rec.template_item_tab_page_id
1448: ,p_object_version_number => cur_rec.object_version_number);
1449: END LOOP;
1450: