1 PACKAGE GMF_ResourceCost_PUB AUTHID CURRENT_USER AS
2 /* $Header: GMFPRESS.pls 120.1.12000000.1 2007/01/17 16:52:55 appldev ship $ */
3 /*#
4 * This is the public interface for OPM Resource Cost API.
5 * This API can be used for creation, updation, deletion and
6 * retrieval of resource costs from the resource cost details table.
7 * @rep:scope public
8 * @rep:product GMF
9 * @rep:displayname GMF Resource Cost API
10 * @rep:lifecycle active
11 * @rep:category BUSINESS_ENTITY GMF_RESOURCE_COST
12 */
13
14 -- Definition of all the entities
15 TYPE Resource_Cost_Rec_Type IS RECORD
16 ( resources cm_rsrc_dtl.resources%TYPE,
17 legal_entity_id cm_rsrc_dtl.legal_entity_id%TYPE ,
18 organization_id cm_rsrc_dtl.organization_id%TYPE ,
19 organization_code mtl_parameters.organization_code%TYPE ,
20 period_id cm_rsrc_dtl.period_id%TYPE ,
21 calendar_code cm_rsrc_dtl.calendar_code%TYPE ,
22 period_code cm_rsrc_dtl.period_code%TYPE ,
23 cost_type_id cm_rsrc_dtl.cost_type_id%TYPE ,
24 cost_mthd_code cm_rsrc_dtl.cost_mthd_code%TYPE,
25 usage_uom cm_rsrc_dtl.usage_uom%TYPE,
26 nominal_cost cm_rsrc_dtl.nominal_cost%TYPE,
27 delete_mark cm_rsrc_dtl.delete_mark%TYPE := 0,
28 user_name fnd_user.user_name%TYPE
29 );
30
31 /*#
32 * Resource Cost Creation API
33 * This API Creates a new Resource Cost in the Resource Cost Details table
34 * @param p_api_version Version Number of the API
35 * @param p_init_msg_list Flag for initializing message list
36 * @param p_commit Flag for commiting the data or not
37 * @param x_return_status Return status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
38 * @param x_msg_count Number of messages on message stack
39 * @param x_msg_data Actual message data from message stack
40 * @param p_resource_cost_rec Resource cost record type
41 * @rep:scope public
42 * @rep:lifecycle active
43 * @rep:displayname Create Resource Cost API
44 */
45 PROCEDURE Create_Resource_Cost
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
50 x_return_status OUT NOCOPY VARCHAR2 ,
51 x_msg_count OUT NOCOPY NUMBER ,
52 x_msg_data OUT NOCOPY VARCHAR2 ,
53
54 p_resource_cost_rec IN Resource_Cost_Rec_Type
55 );
56
57 /*#
58 * Resource Cost Updation API
59 * This API Updates a Resource Cost in the Resource Cost Details table
60 * @param p_api_version Version Number of the API
61 * @param p_init_msg_list Flag for initializing message list
62 * @param p_commit Flag for commiting the data or not
63 * @param x_return_status Return status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
64 * @param x_msg_count Number of messages on message stack
65 * @param x_msg_data Actual message data from message stack
66 * @param p_resource_cost_rec Resource cost record type
67 * @rep:scope public
68 * @rep:lifecycle active
69 * @rep:displayname Update Resource Cost API
70 */
71 PROCEDURE Update_Resource_Cost
72 ( p_api_version IN NUMBER ,
73 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
74 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
75
76 x_return_status OUT NOCOPY VARCHAR2 ,
77 x_msg_count OUT NOCOPY NUMBER ,
78 x_msg_data OUT NOCOPY VARCHAR2 ,
79
80 p_resource_cost_rec IN Resource_Cost_Rec_Type
81 );
82
83 /*#
84 * Resource Cost Deletion API
85 * This API Deletes a Resource Cost from the Resource Cost Details table
86 * @param p_api_version Version Number of the API
87 * @param p_init_msg_list Flag for initializing message list
88 * @param p_commit Flag for commiting the data or not
89 * @param x_return_status Return status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
90 * @param x_msg_count Number of messages on message stack
91 * @param x_msg_data Actual message data from message stack
92 * @param p_resource_cost_rec Resource cost record type
93 * @rep:scope public
94 * @rep:lifecycle active
95 * @rep:displayname Delete Resource Cost API
96 */
97 PROCEDURE Delete_Resource_Cost
98 ( p_api_version IN NUMBER ,
99 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
100 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
101
102 x_return_status OUT NOCOPY VARCHAR2 ,
103 x_msg_count OUT NOCOPY NUMBER ,
104 x_msg_data OUT NOCOPY VARCHAR2 ,
105
106 p_resource_cost_rec IN Resource_Cost_Rec_Type
107 );
108
109 /*#
110 * Resource Cost Retrieval API
111 * This API Retrieves a Resource Cost from the Resource Cost Details table
112 * @param p_api_version Version Number of the API
113 * @param p_init_msg_list Flag for initializing message list
114 * @param x_return_status Return status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
115 * @param x_msg_count Number of messages on message stack
116 * @param x_msg_data Actual message data from message stack
117 * @param p_resource_cost_rec Resource cost record type
118 * @param x_resource_cost_rec Resource cost record type
119 * @rep:scope public
120 * @rep:lifecycle active
121 * @rep:displayname Retrieve Resource Cost API
122 */
123 PROCEDURE Get_Resource_Cost
124 ( p_api_version IN NUMBER ,
125 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
126
127 x_return_status OUT NOCOPY VARCHAR2 ,
128 x_msg_count OUT NOCOPY NUMBER ,
129 x_msg_data OUT NOCOPY VARCHAR2 ,
130
131 p_resource_cost_rec IN Resource_Cost_Rec_Type ,
132 x_resource_cost_rec OUT NOCOPY Resource_Cost_Rec_Type
133 );
134
135 END GMF_ResourceCost_PUB;
136