1 PACKAGE CSM_SERIAL_NUMBERS_EVENT_PKG
2 /* $Header: csmeslns.pls 120.2.12020000.2 2013/04/09 10:59:30 saradhak ship $*/
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(p_status OUT NOCOPY VARCHAR2,
16 p_message OUT NOCOPY VARCHAR2);
17
18 PROCEDURE DELETE_OLD_ORG_SERIAL_NUMBERS(p_organization_id IN number
19 , p_user_id IN number
20 , p_resource_id IN number);
21
22 PROCEDURE GET_NEW_ORG_SERIAL_NUMBERS(p_organization_id IN number
23 , p_user_id IN number
24 , p_resource_id IN number);
25
26 PROCEDURE INV_LOC_ASS_MSN_MAKE_DIRTY_I(p_csp_inv_loc_assignment_id IN NUMBER,
27 p_user_id IN NUMBER);
28
29 PROCEDURE INV_LOC_ASS_MSN_MAKE_DIRTY_D(p_csp_inv_loc_assignment_id IN NUMBER,
30 p_user_id IN NUMBER);
31
32 PROCEDURE INSERT_MTL_SERIAL_NUMBERS(p_organization_id IN number,
33 p_last_run_date IN date, p_resource_id IN number, p_user_id IN number);
34
35 PROCEDURE RECEIVED_MTL_SERIAL_NUM(p_org_id IN NUMBER,p_subinv_code IN VARCHAR2, p_item_id IN NUMBER,
36 p_serial_number IN VARCHAR2,p_user_id IN NUMBER);
37
38 END; -- Package spec