APPS.HR_FORM_TEMPLATES_API dependencies on HR_SOURCE_FORM_TEMPLATES

Line 209: FROM hr_source_form_templates sft

205: (p_form_template_id IN NUMBER
206: )
207: IS
208: SELECT sft.form_template_id_from
209: FROM hr_source_form_templates sft
210: WHERE sft.form_template_id_to = p_form_template_id;
211: l_source_form_template csr_source_form_templates%ROWTYPE;
212:
213: l_proc varchar2(72) := g_package||'copy_template';

Line 443: hr_source_form_templates_bsi.create_source_form_template(

439: EXIT;
440: END IF;
441: END LOOP;
442:
443: hr_source_form_templates_bsi.create_source_form_template(
444: p_effective_date => TRUNC(p_effective_date)
445: ,p_form_template_id_to => l_form_template_id_to
446: ,p_form_template_id_from => l_form_template_id_from
447: ,p_source_form_template_id => l_source_form_template_id

Line 877: hr_source_form_templates_bsi.create_source_form_template(

873: hr_utility.set_location(' At:'||l_proc, 30);
874:
875: IF g_session_mode <> 'SEED_DATA' THEN
876:
877: hr_source_form_templates_bsi.create_source_form_template(
878: p_effective_date => TRUNC(p_effective_date)
879: ,p_form_template_id_to => l_form_template_id
880: ,p_form_template_id_from => NULL
881: ,p_source_form_template_id => l_source_form_template_id

Line 1050: FROM hr_source_form_templates

1046:
1047: CURSOR cur_del_form_tmplt
1048: IS
1049: SELECT source_form_template_id
1050: FROM hr_source_form_templates
1051: WHERE form_template_id_to = p_form_template_id;
1052:
1053: l_temp number;
1054:

Line 1058: FROM hr_source_form_templates hsf

1054:
1055: CURSOR cur_api_val
1056: IS
1057: SELECT source_form_template_id
1058: FROM hr_source_form_templates hsf
1059: WHERE hsf.form_template_id_to = p_form_template_id;
1060:
1061: l_proc varchar2(72) := g_package||'delete_template';
1062: begin

Line 1140: hr_source_form_templates_bsi.delete_source_form_template

1136:
1137: hr_utility.set_location('At:'|| l_proc, 80);
1138:
1139: FOR cur_rec in cur_del_form_tmplt LOOP
1140: hr_source_form_templates_bsi.delete_source_form_template
1141: (p_source_form_template_id => cur_rec.source_form_template_id
1142: ,p_object_version_number => p_object_version_number);
1143: END LOOP;
1144:

Line 1300: FROM hr_source_form_templates hsf

1296:
1297: CURSOR cur_api_val
1298: IS
1299: SELECT source_form_template_id
1300: FROM hr_source_form_templates hsf
1301: WHERE hsf.form_template_id_to = p_form_template_id;
1302:
1303: l_proc varchar2(72) := g_package||'update_template';
1304: l_object_version_number number;