1 PACKAGE wms_rule_gen_pkgs AUTHID CURRENT_USER AS
2 /* $Header: WMSGNPKS.pls 115.5 2002/12/01 04:58:59 rbande noship $ */
3
4 TYPE tbl_long_type IS TABLE OF LONG INDEX BY BINARY_INTEGER;
5 PROCEDURE GenerateRuleExecPkgs
6 (p_api_version IN NUMBER ,
7 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false ,
8 p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full ,
9 x_return_status OUT NOCOPY VARCHAR2 ,
10 x_msg_count OUT NOCOPY NUMBER ,
11 x_msg_data OUT NOCOPY VARCHAR2 ,
12 p_pick_code IN NUMBER DEFAULT NULL ,
13 p_put_code IN NUMBER DEFAULT NULL ,
14 p_task_code IN NUMBER DEFAULT NULL ,
15 p_label_code IN NUMBER DEFAULT NULL ,
16 p_CG_code IN NUMBER DEFAULT NULL ,
17 p_OP_code IN NUMBER DEFAULT NULL ,
18 p_pkg_type IN VARCHAR2 DEFAULT NULL
19 );
20
21 PROCEDURE update_count(
22 p_rule_type IN VARCHAR2
23 , p_count IN NUMBER );
24
25
26 FUNCTION get_count_no_lock(p_rule_type IN VARCHAR2)
27 RETURN NUMBER ;
28
29 FUNCTION get_count_with_lock(P_RULE_TYPE IN VARCHAR2 )
30 RETURN NUMBER;
31
32
33
34
35 END wms_rule_gen_pkgs;
36
37