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