APPS.PQH_TEM_DEL dependencies on PQH_TEMPLATES

Line 53: p_entity_name=>'PQH_TEMPLATES',

49: Begin
50: hr_utility.set_location('Entering:'||l_proc, 5);
51: --
52: PER_RIC_PKG.chk_integrity(
53: p_entity_name=>'PQH_TEMPLATES',
54: p_ref_entity_info =>
55: PER_RIC_PKG.ref_entity_tbl(
56: PER_RIC_PKG.ref_info_rec('PQH_REF_TEMPLATES',PER_RIC_PKG.column_info_tbl(
57: PER_RIC_PKG.col_info_rec('BASE_TEMPLATE_ID', NULL,p_rec.template_id, NULL))),

Line 62: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES_TL', PER_RIC_PKG.column_info_tbl(

58: PER_RIC_PKG.ref_info_rec('PQH_REF_TEMPLATES',PER_RIC_PKG.column_info_tbl(
59: PER_RIC_PKG.col_info_rec('PARENT_TEMPLATE_ID', NULL,p_rec.template_id, NULL))),
60: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATE_ATTRIBUTES', PER_RIC_PKG.column_info_tbl(
61: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,p_rec.template_id,NULL))),
62: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES_TL', PER_RIC_PKG.column_info_tbl(
63: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,p_rec.template_id,NULL)))),
64: p_ref_type=>'DEL');
65: --
66: -- Delete the pqh_templates row.

Line 66: -- Delete the pqh_templates row.

62: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES_TL', PER_RIC_PKG.column_info_tbl(
63: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,p_rec.template_id,NULL)))),
64: p_ref_type=>'DEL');
65: --
66: -- Delete the pqh_templates row.
67: --
68: delete from pqh_templates
69: where template_id = p_rec.template_id;
70: --

Line 68: delete from pqh_templates

64: p_ref_type=>'DEL');
65: --
66: -- Delete the pqh_templates row.
67: --
68: delete from pqh_templates
69: where template_id = p_rec.template_id;
70: --
71: --
72: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 191: (p_module_name => 'pqh_templates'

187: --
188: when hr_api.cannot_find_prog_unit then
189: --
190: hr_api.cannot_find_prog_unit_error
191: (p_module_name => 'pqh_templates'
192: ,p_hook_type => 'AD');
193: --
194: end;
195: --