1 PACKAGE CSM_SERIAL_NUMBERS_EVENT_PKG
2 /* $Header: csmeslns.pls 120.2 2006/05/22 06:56:35 trajasek noship $*/
3 AUTHID CURRENT_USER AS
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_SERIAL_NUMBERS_ACC;
16
17 PROCEDURE DELETE_OLD_ORG_SERIAL_NUMBERS(p_organization_id IN number
18 , p_user_id IN number
19 , p_resource_id IN number);
20
21 PROCEDURE GET_NEW_ORG_SERIAL_NUMBERS(p_organization_id IN number
22 , p_user_id IN number
23 , p_resource_id IN number);
24
25 PROCEDURE INV_LOC_ASS_MSN_MAKE_DIRTY_I(p_csp_inv_loc_assignment_id IN NUMBER,
26 p_user_id IN NUMBER);
27
28 PROCEDURE INV_LOC_ASS_MSN_MAKE_DIRTY_D(p_csp_inv_loc_assignment_id IN NUMBER,
29 p_user_id IN NUMBER);
30
31 PROCEDURE INSERT_MTL_SERIAL_NUMBERS(p_organization_id IN number,
32 p_last_run_date IN date, p_resource_id IN number, p_user_id IN number);
33
34 END; -- Package spec