DBA Data[Home] [Help]

APPS.PQH_RHT_INS dependencies on PQH_ROUTING_HISTORY

Line 56: -- Insert the row into: pqh_routing_history

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_history
57: --
58: insert into pqh_routing_history
59: ( routing_history_id,
60: approval_cd,

Line 58: insert into pqh_routing_history

54: --
55: --
56: -- Insert the row into: pqh_routing_history
57: --
58: insert into pqh_routing_history
59: ( routing_history_id,
60: approval_cd,
61: comments,
62: forwarded_by_assignment_id,

Line 169: Cursor C_Sel1 is select pqh_routing_history_s.nextval from sys.dual;

165: Procedure pre_insert(p_rec in out nocopy pqh_rht_shd.g_rec_type) is
166: --
167: l_proc varchar2(72) := g_package||'pre_insert';
168: --
169: Cursor C_Sel1 is select pqh_routing_history_s.nextval from sys.dual;
170: --
171: Begin
172: hr_utility.set_location('Entering:'||l_proc, 5);
173: --

Line 266: (p_module_name => 'pqh_routing_history'

262: --
263: when hr_api.cannot_find_prog_unit then
264: --
265: hr_api.cannot_find_prog_unit_error
266: (p_module_name => 'pqh_routing_history'
267: ,p_hook_type => 'AI');
268: --
269: end;
270: --