35: G_INVALID_BUS_DOC_ID_MSG CONSTANT VARCHAR2(200) := 'OKC_REP_INVALID_BUS_DOC_ID';
36:
37: ---------------------------------------------------------------------------
38:
39: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
40: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
41:
42: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
43: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
36:
37: ---------------------------------------------------------------------------
38:
39: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
40: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
41:
42: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
43: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
44: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
38:
39: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
40: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
41:
42: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
43: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
44: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
45:
46: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
39: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
40: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
41:
42: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
43: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
44: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
45:
46: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
47: G_CURRENT_ORG_ID NUMBER := -99;
40: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
41:
42: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
43: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
44: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
45:
46: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
47: G_CURRENT_ORG_ID NUMBER := -99;
48: G_ORG_ID NUMBER ;
53: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
54: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
55: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
56: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
57: p_create_contract IN VARCHAR2 := fnd_api.g_true,
58: p_commit IN VARCHAR2 := fnd_api.g_false,
59: x_msg_data OUT NOCOPY VARCHAR2,
60: x_msg_count OUT NOCOPY NUMBER,
61: x_return_status OUT NOCOPY VARCHAR2
54: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
55: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
56: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
57: p_create_contract IN VARCHAR2 := fnd_api.g_true,
58: p_commit IN VARCHAR2 := fnd_api.g_false,
59: x_msg_data OUT NOCOPY VARCHAR2,
60: x_msg_count OUT NOCOPY NUMBER,
61: x_return_status OUT NOCOPY VARCHAR2
62: );
94: x_msg_count OUT NOCOPY NUMBER,
95: x_return_status OUT NOCOPY VARCHAR2);
96:
97: Procedure delete_contract(p_api_version IN NUMBER,
98: p_commit IN VARCHAR2 := fnd_api.g_false,
99: p_contract_id IN NUMBER,
100: x_msg_data OUT NOCOPY VARCHAR2,
101: x_msg_count OUT NOCOPY NUMBER,
102: x_return_status OUT NOCOPY VARCHAR2
143: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
144: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
145: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
146: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
147: p_commit IN VARCHAR2 := fnd_api.g_false,
148: x_msg_data OUT NOCOPY VARCHAR2,
149: x_msg_count OUT NOCOPY NUMBER,
150: x_return_status OUT NOCOPY VARCHAR2
151: );
154: Deletes the Contract for the given document type.
155: */
156:
157: Procedure delete_contract(p_api_version IN NUMBER,
158: p_commit IN VARCHAR2 := fnd_api.g_false,
159: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
160: p_contract_type IN VARCHAR2 DEFAULT NULL,
161: p_contract_id IN NUMBER DEFAULT NULL,
162: x_msg_data OUT NOCOPY VARCHAR2,
173:
174: Procedure create_new_contract_version(p_api_version IN NUMBER,
175: p_contract_id IN NUMBER,
176: p_run_id IN NUMBER,
177: p_commit IN VARCHAR2 := fnd_api.g_false,
178: x_msg_data OUT NOCOPY VARCHAR2,
179: x_msg_count OUT NOCOPY NUMBER,
180: x_return_status OUT NOCOPY VARCHAR2
181: );
192: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
193: p_contract_type IN VARCHAR2 DEFAULT NULL,
194: p_contract_id IN NUMBER DEFAULT NULL,
195: p_run_id IN NUMBER,
196: p_commit IN VARCHAR2 := fnd_api.g_false,
197: x_msg_data OUT NOCOPY VARCHAR2,
198: x_msg_count OUT NOCOPY NUMBER,
199: x_return_status OUT NOCOPY VARCHAR2
200: );
228: x_return_status OUT NOCOPY VARCHAR2
229: );
230:
231: PROCEDURE cancel_contract(p_api_version IN NUMBER,
232: p_commit IN VARCHAR2 := fnd_api.g_false,
233: p_contract_id IN NUMBER,
234: x_msg_data OUT NOCOPY VARCHAR2,
235: x_msg_count OUT NOCOPY NUMBER,
236: x_return_status OUT NOCOPY VARCHAR2
236: x_return_status OUT NOCOPY VARCHAR2
237: );
238:
239: Procedure delete_cancel_contract(p_api_version IN NUMBER,
240: p_commit IN VARCHAR2 := fnd_api.g_false,
241: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
242: p_contract_type IN VARCHAR2 DEFAULT NULL,
243: p_contract_id IN NUMBER DEFAULT NULL,
244: x_msg_data OUT NOCOPY VARCHAR2,
253: Procedure cancel_contract(p_api_version IN NUMBER,
254: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
255: p_contract_type IN VARCHAR2 DEFAULT NULL,
256: p_contract_id IN NUMBER DEFAULT NULL,
257: p_commit IN VARCHAR2 := fnd_api.g_false,
258: x_msg_data OUT NOCOPY VARCHAR2,
259: x_msg_count OUT NOCOPY NUMBER,
260: x_return_status OUT NOCOPY VARCHAR2
261: ) ;