1 PACKAGE JTF_NOTES_UTIL_PVT AUTHID CURRENT_USER AS
2 /* $Header: jtfvnus.pls 115.8 2002/11/16 00:30:22 hbouten ship $ */
3
4 TYPE JTF_NOTES_CONTEXT_TBL IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
5
6 PROCEDURE GetContexts
7 ( p_api_version IN NUMBER
8 , p_init_msg_list IN VARCHAR2
9 , p_validation_level IN NUMBER
10 , p_note_id IN NUMBER
11 , x_context_count OUT NOCOPY NUMBER
12 , x_context_id OUT NOCOPY JTF_NUMBER_TABLE
13 , x_context_type_code OUT NOCOPY JTF_VARCHAR2_TABLE_100
14 , x_context_type_name OUT NOCOPY JTF_VARCHAR2_TABLE_100
15 , x_context_select_id OUT NOCOPY JTF_NUMBER_TABLE
16 , x_context_select_name OUT NOCOPY JTF_VARCHAR2_TABLE_2000
17 , x_context_select_details OUT NOCOPY JTF_VARCHAR2_TABLE_2000
18 , x_return_status OUT NOCOPY VARCHAR2
19 , x_msg_count OUT NOCOPY NUMBER
20 , x_msg_data OUT NOCOPY VARCHAR2
21 );
22
23 FUNCTION GetNotesDetail
24 (
25 p_note_id IN NUMBER
26 ) RETURN VARCHAR2;
27
28 FUNCTION CheckAttachments
29 (
30 p_note_id IN NUMBER
31 ) RETURN NUMBER;
32
33 FUNCTION HasCLOB
34 (
35 p_note_id IN NUMBER
36 ) RETURN VARCHAR2;
37
38 FUNCTION JTFObjectValid
39 ( p_object_code IN VARCHAR2
40 ) RETURN VARCHAR2;
41
42 FUNCTION SelectNameVARCHAR2
43 ( p_select_name IN VARCHAR2
44 ) RETURN VARCHAR2;
45
46 FUNCTION SelectNameVARCHAR2
47 ( p_select_name IN NUMBER
48 ) RETURN VARCHAR2;
49
50
51 END JTF_NOTES_UTIL_PVT;