13: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
14: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
15: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
16: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_terminate_PUB';
17: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
18: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
19: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
20: ---------------------------------------------------------------------------
21: g_terminate_in_parameters_rec terminate_in_parameters_rec;
14: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
15: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
16: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_terminate_PUB';
17: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
18: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
19: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
20: ---------------------------------------------------------------------------
21: g_terminate_in_parameters_rec terminate_in_parameters_rec;
22: g_terminate_in_cle_rec terminate_in_cle_rec;
15: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
16: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_terminate_PUB';
17: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
18: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
19: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
20: ---------------------------------------------------------------------------
21: g_terminate_in_parameters_rec terminate_in_parameters_rec;
22: g_terminate_in_cle_rec terminate_in_cle_rec;
23:
24: FUNCTION is_k_term_allowed(p_chr_id IN NUMBER,p_sts_code IN VARCHAR2) RETURN BOOLEAN;
25: FUNCTION is_kl_term_allowed(p_cle_id IN NUMBER,p_sts_code IN VARCHAR2) RETURN BOOLEAN;
26:
27: PROCEDURE terminate_chr( p_api_version IN NUMBER,
28: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
29: x_return_status OUT NOCOPY VARCHAR2,
30: x_msg_count OUT NOCOPY NUMBER,
31: x_msg_data OUT NOCOPY VARCHAR2,
32: p_terminate_in_parameters_tbl IN terminate_in_parameters_tbl,
29: x_return_status OUT NOCOPY VARCHAR2,
30: x_msg_count OUT NOCOPY NUMBER,
31: x_msg_data OUT NOCOPY VARCHAR2,
32: p_terminate_in_parameters_tbl IN terminate_in_parameters_tbl,
33: p_do_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
34: );
35:
36: PROCEDURE terminate_chr( p_api_version IN NUMBER,
37: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
33: p_do_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
34: );
35:
36: PROCEDURE terminate_chr( p_api_version IN NUMBER,
37: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
38: x_return_status OUT NOCOPY VARCHAR2,
39: x_msg_count OUT NOCOPY NUMBER,
40: x_msg_data OUT NOCOPY VARCHAR2,
41: p_terminate_in_parameters_rec IN terminate_in_parameters_rec,
38: x_return_status OUT NOCOPY VARCHAR2,
39: x_msg_count OUT NOCOPY NUMBER,
40: x_msg_data OUT NOCOPY VARCHAR2,
41: p_terminate_in_parameters_rec IN terminate_in_parameters_rec,
42: p_do_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
43: );
44:
45: PROCEDURE validate_chr( p_api_version IN NUMBER,
46: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
42: p_do_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
43: );
44:
45: PROCEDURE validate_chr( p_api_version IN NUMBER,
46: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
47: x_return_status OUT NOCOPY VARCHAR2,
48: x_msg_count OUT NOCOPY NUMBER,
49: x_msg_data OUT NOCOPY VARCHAR2,
50: p_terminate_in_parameters_tbl IN terminate_in_parameters_tbl);
49: x_msg_data OUT NOCOPY VARCHAR2,
50: p_terminate_in_parameters_tbl IN terminate_in_parameters_tbl);
51:
52: PROCEDURE validate_chr( p_api_version IN NUMBER,
53: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
54: x_return_status OUT NOCOPY VARCHAR2,
55: x_msg_count OUT NOCOPY NUMBER,
56: x_msg_data OUT NOCOPY VARCHAR2,
57: p_terminate_in_parameters_rec IN terminate_in_parameters_rec );
56: x_msg_data OUT NOCOPY VARCHAR2,
57: p_terminate_in_parameters_rec IN terminate_in_parameters_rec );
58:
59: PROCEDURE terminate_cle( p_api_version IN NUMBER,
60: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
61: x_return_status OUT NOCOPY VARCHAR2,
62: x_msg_count OUT NOCOPY NUMBER,
63: x_msg_data OUT NOCOPY VARCHAR2,
64: p_terminate_in_parameters_tbl IN terminate_in_cle_tbl,
61: x_return_status OUT NOCOPY VARCHAR2,
62: x_msg_count OUT NOCOPY NUMBER,
63: x_msg_data OUT NOCOPY VARCHAR2,
64: p_terminate_in_parameters_tbl IN terminate_in_cle_tbl,
65: p_do_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE);
66:
67: PROCEDURE terminate_cle( p_api_version IN NUMBER,
68: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
69: x_return_status OUT NOCOPY VARCHAR2,
64: p_terminate_in_parameters_tbl IN terminate_in_cle_tbl,
65: p_do_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE);
66:
67: PROCEDURE terminate_cle( p_api_version IN NUMBER,
68: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
69: x_return_status OUT NOCOPY VARCHAR2,
70: x_msg_count OUT NOCOPY NUMBER,
71: x_msg_data OUT NOCOPY VARCHAR2,
72: p_terminate_in_parameters_rec IN terminate_in_cle_rec,
69: x_return_status OUT NOCOPY VARCHAR2,
70: x_msg_count OUT NOCOPY NUMBER,
71: x_msg_data OUT NOCOPY VARCHAR2,
72: p_terminate_in_parameters_rec IN terminate_in_cle_rec,
73: p_do_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
74: );
75:
76: PROCEDURE validate_cle( p_api_version IN NUMBER,
77: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
73: p_do_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
74: );
75:
76: PROCEDURE validate_cle( p_api_version IN NUMBER,
77: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
78: x_return_status OUT NOCOPY VARCHAR2,
79: x_msg_count OUT NOCOPY NUMBER,
80: x_msg_data OUT NOCOPY VARCHAR2,
81: p_terminate_in_parameters_tbl IN terminate_in_cle_tbl);
80: x_msg_data OUT NOCOPY VARCHAR2,
81: p_terminate_in_parameters_tbl IN terminate_in_cle_tbl);
82:
83: PROCEDURE validate_cle( p_api_version IN NUMBER,
84: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
85: x_return_status OUT NOCOPY VARCHAR2,
86: x_msg_count OUT NOCOPY NUMBER,
87: x_msg_data OUT NOCOPY VARCHAR2,
88: p_terminate_in_parameters_rec IN terminate_in_cle_rec);