PACKAGE: APPS.INV_TURNS

Source

1 PACKAGE INV_TURNS AUTHID CURRENT_USER as
2 /* $Header: INVTRNIS.pls 115.8 2003/03/19 05:27:02 aapaul ship $ */
3 
4 g_pkg_name CONSTANT VARCHAR2(30) := 'INV_TURNS';
5 
6 PROCEDURE CLOSED_TB (
7 	p_organization_id IN NUMBER,
8 	p_period_id IN NUMBER,
9 	err_msg OUT NOCOPY VARCHAR2
10 );
11 
12 PROCEDURE CLOSED_SC (
13 	p_organization_id IN NUMBER,
14 	p_period_id IN NUMBER,
15 	p_last_period_id IN NUMBER,
16 	err_msg OUT NOCOPY VARCHAR2
17 );
18 
19 PROCEDURE CLOSED_WIP (
20 	p_organization_id IN NUMBER,
21 	p_period_id IN NUMBER,
22 	err_msg OUT NOCOPY VARCHAR2
23 );
24 
25 PROCEDURE CLOSED_COGS(
26 	p_organization_id IN NUMBER,
27 	p_period_id IN NUMBER,
28 	err_msg OUT NOCOPY VARCHAR2
29 );
30 
31 PROCEDURE CREATE_OPEN_PERIODS (
32                              ERRBUF               OUT NOCOPY VARCHAR2,
33                              RETCODE              OUT NOCOPY NUMBER
34 );
35 
36 PROCEDURE FIND_TXN_VALUES (
37 	err_msg OUT NOCOPY varchar2,
38 	p_organization_id IN NUMBER,
39 	p_new_period IN NUMBER,
40 	p_period_id IN NUMBER,
41 	p_period_start_date DATE,
42 	p_schedule_close_date DATE
43 );
44 -- Added the below function for bug 2740652
45 FUNCTION GET_MBI_ONHAND(x_organization_id NUMBER,
46                         x_inventory_item_id NUMBER,
47                         x_last_period_id NUMBER) return NUMBER;
48 
49 END INV_TURNS;