1 PACKAGE IEX_NOTES_PVT AUTHID CURRENT_USER AS
2 /* $Header: iexvntss.pls 120.3 2004/10/20 13:26:57 jypark ship $ */
3
4 TYPE CONTEXT_REC_TYPE IS RECORD
5 (
6 CONTEXT_TYPE VARCHAR2(100),
7 CONTEXT_ID NUMBER
8 );
9 TYPE CONTEXTS_TBL_TYPE IS TABLE OF CONTEXT_REC_TYPE INDEX BY BINARY_INTEGER;
10
11 TYPE NOTES_SUMMARY_TBL_TYPE IS TABLE OF VARCHAR2(32000) INDEX BY BINARY_INTEGER;
12
13 PROCEDURE Create_Note(
14 p_api_version IN NUMBER,
15 p_init_msg_list IN VARCHAR2,
16 p_commit IN VARCHAR2,
17 p_validation_level IN NUMBER,
18 x_return_status OUT NOCOPY VARCHAR2,
19 x_msg_count OUT NOCOPY NUMBER,
20 x_msg_data OUT NOCOPY VARCHAR2,
21 p_source_object_id IN NUMBER,
22 p_source_object_code IN VARCHAR2,
23 p_note_type IN VARCHAR2,
24 p_notes IN VARCHAR2,
25 p_contexts_tbl IN CONTEXTS_TBL_TYPE,
26 x_note_id OUT NOCOPY NUMBER);
27
28
29 -- create by jypark for notes form's getting notes summary functionality
30 PROCEDURE Get_Notes_Summary(
31 p_api_version IN NUMBER,
32 p_init_msg_list IN VARCHAR2,
33 p_commit IN VARCHAR2,
34 p_validation_level IN NUMBER,
35 x_return_status OUT NOCOPY VARCHAR2,
36 x_msg_count OUT NOCOPY NUMBER,
37 x_msg_data OUT NOCOPY VARCHAR2,
38 p_user_id IN NUMBER,
39 p_object_code IN VARCHAR2,
40 p_object_id IN VARCHAR2,
41 p_summary_order IN VARCHAR2,
42 p_new_line_chr IN VARCHAR2,
43 x_notes_summary_tbl OUT NOCOPY NOTES_SUMMARY_TBL_TYPE);
44
45 FUNCTION GET_NOTE_HISTORY(p_jtf_note_id NUMBER)
46 RETURN VARCHAR2;
47 END;