1 PACKAGE WMS_SELECTION_CRITERIA_TXN_PKG AS
2 /* $Header: WMSSCTXS.pls 120.1 2005/05/27 01:43:00 appldev $ */
3 --
4 PROCEDURE INSERT_ROW (
5 X_STG_ASSIGNMENT_ID IN NUMBER
6 ,X_SEQUENCE_NUMBER IN NUMBER
7 ,X_RULE_TYPE_CODE IN NUMBER
8 ,X_RETURN_TYPE_CODE IN VARCHAR2
9 ,X_RETURN_TYPE_ID IN NUMBER
10 ,X_ENABLED_FLAG IN VARCHAR2
11 ,X_DATE_TYPE_CODE IN VARCHAR2
12 ,X_DATE_TYPE_FROM IN NUMBER
13 ,X_DATE_TYPE_TO IN NUMBER
14 ,X_DATE_TYPE_LOOKUP_TYPE IN VARCHAR2
15 ,X_EFFECTIVE_FROM IN DATE
16 ,X_EFFECTIVE_TO IN DATE
17 ,X_FROM_ORGANIZATION_ID IN NUMBER
18 ,X_FROM_SUBINVENTORY_NAME IN VARCHAR2
19 ,X_TO_ORGANIZATION_ID IN NUMBER
20 ,X_TO_SUBINVENTORY_NAME IN VARCHAR2
21 ,X_CUSTOMER_ID IN NUMBER
22 ,X_FREIGHT_CODE IN VARCHAR2
23 ,X_INVENTORY_ITEM_ID IN NUMBER
24 ,X_ITEM_TYPE IN VARCHAR2
25 ,X_ASSIGNMENT_GROUP_ID IN NUMBER
26 ,X_ABC_CLASS_ID IN NUMBER
27 ,X_CATEGORY_SET_ID IN NUMBER
28 ,X_CATEGORY_ID IN NUMBER
29 ,X_ORDER_TYPE_ID IN NUMBER
30 ,X_VENDOR_ID IN NUMBER
31 ,X_PROJECT_ID IN NUMBER
32 ,X_TASK_ID IN NUMBER
33 ,X_USER_ID IN NUMBER
34 ,X_TRANSACTION_ACTION_ID IN NUMBER
35 ,X_REASON_ID IN NUMBER
36 ,X_TRANSACTION_SOURCE_TYPE_ID IN NUMBER
37 ,X_TRANSACTION_TYPE_ID IN NUMBER
38 ,X_UOM_CODE IN VARCHAR2
39 ,X_UOM_CLASS IN VARCHAR2
40 ,X_LOCATION_ID IN NUMBER
41 ,X_LAST_UPDATED_BY IN NUMBER
42 ,X_LAST_UPDATE_DATE IN DATE
43 ,X_CREATED_BY IN NUMBER
44 ,X_CREATION_DATE IN DATE
45 ,X_LAST_UPDATE_LOGIN IN NUMBER);
46
47 PROCEDURE LOCK_ROW (
48 X_STG_ASSIGNMENT_ID IN NUMBER
49 ,X_SEQUENCE_NUMBER IN NUMBER
50 ,X_RULE_TYPE_CODE IN NUMBER
51 ,X_RETURN_TYPE_CODE IN VARCHAR2
52 ,X_RETURN_TYPE_ID IN NUMBER
53 ,X_ENABLED_FLAG IN VARCHAR2
54 ,X_DATE_TYPE_CODE IN VARCHAR2
55 ,X_DATE_TYPE_FROM IN NUMBER
56 ,X_DATE_TYPE_TO IN NUMBER
57 ,X_DATE_TYPE_LOOKUP_TYPE IN VARCHAR2
58 ,X_EFFECTIVE_FROM IN DATE
59 ,X_EFFECTIVE_TO IN DATE
60 ,X_FROM_ORGANIZATION_ID IN NUMBER
61 ,X_FROM_SUBINVENTORY_NAME IN VARCHAR2
62 ,X_TO_ORGANIZATION_ID IN NUMBER
63 ,X_TO_SUBINVENTORY_NAME IN VARCHAR2
64 ,X_CUSTOMER_ID IN NUMBER
65 ,X_FREIGHT_CODE IN VARCHAR2
66 ,X_INVENTORY_ITEM_ID IN NUMBER
67 ,X_ITEM_TYPE IN VARCHAR2
68 ,X_ASSIGNMENT_GROUP_ID IN NUMBER
69 ,X_ABC_CLASS_ID IN NUMBER
70 ,X_CATEGORY_SET_ID IN NUMBER
71 ,X_CATEGORY_ID IN NUMBER
72 ,X_ORDER_TYPE_ID IN NUMBER
73 ,X_VENDOR_ID IN NUMBER
74 ,X_PROJECT_ID IN NUMBER
75 ,X_TASK_ID IN NUMBER
76 ,X_USER_ID IN NUMBER
77 ,X_TRANSACTION_ACTION_ID IN NUMBER
78 ,X_REASON_ID IN NUMBER
79 ,X_TRANSACTION_SOURCE_TYPE_ID IN NUMBER
80 ,X_TRANSACTION_TYPE_ID IN NUMBER
81 ,X_UOM_CODE IN VARCHAR2
82 ,X_UOM_CLASS IN VARCHAR2
83 ,X_LOCATION_ID IN NUMBER);
84
85 PROCEDURE UPDATE_ROW (
86 X_STG_ASSIGNMENT_ID IN NUMBER
87 ,X_SEQUENCE_NUMBER IN NUMBER
88 ,X_RULE_TYPE_CODE IN NUMBER
89 ,X_RETURN_TYPE_CODE IN VARCHAR2
90 ,X_RETURN_TYPE_ID IN NUMBER
91 ,X_ENABLED_FLAG IN VARCHAR2
92 ,X_DATE_TYPE_CODE IN VARCHAR2
93 ,X_DATE_TYPE_FROM IN NUMBER
94 ,X_DATE_TYPE_TO IN NUMBER
95 ,X_DATE_TYPE_LOOKUP_TYPE IN VARCHAR2
96 ,X_EFFECTIVE_FROM IN DATE
97 ,X_EFFECTIVE_TO IN DATE
98 ,X_FROM_ORGANIZATION_ID IN NUMBER
99 ,X_FROM_SUBINVENTORY_NAME IN VARCHAR2
100 ,X_TO_ORGANIZATION_ID IN NUMBER
101 ,X_TO_SUBINVENTORY_NAME IN VARCHAR2
102 ,X_CUSTOMER_ID IN NUMBER
103 ,X_FREIGHT_CODE IN VARCHAR2
104 ,X_INVENTORY_ITEM_ID IN NUMBER
105 ,X_ITEM_TYPE IN VARCHAR2
106 ,X_ASSIGNMENT_GROUP_ID IN NUMBER
107 ,X_ABC_CLASS_ID IN NUMBER
108 ,X_CATEGORY_SET_ID IN NUMBER
109 ,X_CATEGORY_ID IN NUMBER
110 ,X_ORDER_TYPE_ID IN NUMBER
111 ,X_VENDOR_ID IN NUMBER
112 ,X_PROJECT_ID IN NUMBER
113 ,X_TASK_ID IN NUMBER
114 ,X_USER_ID IN NUMBER
115 ,X_TRANSACTION_ACTION_ID IN NUMBER
116 ,X_REASON_ID IN NUMBER
117 ,X_TRANSACTION_SOURCE_TYPE_ID IN NUMBER
118 ,X_TRANSACTION_TYPE_ID IN NUMBER
119 ,X_UOM_CODE IN VARCHAR2
120 ,X_UOM_CLASS IN VARCHAR2
121 ,X_LOCATION_ID IN NUMBER
122 ,X_LAST_UPDATED_BY IN NUMBER
123 ,X_LAST_UPDATE_DATE IN DATE
124 ,X_LAST_UPDATE_LOGIN IN NUMBER);
125
126 PROCEDURE DELETE_ROW (
127 X_STG_ASSIGNMENT_ID IN NUMBER
128 );
129
130
131 END WMS_SELECTION_CRITERIA_TXN_PKG;
|
|
|