1 Package ghr_prh_api AUTHID CURRENT_USER as
2 /* $Header: ghprhapi.pkh 115.1 1999/11/09 16:03:47 pkm ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |--------------------------< upd_date_notif_sent>--------------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 -- {Start Of Comments}
9 --
10 -- Description:
11 -- This api updates the ghr_pa_notifications table with the date_notification_sent
12 --
13 -- Prerequisites:
14 --
15 -- In Parameters:
16 -- Name Reqd Type Description
17 -- p_validate boolean If true, the database remains
18 -- unchanged. If false the
19 -- assignment will be updated in
20 -- p_pa_request_id Y number
21 -- p_date_notification_sent date
22
23 -- Post Success:
24 -- The pa_routing_history record is update
25 --
26 -- Post Failure:
27 -- The api will not update the pa_routing_history record and raises an error
28 --
29 -- Access Status:
30 -- Public.
31 --
32 -- {End Of Comments}
33 --
34
35 procedure upd_date_notif_sent
36 (p_validate in boolean default false,
37 p_pa_request_id in number,
38 p_date_notification_sent in date default trunc(sysdate)
39 );
40 end ghr_prh_api;