1 PACKAGE wms_txnreasons_pub AUTHID CURRENT_USER as
2 /* $Header: WMSTXR3S.pls 120.1 2005/06/10 10:15:48 appldev $ */
3 Procedure Start_Workflow(
4 P_REASON_ID IN NUMBER,
5 P_REASON_NAME IN VARCHAR2 DEFAULT NULL,
6 P_SOURCE_ORGANIZATION_ID IN NUMBER DEFAULT NULL,
7 P_DESTINATION_ORGANIZATION_ID IN NUMBER DEFAULT NULL,
8 P_LPN_ID IN NUMBER DEFAULT NULL,
9 P_INVENTORY_ITEM_ID IN NUMBER DEFAULT NULL,
10 P_REVISION IN VARCHAR2 DEFAULT NULL,
11 p_update_status_method IN VARCHAR2 DEFAULT NULL,
12 P_LOT_NUMBER IN VARCHAR2 DEFAULT NULL,
13 p_to_lot_number IN VARCHAR2 DEFAULT NULL,
14 P_LOT_STATUS IN VARCHAR2 DEFAULT NULL,
15 P_SUBLOT_NUMBER IN VARCHAR2 DEFAULT NULL,
16 P_SUBLOT_STATUS IN VARCHAR2 DEFAULT NULL,
17 P_SOURCE_SUBINVENTORY IN VARCHAR2 DEFAULT NULL,
18 P_SOURCE_SUBINVENTORY_STATUS IN VARCHAR2 DEFAULT NULL,
19 P_DESTINATION_SUBINVENTORY IN VARCHAR2 DEFAULT NULL,
20 P_DESTINATION_SUBINVENTORY_ST IN VARCHAR2 DEFAULT NULL,
21 P_SOURCE_LOCATOR IN NUMBER DEFAULT NULL,
22 P_SOURCE_LOCATOR_STATUS IN VARCHAR2 DEFAULT NULL,
23 P_DESTINATION_LOCATOR IN NUMBER DEFAULT NULL,
24 P_DESTINATION_LOCATOR_STATUS IN VARCHAR2 DEFAULT NULL,
25 P_SOURCE_IMMEDIATE_LPN_ID IN NUMBER DEFAULT NULL,
26 P_SOURCE_IMMEDIATE_LPN_STATUS IN VARCHAR2 DEFAULT NULL,
27 P_SOURCE_TOPLEVEL_LPN_ID IN NUMBER DEFAULT NULL,
28 P_SOURCE_TOPLEVEL_LPN_STATUS IN VARCHAR2 DEFAULT NULL,
29 P_DEST_IMMEDIATE_LPN_ID IN NUMBER DEFAULT NULL,
30 P_DEST_IMMEDIATE_LPN_STATUS IN VARCHAR2 DEFAULT NULL,
31 P_DEST_TOPLEVEL_LPN_ID IN NUMBER DEFAULT NULL,
32 P_DEST_TOPLEVEL_LPN_STATUS IN VARCHAR2 DEFAULT NULL,
33 P_SERIAL_NUMBER IN VARCHAR2 DEFAULT NULL,
34 p_to_serial_number IN VARCHAR2 DEFAULT NULL,
35 P_SERIAL_NUMBER_STATUS IN VARCHAR2 DEFAULT NULL,
36 P_PRIMARY_UOM IN VARCHAR2 DEFAULT NULL,
37 P_TRANSACTION_UOM IN VARCHAR2 DEFAULT NULL,
38 P_PRIMARY_QUANTITY IN NUMBER DEFAULT NULL,
39 P_TRANSACTION_QUANTITY IN NUMBER DEFAULT NULL,
40 P_TRANSACTION_ACTION_ID IN NUMBER DEFAULT NULL,
41 P_TRANSACTION_SOURCE_TYPE_ID IN NUMBER DEFAULT NULL,
42 P_TRANSACTION_SOURCE IN VARCHAR2 DEFAULT NULL,
43 P_PARENT_TRANSACTION_SOURCE IN VARCHAR2 DEFAULT NULL,
44 P_PARENT_TRANS_ACTION_ID IN NUMBER DEFAULT NULL,
45 P_PARENT_TRANS_SOURCE_TYPE_ID IN NUMBER DEFAULT NULL,
46 P_RESERVATION_ID IN NUMBER DEFAULT NULL,
47 P_EQUIPMENT_ID IN NUMBER DEFAULT NULL,
48 P_ROLE_ID IN NUMBER DEFAULT NULL,
49 P_EMPLOYEE_ID IN NUMBER DEFAULT NULL,
50 P_TASK_TYPE_ID IN NUMBER DEFAULT NULL,
51 P_TASK_ID IN NUMBER DEFAULT NULL,
52 P_CALLING_PROGRAM_NAME IN VARCHAR2 DEFAULT NULL,
53 P_EMAIL_ID IN VARCHAR2 DEFAULT NULL,
54 P_PROGRAM_NAME IN VARCHAR2 DEFAULT NULL,
55 P_RUN_MODE IN VARCHAR2 DEFAULT NULL,
56 P_INIT_MSG_LST IN VARCHAR2 DEFAULT fnd_api.g_false,
57 P_PROGRAM_CONTROL_ARG1 IN VARCHAR2 DEFAULT NULL,
58 P_PROGRAM_CONTROL_ARG2 IN VARCHAR2 DEFAULT NULL,
59 P_PROGRAM_CONTROL_ARG3 IN VARCHAR2 DEFAULT NULL,
60 P_PROGRAM_CONTROL_ARG4 IN VARCHAR2 DEFAULT NULL,
61 P_PROGRAM_CONTROL_ARG5 IN VARCHAR2 DEFAULT NULL,
62 P_PROGRAM_CONTROL_ARG6 IN VARCHAR2 DEFAULT NULL,
63 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
64 X_MSG_DATA OUT NOCOPY VARCHAR2,
65 X_MSG_COUNT OUT NOCOPY NUMBER,
66 X_REVISION OUT NOCOPY VARCHAR2,
67 X_LOT_NUMBER OUT NOCOPY VARCHAR2,
68 X_LOT_STATUS OUT NOCOPY VARCHAR2,
69 X_SUBLOT_NUMBER OUT NOCOPY VARCHAR2,
70 X_SUBLOT_STATUS OUT NOCOPY VARCHAR2,
71 X_LPN_ID OUT NOCOPY NUMBER,
72 X_LPN_STATUS OUT NOCOPY VARCHAR2,
73 X_UOM_CODE OUT NOCOPY VARCHAR2,
74 X_QUANTITY OUT NOCOPY NUMBER,
75 X_INVENTORY_ITEM_ID OUT NOCOPY NUMBER,
76 X_ORGANIZATION_ID OUT NOCOPY NUMBER,
77 X_SUBINVENTORY OUT NOCOPY VARCHAR2,
78 X_SUBINVENTORY_STATUS OUT NOCOPY VARCHAR2,
79 X_LOCATOR OUT NOCOPY NUMBER,
80 X_LOCATOR_STATUS OUT NOCOPY VARCHAR2,
81 X_PRIMARY_QUANTITY OUT NOCOPY NUMBER,
82 X_TRANSACTION_QUANTITY OUT NOCOPY NUMBER,
83 X_NEXT_FORM OUT NOCOPY VARCHAR2,
84 X_NEXT_MOBILE_FORM OUT NOCOPY VARCHAR2,
85 X_NEXT_PLSQL_PROGRAM OUT NOCOPY VARCHAR2,
86 X_RESERVATION_ID OUT NOCOPY NUMBER,
87 X_IS_RESERVATION_SUCCESSFUL OUT NOCOPY VARCHAR2,
88 X_IS_CYCLE_COUNT_SUCCESSFUL OUT NOCOPY VARCHAR2
89 ) ;
90
91 end wms_txnreasons_pub;