1 PACKAGE WSMPLBJT AUTHID CURRENT_USER AS
2 /* $Header: WSMLBJTS.pls 120.1 2005/06/21 03:26:20 appldev ship $ */
3
4 FUNCTION Material_Issue (
5 X_Wip_Entity_Id IN NUMBER,
6 X_Inventory_Item_Id IN NUMBER,
7 X_Organization_id IN NUMBER,
8 X_Quantity IN NUMBER,
9 X_Acct_Period_Id IN NUMBER,
10 X_Lot_Creation_Id IN NUMBER,
11 X_Lot_Number IN VARCHAR2,
12 X_Subinventory IN VARCHAR2,
13 X_Locator_Id IN NUMBER,
14 X_Revision IN VARCHAR2,
15 X_err_code OUT NOCOPY NUMBER,
16 X_err_msg OUT NOCOPY VARCHAR2,
17 X_passed_header_id IN NUMBER DEFAULT null,
18 -- ST : Serial Support Project --
19 -- Return the transaction temp id also... --
20 X_Temp_id OUT NOCOPY NUMBER
21 -- ST : Serial Support Project --
22 )
23 RETURN NUMBER;
24
25
26 FUNCTION get_assembly(
27 X_Component_Item_Id IN NUMBER,
28 X_Organization_Id IN NUMBER,
29 X_err_code OUT NOCOPY NUMBER,
30 X_err_msg OUT NOCOPY VARCHAR2)
31 RETURN NUMBER;
32
33 FUNCTION get_id(
34 X_item_name IN VARCHAR2,
35 X_organization_id IN NUMBER,
36 X_err_code OUT NOCOPY NUMBER,
37 X_err_msg OUT NOCOPY VARCHAR2)
38 return NUMBER;
39
40 FUNCTION next_job_name (
41 X_Job_Name IN VARCHAR2,
42 X_Organization_Id IN NUMBER,
43 X_Item_Id IN NUMBER,
44 X_Count IN NUMBER,
45 X_err_code OUT NOCOPY NUMBER,
46 X_err_msg OUT NOCOPY VARCHAR2)
47
48 RETURN NUMBER;
49
50 END WSMPLBJT;