APPS.PQH_TEM_INS dependencies on PQH_TEMPLATES

Line 56: p_entity_name=> 'PQH_TEMPLATES',

52: hr_utility.set_location('Entering:'||l_proc, 5);
53: p_rec.object_version_number := 1; -- Initialise the object version
54: --
55: per_ric_pkg.Chk_integrity (
56: p_entity_name=> 'PQH_TEMPLATES',
57: p_ref_entity=>'PQH_TRANSACTION_CATEGORIES',
58: p_ref_column_name=>'TRANSACTION_CATEGORY_ID',
59: p_ref_col_value_number=>p_rec.transaction_category_id,
60: p_ref_col_value_varchar=>NULL,

Line 64: -- Insert the row into: pqh_templates

60: p_ref_col_value_varchar=>NULL,
61: p_ref_col_value_date=>NULL,
62: p_ref_type=> 'INS');
63: --
64: -- Insert the row into: pqh_templates
65: --
66: insert into pqh_templates
67: ( template_name,
68: short_name,

Line 66: insert into pqh_templates

62: p_ref_type=> 'INS');
63: --
64: -- Insert the row into: pqh_templates
65: --
66: insert into pqh_templates
67: ( template_name,
68: short_name,
69: template_id,
70: attribute_only_flag,

Line 155: Cursor C_Sel1 is select pqh_templates_s.nextval from sys.dual;

151: Procedure pre_insert(p_rec in out nocopy pqh_tem_shd.g_rec_type) is
152: --
153: l_proc varchar2(72) := g_package||'pre_insert';
154: --
155: Cursor C_Sel1 is select pqh_templates_s.nextval from sys.dual;
156: --
157: Begin
158: hr_utility.set_location('Entering:'||l_proc, 5);
159: --

Line 237: (p_module_name => 'pqh_templates'

233: --
234: when hr_api.cannot_find_prog_unit then
235: --
236: hr_api.cannot_find_prog_unit_error
237: (p_module_name => 'pqh_templates'
238: ,p_hook_type => 'AI');
239: --
240: end;
241: --