DBA Data[Home] [Help]

APPS.CS_CHARGE_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 30: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

26: -- PROGRAM UNITS
27: -----------------------------------------------------------------------------
28: PROCEDURE Create_Charge_Details(
29: p_api_version IN NUMBER,
30: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
31: p_commit IN VARCHAR2 := FND_API.G_FALSE,
32: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
33: x_return_status OUT NOCOPY VARCHAR2,
34: x_msg_count OUT NOCOPY NUMBER,

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

27: -----------------------------------------------------------------------------
28: PROCEDURE Create_Charge_Details(
29: p_api_version IN NUMBER,
30: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
31: p_commit IN VARCHAR2 := FND_API.G_FALSE,
32: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
33: x_return_status OUT NOCOPY VARCHAR2,
34: x_msg_count OUT NOCOPY NUMBER,
35: x_object_version_number OUT NOCOPY NUMBER,

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

28: PROCEDURE Create_Charge_Details(
29: p_api_version IN NUMBER,
30: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
31: p_commit IN VARCHAR2 := FND_API.G_FALSE,
32: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
33: x_return_status OUT NOCOPY VARCHAR2,
34: x_msg_count OUT NOCOPY NUMBER,
35: x_object_version_number OUT NOCOPY NUMBER,
36: x_estimate_detail_id OUT NOCOPY NUMBER,

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

42: p_resp_appl_id IN NUMBER := FND_GLOBAL.RESP_APPL_ID,
43: p_resp_id IN NUMBER := FND_GLOBAL.RESP_ID,
44: p_user_id IN NUMBER := FND_GLOBAL.USER_ID,
45: p_login_id IN NUMBER := NULL,
46: p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
47: p_est_detail_rec IN CS_Charge_Details_PUB.Charges_Rec_Type);
48:
49:
50:

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

52: -- Updates CS_ESTIMATE_DETAILS
53:
54: PROCEDURE Update_Charge_Details(
55: p_api_version IN NUMBER,
56: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
57: p_commit IN VARCHAR2 := FND_API.G_FALSE,
58: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
59: x_return_status OUT NOCOPY VARCHAR2,
60: x_msg_count OUT NOCOPY NUMBER,

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

53:
54: PROCEDURE Update_Charge_Details(
55: p_api_version IN NUMBER,
56: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
57: p_commit IN VARCHAR2 := FND_API.G_FALSE,
58: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
59: x_return_status OUT NOCOPY VARCHAR2,
60: x_msg_count OUT NOCOPY NUMBER,
61: x_object_version_number OUT NOCOPY NUMBER,

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

54: PROCEDURE Update_Charge_Details(
55: p_api_version IN NUMBER,
56: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
57: p_commit IN VARCHAR2 := FND_API.G_FALSE,
58: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
59: x_return_status OUT NOCOPY VARCHAR2,
60: x_msg_count OUT NOCOPY NUMBER,
61: x_object_version_number OUT NOCOPY NUMBER,
62: x_msg_data OUT NOCOPY VARCHAR2,

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

66: p_resp_appl_id IN NUMBER := FND_GLOBAL.RESP_APPL_ID,
67: p_resp_id IN NUMBER := FND_GLOBAL.RESP_ID,
68: p_user_id IN NUMBER := FND_GLOBAL.USER_ID,
69: p_login_id IN NUMBER := NULL,
70: p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
71: p_est_detail_rec IN CS_Charge_Details_PUB.Charges_Rec_Type);
72:
73:
74: -- Procedure Delete Charge Detail

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

75: -- Deletes CS_ESTIMATE_DETAILS
76:
77: PROCEDURE Delete_Charge_Details(
78: p_api_version IN NUMBER,
79: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
80: p_commit IN VARCHAR2 := FND_API.G_FALSE,
81: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
82: x_return_status OUT NOCOPY VARCHAR2,
83: x_msg_count OUT NOCOPY NUMBER,

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

76:
77: PROCEDURE Delete_Charge_Details(
78: p_api_version IN NUMBER,
79: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
80: p_commit IN VARCHAR2 := FND_API.G_FALSE,
81: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
82: x_return_status OUT NOCOPY VARCHAR2,
83: x_msg_count OUT NOCOPY NUMBER,
84: x_msg_data OUT NOCOPY VARCHAR2,

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

77: PROCEDURE Delete_Charge_Details(
78: p_api_version IN NUMBER,
79: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
80: p_commit IN VARCHAR2 := FND_API.G_FALSE,
81: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
82: x_return_status OUT NOCOPY VARCHAR2,
83: x_msg_count OUT NOCOPY NUMBER,
84: x_msg_data OUT NOCOPY VARCHAR2,
85: p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,

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

81: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
82: x_return_status OUT NOCOPY VARCHAR2,
83: x_msg_count OUT NOCOPY NUMBER,
84: x_msg_data OUT NOCOPY VARCHAR2,
85: p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
86: p_estimate_detail_id IN NUMBER := NULL) ;
87:
88: -- Procedure Copy Estimate
89: -- Copies Estimate from CS_ESTIMATE_DETAILS

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

89: -- Copies Estimate from CS_ESTIMATE_DETAILS
90:
91: Procedure Copy_Estimate(
92: p_api_version IN NUMBER,
93: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
94: p_commit IN VARCHAR2 := FND_API.G_FALSE,
95: p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
96: p_estimate_detail_id IN NUMBER := NULL,
97: x_estimate_detail_id OUT NOCOPY NUMBER,

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

90:
91: Procedure Copy_Estimate(
92: p_api_version IN NUMBER,
93: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
94: p_commit IN VARCHAR2 := FND_API.G_FALSE,
95: p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
96: p_estimate_detail_id IN NUMBER := NULL,
97: x_estimate_detail_id OUT NOCOPY NUMBER,
98: x_return_status OUT NOCOPY VARCHAR2,

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

91: Procedure Copy_Estimate(
92: p_api_version IN NUMBER,
93: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
94: p_commit IN VARCHAR2 := FND_API.G_FALSE,
95: p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
96: p_estimate_detail_id IN NUMBER := NULL,
97: x_estimate_detail_id OUT NOCOPY NUMBER,
98: x_return_status OUT NOCOPY VARCHAR2,
99: x_msg_count OUT NOCOPY NUMBER,

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

125:
126: PROCEDURE Purge_Chg_Validations
127: (
128: p_api_version_number IN NUMBER := 1.0
129: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
130: , p_commit IN VARCHAR2 := FND_API.G_FALSE
131: , p_object_type IN VARCHAR2
132: , p_processing_set_id IN NUMBER
133: , x_return_status OUT NOCOPY VARCHAR2

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

126: PROCEDURE Purge_Chg_Validations
127: (
128: p_api_version_number IN NUMBER := 1.0
129: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
130: , p_commit IN VARCHAR2 := FND_API.G_FALSE
131: , p_object_type IN VARCHAR2
132: , p_processing_set_id IN NUMBER
133: , x_return_status OUT NOCOPY VARCHAR2
134: , x_msg_count OUT NOCOPY NUMBER

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

139:
140: PROCEDURE Purge_Charges
141: (
142: p_api_version_number IN NUMBER := 1.0
143: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
144: , p_commit IN VARCHAR2 := FND_API.G_FALSE
145: , p_object_type IN VARCHAR2
146: , p_processing_set_id IN NUMBER
147: , x_return_status OUT NOCOPY VARCHAR2

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

140: PROCEDURE Purge_Charges
141: (
142: p_api_version_number IN NUMBER := 1.0
143: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
144: , p_commit IN VARCHAR2 := FND_API.G_FALSE
145: , p_object_type IN VARCHAR2
146: , p_processing_set_id IN NUMBER
147: , x_return_status OUT NOCOPY VARCHAR2
148: , x_msg_count OUT NOCOPY NUMBER