[Home] [Help]
PACKAGE: APPS.OKL_SEC_INVESTOR_REVENUE_PVT
Source
1 PACKAGE Okl_Sec_Investor_Revenue_Pvt AS
2 /* $Header: OKLRSZRS.pls 120.2 2005/10/30 04:38:37 appldev noship $ */
3
4 TYPE szr_rec_type IS RECORD (
5 id NUMBER := OKC_API.G_MISS_NUM
6 ,top_line_id NUMBER := OKC_API.G_MISS_NUM
7 -- mvasudev, 10/12/2004, Bug#3909240
8 -- ,kle_sty_id NUMBER := OKL_API.G_MISS_NUM
9 ,kle_sty_subclass OKL_K_LINES.STREAM_TYPE_SUBCLASS%TYPE := OKC_API.G_MISS_CHAR
10 -- END,mvasudev, 10/12/2004, Bug#3909240
11 ,kle_percent_stake NUMBER := OKL_API.G_MISS_NUM
12 ,dnz_chr_id NUMBER := OKL_API.G_MISS_NUM
13 ,kle_amount_stake NUMBER := OKL_API.G_MISS_NUM
14 ,cle_lse_id NUMBER := OKC_API.G_MISS_NUM
15 ,cle_date_terminated OKC_K_LINES_V.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE
16 ,cle_start_date OKC_K_LINES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
17 ,cle_end_date OKC_K_LINES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
18 ,cle_currency_code OKC_K_LINES_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
19 ,cle_sts_code OKC_K_LINES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
20 );
21
22 ---------------------------------------------------------------------------
23 -- GLOBAL MESSAGE CONSTANTS
24 ---------------------------------------------------------------------------
25
26
27 ---------------------------------------------------------------------------
28 -- GLOBAL CONSTANTS
29 ---------------------------------------------------------------------------
30 G_APP_NAME CONSTANT VARCHAR2(3) := 'OKL';
31 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_SEC_INVESTOR_REVENUE_PVT';
32 G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
33 G_API_VERSION CONSTANT NUMBER := 1;
34 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
35 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
36 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
37 G_COMMIT CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
38 G_INIT_MSG_LIST CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
39 G_VALIDATION_LEVEL CONSTANT NUMBER := FND_API.G_VALID_LEVEL_FULL;
40
41 -- Global Variables
42 G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
43 G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
44 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
45 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
46 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
47
48 G_EXCEPTION_HALT_PROCESSING EXCEPTION;
49 G_EXCEPTION_ERROR EXCEPTION;
50 G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
51
52 G_AK_REGION_NAME VARCHAR2(25) := 'OKL_LA_INV_REVENUE_SHARE';
53
54 TYPE szr_tbl_type IS TABLE OF szr_rec_type INDEX BY BINARY_INTEGER;
55
56 SUBTYPE clev_rec_type IS OKL_OKC_MIGRATION_PVT.clev_rec_type;
57 SUBTYPE klev_rec_type IS OKL_CONTRACT_PUB.klev_rec_type;
58
59 PROCEDURE create_investor_revenue(p_api_version IN NUMBER,
60 p_init_msg_list IN VARCHAR2,
61 x_return_status OUT NOCOPY VARCHAR2,
62 x_msg_count OUT NOCOPY NUMBER,
63 x_msg_data OUT NOCOPY VARCHAR2,
64 p_szr_rec IN szr_rec_type,
65 x_szr_rec OUT NOCOPY szr_rec_type);
66
67 PROCEDURE update_investor_revenue(p_api_version IN NUMBER,
68 p_init_msg_list IN VARCHAR2,
69 x_return_status OUT NOCOPY VARCHAR2,
70 x_msg_count OUT NOCOPY NUMBER,
71 x_msg_data OUT NOCOPY VARCHAR2,
72 p_szr_rec IN szr_rec_type,
73 x_szr_rec OUT NOCOPY szr_rec_type);
74
75 PROCEDURE delete_investor_revenue(p_api_version IN NUMBER,
76 p_init_msg_list IN VARCHAR2,
77 x_return_status OUT NOCOPY VARCHAR2,
78 x_msg_count OUT NOCOPY NUMBER,
79 x_msg_data OUT NOCOPY VARCHAR2,
80 p_szr_rec IN szr_rec_type);
81
82 PROCEDURE create_investor_revenue(p_api_version IN NUMBER,
83 p_init_msg_list IN VARCHAR2,
84 x_return_status OUT NOCOPY VARCHAR2,
85 x_msg_count OUT NOCOPY NUMBER,
86 x_msg_data OUT NOCOPY VARCHAR2,
87 p_szr_tbl IN szr_tbl_type,
88 x_szr_tbl OUT NOCOPY szr_tbl_type);
89
90 PROCEDURE update_investor_revenue(p_api_version IN NUMBER,
91 p_init_msg_list IN VARCHAR2,
92 x_return_status OUT NOCOPY VARCHAR2,
93 x_msg_count OUT NOCOPY NUMBER,
94 x_msg_data OUT NOCOPY VARCHAR2,
95 p_szr_tbl IN szr_tbl_type,
96 x_szr_tbl OUT NOCOPY szr_tbl_type);
97
98 PROCEDURE delete_investor_revenue(p_api_version IN NUMBER,
99 p_init_msg_list IN VARCHAR2,
100 x_return_status OUT NOCOPY VARCHAR2,
101 x_msg_count OUT NOCOPY NUMBER,
102 x_msg_data OUT NOCOPY VARCHAR2,
103 p_szr_tbl IN szr_tbl_type);
104
105 END Okl_Sec_Investor_Revenue_Pvt;