1 PACKAGE CST_ItemResourceCosts_GRP AS
2 /* $Header: CSTGIRCS.pls 120.0 2005/05/25 05:57:07 appldev noship $ */
3
4 LAST_N_PO_RECEIPTS CONSTANT NUMBER := 5;
5
6 -------------------------------------------------------------------------------
7 -- API name : Get_ItemCost
8 -- Type : Group
9 -- Function : Returns item cost for the given item ID,
10 -- cost type, and organization.
11 -- Parameters :
12 -- IN :
13 -- p_api_version IN NUMBER Required
14 -- p_init_msg_list IN VARCHAR2 Optional
15 -- Default = FND_API.G_FALSE
16 -- p_commit IN VARCHAR2 Optional
17 -- Default = FND_API.G_FALSE
18 -- p_validation_level IN NUMBER Optional
19 -- Default = FND_API.G_VALID_LEVEL_FULL
20 -- p_item_id IN NUMBER Required
21 -- p_organization_id IN NUMBER Required
22 -- p_cost_source IN NUMBER Required
23 -- 1 - Return item cost from valuation cost type.
24 -- 2 - Return item cost from user-provided cost type.
25 -- 3 - Return item cost as the list price per unit
26 -- from item definition.
27 -- 4 - Return item cost as average of the
28 -- last 5 PO receipts of this item.
29 -- p_cost_type_id IN NUMBER Optional
30 -- Default = 0
31 --
32 -- OUT :
33 -- x_return_status OUT VARCHAR2(1)
34 -- x_msg_count OUT NUMBER
35 -- x_msg_data OUT VARCHAR2(2000)
36 -- x_item_cost OUT NUMBER
37 -- x_currency_code OUT VARCHAR2(15)
38 -- - functional currency of p_organizaiton_id
39 --
40 -- Version :
41 -- Initial version 1.0
42 --
43 -- End of comments
44 -------------------------------------------------------------------------------
45 PROCEDURE Get_ItemCost(
46 p_api_version IN NUMBER,
47 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
48 p_commit IN VARCHAR2 := FND_API.G_FALSE,
49 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
50 x_return_status OUT NOCOPY VARCHAR2,
51 x_msg_count OUT NOCOPY NUMBER,
52 x_msg_data OUT NOCOPY VARCHAR2,
53 p_item_id IN NUMBER,
54 p_organization_id IN NUMBER,
55 p_cost_source IN NUMBER,
56 p_cost_type_id IN NUMBER := 0,
57 x_item_cost OUT NOCOPY NUMBER,
58 x_currency_code OUT NOCOPY VARCHAR2
59 );
60
61
62 -------------------------------------------------------------------------------
63 -- API name : Get_ResourceRate
64 -- Type : Private
65 -- Function : Returns resource rate for the given resource,
66 -- cost type, and organization.
67 -- Parameters :
68 -- IN :
69 -- p_api_version IN NUMBER Required
70 -- p_init_msg_list IN VARCHAR2 Optional
71 -- Default = FND_API.G_FALSE
72 -- p_commit IN VARCHAR2 Optional
73 -- Default = FND_API.G_FALSE
74 -- p_validation_level IN NUMBER Optional
75 -- Default = FND_API.G_VALID_LEVEL_FULL
76 -- p_resource_id IN NUMBER Required
77 -- p_organization_id IN NUMBER Required
78 -- p_cost_type_id IN NUMBER Optional
79 -- Default = 0 -> will then default to AvgRates
80 --
81 -- OUT :
82 -- x_return_status OUT VARCHAR2(1)
83 -- x_msg_count OUT NUMBER
84 -- x_msg_data OUT VARCHAR2(2000)
85 -- x_resource_rate OUT NUMBER
86 -- x_currency_code OUT VARCHAR2(15)
87 -- - functional currency of p_organizaiton_id
88 -- Version :
89 -- Initial version 1.0
90 --
91 -- End of comments
92 -------------------------------------------------------------------------------
93 PROCEDURE Get_ResourceRate(
94 p_api_version IN NUMBER,
95 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
96 p_commit IN VARCHAR2 := FND_API.G_FALSE,
97 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
98 x_return_status OUT NOCOPY VARCHAR2,
99 x_msg_count OUT NOCOPY NUMBER,
100 x_msg_data OUT NOCOPY VARCHAR2,
101 p_resource_id IN NUMBER,
102 p_organization_id IN NUMBER,
103 p_cost_type_id IN NUMBER := 0,
104 x_resource_rate OUT NOCOPY NUMBER,
105 x_currency_code OUT NOCOPY VARCHAR2
106 );
107
108 END CST_ItemResourceCosts_GRP;