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';
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';
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:
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: -----------------------------------------------------------------------------
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,
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,
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,
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:
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,
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,
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:
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,
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,
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,
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
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