PACKAGE: APPS.JTF_NOTES_UTIL_PVT

Source

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;