DBA Data[Home] [Help]

APPS.CS_COST_DETAILS_PVT dependencies on FND_API

Line 14: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;

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

Line 15: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;

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

Line 20: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

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:

Line 21: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_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: -----------------------------------------------------------------------------

Line 22: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

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

Line 31: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 32: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 33: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 43: p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,

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:

Line 53: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 54: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 55: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 64: p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,

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:

Line 74: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 75: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 76: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 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.

Line 89: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

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

Line 90: , p_commit IN VARCHAR2 := FND_API.G_FALSE

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