[Home] [Help]
PACKAGE: APPS.OKC_TERMINATE_PVT
Source
1 PACKAGE OKC_TERMINATE_PVT AUTHID CURRENT_USER as
2 /* $Header: OKCRTERS.pls 120.0 2005/05/26 09:50:19 appldev noship $ */
3
4 Type terminate_in_parameters_rec is RECORD (
5 p_Contract_id number ,
6 p_contract_number okc_k_headers_v.contract_number%type,
7 p_contract_modifier okc_k_headers_v.contract_number_modifier%type,
8 p_orig_end_date date ,
9 p_contract_version varchar2(9),
10 p_termination_date date ,
11 p_termination_reason fnd_lookups.lookup_code%type );
12
13
14 Type terminate_in_parameters_tbl is table of terminate_in_parameters_rec
15 INDEX BY BINARY_INTEGER;
16
17 Type terminate_in_cle_rec is RECORD (
18 p_cle_id number ,
19 p_line_number okc_k_lines_v.line_number%type ,
20 p_item_description okc_k_lines_v.item_description%type ,
21 p_dnz_chr_id number ,
22 p_sts_code okc_k_lines_v.sts_code%type ,
23 p_date_terminated okc_k_lines_v.date_terminated%type ,
24 p_orig_end_date date ,
25 p_lse_id number ,
26 p_termination_date date ,
27 p_termination_reason fnd_lookups.lookup_code%type );
28
29 Type terminate_in_cle_tbl is table of terminate_in_cle_rec
30 INDEX BY BINARY_INTEGER;
31
32 l_rulv_rec OKC_RULE_PUB.rulv_rec_type;
33
34 -- GLOBAL VARIABLES
35 ---------------------------------------------------------------------------
36 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
37 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
38 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
39 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
40 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_TERMINATE_PVT';
41 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
42 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
43 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
44 ---------------------------------------------------------------------------
45
46 FUNCTION is_k_term_allowed(p_chr_id IN NUMBER,p_sts_code IN VARCHAR2) RETURN BOOLEAN;
47 FUNCTION is_kl_term_allowed(p_cle_id IN NUMBER,p_sts_code IN VARCHAR2) RETURN BOOLEAN;
48
49 PROCEDURE terminate_chr( p_api_version IN NUMBER,
50 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
51 x_return_status OUT NOCOPY VARCHAR2,
52 x_msg_count OUT NOCOPY NUMBER,
53 x_msg_data OUT NOCOPY VARCHAR2,
54 p_terminate_in_parameters_rec IN terminate_in_parameters_rec
55 );
56
57 PROCEDURE validate_chr( p_api_version IN NUMBER,
58 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
59 x_return_status OUT NOCOPY VARCHAR2,
60 x_msg_count OUT NOCOPY NUMBER,
61 x_msg_data OUT NOCOPY VARCHAR2,
62 p_terminate_in_parameters_rec IN terminate_in_parameters_rec
63 );
64
65 PROCEDURE terminate_cle( p_api_version IN NUMBER,
66 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
67 x_return_status OUT NOCOPY VARCHAR2,
68 x_msg_count OUT NOCOPY NUMBER,
69 x_msg_data OUT NOCOPY VARCHAR2,
70 p_terminate_in_parameters_rec IN terminate_in_cle_rec
71 );
72
73
74 PROCEDURE validate_cle( p_api_version IN NUMBER,
75 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
76 x_return_status OUT NOCOPY VARCHAR2,
77 x_msg_count OUT NOCOPY NUMBER,
78 x_msg_data OUT NOCOPY VARCHAR2,
79 p_terminate_in_parameters_rec IN terminate_in_cle_rec);
80
81
82 END OKC_TERMINATE_PVT;