1 PACKAGE ENI_UPD_ASSGN AUTHID CURRENT_USER AS
2 /* $Header: ENIIASGS.pls 115.0 2003/07/01 14:50:26 dsakalle noship $ */
3
4 -- This Public Procedure is used to Update Item Assignment flag in denorm table
5 PROCEDURE UPDATE_ASSGN_FLAG(
6 p_new_category_id IN NUMBER,
7 p_old_category_id IN NUMBER,
8 x_return_status OUT NOCOPY VARCHAR2,
9 x_msg_count OUT NOCOPY NUMBER,
10 x_msg_data OUT NOCOPY VARCHAR2);
11
12 END ENI_UPD_ASSGN;