eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_FYI_NOTIFY_API dependencies on PQH_FYI_NOTIFY

Line 1: Package Body pqh_fyi_notify_api as

1: Package Body pqh_fyi_notify_api as
2: /* $Header: pqfynapi.pkb 115.4 2002/12/06 18:06:21 rpasapul ship $ */
3: --
4: -- Package Variables
5: --

Line 6: g_package varchar2(33) := ' pqh_fyi_notify_api.';

2: /* $Header: pqfynapi.pkb 115.4 2002/12/06 18:06:21 rpasapul ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' pqh_fyi_notify_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_fyi_notify >----------------------|
10: -- ----------------------------------------------------------------------------

Line 28: l_fyi_notified_id pqh_fyi_notify.fyi_notified_id%TYPE;

24: ) is
25: --
26: -- Declare cursors and local variables
27: --
28: l_fyi_notified_id pqh_fyi_notify.fyi_notified_id%TYPE;
29: l_proc varchar2(72) := g_package||'create_fyi_notify';
30: l_object_version_number pqh_fyi_notify.object_version_number%TYPE;
31: --
32: begin

Line 30: l_object_version_number pqh_fyi_notify.object_version_number%TYPE;

26: -- Declare cursors and local variables
27: --
28: l_fyi_notified_id pqh_fyi_notify.fyi_notified_id%TYPE;
29: l_proc varchar2(72) := g_package||'create_fyi_notify';
30: l_object_version_number pqh_fyi_notify.object_version_number%TYPE;
31: --
32: begin
33: --
34: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 48: pqh_fyi_notify_bk1.create_fyi_notify_b

44: begin
45: --
46: -- Start of API User Hook for the before hook of create_fyi_notify
47: --
48: pqh_fyi_notify_bk1.create_fyi_notify_b
49: (
50: p_transaction_category_id => p_transaction_category_id
51: ,p_transaction_id => p_transaction_id
52: ,p_notification_event_cd => p_notification_event_cd

Line 89: pqh_fyi_notify_bk1.create_fyi_notify_a

85: begin
86: --
87: -- Start of API User Hook for the after hook of create_fyi_notify
88: --
89: pqh_fyi_notify_bk1.create_fyi_notify_a
90: (
91: p_fyi_notified_id => l_fyi_notified_id
92: ,p_transaction_category_id => p_transaction_category_id
93: ,p_transaction_id => p_transaction_id

Line 176: l_object_version_number pqh_fyi_notify.object_version_number%TYPE;

172: --
173: -- Declare cursors and local variables
174: --
175: l_proc varchar2(72) := g_package||'update_fyi_notify';
176: l_object_version_number pqh_fyi_notify.object_version_number%TYPE;
177: --
178: begin
179: --
180: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 196: pqh_fyi_notify_bk2.update_fyi_notify_b

192: begin
193: --
194: -- Start of API User Hook for the before hook of update_fyi_notify
195: --
196: pqh_fyi_notify_bk2.update_fyi_notify_b
197: (
198: p_fyi_notified_id => p_fyi_notified_id
199: ,p_transaction_category_id => p_transaction_category_id
200: ,p_transaction_id => p_transaction_id

Line 238: pqh_fyi_notify_bk2.update_fyi_notify_a

234: begin
235: --
236: -- Start of API User Hook for the after hook of update_fyi_notify
237: --
238: pqh_fyi_notify_bk2.update_fyi_notify_a
239: (
240: p_fyi_notified_id => p_fyi_notified_id
241: ,p_transaction_category_id => p_transaction_category_id
242: ,p_transaction_id => p_transaction_id

Line 314: l_object_version_number pqh_fyi_notify.object_version_number%TYPE;

310: --
311: -- Declare cursors and local variables
312: --
313: l_proc varchar2(72) := g_package||'update_fyi_notify';
314: l_object_version_number pqh_fyi_notify.object_version_number%TYPE;
315: --
316: begin
317: --
318: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 335: pqh_fyi_notify_bk3.delete_fyi_notify_b

331: begin
332: --
333: -- Start of API User Hook for the before hook of delete_fyi_notify
334: --
335: pqh_fyi_notify_bk3.delete_fyi_notify_b
336: (
337: p_fyi_notified_id => p_fyi_notified_id
338: ,p_object_version_number => p_object_version_number
339: ,p_effective_date => trunc(p_effective_date)

Line 363: pqh_fyi_notify_bk3.delete_fyi_notify_a

359: begin
360: --
361: -- Start of API User Hook for the after hook of delete_fyi_notify
362: --
363: pqh_fyi_notify_bk3.delete_fyi_notify_a
364: (
365: p_fyi_notified_id => p_fyi_notified_id
366: ,p_object_version_number => l_object_version_number
367: ,p_effective_date => trunc(p_effective_date)

Line 442: end pqh_fyi_notify_api;

438: hr_utility.set_location(' Leaving:'||l_proc, 70);
439: --
440: end lck;
441: --
442: end pqh_fyi_notify_api;