1 PACKAGE wms_strategy_upgrade_pvt AUTHID CURRENT_USER AS
2 /* $Header: WMSSTGUS.pls 115.4 2003/02/21 01:46:50 grao noship $ */
3 --
4 -- File : WMSSTGUS.pls
5 -- Content : WMS_Strategy_upgrade_PVT package specification
6 -- Description : WMS private API's
7 -- Notes :
8 -- Created : 10/31/02 Grao
9 --
10 -- API name : Upgrade Script for Strategy search order / Strategy Assignments
11 -- Type : Private
12 -- Function : Convert each strategy assignment record into a record in the new table
13 -- WMS_SELECTION_CRITERIA_TXN
14 --
15 --
16 --
17 --
18 --
19 -- Pre-reqs : record in WMS_STAGINGLANES_ASSIGNMENTS
20 --
21 --
22 -- Input Parameters :
23
24 --
25 -- Output Parameter :
26
27 procedure copy_stg_assignments
28 ( x_return_status OUT NOCOPY VARCHAR2
29 ,x_msg_count OUT NOCOPY NUMBER
30 ,x_msg_data OUT NOCOPY VARCHAR2
31 );
32
33 PROCEDURE INSERT_ROW (
34 X_STG_ASSIGNMENT_ID IN NUMBER
35 ,X_SEQUENCE_NUMBER IN NUMBER
36 ,X_RULE_TYPE_CODE IN NUMBER
37 ,X_RETURN_TYPE_CODE IN VARCHAR2
38 ,X_RETURN_TYPE_ID IN NUMBER
39 ,X_ENABLED_FLAG IN VARCHAR2
40 ,X_DATE_TYPE_CODE IN VARCHAR2
41 ,X_DATE_TYPE_FROM IN NUMBER
42 ,X_DATE_TYPE_TO IN NUMBER
43 ,X_DATE_TYPE_LOOKUP_TYPE IN VARCHAR2
44 ,X_EFFECTIVE_FROM IN DATE
45 ,X_EFFECTIVE_TO IN DATE
46 ,X_FROM_ORGANIZATION_ID IN NUMBER
47 ,X_FROM_SUBINVENTORY_NAME IN VARCHAR2
48 ,X_TO_ORGANIZATION_ID IN NUMBER
49 ,X_TO_SUBINVENTORY_NAME IN VARCHAR2
50 ,X_CUSTOMER_ID IN NUMBER
51 ,X_FREIGHT_CODE IN VARCHAR2
52 ,X_INVENTORY_ITEM_ID IN NUMBER
53 ,X_ITEM_TYPE IN VARCHAR2
54 ,X_ASSIGNMENT_GROUP_ID IN NUMBER
55 ,X_ABC_CLASS_ID IN NUMBER
56 ,X_CATEGORY_SET_ID IN NUMBER
57 ,X_CATEGORY_ID IN NUMBER
58 ,X_ORDER_TYPE_ID IN NUMBER
59 ,X_VENDOR_ID IN NUMBER
60 ,X_PROJECT_ID IN NUMBER
61 ,X_TASK_ID IN NUMBER
62 ,X_USER_ID IN NUMBER
63 ,X_TRANSACTION_ACTION_ID IN NUMBER
64 ,X_REASON_ID IN NUMBER
65 ,X_TRANSACTION_SOURCE_TYPE_ID IN NUMBER
66 ,X_TRANSACTION_TYPE_ID IN NUMBER
67 ,X_UOM_CODE IN VARCHAR2
68 ,X_UOM_CLASS IN VARCHAR2
69 ,X_LAST_UPDATED_BY IN NUMBER
70 ,X_LAST_UPDATE_DATE IN DATE
71 ,X_CREATED_BY IN NUMBER
72 ,X_CREATION_DATE IN DATE
73 ,X_LAST_UPDATE_LOGIN IN NUMBER);
74
75 end WMS_Strategy_upgrade_PVT ;