1 PACKAGE CSP_NOTIFICATIONS_PVT AUTHID CURRENT_USER AS
2 /* $Header: cspvpnos.pls 115.7 2002/11/26 06:05:39 hhaugeru ship $ */
3 -- Start of comments
4 -- API name : calculate_loop
5 -- Type : Private
6 -- Function :
7 -- Pre-reqs : None.
8 -- Parameters :
9 -- IN : p_api_version Standards input
10 -- p_parts_loop_id Parts loop identifier
11 -- p_inventory_item_id Item identifier
12 -- p_include_intransit_mo Flag to include intransit move orders
13 -- p_include_interorg_transfers Flag to include interorg transfers
14 -- p_include_sales_orders Flag to include sales orders
15 -- p_include_move_orders Flag to include move orders
16 -- p_include_requisitions Flag to include requisitions
17 -- p_include_purchase_orders Flag to include purchase orders
18 -- p_include_work_orders Flag to include work orders
19 -- p_include_onhand_good Flag to include onhand good
20 -- p_include_onhand_bad Flag to include onhand bad
21 -- p_tolerance_percent Tolerance percent allowed
22 --
23 -- OUT : x_above Positive number indicates above level
24 -- x_below Positive number indicates below level
25 -- x_not_enough_good_parts Positive number indicates not enough good parts
26 -- x_quantity_level Quantity level in parts loop for this item
27 -- x_onhand_good Quantity of onhand good parts.
28 -- x_min_good Minimun onhand good allowed
29 -- x_total_loop_quantity Total quantity should be in loop
30 -- x_return_status standard output parameter
31 -- x_msg_count standard output parameter
32 -- x_msg_data standard output parameter
33 --
34 -- Version : Current version 1.0
35 -- Changed....
36 -- previous version none
37 -- Changed....
38 -- .
39 -- .
40 -- previous version none
41 -- Changed....
42 -- Initial version 1.0
43 --
44 -- Notes :
45 -- Api is used to calculate an item's quantity in released
46 -- work orders within the time fence for a specified subinventory.
47 --
48 -- End of comments
49
50 PROCEDURE calculate_loop
51 ( p_api_version IN NUMBER,
52 p_parts_loop_id IN NUMBER,
53 p_inventory_item_id IN NUMBER,
54 p_include_intransit_mo VARCHAR2 DEFAULT null,
55 p_include_interorg_transfers VARCHAR2 DEFAULT null,
56 p_include_sales_orders VARCHAR2 DEFAULT null,
57 p_include_move_orders VARCHAR2 DEFAULT null,
58 p_include_requisitions VARCHAR2 DEFAULT null,
59 p_include_purchase_orders VARCHAR2 DEFAULT null,
60 p_include_work_orders VARCHAR2 DEFAULT null,
61 p_include_onhand_good VARCHAR2 DEFAULT null,
62 p_include_onhand_bad VARCHAR2 DEFAULT null,
63 p_tolerance_percent NUMBER DEFAULT null,
64 x_above OUT NOCOPY NUMBER,
65 x_below OUT NOCOPY NUMBER,
66 x_not_enough_good_parts OUT NOCOPY NUMBER,
67 x_quantity_level OUT NOCOPY NUMBER,
68 x_onhand_good OUT NOCOPY NUMBER,
69 x_min_good OUT NOCOPY NUMBER,
70 x_total_loop_quantity OUT NOCOPY NUMBER,
71 x_return_status OUT NOCOPY VARCHAR2,
72 x_msg_count OUT NOCOPY NUMBER,
73 x_msg_data OUT NOCOPY VARCHAR2
74 );
75
76 -- Start of comments
77 -- API name : find_notifications
78 -- Type : Private
79 -- Function :
80 -- Pre-reqs : None.
81 -- Parameters :
82 -- IN : p_api_version Standards input
83 -- p_organization_id Organization identifier
84 -- p_inventory_item_id Item identifier
85 -- p_subinventory_code Name of subinventory
86 -- p_time_fence Number of days in time fence
87 --
88 -- OUT : x_return_status standard output parameter
89 -- x_msg_count standard output parameter
90 -- x_msg_data standard output parameter
91 --
92 -- Version : Current version 1.0
93 -- Changed....
94 -- previous version none
95 -- Changed....
96 -- .
97 -- .
98 -- previous version none
99 -- Changed....
100 -- Initial version 1.0
101 --
102 -- Notes :
103 -- Api is used to calculate an item's quantity in released
104 -- work orders within the time fence for a specified subinventory.
105 --
106 -- End of comments
107 PROCEDURE create_notifications
108 ( errbuf OUT NOCOPY VARCHAR2,
109 retcode OUT NOCOPY NUMBER,
110 p_api_version IN NUMBER,
111 p_organization_id IN NUMBER
112 );
113 END;