1 PACKAGE CSM_SYSTEM_ITEM_EVENT_PKG AS
2 /* $Header: csmemsis.pls 120.2 2008/02/06 12:39:43 anaraman ship $ */
3
4 --
5 -- To modify this template, edit file PKGSPEC.TXT in TEMPLATE
6 -- directory of SQL Navigator
7 --
8 -- Purpose: Briefly explain the functionality of the package
9 --
10 -- MODIFICATION HISTORY
11 -- Person Date Comments
12 -- --------- ------ ------------------------------------------
13 -- Enter package declarations as shown below
14
15 PROCEDURE Refresh_mtl_onhand_quantity(p_status OUT NOCOPY VARCHAR2, p_message OUT NOCOPY VARCHAR2);
16
17 PROCEDURE Refresh_Acc (p_status OUT NOCOPY VARCHAR2, p_message OUT NOCOPY VARCHAR2);
18
19 PROCEDURE get_new_user_system_items(p_user_id IN number);
20
21 PROCEDURE SYSTEM_ITEM_MDIRTY_I(p_inventory_item_id IN NUMBER,
22 p_organization_id IN NUMBER,
23 p_user_id IN NUMBER);
24
25 PROCEDURE SYSTEM_ITEM_MDIRTY_D(p_inventory_item_id IN NUMBER,
26 p_organization_id IN NUMBER,
27 p_user_id IN NUMBER);
28
29 -- below procedure is called from csm_mtl_system_items where there is an org change
30 PROCEDURE delete_system_items(p_user_id IN NUMBER,
31 p_organization_id IN NUMBER);
32
33 END CSM_SYSTEM_ITEM_EVENT_PKG; -- Package spec
34