DBA Data[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;