[Home] [Help]
PACKAGE: APPS.OKL_SEC_INVESTOR_PVT
Source
1 PACKAGE OKL_SEC_INVESTOR_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRSZIS.pls 115.5 2003/10/22 23:14:11 ashariff noship $ */
3 /* *************************************** */
4
5 TYPE inv_rec_type IS RECORD (
6 cpl_id NUMBER := OKC_API.G_MISS_NUM,
7 cpl_cpl_id NUMBER := OKC_API.G_MISS_NUM,
8 cpl_chr_id NUMBER := OKC_API.G_MISS_NUM,
9 cpl_cle_id NUMBER := OKC_API.G_MISS_NUM,
10 cpl_rle_code OKC_K_PARTY_ROLES_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
11 cpl_dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
12 cpl_object1_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
13 cpl_object1_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
14 cpl_jtot_object1_code OKC_K_PARTY_ROLES_V.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
15 cle_id NUMBER := OKC_API.G_MISS_NUM,
16 cle_lse_id NUMBER := OKC_API.G_MISS_NUM,
17 cle_line_number OKC_K_LINES_V.LINE_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
18 cle_sts_code OKC_K_LINES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
19 cle_comments OKC_K_LINES_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
20 cle_date_terminated OKC_K_LINES_V.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
21 cle_start_date OKC_K_LINES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
22 cle_end_date OKC_K_LINES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
23 KLE_ID NUMBER := OKL_API.G_MISS_NUM,
24 KLE_PERCENT_STAKE NUMBER := OKL_API.G_MISS_NUM,
25 KLE_PERCENT NUMBER := OKL_API.G_MISS_NUM,
26 KLE_EVERGREEN_PERCENT NUMBER := OKL_API.G_MISS_NUM,
27 KLE_AMOUNT_STAKE NUMBER := OKL_API.G_MISS_NUM,
28 KLE_DATE_SOLD OKL_K_LINES.DATE_SOLD%TYPE := OKL_API.G_MISS_DATE,
29 KLE_DELIVERED_DATE OKL_K_LINES.DELIVERED_DATE%TYPE := OKL_API.G_MISS_DATE,
30 KLE_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
31 KLE_DATE_FUNDING OKL_K_LINES.DATE_FUNDING%TYPE := OKL_API.G_MISS_DATE,
32 KLE_DATE_FUNDING_REQUIRED OKL_K_LINES.DATE_FUNDING_REQUIRED%TYPE := OKL_API.G_MISS_DATE,
33 KLE_DATE_ACCEPTED OKL_K_LINES.DATE_ACCEPTED%TYPE := OKL_API.G_MISS_DATE,
34 KLE_DATE_DELIVERY_EXPECTED OKL_K_LINES.DATE_DELIVERY_EXPECTED%TYPE := OKL_API.G_MISS_DATE,
35 KLE_CAPITAL_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
36 NAME OKX_PARTIES_V.NAME%TYPE := OKL_API.G_MISS_CHAR,
37 DESCRIPTION OKX_PARTIES_V.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
38 DATE_PAY_INVESTOR_START OKL_K_LINES_V.DATE_PAY_INVESTOR_START%TYPE := OKL_API.G_MISS_DATE,
39 PAY_INVESTOR_FREQUENCY OKL_K_LINES_V.PAY_INVESTOR_FREQUENCY%TYPE := OKL_API.G_MISS_CHAR,
40 PAY_INVESTOR_EVENT OKL_K_LINES_V.PAY_INVESTOR_EVENT%TYPE := OKL_API.G_MISS_CHAR,
41 PAY_INVESTOR_REMITTANCE_DAYS NUMBER := OKL_API.G_MISS_NUM,
42 START_DATE OKC_K_LINES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
43 BILL_TO_SITE_USE_ID NUMBER := OKL_API.G_MISS_NUM,
44 CUST_ACCT_ID NUMBER := OKL_API.G_MISS_NUM);
45
46
47 TYPE inv_tbl_type IS TABLE OF inv_rec_type INDEX BY BINARY_INTEGER;
48
49
50 subtype clev_rec_type is OKL_OKC_MIGRATION_PVT.clev_rec_type;
51 subtype clev_tbl_type is OKL_OKC_MIGRATION_PVT.clev_tbl_type;
52
53 subtype klev_rec_type is OKL_CONTRACT_PUB.klev_rec_type;
54 subtype cplv_rec_type is OKL_OKC_MIGRATION_PVT.cplv_rec_type;
55
56 TYPE hdr_tbl_type IS TABLE OF VARCHAR2(256) INDEX BY BINARY_INTEGER;
57
58 G_TOPLINE_LTY_CODE varchar2(10) := 'INVESTMENT';
59 G_INVESTOR_RLE_CODE varchar2(8) := 'INVESTOR';
60 G_INVESTOR_OBJECT_CODE varchar2(9) := 'OKX_PARTY';
61 G_AK_REGION_NAME varchar2(19) := 'OKL_LA_SEC_INVESTOR';
62
63
64
65 PROCEDURE create_investor(
66 p_api_version IN NUMBER,
67 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
68 x_return_status OUT NOCOPY VARCHAR2,
69 x_msg_count OUT NOCOPY NUMBER,
70 x_msg_data OUT NOCOPY VARCHAR2,
71 p_inv_tbl IN inv_tbl_type,
72 x_inv_tbl OUT NOCOPY inv_tbl_type);
73
74
75 PROCEDURE update_investor(
76 p_api_version IN NUMBER,
77 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
78 x_return_status OUT NOCOPY VARCHAR2,
79 x_msg_count OUT NOCOPY NUMBER,
80 x_msg_data OUT NOCOPY VARCHAR2,
81 p_inv_tbl IN inv_tbl_type,
82 x_inv_tbl OUT NOCOPY inv_tbl_type);
83
84 PROCEDURE delete_investor(
85 p_api_version IN NUMBER,
86 p_init_msg_list IN VARCHAR2,
87 x_return_status OUT NOCOPY VARCHAR2,
88 x_msg_count OUT NOCOPY NUMBER,
89 x_msg_data OUT NOCOPY VARCHAR2,
90 p_inv_tbl IN inv_tbl_type);
91
92 END OKL_SEC_INVESTOR_PVT;