PACKAGE: APPS.WIP_FLOW_COMPLETION_FILTER

Source

1 PACKAGE wip_flow_completion_filter AUTHID CURRENT_USER AS
2 /* $Header: wipfwocs.pls 115.7 2002/11/28 19:41:34 rmahidha ship $  */
3 
4 TYPE ret_sch_rec is RECORD (
5   wip_entity_id NUMBER,
6   completion_subinventory VARCHAR2(10),
7   completion_locator_id NUMBER,
8   quantity NUMBER );
9 
10 TYPE ret_sch_t IS TABLE OF ret_sch_rec index by binary_integer;
11 
12 PROCEDURE retrieve_schedules (i_where IN VARCHAR2, i_default_sub IN VARCHAR2,
13                               i_default_loc IN NUMBER,
14 			      i_org_locator_control IN NUMBER,
15 			      i_qty_retrieve IN NUMBER,
16 			      i_num_records IN NUMBER,
17                               o_result OUT NOCOPY ret_sch_t,
18 			      o_restrict_error OUT NOCOPY BOOLEAN,
19 			      o_lot_serial_error OUT NOCOPY BOOLEAN,
20                               o_error_num OUT NOCOPY NUMBER,
21 			      o_error_msg OUT NOCOPY VARCHAR2);
22 
23 FUNCTION loc_control(org_control      IN    number,
24                      sub_control      IN    number,
25                      item_control     IN    number default NULL,
26                      restrict_flag    IN    Number default NULL)
27                      return number;
28 
29 END wip_flow_completion_filter;