1 PACKAGE PO_CO_TOLERANCES_PVT AS
2 /* $Header: PO_CO_TOLERANCES_PVT.pls 120.1.12010000.3 2008/11/22 11:03:24 rojain ship $ */
3
4 --<R12 REQUESTER DRIVEN PROCUREMENT START-->
5 ------------------------------------------------------------------------------
6 --Start of Comments
7 --Name: GET_TOLERANCES
8 --Pre-reqs:
9 -- None
10 --Modifies:
11 -- None
12 --Locks:
13 -- None
14 --Function:
15 -- 1. This procedure will retrieve the tolerances of a
16 -- given change order type and operating unit.
17 --Parameters:
18 --IN:
19 -- p_api_version
20 -- Used to determine compatibility of API and calling program
21 -- p_init_msg_list
22 -- True/False parameter to initialize message list
23 -- p_organization_id
24 -- Operating Unit Id
25 -- p_change_order_type
26 -- Change Order Type for which the tolerances should be retrieved.
27 --OUT:
28 -- x_tolerances_tbl
29 -- Table containing the tolerances and their values
30 -- x_return_status
31 -- The standard OUT parameter giving return status of the API call.
32 -- FND_API.G_RET_STS_ERROR - for expected error
33 -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
34 -- FND_API.G_RET_STS_SUCCESS - for success
35 -- x_msg_count
36 -- The count of number of messages added to the message list in this call
37 -- x_msg_data
38 -- If the count is 1 then x_msg_data contains the message returned
39 --End of Comment
40 -------------------------------------------------------------------------------
41 procedure GET_TOLERANCES(p_api_version IN NUMBER,
42 p_init_msg_list IN VARCHAR2,
43 p_organization_id IN NUMBER,
44 p_change_order_type IN VARCHAR2,
45 x_tolerances_tbl IN OUT NOCOPY PO_CO_TOLERANCES_GRP.tolerances_tbl_type,
46 x_return_status OUT NOCOPY VARCHAR2,
47 x_msg_count OUT NOCOPY NUMBER,
48 x_msg_data OUT NOCOPY VARCHAR2);
49
50 --<R12 REQUESTER DRIVEN PROCUREMENT END-->
51
52 END;
[Home] [Help]