[Home] [Help]
PACKAGE: APPS.CS_COST_DETAILS_PVT
Source
1 PACKAGE CS_Cost_Details_PVT AS
2 /* $Header: csxvcsts.pls 120.2 2008/01/11 05:48:06 amganapa noship $ */
3
4 -----------------------------------------------------------------------------
5 -- PACKAGE SPECIFIC CONSTANTS
6 -----------------------------------------------------------------------------
7 G_PKG_NAME CONSTANT VARCHAR2(30) := 'CS_COST_DETAILS_PVT';
8
9 -----------------------------------------------------------------------------
10 -- APPLICATION GLOBAL CONSTANTS
11 -----------------------------------------------------------------------------
12 G_APP_NAME CONSTANT VARCHAR2(2) := 'CS';
13 G_API_VERSION CONSTANT NUMBER := 1.0;
14 G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
15 G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
16 G_DB_ERROR CONSTANT VARCHAR2(11) := 'CS_DB_ERROR';
17 G_PROG_NAME_TOKEN CONSTANT VARCHAR2(9) := 'PROG_NAME';
18 G_SQLCODE_TOKEN CONSTANT VARCHAR2(7) := 'SQLCODE';
19 G_SQLERRM_TOKEN CONSTANT VARCHAR2(7) := 'SQLERRM';
20 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
21 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
22 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
23
24
25 -----------------------------------------------------------------------------
26 -- PROGRAM UNITS
27 -----------------------------------------------------------------------------
28 PROCEDURE Create_cost_details
29 (
30 p_api_version IN NUMBER,
31 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
32 p_commit IN VARCHAR2 := FND_API.G_FALSE,
33 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
34 x_return_status OUT NOCOPY VARCHAR2,
35 x_msg_count OUT NOCOPY NUMBER,
36 x_object_version_number OUT NOCOPY NUMBER,
37 x_msg_data OUT NOCOPY VARCHAR2,
38 x_cost_id OUT NOCOPY NUMBER,
39 p_resp_appl_id IN NUMBER := FND_GLOBAL.RESP_APPL_ID,
40 p_resp_id IN NUMBER := FND_GLOBAL.RESP_ID,
41 p_user_id IN NUMBER := FND_GLOBAL.USER_ID,
42 p_login_id IN NUMBER := FND_GLOBAL.LOGIN_ID,
43 p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
44 p_Cost_Rec IN CS_Cost_Details_PUB.Cost_Rec_Type,
45 p_cost_creation_override IN VARCHAR2 :='N'
46 );
47
48
49
50 PROCEDURE Update_Cost_details
51 (
52 p_api_version IN NUMBER,
53 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
54 p_commit IN VARCHAR2 := FND_API.G_FALSE,
55 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
56 x_return_status OUT NOCOPY VARCHAR2,
57 x_msg_count OUT NOCOPY NUMBER,
58 x_object_version_number OUT NOCOPY NUMBER,
59 x_msg_data OUT NOCOPY VARCHAR2,
60 p_resp_appl_id IN NUMBER := FND_GLOBAL.RESP_APPL_ID,
61 p_resp_id IN NUMBER := FND_GLOBAL.RESP_ID,
62 p_user_id IN NUMBER := FND_GLOBAL.USER_ID,
63 p_login_id IN NUMBER := FND_GLOBAL.LOGIN_ID,
64 p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
65 p_Cost_Rec IN CS_Cost_Details_PUB.Cost_Rec_Type
66 ) ;
67
68
69
70
71 PROCEDURE Delete_Cost_Details
72 (
73 p_api_version IN NUMBER,
74 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
75 p_commit IN VARCHAR2 := FND_API.G_FALSE,
76 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
77 x_return_status OUT NOCOPY VARCHAR2,
78 x_msg_count OUT NOCOPY NUMBER,
79 x_msg_data OUT NOCOPY VARCHAR2,
80 p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
81 p_cost_id IN NUMBER := NULL
82 ) ;
83
84 -- Procedure to purge cost lines attached to an SR.
85
86 PROCEDURE Purge_Cost
87 (
88 p_api_version_number IN NUMBER := 1.0
89 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
90 , p_commit IN VARCHAR2 := FND_API.G_FALSE
91 , p_object_type IN VARCHAR2
92 , p_processing_set_id IN NUMBER
93 , x_return_status OUT NOCOPY VARCHAR2
94 , x_msg_count OUT NOCOPY NUMBER
95 , x_msg_data OUT NOCOPY VARCHAR2
96 );
97
98 PROCEDURE get_currency_converted_value
99 (
100 p_from_currency IN VARCHAR2,
101 p_to_currency IN VARCHAR2,
102 p_value IN NUMBER,
103 p_ou IN VARCHAR2,
104 x_value OUT NOCOPY NUMBER
105 ) ;
106
107 END CS_Cost_Details_PVT;