[Home] [Help]
PACKAGE: APPS.OKL_VP_TERMINATE_PVT
Source
1 PACKAGE OKL_VP_TERMINATE_PVT AUTHID CURRENT_USER AS
2 /*$Header: OKLRTERS.pls 115.3 2002/03/21 18:06:12 pkm ship $*/
3
4 TYPE terminate_header_rec_type IS RECORD (
5 p_id okc_k_headers_v.id%type,
6 p_current_end_date okc_k_headers_v.end_date%TYPE,
7 p_terminate_date okc_k_headers_v.DATE_TERMINATED%type,
8 p_term_reason okc_k_headers_v.TRN_CODE%TYPE);
9
10
11 G_PKG_NAME CONSTANT VARCHAR2(200) := 'okl_vp_terminate_pvt' ;
12 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
13
14 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
15 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
16 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
17 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
18 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
19 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKL_UPPER_CASE_REQUIRED';
20 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
21
22
23 PROCEDURE terminate_contract(p_api_version IN NUMBER,
24 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
25 x_return_status OUT NOCOPY VARCHAR2,
26 x_msg_count OUT NOCOPY NUMBER,
27 x_msg_data OUT NOCOPY VARCHAR2,
28 p_ter_header_rec IN terminate_header_rec_type);
29
30
31
32 END OKL_VP_TERMINATE_PVT;