1 PACKAGE EAM_PROCESS_WO_UTIL_PVT AUTHID CURRENT_USER AS
2 /* $Header: EAMVPWUS.pls 120.1.12000000.1 2007/01/16 09:46:51 appldev ship $ */
3 /***************************************************************************
4 --
5 -- Copyright (c) 2002 Oracle Corporation, Redwood Shores, CA, USA
6 -- All rights reserved.
7 --
8 -- FILENAME
9 --
10 -- EAMVPWUS.pls
11 --
12 -- DESCRIPTION
13 --
14 -- Spec of package EAM_PROCESS_WO_UTIL_PVT
15 --
16 -- NOTES
17 --
18 -- HISTORY
19 --
20 -- 12-OCT-2003 Basanth Roy Initial Creation
21 ***************************************************************************/
22
23
24 PROCEDURE create_requisition
25 ( p_api_version IN NUMBER := 1.0
26 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
27 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
28 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
29 ,x_return_status OUT NOCOPY VARCHAR2
30 ,x_msg_count OUT NOCOPY NUMBER
31 ,x_msg_data OUT NOCOPY VARCHAR2
32 ,p_wip_entity_id IN NUMBER -- data
33 ,p_operation_seq_num IN NUMBER
34 ,p_organization_id IN NUMBER
35 ,p_user_id IN NUMBER
36 ,p_responsibility_id IN NUMBER
37 ,p_quantity IN NUMBER
38 ,p_unit_price IN NUMBER
39 ,p_category_id IN NUMBER
40 ,p_item_description IN VARCHAR2
41 ,p_uom_code IN VARCHAR2
42 ,p_need_by_date IN DATE
43 ,p_inventory_item_id IN NUMBER
44 ,p_direct_item_id IN NUMBER
45 ,p_suggested_vendor_id IN NUMBER
46 ,p_suggested_vendor_name IN VARCHAR2
47 ,p_suggested_vendor_site IN VARCHAR2
48 ,p_suggested_vendor_phone IN VARCHAR2
49 ,p_suggested_vendor_item_num IN VARCHAR2) ;
50
51
52 PROCEDURE create_reqs_at_wo_rel
53 ( p_api_version IN NUMBER := 1.0
54 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
55 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
56 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
57 ,x_return_status OUT NOCOPY VARCHAR2
58 ,x_msg_count OUT NOCOPY NUMBER
59 ,x_msg_data OUT NOCOPY VARCHAR2
60 ,p_user_id IN NUMBER
61 ,p_responsibility_id IN NUMBER
62 ,p_wip_entity_id IN NUMBER -- data
63 ,p_organization_id IN NUMBER);
64
65
66 PROCEDURE create_reqs_at_di_upd
67 ( p_api_version IN NUMBER := 1.0
68 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
69 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
70 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
71 ,x_return_status OUT NOCOPY VARCHAR2
72 ,x_msg_count OUT NOCOPY NUMBER
73 ,x_msg_data OUT NOCOPY VARCHAR2
74 ,p_user_id IN NUMBER
75 ,p_responsibility_id IN NUMBER
76 ,p_wip_entity_id IN NUMBER -- data
77 ,p_organization_id IN NUMBER
78 ,p_direct_item_sequence_id IN NUMBER
79 ,p_inventory_item_id IN NUMBER
80 ,p_required_quantity IN NUMBER);
81
82
83 END EAM_PROCESS_WO_UTIL_PVT;