1 PACKAGE XTR_WORKFLOW_PKG AUTHID CURRENT_USER AS
2 /* $Header: xtrwfpks.pls 120.1 2005/06/29 07:22:28 rjose ship $*/
3
4 FUNCTION CREATE_XTR_ROLES(p_role_users IN VARCHAR2,
5 p_expiration_date IN DATE) RETURN VARCHAR2;
6
7 PROCEDURE START_WORKFLOW(p_process IN VARCHAR2,
8 p_owner IN VARCHAR2,
9 p_deal_no IN NUMBER,
10 p_trans_no IN NUMBER,
11 p_deal_type IN VARCHAR2,
12 p_log_id IN NUMBER default null,
13 p_varnum_1 IN NUMBER default null,
14 p_varnum_2 IN NUMBER default null,
15 p_varchar_1 IN VARCHAR2 default null,
16 p_varchar_2 IN VARCHAR2 default null,
17 p_vardate_1 IN DATE default null,
18 p_vardate_2 IN DATE default null);
19
20 PROCEDURE START_LIMITS_NTF(p_process IN VARCHAR2,
21 p_owner IN VARCHAR2,
22 p_receiver IN VARCHAR2,
23 p_log_id IN NUMBER);
24
25 PROCEDURE LIMITS_BREACHED_DOC(document_id IN VARCHAR2,
26 display_type IN VARCHAR2,
27 document IN OUT NOCOPY VARCHAR2,
28 document_type IN OUT NOCOPY VARCHAR2);
29
30 PROCEDURE DELETE_XTR_USERS(p_name IN VARCHAR2,
31 p_dsp_name IN VARCHAR2,
32 p_email IN VARCHAR2);
33
34 END XTR_WORKFLOW_PKG;
35