[Home] [Help]
PACKAGE: APPS.OKL_COPY_ASSET_PUB
Source
1 Package okl_copy_asset_pub AUTHID CURRENT_USER as
2 /* $Header: OKLPCALS.pls 115.4 2002/11/30 08:32:41 spillaip noship $ */
3
4 subtype klev_tbl_type is OKL_COPY_ASSET_PVT.klev_tbl_type;
5
6 g_from_cle_id OKC_K_LINES_V.CLE_ID%TYPE;
7 g_from_cle_id_tbl klev_tbl_type;
8 g_to_cle_id OKC_K_LINES_V.CLE_ID%TYPE;
9 g_to_chr_id OKC_K_LINES_V.CHR_ID%TYPE;
10 g_to_template_yn VARCHAR2(3);
11 g_copy_reference VARCHAR2(30);
12 g_copy_line_party_yn VARCHAR2(3);
13 g_renew_ref_yn VARCHAR2(3);
14
15
16 Procedure copy_asset_lines(
17 p_api_version IN NUMBER,
18 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
19 x_return_status OUT NOCOPY VARCHAR2,
20 x_msg_count OUT NOCOPY NUMBER,
21 x_msg_data OUT NOCOPY VARCHAR2,
22 P_from_cle_id IN NUMBER,
23 p_to_cle_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
24 p_to_chr_id IN NUMBER,
25 p_to_template_yn IN VARCHAR2,
26 p_copy_reference IN VARCHAR2,
27 p_copy_line_party_yn IN VARCHAR2,
28 p_renew_ref_yn IN VARCHAR2,
29 p_trans_type IN VARCHAR2,
30 x_cle_id OUT NOCOPY NUMBER);
31
32 Procedure copy_asset_lines(
33 p_api_version IN NUMBER,
34 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
35 x_return_status OUT NOCOPY VARCHAR2,
36 x_msg_count OUT NOCOPY NUMBER,
37 x_msg_data OUT NOCOPY VARCHAR2,
38 p_from_cle_id_tbl IN klev_tbl_type,
39 p_to_cle_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
40 p_to_chr_id IN NUMBER,
41 p_to_template_yn IN VARCHAR2,
42 p_copy_reference IN VARCHAR2,
43 p_copy_line_party_yn IN VARCHAR2,
44 p_renew_ref_yn IN VARCHAR2,
45 p_trans_type IN VARCHAR2,
46 x_cle_id_tbl OUT NOCOPY klev_tbl_type);
47
48 Procedure copy_all_lines(
49 p_api_version IN NUMBER,
50 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
51 x_return_status OUT NOCOPY VARCHAR2,
52 x_msg_count OUT NOCOPY NUMBER,
53 x_msg_data OUT NOCOPY VARCHAR2,
54 p_from_cle_id_tbl IN klev_tbl_type,
55 p_to_cle_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
56 p_to_chr_id IN NUMBER,
57 p_to_template_yn IN VARCHAR2,
58 p_copy_reference IN VARCHAR2,
59 p_copy_line_party_yn IN VARCHAR2,
60 p_renew_ref_yn IN VARCHAR2,
61 p_trans_type IN VARCHAR2,
62 x_cle_id_tbl OUT NOCOPY klev_tbl_type);
63
64 End okl_copy_asset_pub;