1 PACKAGE PA_CI_ACTIONS_UTIL AUTHID CURRENT_USER AS
2 /* $Header: PACIACUS.pls 115.9 2003/02/24 20:09:43 atwang noship $ */
3
4 Function action_with_reply(p_ci_action_id in number)
5 return varchar2;
6
7 PROCEDURE CheckHzPartyName_Or_Id(
8 p_resource_id IN NUMBER,
9 p_resource_name IN VARCHAR2,
10 p_date IN DATE DEFAULT SYSDATE,
11 p_check_id_flag IN VARCHAR2,
12 p_resource_type_id IN NUMBER DEFAULT 101,
13 x_party_id OUT NOCOPY NUMBER,
14 x_resource_type_id OUT NOCOPY NUMBER,
15 x_return_status OUT NOCOPY VARCHAR2,
16 x_msg_count OUT NOCOPY NUMBER,
17 x_msg_data OUT NOCOPY VARCHAR2 );
18
19 Function get_next_ci_action_number( p_ci_id in number)
20 return number;
21
22 Function get_party_id (
23 p_user_id in number )
24 return number;
25
26 function GET_CI_OPEN_ACTIONS(
27 p_ci_id IN NUMBER := NULL) RETURN NUMBER;
28
29 function GET_MY_ACTIONS(p_action_status IN VARCHAR2,
30 p_ci_id IN NUMBER := NULL) RETURN NUMBER;
31
32 function CHECK_OPEN_ACTIONS_EXIST(p_ci_id IN NUMBER := NULL)
33 RETURN VARCHAR2;
34
35 function GET_TOP_PARENT_ACTION(p_ci_action_id IN NUMBER)
36 RETURN NUMBER;
37
38 END; -- Package Specification PA_CI_ACTIONS_UTILS