1: PACKAGE okl_split_asset_pub As
2: /* $Header: OKLPSPAS.pls 120.3 2007/12/14 06:04:07 rpillay ship $ */
3:
4: subtype trxv_rec_type is OKL_SPLIT_ASSET_PVT.trxv_rec_type;
5: subtype txlv_rec_type is OKL_SPLIT_ASSET_PVT.txlv_rec_type;
6: subtype txdv_rec_type is OKL_SPLIT_ASSET_PVT.txdv_rec_type;
7: subtype txdv_tbl_type is OKL_SPLIT_ASSET_PVT.txdv_tbl_type;
8: subtype itiv_rec_type is OKL_SPLIT_ASSET_PVT.itiv_rec_type;
1: PACKAGE okl_split_asset_pub As
2: /* $Header: OKLPSPAS.pls 120.3 2007/12/14 06:04:07 rpillay ship $ */
3:
4: subtype trxv_rec_type is OKL_SPLIT_ASSET_PVT.trxv_rec_type;
5: subtype txlv_rec_type is OKL_SPLIT_ASSET_PVT.txlv_rec_type;
6: subtype txdv_rec_type is OKL_SPLIT_ASSET_PVT.txdv_rec_type;
7: subtype txdv_tbl_type is OKL_SPLIT_ASSET_PVT.txdv_tbl_type;
8: subtype itiv_rec_type is OKL_SPLIT_ASSET_PVT.itiv_rec_type;
9: subtype itiv_tbl_type is OKL_SPLIT_ASSET_PVT.itiv_tbl_type;
2: /* $Header: OKLPSPAS.pls 120.3 2007/12/14 06:04:07 rpillay ship $ */
3:
4: subtype trxv_rec_type is OKL_SPLIT_ASSET_PVT.trxv_rec_type;
5: subtype txlv_rec_type is OKL_SPLIT_ASSET_PVT.txlv_rec_type;
6: subtype txdv_rec_type is OKL_SPLIT_ASSET_PVT.txdv_rec_type;
7: subtype txdv_tbl_type is OKL_SPLIT_ASSET_PVT.txdv_tbl_type;
8: subtype itiv_rec_type is OKL_SPLIT_ASSET_PVT.itiv_rec_type;
9: subtype itiv_tbl_type is OKL_SPLIT_ASSET_PVT.itiv_tbl_type;
10: -- subtype cimv_rec_type is OKC_CONTRACT_ITEM_PUB.cimv_rec_type;
3:
4: subtype trxv_rec_type is OKL_SPLIT_ASSET_PVT.trxv_rec_type;
5: subtype txlv_rec_type is OKL_SPLIT_ASSET_PVT.txlv_rec_type;
6: subtype txdv_rec_type is OKL_SPLIT_ASSET_PVT.txdv_rec_type;
7: subtype txdv_tbl_type is OKL_SPLIT_ASSET_PVT.txdv_tbl_type;
8: subtype itiv_rec_type is OKL_SPLIT_ASSET_PVT.itiv_rec_type;
9: subtype itiv_tbl_type is OKL_SPLIT_ASSET_PVT.itiv_tbl_type;
10: -- subtype cimv_rec_type is OKC_CONTRACT_ITEM_PUB.cimv_rec_type;
11: subtype cimv_rec_type is OKL_SPLIT_ASSET_PVT.cimv_rec_type;
4: subtype trxv_rec_type is OKL_SPLIT_ASSET_PVT.trxv_rec_type;
5: subtype txlv_rec_type is OKL_SPLIT_ASSET_PVT.txlv_rec_type;
6: subtype txdv_rec_type is OKL_SPLIT_ASSET_PVT.txdv_rec_type;
7: subtype txdv_tbl_type is OKL_SPLIT_ASSET_PVT.txdv_tbl_type;
8: subtype itiv_rec_type is OKL_SPLIT_ASSET_PVT.itiv_rec_type;
9: subtype itiv_tbl_type is OKL_SPLIT_ASSET_PVT.itiv_tbl_type;
10: -- subtype cimv_rec_type is OKC_CONTRACT_ITEM_PUB.cimv_rec_type;
11: subtype cimv_rec_type is OKL_SPLIT_ASSET_PVT.cimv_rec_type;
12: subtype klev_rec_type is OKL_SPLIT_ASSET_PVT.klev_rec_type;
5: subtype txlv_rec_type is OKL_SPLIT_ASSET_PVT.txlv_rec_type;
6: subtype txdv_rec_type is OKL_SPLIT_ASSET_PVT.txdv_rec_type;
7: subtype txdv_tbl_type is OKL_SPLIT_ASSET_PVT.txdv_tbl_type;
8: subtype itiv_rec_type is OKL_SPLIT_ASSET_PVT.itiv_rec_type;
9: subtype itiv_tbl_type is OKL_SPLIT_ASSET_PVT.itiv_tbl_type;
10: -- subtype cimv_rec_type is OKC_CONTRACT_ITEM_PUB.cimv_rec_type;
11: subtype cimv_rec_type is OKL_SPLIT_ASSET_PVT.cimv_rec_type;
12: subtype klev_rec_type is OKL_SPLIT_ASSET_PVT.klev_rec_type;
13: -- subtype clev_rec_type is OKC_CONTRACT_PUB.clev_rec_type;
7: subtype txdv_tbl_type is OKL_SPLIT_ASSET_PVT.txdv_tbl_type;
8: subtype itiv_rec_type is OKL_SPLIT_ASSET_PVT.itiv_rec_type;
9: subtype itiv_tbl_type is OKL_SPLIT_ASSET_PVT.itiv_tbl_type;
10: -- subtype cimv_rec_type is OKC_CONTRACT_ITEM_PUB.cimv_rec_type;
11: subtype cimv_rec_type is OKL_SPLIT_ASSET_PVT.cimv_rec_type;
12: subtype klev_rec_type is OKL_SPLIT_ASSET_PVT.klev_rec_type;
13: -- subtype clev_rec_type is OKC_CONTRACT_PUB.clev_rec_type;
14: subtype clev_rec_type is OKL_SPLIT_ASSET_PVT.clev_rec_type;
15:
8: subtype itiv_rec_type is OKL_SPLIT_ASSET_PVT.itiv_rec_type;
9: subtype itiv_tbl_type is OKL_SPLIT_ASSET_PVT.itiv_tbl_type;
10: -- subtype cimv_rec_type is OKC_CONTRACT_ITEM_PUB.cimv_rec_type;
11: subtype cimv_rec_type is OKL_SPLIT_ASSET_PVT.cimv_rec_type;
12: subtype klev_rec_type is OKL_SPLIT_ASSET_PVT.klev_rec_type;
13: -- subtype clev_rec_type is OKC_CONTRACT_PUB.clev_rec_type;
14: subtype clev_rec_type is OKL_SPLIT_ASSET_PVT.clev_rec_type;
15:
16: subtype cle_rec_type is OKL_SPLIT_ASSET_PVT.cle_rec_type;
10: -- subtype cimv_rec_type is OKC_CONTRACT_ITEM_PUB.cimv_rec_type;
11: subtype cimv_rec_type is OKL_SPLIT_ASSET_PVT.cimv_rec_type;
12: subtype klev_rec_type is OKL_SPLIT_ASSET_PVT.klev_rec_type;
13: -- subtype clev_rec_type is OKC_CONTRACT_PUB.clev_rec_type;
14: subtype clev_rec_type is OKL_SPLIT_ASSET_PVT.clev_rec_type;
15:
16: subtype cle_rec_type is OKL_SPLIT_ASSET_PVT.cle_rec_type;
17: subtype cle_tbl_type is OKL_SPLIT_ASSET_PVT.cle_tbl_type;
18: subtype ast_line_rec_type is OKL_SPLIT_ASSET_PVT.ast_line_rec_type;
12: subtype klev_rec_type is OKL_SPLIT_ASSET_PVT.klev_rec_type;
13: -- subtype clev_rec_type is OKC_CONTRACT_PUB.clev_rec_type;
14: subtype clev_rec_type is OKL_SPLIT_ASSET_PVT.clev_rec_type;
15:
16: subtype cle_rec_type is OKL_SPLIT_ASSET_PVT.cle_rec_type;
17: subtype cle_tbl_type is OKL_SPLIT_ASSET_PVT.cle_tbl_type;
18: subtype ast_line_rec_type is OKL_SPLIT_ASSET_PVT.ast_line_rec_type;
19:
20: subtype ib_rec_type is OKL_SPLIT_ASSET_PVT.ib_rec_type;
13: -- subtype clev_rec_type is OKC_CONTRACT_PUB.clev_rec_type;
14: subtype clev_rec_type is OKL_SPLIT_ASSET_PVT.clev_rec_type;
15:
16: subtype cle_rec_type is OKL_SPLIT_ASSET_PVT.cle_rec_type;
17: subtype cle_tbl_type is OKL_SPLIT_ASSET_PVT.cle_tbl_type;
18: subtype ast_line_rec_type is OKL_SPLIT_ASSET_PVT.ast_line_rec_type;
19:
20: subtype ib_rec_type is OKL_SPLIT_ASSET_PVT.ib_rec_type;
21: subtype ib_tbl_type is OKL_SPLIT_ASSET_PVT.ib_tbl_type;
14: subtype clev_rec_type is OKL_SPLIT_ASSET_PVT.clev_rec_type;
15:
16: subtype cle_rec_type is OKL_SPLIT_ASSET_PVT.cle_rec_type;
17: subtype cle_tbl_type is OKL_SPLIT_ASSET_PVT.cle_tbl_type;
18: subtype ast_line_rec_type is OKL_SPLIT_ASSET_PVT.ast_line_rec_type;
19:
20: subtype ib_rec_type is OKL_SPLIT_ASSET_PVT.ib_rec_type;
21: subtype ib_tbl_type is OKL_SPLIT_ASSET_PVT.ib_tbl_type;
22:
16: subtype cle_rec_type is OKL_SPLIT_ASSET_PVT.cle_rec_type;
17: subtype cle_tbl_type is OKL_SPLIT_ASSET_PVT.cle_tbl_type;
18: subtype ast_line_rec_type is OKL_SPLIT_ASSET_PVT.ast_line_rec_type;
19:
20: subtype ib_rec_type is OKL_SPLIT_ASSET_PVT.ib_rec_type;
21: subtype ib_tbl_type is OKL_SPLIT_ASSET_PVT.ib_tbl_type;
22:
23: FUNCTION is_serialized(p_cle_id IN NUMBER) Return VARCHAR2;
24:
17: subtype cle_tbl_type is OKL_SPLIT_ASSET_PVT.cle_tbl_type;
18: subtype ast_line_rec_type is OKL_SPLIT_ASSET_PVT.ast_line_rec_type;
19:
20: subtype ib_rec_type is OKL_SPLIT_ASSET_PVT.ib_rec_type;
21: subtype ib_tbl_type is OKL_SPLIT_ASSET_PVT.ib_tbl_type;
22:
23: FUNCTION is_serialized(p_cle_id IN NUMBER) Return VARCHAR2;
24:
25: PROCEDURE Create_Split_Transaction(p_api_version IN NUMBER,