1 PACKAGE WMS_WIP_Integration AS
2 /* $Header: WMSWIPIS.pls 120.0.12010000.1 2008/07/28 18:38:27 appldev ship $ */
3
4
5 /* Used to update move order line
6 */
7
8 PROCEDURE Update_MO_Line
9 (p_lpn_id IN NUMBER,
10 p_wms_process_flag IN NUMBER,
11 x_return_status OUT NOCOPY VARCHAR2,
12 x_msg_count OUT NOCOPY NUMBER,
13 x_msg_data OUT NOCOPY VARCHAR2);
14
15 /* Backflush API to copy WIP data to inventory tables
16 */
17
18 PROCEDURE Backflush
19 (p_header_id IN NUMBER,
20 x_return_status OUT NOCOPY VARCHAR2,
21 x_msg_count OUT NOCOPY NUMBER,
22 x_msg_data OUT NOCOPY VARCHAR2);
23
24 PROCEDURE Capture_serial_atts
25 (p_ref_id IN NUMBER,
26 p_temp_id IN NUMBER,
27 p_last_update_date IN DATE,
28 p_last_updated_by IN NUMBER,
29 p_creation_date IN DATE,
30 p_created_by IN NUMBER,
31 p_fm_serial_number IN VARCHAR2,
32 p_to_serial_number IN VARCHAR2,
33 p_serial_temp_id IN NUMBER,
34 p_serial_flag IN NUMBER);
35
36 PROCEDURE Capture_lot_atts
37 (p_ref_id IN NUMBER,
38 p_temp_id IN NUMBER,
39 p_lot IN VARCHAR2);
40
41 PROCEDURE Update_serial
42 ( p_header_id IN NUMBER,
43 p_serial_number IN VARCHAR2,
44 x_return_status OUT NOCOPY VARCHAR2,
45 x_msg_count OUT NOCOPY NUMBER,
46 x_msg_data OUT NOCOPY VARCHAR2);
47
48 PROCEDURE Insert_lot
49 ( p_header_id IN NUMBER,
50 p_lot_number IN VARCHAR2,
51 x_return_status OUT NOCOPY VARCHAR2,
52 x_msg_count OUT NOCOPY NUMBER,
53 x_msg_data OUT NOCOPY VARCHAR2);
54
55 PROCEDURE Perform_lot_validations(
56 p_item_id IN NUMBER,
57 p_org_id IN NUMBER,
58 p_lot_number IN VARCHAR2,
59 x_return_status OUT NOCOPY VARCHAR2,
60 x_msg_count OUT NOCOPY NUMBER,
61 x_msg_data OUT NOCOPY VARCHAR2);
62
63 PROCEDURE post_completion
64 (p_item_id IN NUMBER,
65 p_org_id IN NUMBER,
66 p_fm_serial_number IN VARCHAR2,
67 p_to_serial_number IN VARCHAR2,
68 p_quantity IN NUMBER,
69 x_return_status OUT NOCOPY VARCHAR2,
70 x_msg_count OUT NOCOPY NUMBER,
71 x_msg_data OUT NOCOPY VARCHAR2
72 );
73
74 PROCEDURE get_wip_job_info
75 (p_temp_id IN NUMBER,
76 p_wip_entity_type IN NUMBER,
77 x_job OUT NOCOPY VARCHAR2,
78 x_line OUT NOCOPY VARCHAR2,
79 x_dept OUT NOCOPY VARCHAR2,
80 x_operation_seq_num OUT NOCOPY NUMBER,
81 x_start_date OUT NOCOPY DATE,
82 x_schedule OUT NOCOPY VARCHAR2,
83 x_assembly OUT NOCOPY VARCHAR2,
84 x_return_status OUT NOCOPY VARCHAR2,
85 x_msg_count OUT NOCOPY NUMBER,
86 x_msg_data OUT NOCOPY VARCHAR2
87 );
88
89 PROCEDURE get_wip_info_for_putaway
90 (p_temp_id IN NUMBER,
91 x_wip_entity_type OUT NOCOPY NUMBER,
92 x_job OUT NOCOPY VARCHAR2,
93 x_line OUT NOCOPY VARCHAR2,
94 x_dept OUT NOCOPY VARCHAR2,
95 x_operation_seq_num OUT NOCOPY NUMBER,
96 x_start_date OUT NOCOPY DATE,
97 x_schedule OUT NOCOPY VARCHAR2,
98 x_assembly OUT NOCOPY VARCHAR2,
99 x_wip_entity_id OUT NOCOPY NUMBER,
100 x_return_status OUT NOCOPY VARCHAR2,
101 x_msg_count OUT NOCOPY NUMBER,
102 x_msg_data OUT NOCOPY VARCHAR2
103 );
104
105 PROCEDURE unallocate_material
106 (p_wip_entity_id IN NUMBER,
107 p_operation_seq_num IN NUMBER,
108 p_inventory_item_id IN NUMBER,
109 p_repetitive_schedule_id IN NUMBER := NULL,
110 p_primary_quantity IN NUMBER,
111 x_return_status OUT NOCOPY VARCHAR2,
112 x_msg_data OUT NOCOPY VARCHAR2
113 );
114
115
116
117 PROCEDURE transfer_Reservation
118 (
119 P_HEADER_ID IN NUMBER,
120 P_SUBINVENTORY_CODE IN VARCHAR2,
121 P_LOCATOR_ID IN NUMBER,
122 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
123 X_MSG_COUNT OUT NOCOPY NUMBER,
124 X_ERR_MSG OUT NOCOPY VARCHAR2,
125 p_temp_id IN NUMBER);
126
127 PROCEDURE mydebug(msg in varchar2);
128
129 PROCEDURE update_mmtt_for_wip
130 ( p_transaction_temp_id IN NUMBER
131 , p_wip_entity_id IN NUMBER
132 , p_operation_seq_num IN NUMBER
133 , p_repetitive_schedule_id IN NUMBER DEFAULT NULL
134 , p_transaction_type_id IN NUMBER
135 );
136
137 -- Bug 2747945 : Added business flow code to the call to the wip processor.
138 PROCEDURE wip_processor
139 (p_txn_hdr_id IN NUMBER,
140 p_business_flow_code IN NUMBER DEFAULT NULL,
141 x_return_status OUT NOCOPY VARCHAR2);
142
143
144 END WMS_WIP_Integration;
145