13:
14: ------------------------------------------------------------------------------
15: -- GLOBAL CONSTANTS
16: ------------------------------------------------------------------------------
17: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
18: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
19: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
20: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
21: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
14: ------------------------------------------------------------------------------
15: -- GLOBAL CONSTANTS
16: ------------------------------------------------------------------------------
17: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
18: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
19: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
20: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
21: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
22: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
15: -- GLOBAL CONSTANTS
16: ------------------------------------------------------------------------------
17: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
18: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
19: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
20: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
21: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
22: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
23: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
16: ------------------------------------------------------------------------------
17: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
18: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
19: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
20: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
21: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
22: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
23: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
24: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
17: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
18: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
19: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
20: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
21: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
22: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
23: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
24: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
25: G_REP_QA_TYPE CONSTANT VARCHAR2(30) := 'REPOSITORY';
105: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
106: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
107: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type ,
108: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type ,
109: p_commit IN VARCHAR2 := fnd_api.g_false,
110: x_msg_data OUT NOCOPY VARCHAR2,
111: x_msg_count OUT NOCOPY NUMBER,
112: x_return_status OUT NOCOPY VARCHAR2
113: );
119: Procedure delete_contract(p_api_version IN NUMBER,
120: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
121: p_contract_type IN VARCHAR2 DEFAULT NULL,
122: p_contract_id IN NUMBER DEFAULT NULL,
123: p_commit IN VARCHAR2 := fnd_api.g_false,
124: x_msg_data OUT NOCOPY VARCHAR2,
125: x_msg_count OUT NOCOPY NUMBER,
126: x_return_status OUT NOCOPY VARCHAR2
127: );
136: Procedure create_new_contract_version(p_api_version IN NUMBER,
137: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
138: p_contract_type IN VARCHAR2 DEFAULT NULL,
139: p_contract_id IN NUMBER DEFAULT NULL,
140: p_commit IN VARCHAR2 := fnd_api.g_false,
141: x_msg_data OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
143: x_return_status OUT NOCOPY VARCHAR2
144: );