1 PACKAGE wms_workflow_wrappers AS
2 /* $Header: WMSWFWRS.pls 120.1 2008/01/11 14:22:00 rkatoori ship $ */
3
4 -- This procedure is the wrapper that calls the Start_workflow procedure
5 -- Example is set for p_reason_name = 'INSUFFICIENT QUANTITY'
6 PROCEDURE wms_insuff_qty_wrapper( p_api_version_number IN NUMBER
7 , x_return_status OUT NOCOPY VARCHAR2
8 , x_msg_count OUT NOCOPY NUMBER
9 , x_msg_data OUT NOCOPY VARCHAR2
10 , p_tsk_id IN NUMBER -- task id
11 , p_user_id IN VARCHAR2
12 , p_organization_id IN NUMBER
13 , p_rsn_id IN NUMBER -- reason id
14 , p_quantity_picked IN NUMBER
15 );
16
17
18 PROCEDURE wf_wrapper(p_api_version IN NUMBER
19 , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
20 , p_commit IN VARCHAR2 := fnd_api.g_false
21 , x_return_status OUT NOCOPY VARCHAR2
22 , x_msg_count OUT NOCOPY NUMBER
23 , x_msg_data OUT NOCOPY VARCHAR2
24 , p_org_id IN NUMBER
25 , p_rsn_id IN NUMBER
26 , p_calling_program IN VARCHAR2
27 , p_tmp_id IN NUMBER DEFAULT NULL
28 , p_quantity_picked IN NUMBER DEFAULT NULL
29 , p_dest_sub IN VARCHAR2 DEFAULT NULL
30 , p_dest_loc IN NUMBER DEFAULT NULL
31 );
32
33 PROCEDURE wf_start_workflow(
34 P_REASON_ID IN NUMBER,
35 P_CALLING_PROGRAM_NAME IN VARCHAR2,
36 P_SOURCE_ORGANIZATION_ID IN NUMBER,
37 P_REASON_NAME IN VARCHAR2 DEFAULT NULL,
38 P_DESTINATION_ORGANIZATION_ID IN NUMBER DEFAULT NULL,
39 P_SOURCE_SUBINVENTORY IN VARCHAR2 DEFAULT NULL,
40 P_SOURCE_SUBINVENTORY_STATUS IN NUMBER DEFAULT NULL,
41 P_DESTINATION_SUBINVENTORY IN VARCHAR2 DEFAULT NULL,
42 P_DESTINATION_SUBINVENTORY_ST IN NUMBER DEFAULT NULL,
43 P_SOURCE_LOCATOR IN NUMBER DEFAULT NULL,
44 P_SOURCE_LOCATOR_STATUS IN NUMBER DEFAULT NULL,
45 P_DESTINATION_LOCATOR IN NUMBER DEFAULT NULL,
46 P_DESTINATION_LOCATOR_STATUS IN NUMBER DEFAULT NULL,
47 P_LPN_ID IN NUMBER DEFAULT NULL,
48 P_ONHAND_STATUS IN VARCHAR2 DEFAULT NULL, -- Added for Onhand material support --6633612
49 P_LPN_STATUS IN NUMBER DEFAULT NULL,
50 P_CONTENT_LPN_ID IN NUMBER DEFAULT NULL,
51 P_CONTENT_LPN_STATUS IN NUMBER DEFAULT NULL,
52 p_source_parent_lpn_id IN NUMBER DEFAULT NULL,
53 P_SOURCE_parent_LPN_STATUS IN NUMBER DEFAULT NULL,
54 P_SOURCE_OUTERMOST_LPN_ID IN NUMBER DEFAULT NULL,
55 P_SOURCE_OUTERMOST_LPN_STATUS IN NUMBER DEFAULT NULL,
56 p_dest_lpn_id IN NUMBER DEFAULT NULL,
57 p_dest_lpn_status IN NUMBER DEFAULT NULL,
58 p_dest_parent_lpn_id IN NUMBER DEFAULT NULL,
59 p_dest_parent_lpn_status IN NUMBER DEFAULT NULL,
60 P_DEST_OUTERMOST_LPN_ID IN NUMBER DEFAULT NULL,
61 P_DEST_OUTERMOST_LPN_STATUS IN NUMBER DEFAULT NULL,
62 P_INVENTORY_ITEM_ID IN NUMBER DEFAULT NULL,
63 P_REVISION IN VARCHAR2 DEFAULT NULL,
64 P_LOT_NUMBER IN VARCHAR2 DEFAULT NULL,
65 p_to_lot_number IN VARCHAR2 DEFAULT NULL,
66 P_LOT_STATUS IN NUMBER DEFAULT NULL,
67 P_SERIAL_NUMBER IN VARCHAR2 DEFAULT NULL,
68 p_to_serial_number IN VARCHAR2 DEFAULT NULL,
69 P_SERIAL_NUMBER_STATUS IN NUMBER DEFAULT NULL,
70 P_PRIMARY_UOM IN VARCHAR2 DEFAULT NULL,
71 P_TRANSACTION_UOM IN VARCHAR2 DEFAULT NULL,
72 P_PRIMARY_QUANTITY IN NUMBER DEFAULT NULL,
73 P_TRANSACTION_QUANTITY IN NUMBER DEFAULT NULL,
74 P_TRANSACTION_ACTION_ID IN NUMBER DEFAULT NULL,
75 P_TRANSACTION_SOURCE_TYPE_ID IN NUMBER DEFAULT NULL,
76 P_TRANSACTION_SOURCE IN NUMBER DEFAULT NULL,
77 P_RESERVATION_ID IN NUMBER DEFAULT NULL,
78 P_EQUIPMENT_ID IN NUMBER DEFAULT NULL,
79 P_USER_ID IN NUMBER DEFAULT NULL,
80 P_TASK_TYPE_ID IN NUMBER DEFAULT NULL,
81 P_TASK_ID IN NUMBER DEFAULT NULL,
82 p_txn_temp_id IN NUMBER DEFAULT NULL,
83 p_update_status_method IN VARCHAR2 DEFAULT NULL,
84 P_PROGRAM_CONTROL_ARG1 IN VARCHAR2 DEFAULT NULL,
85 P_PROGRAM_CONTROL_ARG2 IN VARCHAR2 DEFAULT NULL,
86 P_PROGRAM_CONTROL_ARG3 IN VARCHAR2 DEFAULT NULL,
87 P_PROGRAM_CONTROL_ARG4 IN VARCHAR2 DEFAULT NULL,
88 P_PROGRAM_CONTROL_ARG5 IN VARCHAR2 DEFAULT NULL,
89 P_PROGRAM_CONTROL_ARG6 IN VARCHAR2 DEFAULT NULL,
90 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
91 X_MSG_DATA OUT NOCOPY VARCHAR2,
92 X_MSG_COUNT OUT NOCOPY NUMBER,
93 X_ORGANIZATION_ID OUT NOCOPY NUMBER,
94 X_SUBINVENTORY OUT NOCOPY VARCHAR2,
95 X_SUBINVENTORY_STATUS OUT NOCOPY NUMBER,
96 X_LOCATOR OUT NOCOPY NUMBER,
97 X_LOCATOR_STATUS OUT NOCOPY NUMBER,
98 X_LPN_ID OUT NOCOPY NUMBER,
99 X_LPN_STATUS OUT NOCOPY NUMBER,
100 X_INVENTORY_ITEM_ID OUT NOCOPY NUMBER,
101 X_REVISION OUT NOCOPY VARCHAR2,
102 X_LOT_NUMBER OUT NOCOPY VARCHAR2,
103 X_LOT_STATUS OUT NOCOPY NUMBER,
104 X_QUANTITY OUT NOCOPY NUMBER,
105 X_UOM_CODE OUT NOCOPY VARCHAR2,
106 X_PRIMARY_QUANTITY OUT NOCOPY NUMBER,
107 X_TRANSACTION_QUANTITY OUT NOCOPY NUMBER,
108 X_RESERVATION_ID OUT NOCOPY NUMBER
109 );
110
111
112 PROCEDURE WF_SUGGEST_ALT_LOC (itemtype IN VARCHAR2,
113 itemkey IN VARCHAR2,
114 actid IN NUMBER,
115 funcmode IN VARCHAR2,
116 result OUT NOCOPY VARCHAR2) ;
117
118
119 PROCEDURE WF_Cycle_Count (itemtype IN VARCHAR2,
120 itemkey IN VARCHAR2,
121 actid IN NUMBER,
122 funcmode IN VARCHAR2,
123 result OUT NOCOPY VARCHAR2) ;
124
125 PROCEDURE WF_is_task_processed (itemtype IN VARCHAR2,
126 itemkey IN VARCHAR2,
127 actid IN NUMBER,
128 funcmode IN VARCHAR2,
129 result OUT NOCOPY VARCHAR2) ;
130
131 PROCEDURE WF_generate_next_task (itemtype IN VARCHAR2,
132 itemkey IN VARCHAR2,
133 actid IN NUMBER,
134 funcmode IN VARCHAR2,
135 result OUT NOCOPY VARCHAR2) ;
136
137 PROCEDURE wf_send_to_bg (itemtype IN VARCHAR2,
138 itemkey IN VARCHAR2,
139 actid IN NUMBER,
140 funcmode IN VARCHAR2,
141 result OUT NOCOPY VARCHAR2) ;
142
143 PROCEDURE wms_inadequate_quantity (itemtype IN VARCHAR2,
144 itemkey IN VARCHAR2,
145 actid IN NUMBER,
146 funcmode IN VARCHAR2,
147 result OUT NOCOPY VARCHAR2) ;
148
149
150 END wms_workflow_wrappers;
151