[Home] [Help]
PACKAGE: APPS.OKC_EXTEND_PUB
Source
1 PACKAGE OKC_EXTEND_PUB as
2 /* $Header: OKCPEXTS.pls 120.0 2005/05/25 19:00:22 appldev noship $ */
3
4 SUBTYPE extend_in_parameters_rec is OKC_EXTEND_PVT.extend_in_parameters_rec;
5 SUBTYPE extend_in_parameters_tbl is OKC_EXTEND_PVT.extend_in_parameters_tbl;
6 SUBTYPE extend_in_cle_rec is OKC_EXTEND_PVT.extend_in_cle_rec;
7 SUBTYPE extend_in_cle_tbl is OKC_EXTEND_PVT.extend_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_EXTEND_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
22 g_extend_in_parameters_rec extend_in_parameters_rec;
23 g_extend_in_cle_rec extend_in_cle_rec;
24
25
26 FUNCTION is_k_extend_allowed(p_chr_id IN NUMBER,p_sts_code IN VARCHAR2) RETURN BOOLEAN;
27 FUNCTION is_kl_extend_allowed(p_cle_id IN NUMBER,p_sts_code IN VARCHAR2) RETURN BOOLEAN;
28
29
30 PROCEDURE extend_chr( p_api_version IN NUMBER,
31 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
32 x_return_status OUT NOCOPY VARCHAR2,
33 x_msg_count OUT NOCOPY NUMBER,
34 x_msg_data OUT NOCOPY VARCHAR2,
35 p_extend_in_parameters_tbl IN extend_in_parameters_tbl,
36 p_do_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
37 );
38
39 PROCEDURE extend_chr( p_api_version IN NUMBER,
40 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
41 x_return_status OUT NOCOPY VARCHAR2,
42 x_msg_count OUT NOCOPY NUMBER,
43 x_msg_data OUT NOCOPY VARCHAR2,
44 p_extend_in_parameters_rec IN extend_in_parameters_rec,
45 p_do_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
46 );
47
48 PROCEDURE validate_chr( p_api_version IN NUMBER,
49 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
50 x_return_status OUT NOCOPY VARCHAR2,
51 x_msg_count OUT NOCOPY NUMBER,
52 x_msg_data OUT NOCOPY VARCHAR2,
53 p_extend_in_parameters_tbl IN extend_in_parameters_tbl);
54
55 PROCEDURE validate_chr( p_api_version IN NUMBER,
56 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
57 x_return_status OUT NOCOPY VARCHAR2,
58 x_msg_count OUT NOCOPY NUMBER,
59 x_msg_data OUT NOCOPY VARCHAR2,
60 p_extend_in_parameters_rec IN extend_in_parameters_rec );
61
62 PROCEDURE extend_cle( p_api_version IN NUMBER,
63 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
64 x_return_status OUT NOCOPY VARCHAR2,
65 x_msg_count OUT NOCOPY NUMBER,
66 x_msg_data OUT NOCOPY VARCHAR2,
67 p_extend_in_parameters_tbl IN extend_in_cle_tbl,
68 p_do_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
69 );
70
71 PROCEDURE extend_cle( p_api_version IN NUMBER,
72 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
73 x_return_status OUT NOCOPY VARCHAR2,
74 x_msg_count OUT NOCOPY NUMBER,
75 x_msg_data OUT NOCOPY VARCHAR2,
76 p_extend_in_parameters_rec IN extend_in_cle_rec,
77 p_do_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
78 );
79
80 PROCEDURE validate_cle( p_api_version IN NUMBER,
81 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
82 x_return_status OUT NOCOPY VARCHAR2,
83 x_msg_count OUT NOCOPY NUMBER,
84 x_msg_data OUT NOCOPY VARCHAR2,
85 p_extend_in_parameters_tbl IN extend_in_cle_tbl);
86
87 PROCEDURE validate_cle( p_api_version IN NUMBER,
88 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
89 x_return_status OUT NOCOPY VARCHAR2,
90 x_msg_count OUT NOCOPY NUMBER,
91 x_msg_data OUT NOCOPY VARCHAR2,
92 p_extend_in_parameters_rec IN extend_in_cle_rec);
93
94 END OKC_EXTEND_PUB;