1 PACKAGE wms_crossdock_grp AS
2 /* $Header: WMSXDGRS.pls 120.3 2005/07/06 13:47:28 stdavid noship $ */
3
4 g_pkg_spec_ver CONSTANT VARCHAR2(100) := '$Header: WMSXDGRS.pls 120.3 2005/07/06 13:47:28 stdavid noship $';
5 g_pkg_name CONSTANT VARCHAR2(30) := 'WMS_CROSSDOCK_GRP';
6
7
8 --
9 --
10 -- VALIDATE_PLANXDOCK_CRT_ID:
11 --
12 -- Returns fnd_api.g_ret_sts_success if p_criterion_id is a valid
13 -- crossdock criterion of type 'Planned'
14 --
15 -- Returns fnd_api.g_ret_sts_error if p_criterion_id is not valid
16 -- or if criterion type is not 'Planned'
17 --
18 -- Returns fnd_api.g_ret_sts_unexp_error for unexpected errors
19 --
20 --
21
22 PROCEDURE validate_planxdock_crt_id
23 ( x_return_status OUT NOCOPY VARCHAR2
24 , p_criterion_id IN NUMBER
25 );
26
27
28 --
29 --
30 -- CHK_PLANXD_CRT_ID_NAME:
31 --
32 -- If a valid ID is passed in, it returns criterion name
33 -- Or else if a valid criterion name is passed in, the ID is returned
34 --
35 -- Returns fnd_api.g_ret_sts_success for success
36 --
37 -- Returns fnd_api.g_ret_sts_error if ID/name is not valid
38 -- or if criterion type is not 'Planned'
39 --
40 -- Returns fnd_api.g_ret_sts_unexp_error for unexpected errors
41 --
42 --
43
44 PROCEDURE chk_planxd_crt_id_name
45 ( x_return_status OUT NOCOPY VARCHAR2
46 , p_criterion_id IN OUT NOCOPY NUMBER
47 , p_criterion_name IN OUT NOCOPY VARCHAR2
48 );
49
50
51 --
52 --
53 -- CHK_MO_TYPE:
54 --
55 -- Takes in a move order line and returns move order header ID,
56 -- move order type, and whether or not it is a putaway move order
57 --
58 -- Returns fnd_api.g_ret_sts_success for success
59 --
60 -- Returns fnd_api.g_ret_sts_error if ID/name is not valid
61 -- or if criterion type is not 'Planned'
62 --
63 -- Returns fnd_api.g_ret_sts_unexp_error for unexpected errors
64 --
65 --
66
67 PROCEDURE chk_mo_type
68 ( x_return_status OUT NOCOPY VARCHAR2
69 , x_mo_header_id OUT NOCOPY NUMBER
70 , x_mo_type OUT NOCOPY NUMBER
71 , x_is_putaway_mo OUT NOCOPY VARCHAR2
72 , p_mo_line_id IN NUMBER
73 );
74
75 END wms_crossdock_grp;