[Home] [Help]
56: p_notification_event_cd IN varchar2,
57: p_notified_type_cd IN varchar2,
58: p_notified_name IN varchar2) IS
59: SELECT COUNT(*)
60: FROM pqh_fyi_notify
61: WHERE transaction_category_id = p_transaction_category_id
62: AND transaction_id = p_transaction_id
63: AND notification_event_cd = p_notification_event_cd
64: AND NVL(notified_type_cd,'X') = NVL(p_notified_type_cd,'X')
93: hr_utility.set_location(' object_version_number: '||p_rec.object_version_number, 14);
94: hr_utility.set_location(' COUNT COMBO: '||l_count, 15);
95: --
96: --
97: -- Insert the row into: pqh_fyi_notify ONLY if the row does not exists i.e l_count = 0
98: --
99:
100: if NVL(l_count,0) = 0 THEN
101: --
98: --
99:
100: if NVL(l_count,0) = 0 THEN
101: --
102: hr_utility.set_location('Inserting INTO pqh_fyi_notify ....',16);
103:
104: insert into pqh_fyi_notify
105: ( fyi_notified_id,
106: transaction_category_id,
100: if NVL(l_count,0) = 0 THEN
101: --
102: hr_utility.set_location('Inserting INTO pqh_fyi_notify ....',16);
103:
104: insert into pqh_fyi_notify
105: ( fyi_notified_id,
106: transaction_category_id,
107: transaction_id,
108: notification_event_cd,
185: Procedure pre_insert(p_rec in out nocopy pqh_fyn_shd.g_rec_type) is
186: --
187: l_proc varchar2(72) := g_package||'pre_insert';
188: --
189: Cursor C_Sel1 is select pqh_fyi_notify_s.nextval from sys.dual;
190: --
191: Begin
192: hr_utility.set_location('Entering:'||l_proc, 5);
193: --
264: --
265: when hr_api.cannot_find_prog_unit then
266: --
267: hr_api.cannot_find_prog_unit_error
268: (p_module_name => 'pqh_fyi_notify'
269: ,p_hook_type => 'AI');
270: --
271: end;
272: --