[Home] [Help]
PACKAGE: APPS.OKL_TRANSFER_ASSUMPTION_PVT
Source
1 PACKAGE OKL_TRANSFER_ASSUMPTION_PVT AS
2 /* $Header: OKLRTNAS.pls 120.1 2005/10/30 03:17:31 appldev noship $ */
3 ----------------------------------------------------------------------------
4 -- GLOBAL VARIABLES
5 ----------------------------------------------------------------------------
6 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TRANSFER_ASSUMPTION_PVT';
7 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
8
9 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
10 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
11 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
12 G_EXCEPTION_ERROR EXCEPTION;
13 G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
14
15 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(30) := 'OKL_UNEXPECTED_ERROR';
16 G_SQLERRM_TOKEN CONSTANT VARCHAR2(30) := 'OKL_SQLERRM';
17 G_SQLCODE_TOKEN CONSTANT VARCHAR2(30) := 'OKL_SQLCODE';
18
19 G_EXC_NAME_OTHERS CONSTANT VARCHAR2(6) := 'OTHERS';
20 G_API_TYPE CONSTANT VARCHAR(4) := '_PVT';
21
22 G_INVALID_VALUE CONSTANT VARCHAR2(30) := OKL_API.G_INVALID_VALUE;
23 G_COL_NAME_TOKEN CONSTANT VARCHAR2(30) := OKL_API.G_COL_NAME_TOKEN;
24
25 ----------------------------------------------------------------------------
26 -- Data Structures
27 ----------------------------------------------------------------------------
28
29 ----------------------------------------------------------------------------
30 -- Global Exception
31 ----------------------------------------------------------------------------
32 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
33
34 ----------------------------------------------------------------------------
35 -- Procedures and Functions
36 ------------------------------------------------------------------------------
37 ----------------------------------------------------------------------------------
38 -- Start of comments
39 --
40 -- Procedure Name : update_full_tna_creditline
41 -- Description : Calculate total Transfers and Assumption amount based on
42 -- pass in contract ID and update correlated credit lines' tna amount
43 -- Business Rules :
44 -- Parameters :
45 -- Version : 1.0
46 -- End of comments
47 ----------------------------------------------------------------------------------
48 PROCEDURE update_full_tna_creditline(
49 p_api_version IN NUMBER
50 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_chr_id IN okc_k_headers_b.id%type
55 );
56
57 ----------------------------------------------------------------------------------
58 -- Start of comments
59 --
60 -- Procedure Name : update_partial_tna_creditline
61 -- Description : Calculate Transfers and Assumption amount for for the
62 -- source and destination contract's asset and update correlated
63 -- credit line's tna amount
64 -- Business Rules :
65 -- Parameters :
66 -- Version : 1.0
67 -- End of comments
68 ----------------------------------------------------------------------------------
69 PROCEDURE update_partial_tna_creditline(
70 p_api_version IN NUMBER
71 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
72 ,x_return_status OUT NOCOPY VARCHAR2
73 ,x_msg_count OUT NOCOPY NUMBER
74 ,x_msg_data OUT NOCOPY VARCHAR2
75 ,p_chr_id IN okc_k_headers_b.id%type
76 );
77
78
79 END OKL_TRANSFER_ASSUMPTION_PVT;