1 PACKAGE PER_RESPOWNER_UTIL_SS AUTHID CURRENT_USER AS
2 /* $Header: perroutl.pkh 120.0 2005/05/31 19:40:44 appldev noship $ */
3
4 -- Global Variables
5 gv_package CONSTANT VARCHAR2(100) DEFAULT 'per_respowner_util_ss';
6
7 gv_user_name_stmt CONSTANT VARCHAR2(2000) DEFAULT
8 'select user_name from fnd_user '||
9 ' where trunc(sysdate) between trunc(start_date) '||
10 ' and nvl(trunc(end_date), trunc(sysdate)) ';
11
12 TYPE resp_owner_table IS TABLE OF per_responsibility_owner%ROWTYPE INDEX BY BINARY_INTEGER ;
13 TYPE ref_cursor IS REF CURSOR;
14
15 PROCEDURE populate_respowner_temp_table (
16 p_fnd_object in varchar2
17 ,p_user_name in varchar2
18 );
19
20 PROCEDURE raise_wfevent(
21 p_event_name in varchar2
22 ,p_event_data in wf_parameter_list_t
23 ,p_resp_name in varchar2
24 ,p_owner in varchar2
25 ,p_userid_clause in varchar2 default null
26 );
27
28
29 PROCEDURE revoke_block(
30 itemtype in varchar2
31 ,itemkey in varchar2
32 ,actid in number
33 ,funmode in varchar2
34 ,result in out nocopy varchar2
35 );
36
37 /*This is test subscription function to test the event 'oracle.apps.per.selfservice.respowner.revoke_access'.
38 Uncomment to test, btw needs to create revoke_access_table though.
39 FUNCTION revoke_access_wfevent_subscrb
40 ( p_subscription_guid in raw,
41 p_event in out NOCOPY wf_event_t)
42 RETURN VARCHAR2;
43 */
44
45 END PER_RESPOWNER_UTIL_SS;