[Home] [Help]
PACKAGE: APPS.INV_WIP_PICKING_PVT
Source
1 PACKAGE inv_wip_picking_pvt AUTHID CURRENT_USER AS
2 /* $Header: INVVWPKS.pls 120.5 2010/10/26 16:26:31 abasheer ship $ */
3
4 g_pkg_name CONSTANT VARCHAR2(30) := 'INV_WIP_PICKING_PVT';
5
6 -- Bug 4288399, moving g_wip_patch_level to spec
7 -- Global variable for tracking WIP patch level
8 g_wip_patch_level NUMBER := -999;
9
10 -- added for bug 9895550
11 g_pick_release_caller VARCHAR2(30):= NULL;
12 g_old_detailed_qty NUMBER := -999;
13
14 -- Bug 4288399, creating a new table of records which will be passed back to
15 -- WIP containing errored record information with the error message.
16 TYPE Trolin_ErrRec_Type IS RECORD
17 ( attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
18 , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
19 , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
20 , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
21 , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
22 , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
23 , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
24 , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
25 , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
26 , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
27 , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
28 , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
29 , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
30 , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
31 , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
32 , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
33 , created_by NUMBER := FND_API.G_MISS_NUM
34 , creation_date DATE := FND_API.G_MISS_DATE
35 , date_required DATE := FND_API.G_MISS_DATE
36 , from_locator_id NUMBER := FND_API.G_MISS_NUM
37 , from_subinventory_code VARCHAR2(10) := FND_API.G_MISS_CHAR
38 , from_subinventory_id NUMBER := FND_API.G_MISS_NUM
39 , header_id NUMBER := FND_API.G_MISS_NUM
40 , inventory_item_id NUMBER := FND_API.G_MISS_NUM
41 , last_updated_by NUMBER := FND_API.G_MISS_NUM
42 , last_update_date DATE := FND_API.G_MISS_DATE
43 , last_update_login NUMBER := FND_API.G_MISS_NUM
44 , line_id NUMBER := FND_API.G_MISS_NUM
45 , line_number NUMBER := FND_API.G_MISS_NUM
46 , line_status NUMBER := FND_API.G_MISS_NUM
47 -- Increased lot size to 80 Char - Mercy Thomas - B4625329
48 , lot_number VARCHAR2(80) := FND_API.G_MISS_CHAR
49 , organization_id NUMBER := FND_API.G_MISS_NUM
50 , program_application_id NUMBER := FND_API.G_MISS_NUM
51 , program_id NUMBER := FND_API.G_MISS_NUM
52 , program_update_date DATE := FND_API.G_MISS_DATE
53 , project_id NUMBER := FND_API.G_MISS_NUM
54 , quantity NUMBER := FND_API.G_MISS_NUM
55 , quantity_delivered NUMBER := FND_API.G_MISS_NUM
56 , quantity_detailed NUMBER := FND_API.G_MISS_NUM
57 , reason_id NUMBER := FND_API.G_MISS_NUM
58 , reference VARCHAR2(240) := FND_API.G_MISS_CHAR
59 , reference_id NUMBER := FND_API.G_MISS_NUM
60 , reference_type_code NUMBER := FND_API.G_MISS_NUM
61 , request_id NUMBER := FND_API.G_MISS_NUM
62 , revision VARCHAR2(3) := FND_API.G_MISS_CHAR
63 , serial_number_end VARCHAR2(30) := FND_API.G_MISS_CHAR
64 , serial_number_start VARCHAR2(30) := FND_API.G_MISS_CHAR
65 , status_date DATE := FND_API.G_MISS_DATE
66 , task_id NUMBER := FND_API.G_MISS_NUM
67 , to_account_id NUMBER := FND_API.G_MISS_NUM
68 , to_locator_id NUMBER := FND_API.G_MISS_NUM
69 , to_subinventory_code VARCHAR2(10) := FND_API.G_MISS_CHAR
70 , to_subinventory_id NUMBER := FND_API.G_MISS_NUM
71 , transaction_header_id NUMBER := FND_API.G_MISS_NUM
72 , transaction_type_id NUMBER := FND_API.G_MISS_NUM
73 , txn_source_id NUMBER := FND_API.G_MISS_NUM
74 , txn_source_line_id NUMBER := FND_API.G_MISS_NUM
75 , txn_source_line_detail_id NUMBER := FND_API.G_MISS_NUM
76 , transaction_source_type_id NUMBER := FND_API.G_MISS_NUM
77 , primary_quantity NUMBER := FND_API.G_MISS_NUM
78 , to_organization_id NUMBER := FND_API.G_MISS_NUM
79 , pick_strategy_id NUMBER := FND_API.G_MISS_NUM
80 , put_away_strategy_id NUMBER := FND_API.G_MISS_NUM
81 , uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
82 , unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR
83 , ship_to_location_id NUMBER := FND_API.G_MISS_NUM
84 , from_cost_group_id NUMBER := FND_API.G_MISS_NUM
85 , to_cost_group_id NUMBER := FND_API.G_MISS_NUM
86 , lpn_id NUMBER := FND_API.G_MISS_NUM
87 , to_lpn_id NUMBER := FND_API.G_MISS_NUM
88 , pick_methodology_id NUMBER := FND_API.G_MISS_NUM
89 , container_item_id NUMBER := FND_API.G_MISS_NUM
90 , carton_grouping_id NUMBER := FND_API.G_MISS_NUM
91 , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
92 , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
93 , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
94 , inspection_status NUMBER :=NULL
95 , wms_process_flag NUMBER :=NULL
96 , pick_slip_number NUMBER :=NULL
97 , pick_slip_date DATE :=NULL
98 , ship_set_id NUMBER :=NULL
99 , ship_model_id NUMBER :=NULL
100 , model_quantity NUMBER :=NULL
101 , required_quantity NUMBER :=NULL
102 , error_message VARCHAR2(2000) := FND_API.G_MISS_CHAR);
103
104 TYPE Trolin_ErrTbl_Type IS TABLE OF Trolin_ErrRec_Type
105 INDEX BY BINARY_INTEGER;
106
107 --
108 -- The procedure release_pick_batch is overloaded so that
109 -- WIP 'H' works with Inventory 'I'.
110 --
111 -- pre patchset I version
112 --
113 PROCEDURE release_pick_batch
114 ( p_mo_header_rec IN INV_Move_Order_PUB.Trohdr_Rec_Type
115 , p_mo_line_rec_tbl IN INV_Move_Order_PUB.Trolin_Tbl_Type
116 , p_auto_detail_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
117 , p_auto_pick_confirm_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE
118 , p_allow_partial_pick IN VARCHAR2 DEFAULT FND_API.G_TRUE
119 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
120 , p_init_msg_lst IN VARCHAR2 DEFAULT FND_API.G_FALSE
121 , x_return_status OUT NOCOPY VARCHAR2
122 , x_msg_count OUT NOCOPY NUMBER
123 , x_msg_data OUT NOCOPY VARCHAR2
124 );
125
126 --
127 -- patchset I version
128 --
129 PROCEDURE release_pick_batch
130 ( p_mo_header_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type
131 , p_mo_line_rec_tbl IN inv_move_order_pub.trolin_tbl_type
132 , p_auto_detail_flag IN VARCHAR2 DEFAULT fnd_api.g_true
133 , p_auto_pick_confirm_flag IN VARCHAR2 DEFAULT NULL
134 , p_allow_partial_pick IN VARCHAR2 DEFAULT fnd_api.g_true
135 , p_print_pick_slip IN VARCHAR2 DEFAULT fnd_api.g_false
136 , p_plan_tasks IN BOOLEAN DEFAULT FALSE
137 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
138 , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
139 , x_return_status OUT NOCOPY VARCHAR2
140 , x_msg_count OUT NOCOPY NUMBER
141 , x_msg_data OUT NOCOPY VARCHAR2
142 , x_conc_req_id OUT NOCOPY NUMBER
143 , x_mo_line_errrec_tbl OUT NOCOPY INV_WIP_Picking_PVT.Trolin_ErrTbl_Type -- Bug 4288399
144 );
145
146 PROCEDURE pick_release(
147 x_return_status OUT NOCOPY VARCHAR2
148 , x_msg_count OUT NOCOPY NUMBER
149 , x_msg_data OUT NOCOPY VARCHAR2
150 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
151 , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
152 , p_mo_line_tbl IN inv_move_order_pub.trolin_tbl_type
153 , p_allow_partial_pick IN VARCHAR2 DEFAULT fnd_api.g_true
154 , p_grouping_rule_id IN NUMBER DEFAULT NULL
155 , p_plan_tasks IN BOOLEAN DEFAULT FALSE
156 , p_call_wip_api IN BOOLEAN DEFAULT FALSE
157 );
158
159 PROCEDURE update_mol_for_wip
160 ( x_return_status OUT NOCOPY VARCHAR2
161 , x_msg_count OUT NOCOPY NUMBER
162 , x_msg_data OUT NOCOPY VARCHAR2
163 , p_move_order_line_id IN NUMBER
164 , p_op_seq_num IN NUMBER
165 );
166
167 PROCEDURE get_wip_attributes(
168 x_return_status OUT NOCOPY VARCHAR2
169 , x_wip_entity_type OUT NOCOPY NUMBER
170 , x_push_vs_pull OUT NOCOPY VARCHAR2
171 , x_repetitive_line_id OUT NOCOPY NUMBER
172 , x_department_id OUT NOCOPY NUMBER
173 , x_department_code OUT NOCOPY VARCHAR2
174 , x_pick_slip_number OUT NOCOPY NUMBER
175 , p_wip_entity_id IN NUMBER
176 , p_operation_seq_num IN NUMBER
177 , p_rep_schedule_id IN NUMBER
178 , p_organization_id IN NUMBER
179 , p_inventory_item_id IN NUMBER
180 , p_transaction_type_id IN NUMBER
181 , p_get_pick_slip_number IN BOOLEAN
182 );
183
184 END inv_wip_picking_pvt;