1 PACKAGE CSL_CSI_ITEM_INSTANCES_ACC_PKG AS
2 /* $Header: csliiacs.pls 120.0 2005/05/24 18:39:56 appldev noship $ */
3
4 FUNCTION Replicate_Record
5 ( p_instance_id NUMBER
6 , p_resource_id NUMBER
7 )
8 RETURN BOOLEAN;
9 /*** Function that checks if item instance record should be replicated. Returns TRUE if it should ***/
10
11 FUNCTION Pre_Insert_Child
12 ( p_instance_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 -- ER 3168446
16 ,p_party_site_id IN NUMBER
17 )
18 RETURN BOOLEAN;
19
20 /***
21 Public function that gets called when an item instance needs to be inserted into ACC table.
22 Returns TRUE when record already was or has been inserted into ACC table.
23 ***/
24
25 PROCEDURE Post_Delete_Child
26 ( p_instance_id IN NUMBER
27 ,p_resource_id IN NUMBER
28 ,p_flow_type IN NUMBER DEFAULT CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL
29 -- ER 3168446
30 ,p_party_site_id IN NUMBER
31 );
32 /***
33 Public procedure that gets called when an item instance needs to be deleted from ACC table.
34 ***/
35
36 PROCEDURE Pre_Insert_Item
37 ( p_inventory_item_id IN NUMBER
38 , p_organization_id IN NUMBER
39 , p_subinventory_code IN VARCHAR2
40 , p_resource_id IN NUMBER
41 );
42
43 PROCEDURE Post_Delete_Item
44 ( p_inventory_item_id IN NUMBER
45 , p_organization_id IN NUMBER
46 , p_subinventory_code IN VARCHAR2
47 , p_resource_id IN NUMBER
48 );
49
50 /*Procedure that gets called from mtl_onhand quantities for trackable items*/
51
52 PROCEDURE PRE_INSERT_ITEM_INSTANCE ( x_return_status OUT NOCOPY varchar2);
53 /* Called before item instance Insert */
54
55 PROCEDURE POST_INSERT_ITEM_INSTANCE ( p_api_version IN NUMBER
56 , P_Init_Msg_List IN VARCHAR2
57 , P_Commit IN VARCHAR2
58 , p_validation_level IN NUMBER
59 , p_instance_id IN NUMBER
60 , X_Return_Status OUT NOCOPY VARCHAR2
61 , X_Msg_Count OUT NOCOPY NUMBER
62 , X_Msg_Data OUT NOCOPY VARCHAR2);
63
64 /* Called after item instance Insert */
65
66 PROCEDURE PRE_UPDATE_ITEM_INSTANCE ( x_return_status OUT NOCOPY varchar2);
67 /* Called before item instance Update */
68
69 PROCEDURE POST_UPDATE_ITEM_INSTANCE ( x_return_status OUT NOCOPY varchar2);
70 /* Called after item instance Update */
71
72 PROCEDURE PRE_DELETE_ITEM_INSTANCE ( x_return_status OUT NOCOPY varchar2);
73 /* Called before item instance Delete */
74
75 PROCEDURE POST_DELETE_ITEM_INSTANCE ( x_return_status OUT NOCOPY varchar2);
76 /* Called after item instance Delete */
77
78 PROCEDURE CONC_ITEM_INSTANCES (p_last_run_date IN DATE);
79 /* Concurrent program to update all Item instances */
80
81 --Conc prog to bring down the extended item attributes. ER 3724152
82 PROCEDURE Con_Item_Attr( p_status OUT NOCOPY VARCHAR2,
83 p_message OUT NOCOPY VARCHAR2);
84
85 END CSL_CSI_ITEM_INSTANCES_ACC_PKG;
[Home] [Help]