1 PACKAGE inv_reservation_workflow AS
2 /* $Header: INVRSVWS.pls 120.1 2005/06/17 17:38:14 appldev $*/
3
4 -- Procedure
5 -- handle_broken_reservation
6 -- Description
7 -- Start the work flow process to handle broken reservation
8 -- Note
9 -- You need to provide values for all input parameters. The other
10 -- overloaded version of the procedure requires less information.
11 -- Output Parameters
12 -- x_return_status 'T' if succeeded, 'F' if failed
13 PROCEDURE handle_broken_reservation
14 (
15 p_item_type IN VARCHAR2 DEFAULT 'INVRSVWF'
16 , p_item_key IN VARCHAR2
17 , p_reservation_id IN NUMBER
18 , p_organization_id IN NUMBER
19 , p_organization_code IN VARCHAR2
20 , p_inventory_item_id IN NUMBER
21 , p_inventory_item_number IN VARCHAR2
22 , p_revision IN VARCHAR2
23 , p_lot_number IN VARCHAR2
24 , p_subinventory_code IN VARCHAR2
25 , p_locator_id IN NUMBER
26 , p_locator IN VARCHAR2
27 , p_demand_source_type_id IN NUMBER
28 , p_demand_source_type IN VARCHAR2
29 , p_demand_source_header_id IN NUMBER
30 , p_demand_source_line_id IN NUMBER
31 , p_demand_source_name IN VARCHAR2
32 , p_supply_source_type_id IN NUMBER
33 , p_supply_source_type IN VARCHAR2
34 , p_supply_source_header_id IN NUMBER
35 , p_supply_source_line_id IN NUMBER
36 , p_supply_source_name IN VARCHAR2
37 , p_supply_source_line_detail IN NUMBER
38 , p_primary_uom_code IN VARCHAR2
39 , p_primary_reservation_quantity IN NUMBER
40 , p_from_user_name IN VARCHAR2
41 , p_to_notify_role IN VARCHAR2
42 );
43
44 -- Procedure
45 -- handle_broken_reservation
46 -- Description
47 -- Start the work flow process to handle broken reservation
48 -- Output Parameters
49 -- x_return_status 'T' if succeeded, 'F' if failed
50 PROCEDURE handle_broken_reservation
51 (
52 p_item_type IN VARCHAR2 DEFAULT 'INVRSVWF'
53 , p_item_key IN VARCHAR2
54 , p_reservation_id IN NUMBER
55 , p_from_user_name IN VARCHAR2
56 , p_to_notify_role IN VARCHAR2
57 , x_return_status OUT NOCOPY VARCHAR2
58 );
59
60 PROCEDURE selector
61 ( itemtype IN VARCHAR2
62 , itemkey IN VARCHAR2
63 , actid IN NUMBER
64 , command IN VARCHAR2
65 , result OUT NOCOPY VARCHAR2
66 );
67
68 END inv_reservation_workflow;