[Home] [Help]
PACKAGE: APPS.WMS_XDOCK_UTILS_PVT
Source
1 PACKAGE wms_xdock_utils_pvt AUTHID CURRENT_USER AS
2 /* $Header: WMSXDUTS.pls 120.1 2005/06/17 17:21:22 appldev $ */
3
4 g_pkg_spec_ver CONSTANT VARCHAR2(100) := '$Header: WMSXDUTS.pls 120.1 2005/06/17 17:21:22 appldev $';
5 g_pkg_name CONSTANT VARCHAR2(30) := 'WMS_XDOCK_UTILS_PVT';
6
7
8 --
9 -- Constants used in Planned Crossdocking
10 --
11
12 -- Types of sources
13 G_SRC_TYPE_SUP CONSTANT NUMBER := 1; -- Source type SUPPLY
14 G_SRC_TYPE_DEM CONSTANT NUMBER := 2; -- Source type DEMAND
15
16 -- Crossdock criterion types
17 G_CRT_TYPE_OPP CONSTANT NUMBER := 1; -- Criterion type Opportunistic
18 G_CRT_TYPE_PLAN CONSTANT NUMBER := 2; -- Criterion type Planned
19
20 -- Scheduling methods
21 G_APPT_START_TIME CONSTANT NUMBER := 1; -- Start of dock appointment
22 G_APPT_MEAN_TIME CONSTANT NUMBER := 2; -- Mid-point of dock appointment
23 G_APPT_END_TIME CONSTANT NUMBER := 3; -- End of dock appointment
24
25 -- Crossdocking goals
26 G_MINIMIZE_WAIT CONSTANT NUMBER := 1;
27 G_MAXIMIZE_XDOCK CONSTANT NUMBER := 2;
28 G_CUSTOM_GOAL CONSTANT NUMBER := 3;
29
30 -- Demand sources for Opportunistic Crossdock
31 G_OPP_DEM_SO_SCHED CONSTANT NUMBER := 10; -- Sales Order (Scheduled)
32 G_OPP_DEM_SO_BKORD CONSTANT NUMBER := 20; -- Sales Order (Backordered)
33 G_OPP_DEM_IO_SCHED CONSTANT NUMBER := 30; -- Internal Order (Scheduled)
34 G_OPP_DEM_IO_BKORD CONSTANT NUMBER := 40; -- Internal Order (Backordered)
35 G_OPP_DEM_WIP_BKORD CONSTANT NUMBER := 50; -- WIP Component Demand (Backordered)
36
37 -- Supply sources for Opportunistic Crossdock
38 G_OPP_SUP_PO_RCV CONSTANT NUMBER := 10; -- PO (In Receiving)
39 G_OPP_SUP_REQ_RCV CONSTANT NUMBER := 20; -- Internal Req (In Receiving)
40 G_OPP_SUP_WIP CONSTANT NUMBER := 30; -- WIP
41 G_OPP_SUP_INTR_RCV CONSTANT NUMBER := 40; -- In transit shipments (In Receiving)
42
43 -- Demand sources for Planned Crossdock
44 G_PLAN_DEM_SO_SCHED CONSTANT NUMBER := 10; -- Sales Order (Scheduled)
45 G_PLAN_DEM_SO_BKORD CONSTANT NUMBER := 20; -- Sales Order (Backordered)
46 G_PLAN_DEM_IO_SCHED CONSTANT NUMBER := 30; -- Internal Order (Scheduled)
47 G_PLAN_DEM_IO_BKORD CONSTANT NUMBER := 40; -- Internal Order (Backordered)
48
49 -- Supply sources for Planned Crossdock
50 G_PLAN_SUP_PO_APPR CONSTANT NUMBER := 10; -- Approved PO
51 G_PLAN_SUP_ASN CONSTANT NUMBER := 20; -- ASN
52 G_PLAN_SUP_REQ CONSTANT NUMBER := 30; -- Internal Req
53 G_PLAN_SUP_INTR CONSTANT NUMBER := 40; -- Intransit Shipments
54 G_PLAN_SUP_WIP CONSTANT NUMBER := 50; -- WIP
55 G_PLAN_SUP_RCV CONSTANT NUMBER := 60; -- Material in Receiving
56
57 --
58 -- End of list of constants
59 --
60
61 -- Switch to indicate if reservation change is triggered
62 -- from the demand side or not (default is FALSE)
63 G_DEMAND_TRIGGERED BOOLEAN := FALSE;
64
65
66 FUNCTION is_eligible_supply_source
67 ( p_criterion_id IN NUMBER
68 , p_source_code IN NUMBER
69 ) RETURN BOOLEAN;
70
71
72 FUNCTION is_eligible_demand_source
73 ( p_criterion_id IN NUMBER
74 , p_source_code IN NUMBER
75 ) RETURN BOOLEAN;
76
77
78 PROCEDURE create_crossdock_reservation
79 ( x_return_status OUT NOCOPY VARCHAR2
80 , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
81 );
82
83
84 PROCEDURE update_crossdock_reservation
85 ( x_return_status OUT NOCOPY VARCHAR2
86 , p_orig_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
87 , p_new_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
88 );
89
90
91 PROCEDURE transfer_crossdock_reservation
92 ( x_return_status OUT NOCOPY VARCHAR2
93 , p_orig_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
94 , p_new_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
95 );
96
97
98 PROCEDURE delete_crossdock_reservation
99 ( x_return_status OUT NOCOPY VARCHAR2
100 , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
101 );
102
103
104 PROCEDURE relieve_crossdock_reservation
105 ( x_return_status OUT NOCOPY VARCHAR2
106 , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
107 );
108
109
110 END wms_xdock_utils_pvt;