1 PACKAGE OKE_CHECK_HOLD_PKG AUTHID CURRENT_USER AS
2 /*$Header: OKECKHDS.pls 115.6 2003/10/13 05:21:44 yliou ship $ */
3
4
5 -- GLOBAL VARIABLES
6
7 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKE_CHECK_HOLD_PKG';
8 G_APP_NAME CONSTANT VARCHAR2(200) := OKE_API.G_APP_NAME;
9
10 -- Overloading function : with OUT parameters, return TRUE or FALSE
11 -- for PL/SQL in forms.
12 FUNCTION is_hold(p_api_version IN NUMBER,
13 p_init_msg_list IN VARCHAR2,
14 x_return_status OUT NOCOPY VARCHAR2,
15 x_msg_count OUT NOCOPY NUMBER,
16 x_msg_data OUT NOCOPY VARCHAR2,
17 p_hold_level IN VARCHAR2,
18 p_k_header_id IN NUMBER,
19 p_k_line_id IN NUMBER,
20 p_deliverable_id IN NUMBER)
21 RETURN BOOLEAN;
22 -- Overloading function : no OUT parameters, return 1 or 0
23 -- for SQL view
24 FUNCTION is_hold(p_hold_level IN VARCHAR2,
25 p_k_header_id IN NUMBER,
26 p_k_line_id IN NUMBER,
27 p_deliverable_id IN NUMBER)
28 RETURN NUMBER;
29
30
31 /*-------------------------------------------------------------------------
32 FUNCTION get_hold_descr - get contract description
33 if the hold is on contract level
34 get line description if the hold is on line level
35 get deliverable description if the hold is on
36 deliverable level
37 --------------------------------------------------------------------------*/
38 FUNCTION get_hold_descr (p_k_header_id IN NUMBER,
39 p_k_line_id IN NUMBER,
40 p_deliverable_id IN NUMBER)
41 RETURN VARCHAR2;
42
43 END OKE_CHECK_HOLD_PKG;
44