[Home] [Help]
PACKAGE: APPS.OKL_INS_CLAIM_ASSET_PVT
Source
1 PACKAGE OKL_INS_CLAIM_ASSET_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRCLAS.pls 120.2 2005/10/30 03:38:51 appldev noship $ */
3 subtype acdv_tbl_type is okl_acd_pvt.acdv_tbl_type;
4 subtype acnv_tbl_type is okl_acn_pvt.acnv_tbl_type;
5 subtype clmv_tbl_type is okl_clm_pvt.clmv_tbl_type;
6
7 TYPE stmid_rec_type IS RECORD (
8 ID NUMBER := OKL_API.G_MISS_NUM,
9 STATUS VARCHAR2(30) := OKL_API.G_MISS_CHAR
10 );
11
12 TYPE stmid_rec_type_tbl_type IS TABLE OF stmid_rec_type INDEX BY BINARY_INTEGER;
13
14 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
15 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME';
16 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := 'PARENT_TABLE';
17 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN; --3745151
18 G_VIEW CONSTANT VARCHAR2(200) := 'OKL_K_LINES_V';
19
20 G_HALT_EXCEPTION EXCEPTION;
21
22 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
23 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_INS_CLAIM_ASSETCNDNLNS_PVT';
24 ---------------------------------------------------------------------------
25 -- PROCEDURES
26 ---------------------------------------------------------------------------
27 PROCEDURE create_lease_claim(
28 p_api_version IN NUMBER,
29 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
30 x_return_status OUT NOCOPY VARCHAR2,
31 x_msg_count OUT NOCOPY NUMBER,
32 x_msg_data OUT NOCOPY VARCHAR2,
33 px_clmv_tbl IN OUT NOCOPY clmv_tbl_type,
34 px_acdv_tbl IN OUT NOCOPY acdv_tbl_type,
35 px_acnv_tbl IN OUT NOCOPY acnv_tbl_type
36 );
37
38 PROCEDURE hold_streams(
39 p_api_version IN NUMBER,
40 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
41 x_return_status OUT NOCOPY VARCHAR2,
42 x_msg_count OUT NOCOPY NUMBER,
43 x_msg_data OUT NOCOPY VARCHAR2,
44 p_lsm_id IN stmid_rec_type_tbl_type
45 );
46
47 END OKL_INS_CLAIM_ASSET_PVT;