[Home] [Help]
PACKAGE: APPS.OKL_LA_TRADEIN_PVT
Source
1 PACKAGE OKL_LA_TRADEIN_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRTRIS.pls 120.2 2006/09/11 23:20:54 smereddy noship $ */
3
4 -- GLOBAL VARIABLES
5 ---------------------------------------------------------------------------
6 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_LA_TRADEIN_PVT';
7 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
8 G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
9 G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
10 G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
11 ---------------------------------------------------------------------------
12 -----------------------------------------------------------------------------
13 -- APPLICATION GLOBAL CONSTANTS
14 -----------------------------------------------------------------------------
15 G_API_VERSION CONSTANT NUMBER := 1;
16 G_DB_ERROR CONSTANT VARCHAR2(12) := 'OKL_DB_ERROR';
17 G_PROG_NAME_TOKEN CONSTANT VARCHAR2(9) := 'PROG_NAME';
18 G_SQLCODE_TOKEN CONSTANT VARCHAR2(7) := 'SQLCODE';
19 G_SQLERRM_TOKEN CONSTANT VARCHAR2(7) := 'SQLERRM';
20 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
21 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
22 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
23
24
25 TYPE tradein_rec_type is record
26 (
27 id okc_k_lines_b.id%type,
28 asset_id okc_k_lines_b.id%type,
29 asset_number OKC_K_LINES_TL.name%type,
30 tradein_amount okl_k_lines.tradein_amount%type
31 );
32 TYPE tradein_tbl_type is table of tradein_rec_type INDEX BY BINARY_INTEGER;
33
34 TYPE asset_rec_type IS RECORD ( fin_asset_id NUMBER,
35 amount NUMBER,
36 asset_number VARCHAR2(15));
37
38 TYPE asset_tbl_type IS TABLE OF asset_rec_type INDEX BY BINARY_INTEGER;
39
40 TYPE cle_id_rec_type IS RECORD (cle_id NUMBER);
41
42 TYPE cle_id_tbl_type IS TABLE OF cle_id_rec_type INDEX BY BINARY_INTEGER;
43
44 TYPE link_asset_rec_type IS RECORD (link_line_id NUMBER,
45 link_item_id NUMBER,
46 fin_asset_id NUMBER,
47 amount NUMBER,
48 asset_number VARCHAR2(15));
49
50 TYPE link_asset_tbl_type IS TABLE OF link_asset_rec_type INDEX BY BINARY_INTEGER;
51
52 PROCEDURE create_tradein(
53 p_api_version IN NUMBER,
54 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_msg_data OUT NOCOPY VARCHAR2,
58 p_chr_id IN okl_k_headers.id%TYPE,
59 p_tradein_rec IN tradein_rec_type,
60 x_tradein_rec OUT NOCOPY tradein_rec_type
61 );
62
63 PROCEDURE create_tradein(
64 p_api_version IN NUMBER,
65 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
66 x_return_status OUT NOCOPY VARCHAR2,
67 x_msg_count OUT NOCOPY NUMBER,
68 x_msg_data OUT NOCOPY VARCHAR2,
69 p_chr_id IN okl_k_headers.id%TYPE,
70 p_tradein_tbl IN tradein_tbl_type,
71 x_tradein_tbl OUT NOCOPY tradein_tbl_type
72 );
73
74 PROCEDURE delete_tradein(
75 p_api_version IN NUMBER,
76 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
77 x_return_status OUT NOCOPY VARCHAR2,
78 x_msg_count OUT NOCOPY NUMBER,
79 x_msg_data OUT NOCOPY VARCHAR2,
80 p_chr_id IN okl_k_headers.id%TYPE,
81 p_tradein_rec IN tradein_rec_type,
82 x_tradein_rec OUT NOCOPY tradein_rec_type
83 );
84
85 PROCEDURE delete_tradein(
86 p_api_version IN NUMBER,
87 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
88 x_return_status OUT NOCOPY VARCHAR2,
89 x_msg_count OUT NOCOPY NUMBER,
90 x_msg_data OUT NOCOPY VARCHAR2,
91 p_chr_id IN okl_k_headers.id%TYPE,
92 p_tradein_tbl IN tradein_tbl_type,
93 x_tradein_tbl OUT NOCOPY tradein_tbl_type
94 );
95
96 PROCEDURE update_contract(
97 p_api_version IN NUMBER,
98 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
99 x_return_status OUT NOCOPY VARCHAR2,
100 x_msg_count OUT NOCOPY NUMBER,
101 x_msg_data OUT NOCOPY VARCHAR2,
102 p_chr_id IN okl_k_headers.id%TYPE,
103 p_tradein_date IN okl_k_headers.DATE_TRADEIN%TYPE,
104 p_tradein_amount IN okl_k_headers.tradein_amount%TYPE,
105 p_tradein_desc IN okl_k_headers.tradein_description%TYPE
106 );
107
108 PROCEDURE allocate_amount(p_api_version IN NUMBER,
109 p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE,
110 p_transaction_control IN VARCHAR2 DEFAULT G_TRUE,
111 p_cle_id IN NUMBER,
112 p_chr_id IN NUMBER,
113 p_capitalize_yn IN VARCHAR2,
114 x_cle_id OUT NOCOPY NUMBER,
115 x_chr_id OUT NOCOPY NUMBER,
116 x_return_status OUT NOCOPY VARCHAR2,
117 x_msg_count OUT NOCOPY NUMBER,
118 x_msg_data OUT NOCOPY VARCHAR2);
119
120
121 PROCEDURE allocate_amount_tradein (
122 p_api_version IN NUMBER,
123 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
124 x_return_status OUT NOCOPY VARCHAR2,
125 x_msg_count OUT NOCOPY NUMBER,
126 x_msg_data OUT NOCOPY VARCHAR2,
127 p_chr_id IN NUMBER,
128 p_derive_assoc_amt IN VARCHAR2
129 );
130
131 PROCEDURE delete_contract(
132 p_api_version IN NUMBER,
133 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
134 x_return_status OUT NOCOPY VARCHAR2,
135 x_msg_count OUT NOCOPY NUMBER,
136 x_msg_data OUT NOCOPY VARCHAR2,
137 p_chr_id IN okl_k_headers.id%TYPE
138 );
139
140 END OKL_LA_TRADEIN_PVT;