DBA Data[Home] [Help]

APPS.OKL_SEC_INVESTOR_PVT dependencies on OKC_API

Line 6: cpl_id NUMBER := OKC_API.G_MISS_NUM,

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,

Line 7: cpl_cpl_id NUMBER := OKC_API.G_MISS_NUM,

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,

Line 8: cpl_chr_id NUMBER := OKC_API.G_MISS_NUM,

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,

Line 9: cpl_cle_id NUMBER := OKC_API.G_MISS_NUM,

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,

Line 10: cpl_rle_code OKC_K_PARTY_ROLES_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 11: cpl_dnz_chr_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,

Line 12: cpl_object1_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 13: cpl_object1_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 14: cpl_jtot_object1_code OKC_K_PARTY_ROLES_V.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 15: cle_id NUMBER := OKC_API.G_MISS_NUM,

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,

Line 16: cle_lse_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,

Line 17: cle_line_number OKC_K_LINES_V.LINE_NUMBER%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,

Line 18: cle_sts_code OKC_K_LINES_V.STS_CODE%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,

Line 19: cle_comments OKC_K_LINES_V.COMMENTS%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,

Line 20: cle_date_terminated OKC_K_LINES_V.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,

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,

Line 21: cle_start_date OKC_K_LINES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,

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,

Line 22: cle_end_date OKC_K_LINES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,

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,

Line 42: START_DATE OKC_K_LINES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,

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:

Line 67: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 77: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,