[Home] [Help]
PACKAGE: APPS.OKC_TERMINATE_PUB
Source
1 PACKAGE OKC_TERMINATE_PUB as
2 /* $Header: OKCPTERS.pls 120.0 2005/05/25 22:32:22 appldev noship $ */
3
4 SUBTYPE terminate_in_parameters_rec IS OKC_TERMINATE_PVT.terminate_in_parameters_rec;
5 SUBTYPE terminate_in_parameters_tbl IS OKC_TERMINATE_PVT.terminate_in_parameters_tbl;
6 SUBTYPE terminate_in_cle_rec IS OKC_TERMINATE_PVT.terminate_in_cle_rec;
7 SUBTYPE terminate_in_cle_tbl IS OKC_TERMINATE_PVT.terminate_in_cle_tbl;
8
9
10 -- GLOBAL VARIABLES
11 ---------------------------------------------------------------------------
12 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
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;
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,
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,
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);
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 );
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,
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,
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);
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);
89
90 END OKC_TERMINATE_PUB;