DBA Data[Home] [Help]

APPS.PQH_RLM_INS dependencies on PQH_ROUTING_LIST_MEMBERS

Line 56: -- Insert the row into: pqh_routing_list_members

52: hr_utility.set_location('Entering:'||l_proc, 5);
53: p_rec.object_version_number := 1; -- Initialise the object version
54: --
55: --
56: -- Insert the row into: pqh_routing_list_members
57: --
58: insert into pqh_routing_list_members
59: ( role_id,
60: routing_list_id,

Line 58: insert into pqh_routing_list_members

54: --
55: --
56: -- Insert the row into: pqh_routing_list_members
57: --
58: insert into pqh_routing_list_members
59: ( role_id,
60: routing_list_id,
61: routing_list_member_id,
62: seq_no,

Line 139: Cursor C_Sel1 is select pqh_routing_list_members_s.nextval from sys.dual;

135: Procedure pre_insert(p_rec in out nocopy pqh_rlm_shd.g_rec_type) is
136: --
137: l_proc varchar2(72) := g_package||'pre_insert';
138: --
139: Cursor C_Sel1 is select pqh_routing_list_members_s.nextval from sys.dual;
140: --
141: Begin
142: hr_utility.set_location('Entering:'||l_proc, 5);
143: --

Line 217: (p_module_name => 'pqh_routing_list_members'

213: --
214: when hr_api.cannot_find_prog_unit then
215: --
216: hr_api.cannot_find_prog_unit_error
217: (p_module_name => 'pqh_routing_list_members'
218: ,p_hook_type => 'AI');
219: --
220: end;
221: --