1 PACKAGE CSL_CSF_DEBRIEF_LINE_ACC_PKG AUTHID CURRENT_USER AS
2 /* $Header: csldbacs.pls 120.0 2005/05/25 11:06:50 appldev noship $ */
3
4 FUNCTION Get_Debrief_Header_Id( p_debrief_line_id NUMBER)
5 RETURN NUMBER;
6 /*** Function that returns a debrief line id given a debrief line id ***/
7
8 FUNCTION Replicate_Record
9 ( p_debrief_line_id NUMBER
10 )
11 RETURN BOOLEAN;
12 /*** Function that checks if debrief line should be replicated. Returns TRUE if it should ***/
13
14 FUNCTION Pre_Insert_Child
15 ( p_debrief_line_id IN NUMBER
16 ,p_resource_id IN NUMBER
17 )
18 RETURN BOOLEAN;
19 /***
20 Public function that gets called when a debrief line needs to be inserted into ACC table.
21 Returns TRUE when record already was or has been inserted into ACC table.
22 ***/
23
24 PROCEDURE Pre_Insert_Children
25 ( p_task_assignment_id IN NUMBER
26 ,p_resource_id IN NUMBER
27 );
28 /***
29 Public function that gets called when debrief lines need to be inserted into ACC table.
30 ***/
31
32 PROCEDURE Post_Delete_Child
33 ( p_debrief_line_id IN NUMBER
34 ,p_resource_id IN NUMBER
35 );
36 /***
37 Public procedure that gets called when a debrief line needs to be deleted from ACC table.
38 ***/
39
40 PROCEDURE Post_Delete_Children
41 ( p_task_assignment_id IN NUMBER
42 ,p_resource_id IN NUMBER
43 );
44 /***
45 Public procedure that gets called when debrief lines need to be deleted from ACC table.
46 ***/
47
48 PROCEDURE PRE_INSERT_DEBRIEF_LINE ( x_return_status OUT NOCOPY varchar2);
49 /* Called before debrief Insert */
50
51 PROCEDURE POST_INSERT_DEBRIEF_LINE ( x_return_status OUT NOCOPY varchar2);
52 /* Called after debrief Insert */
53
54 PROCEDURE PRE_UPDATE_DEBRIEF_LINE ( x_return_status OUT NOCOPY varchar2);
55 /* Called before debrief Update */
56
57 PROCEDURE POST_UPDATE_DEBRIEF_LINE ( x_return_status OUT NOCOPY varchar2);
58 /* Called after debrief Update */
59
60 PROCEDURE PRE_DELETE_DEBRIEF_LINE ( x_return_status OUT NOCOPY varchar2);
61 /* Called before debrief Delete */
62
63 PROCEDURE POST_DELETE_DEBRIEF_LINE ( x_return_status OUT NOCOPY varchar2);
64 /* Called after debrief Delete */
65
66 END CSL_CSF_DEBRIEF_LINE_ACC_PKG;