1 package amw_cm_event_listner_pkg as
2 /*$Header: amwcmlss.pls 120.1 2005/12/06 07:15:03 appldev noship $*/
3
4 FUNCTION listen_cm_approval
5 ( p_subscription_guid in raw,
6 p_event in out NOCOPY wf_event_t
7 ) return VARCHAR2;
8
9 ---10.11.2005 npanandi: changed the signature of
10 ---listen_cm_approval to the below procedure
11 ---bug 4473863 fix
12 procedure UPDATE_APPROVAL_STATUS(
13 p_change_id in number
14 ,p_base_change_mgmt_type_code in varchar2
15 ,p_new_approval_status_code in varchar2
16 ,p_workflow_status_code in varchar2
17 ,x_return_status out nocopy varchar2
18 ,x_msg_count out nocopy number
19 ,x_msg_data out nocopy varchar2
20 );
21
22 end amw_cm_event_listner_pkg;