DBA Data[Home] [Help]

APPS.HR_FORM_TEMPLATES_API dependencies on HR_TEMPLATE_ITEMS

Line 195: FROM hr_template_items tit

191:
192: CURSOR cur_tmplt_item
193: IS
194: SELECT tit.template_item_id
195: FROM hr_template_items tit
196: WHERE tit.form_template_id = p_form_template_id_from;
197:
198: CURSOR cur_tmplt_data_group
199: IS

Line 465: hr_template_items_api.copy_template_item(

461:
462: hr_utility.set_location('At:'|| l_proc, 65);
463:
464: FOR cur_rec in cur_tmplt_item LOOP
465: hr_template_items_api.copy_template_item(
466: p_effective_date => TRUNC(p_effective_date)
467: ,p_language_code => l_language_code
468: ,p_template_item_id_from => cur_rec.template_item_id
469: ,p_form_template_id => l_form_template_id_to

Line 1030: FROM hr_template_items

1026: CURSOR cur_del_item
1027: IS
1028: SELECT template_item_id
1029: ,object_version_number
1030: FROM hr_template_items
1031: WHERE form_template_id = p_form_template_id;
1032:
1033: CURSOR cur_del_win
1034: IS

Line 1113: hr_template_items_api.delete_template_item(

1109: IF p_delete_children_flag = 'Y' THEN
1110: hr_utility.set_location('At:'|| l_proc, 50);
1111:
1112: FOR cur_rec in cur_del_item LOOP
1113: hr_template_items_api.delete_template_item(
1114: p_template_item_id => cur_rec.template_item_id
1115: ,p_object_version_number => cur_rec.object_version_number
1116: ,p_delete_children_flag => p_delete_children_flag);
1117: END LOOP;