1 PACKAGE CSL_JTF_TASK_ASS_ACC_PKG AS
2 /* $Header: csltaacs.pls 120.0 2005/05/25 10:59:37 appldev noship $ */
3
4 FUNCTION Replicate_Record
5 ( p_task_assignment_id IN NUMBER
6 , p_flow_type IN NUMBER DEFAULT CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL
7 )
8 RETURN BOOLEAN;
9 /*** Function that checks if assignment record should be replicated. Returns TRUE if it should ***/
10
11 FUNCTION Pre_Insert_Child
12 ( p_task_assignment_id IN NUMBER
13 ,p_resource_id IN NUMBER
14 ,p_flow_type IN NUMBER DEFAULT CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL
15 )
16 RETURN BOOLEAN;
17 /***
18 Public function that gets called when an assignment needs to be inserted into ACC table.
19 Returns TRUE when record already was or has been inserted into ACC table.
20 ***/
21
22 PROCEDURE Post_Delete_Child
23 ( p_task_assignment_id IN NUMBER
24 ,p_resource_id IN NUMBER
25 ,p_flow_type IN NUMBER DEFAULT CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL
26 );
27 /***
28 Public procedure that gets called when an assignment needs to be deleted from ACC table.
29 ***/
30
31 PROCEDURE INSERT_ALL_ACC_RECORDS( p_resource_id IN NUMBER
32 , x_return_status OUT NOCOPY VARCHAR2 );
33 /*Procedure that gets called when a user gets created*/
34 PROCEDURE DELETE_ALL_ACC_RECORDS( p_resource_id IN NUMBER
35 , x_return_status OUT NOCOPY VARCHAR2 );
36 /*Procedure that gets called when a user gets deleted*/
37
38 PROCEDURE PRE_INSERT_TASK_ASSIGNMENT ( x_return_status OUT NOCOPY varchar2);
39 /* Called before assignment Insert */
40
41 PROCEDURE POST_INSERT_TASK_ASSIGNMENT ( x_return_status OUT NOCOPY varchar2);
42 /* Called after assignment Insert */
43
44 PROCEDURE PRE_UPDATE_TASK_ASSIGNMENT ( x_return_status OUT NOCOPY varchar2);
45 /* Called before assignment Update */
46
47 PROCEDURE POST_UPDATE_TASK_ASSIGNMENT ( x_return_status OUT NOCOPY varchar2);
48 /* Called after assignment Update */
49
50 PROCEDURE PRE_DELETE_TASK_ASSIGNMENT ( x_return_status OUT NOCOPY varchar2);
51 /* Called before assignment Delete */
52
53 PROCEDURE POST_DELETE_TASK_ASSIGNMENT ( x_return_status OUT NOCOPY varchar2);
54 /* Called after assignment Delete */
55
56 /*Added by UTEKUMAL - Procedure to purge completed/expired Tasks Assignments*/
57 --Bug 3475657
58 PROCEDURE PURGE_TASK_ASSIGNMENTS(p_status OUT NOCOPY VARCHAR2,
59 p_message OUT NOCOPY VARCHAR2);
60 END CSL_JTF_TASK_ASS_ACC_PKG;