DBA Data[Home] [Help]

APPS.PQH_RST_DEL dependencies on PQH_RULE_SETS

Line 57: p_entity_name=>'PQH_RULE_SETS',

53: -- Added the following code as a part of Zero Downtime Patching Project.
54: -- Code Starts Here.
55: --
56: per_ric_pkg.Chk_integrity(
57: p_entity_name=>'PQH_RULE_SETS',
58: p_ref_entity=>'PQH_RULES',
59: p_ref_column_name=>'RULE_SET_ID',
60: p_ref_col_value_number=>p_rec.rule_set_id,
61: p_ref_col_value_varchar=>NULL,

Line 68: -- Delete the pqh_rule_sets row.

64: --
65: -- Code Ends Here
66: --
67: --
68: -- Delete the pqh_rule_sets row.
69: --
70: delete from pqh_rule_sets
71: where rule_set_id = p_rec.rule_set_id;
72: --

Line 70: delete from pqh_rule_sets

66: --
67: --
68: -- Delete the pqh_rule_sets row.
69: --
70: delete from pqh_rule_sets
71: where rule_set_id = p_rec.rule_set_id;
72: --
73: --
74: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 195: (p_module_name => 'pqh_rule_sets'

191: --
192: when hr_api.cannot_find_prog_unit then
193: --
194: hr_api.cannot_find_prog_unit_error
195: (p_module_name => 'pqh_rule_sets'
196: ,p_hook_type => 'AD');
197: --
198: end;
199: --