[Home] [Help]
PACKAGE: APPS.OKL_AM_ASSET_RETURN_PVT
Source
1 PACKAGE OKL_AM_ASSET_RETURN_PVT AS
2 /* $Header: OKLRARRS.pls 120.2 2005/10/30 04:31:46 appldev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL MESSAGE CONSTANTS
5 ---------------------------------------------------------------------------
6 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
7 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
8 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
9 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
10 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
11 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
12 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKC_NO_PARENT_RECORD';
13 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
14 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
15 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
16
17 ---------------------------------------------------------------------------
18 -- GLOBAL VARIABLES
19 ---------------------------------------------------------------------------
20 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AM_ASSET_RETURN_PVT';
21 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
22
23 ---------------------------------------------------------------------------
24 -- GLOBAL EXCEPTIONS
25 ---------------------------------------------------------------------------
26 G_EXCEPTION_INSURANCE_ERROR EXCEPTION;
27
28 ---------------------------------------------------------------------------
29 -- GLOBAL DATASTRUCTURES
30 ---------------------------------------------------------------------------
31 SUBTYPE artv_rec_type IS OKL_ART_PVT.artv_rec_type;
32 SUBTYPE artv_tbl_type IS OKL_ART_PVT.artv_tbl_type;
33
34 ---------------------------------------------------------------------------
35 -- PROCEDURES
36 ---------------------------------------------------------------------------
37 PROCEDURE create_asset_return(
38 p_api_version IN NUMBER,
39 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
40 x_return_status OUT NOCOPY VARCHAR2,
41 x_msg_count OUT NOCOPY NUMBER,
42 x_msg_data OUT NOCOPY VARCHAR2,
43 p_artv_rec IN artv_rec_type,
44 x_artv_rec OUT NOCOPY artv_rec_type,
45 p_quote_id IN NUMBER DEFAULT NULL);
46
47 PROCEDURE update_asset_return(
48 p_api_version IN NUMBER,
49 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
50 x_return_status OUT NOCOPY VARCHAR2,
51 x_msg_count OUT NOCOPY NUMBER,
52 x_msg_data OUT NOCOPY VARCHAR2,
53 p_artv_rec IN artv_rec_type,
54 x_artv_rec OUT NOCOPY artv_rec_type);
55
56 PROCEDURE create_asset_return(
57 p_api_version IN NUMBER,
58 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
59 x_return_status OUT NOCOPY VARCHAR2,
60 x_msg_count OUT NOCOPY NUMBER,
61 x_msg_data OUT NOCOPY VARCHAR2,
62 p_artv_tbl IN artv_tbl_type,
63 x_artv_tbl OUT NOCOPY artv_tbl_type,
64 p_quote_id IN NUMBER DEFAULT NULL);
65
66 PROCEDURE update_asset_return(
67 p_api_version IN NUMBER,
68 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
69 x_return_status OUT NOCOPY VARCHAR2,
70 x_msg_count OUT NOCOPY NUMBER,
71 x_msg_data OUT NOCOPY VARCHAR2,
72 p_artv_tbl IN artv_tbl_type,
73 x_artv_tbl OUT NOCOPY artv_tbl_type);
74
75
76 END OKL_AM_ASSET_RETURN_PVT;