1 PACKAGE CSL_JTF_NOTES_ACC_PKG AUTHID CURRENT_USER AS
2 /* $Header: cslntacs.pls 115.4 2002/11/08 14:02:06 asiegers ship $ */
3
4 FUNCTION Replicate_Record
5 ( p_jtf_note_id NUMBER
6 )
7 RETURN BOOLEAN;
8 /*** Function that checks if note should be replicated. Returns TRUE if it should ***/
9
10 FUNCTION Pre_Insert_Child
11 ( p_jtf_note_id IN NUMBER
12 ,p_resource_id IN NUMBER
13 )
14 RETURN BOOLEAN;
15 /***
16 Public function that gets called when a note needs to be inserted into ACC table.
17 Returns TRUE when record already was or has been inserted into ACC table.
18 ***/
19
20 FUNCTION Pre_Insert_Children
21 ( p_source_obj_id IN NUMBER
22 ,p_source_obj_code IN VARCHAR2
23 ,p_resource_id IN NUMBER
24 )
25 RETURN BOOLEAN;
26 /***
27 Public function that gets called when notes needs to be inserted into ACC table.
28 Returns TRUE when record already were or have been inserted into ACC table.
29 ***/
30
31 PROCEDURE Post_Delete_Child
32 ( p_jtf_note_id IN NUMBER
33 ,p_resource_id IN NUMBER
34 );
35 /***
36 Public procedure that gets called when a note needs to be deleted from the ACC table.
37 ***/
38
39 PROCEDURE Post_Delete_Children
40 ( p_source_obj_id IN NUMBER
41 ,p_source_obj_code IN VARCHAR2
42 ,p_resource_id IN NUMBER
43 );
44 /***
45 Public procedure that gets called when notes needs to be deleted from the ACC table.
46 ***/
47
48 PROCEDURE PRE_INSERT_NOTES ( x_return_status OUT NOCOPY varchar2);
49 /* Called before note Insert */
50
51 PROCEDURE POST_INSERT_NOTES ( p_api_version IN NUMBER
52 , p_init_msg_list IN VARCHAR2
53 , p_commit IN VARCHAR2
54 , p_validation_level IN NUMBER
55 , x_msg_count OUT NOCOPY NUMBER
56 , x_msg_data OUT NOCOPY VARCHAR2
57 , x_return_status OUT NOCOPY VARCHAR2
58 , p_jtf_note_id IN NUMBER );
59 /* Called after note Insert */
60
61 PROCEDURE PRE_UPDATE_NOTES ( x_return_status OUT NOCOPY varchar2);
62 /* Called before note Update */
63
64 PROCEDURE POST_UPDATE_NOTES ( p_api_version IN NUMBER
65 , p_init_msg_list IN VARCHAR2
66 , p_commit IN VARCHAR2
67 , p_validation_level IN NUMBER
68 , x_msg_count OUT NOCOPY NUMBER
69 , x_msg_data OUT NOCOPY VARCHAR2
70 , x_return_status OUT NOCOPY VARCHAR2
71 , p_jtf_note_id IN NUMBER );
72 /* Called after note Update */
73
74 PROCEDURE PRE_DELETE_NOTES ( x_return_status OUT NOCOPY varchar2);
75 /* Called before note Delete */
76
77 PROCEDURE POST_DELETE_NOTES ( x_return_status OUT NOCOPY varchar2);
78 /* Called after note Delete */
79
80 END CSL_JTF_NOTES_ACC_PKG;