1 PACKAGE CSL_CSP_INV_LOC_ASS_ACC_PKG AUTHID CURRENT_USER AS
2 /* $Header: cslilacs.pls 115.6 2002/11/08 14:02:41 asiegers ship $ */
3
4 /***
5 Function that checks if Inventory Location Assignment record should be replicated.
6 Returns TRUE if it should
7 ***/
8 FUNCTION Replicate_Record
9 ( p_csp_inv_loc_assignment_id NUMBER
10 )
11 RETURN BOOLEAN;
12
13 /***
14 Public function that gets called when a Inventory Location Assignment needs to be inserted into ACC table.
15 Returns TRUE when record already was or has been inserted into ACC table.
16 ***/
17 FUNCTION Pre_Insert_Child
18 ( p_csp_inv_loc_assignment_id IN NUMBER
19 ,p_resource_id IN NUMBER
20 )
21 RETURN BOOLEAN;
22
23 /***
24 Public procedure that gets called when a Inventory Location Assignment needs to be deleted from ACC table.
25 ***/
26 PROCEDURE Post_Delete_Child
27 ( p_csp_inv_loc_assignment_id IN NUMBER
28 ,p_resource_id IN NUMBER
29 );
30
31 /* Called before assignment Insert */
32 PROCEDURE PRE_INSERT_INV_LOC_ASSIGNMENT ( x_return_status OUT NOCOPY VARCHAR2);
33
34 /* Called after assignment Insert */
35 PROCEDURE POST_INSERT_INV_LOC_ASSIGNMENT ( x_return_status OUT NOCOPY VARCHAR2);
36
37 /* Called before assignment Update */
38 PROCEDURE PRE_UPDATE_INV_LOC_ASSIGNMENT ( x_return_status OUT NOCOPY VARCHAR2);
39
40 /* Called after assignment Update */
41 PROCEDURE POST_UPDATE_INV_LOC_ASSIGNMENT ( x_return_status OUT NOCOPY VARCHAR2);
42
43 /* Called before assignment Delete */
44 PROCEDURE PRE_DELETE_INV_LOC_ASSIGNMENT ( x_return_status OUT NOCOPY VARCHAR2);
45
46 /* Called after assignment Delete */
47 PROCEDURE POST_DELETE_INV_LOC_ASSIGNMENT ( x_return_status OUT NOCOPY VARCHAR2);
48
49 PROCEDURE Delete_All_ACC_Records(
50 p_resource_id IN NUMBER,
51 x_return_status OUT NOCOPY VARCHAR2
52 );
53
54 PROCEDURE Insert_All_ACC_Records(
55 p_resource_id IN NUMBER,
56 x_return_status OUT NOCOPY VARCHAR2
57 );
58
59 END CSL_CSP_INV_LOC_ASS_ACC_PKG;