[Home] [Help]
PACKAGE: APPS.OKL_SPLIT_ASSET_PUB
Source
1 PACKAGE okl_split_asset_pub AUTHID CURRENT_USER 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;
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;
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,
26 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
27 x_return_status OUT NOCOPY VARCHAR2,
28 x_msg_count OUT NOCOPY NUMBER,
29 x_msg_data OUT NOCOPY VARCHAR2,
30 p_cle_id IN NUMBER,
31 p_split_into_individuals_yn IN VARCHAR2,
32 p_split_into_units IN NUMBER,
33 p_ib_tbl IN ib_tbl_type,
34 x_txdv_tbl OUT NOCOPY txdv_tbl_type,
35 x_txlv_rec OUT NOCOPY txlv_rec_type,
36 x_trxv_rec OUT NOCOPY trxv_rec_type);
37
38 PROCEDURE Create_Split_Transaction(p_api_version IN NUMBER,
39 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_cle_id IN NUMBER,
44 p_split_into_individuals_yn IN VARCHAR2,
45 p_split_into_units IN NUMBER,
46 x_txdv_tbl OUT NOCOPY txdv_tbl_type,
47 x_txlv_rec OUT NOCOPY txlv_rec_type,
48 x_trxv_rec OUT NOCOPY trxv_rec_type);
49
50 ------------------------
51 --Bug# 3156924
52 ------------------------
53 Procedure validate_trx_date(p_api_version IN NUMBER,
54 p_init_msg_list IN VARCHAR2,
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_msg_data OUT NOCOPY VARCHAR2,
58 p_chr_id IN NUMBER,
59 p_trx_date IN VARCHAR2);
60
61 PROCEDURE Create_Split_Transaction(p_api_version IN NUMBER,
62 p_init_msg_list IN VARCHAR2,
63 x_return_status OUT NOCOPY VARCHAR2,
64 x_msg_count OUT NOCOPY NUMBER,
65 x_msg_data OUT NOCOPY VARCHAR2,
66 p_cle_id IN NUMBER,
67 p_split_into_individuals_yn IN VARCHAR2,
68 p_split_into_units IN NUMBER,
69 p_ib_tbl IN ib_tbl_type,
70 --Bug# 3156924
71 p_trx_date IN DATE,
72 --bug# 3156924
73 x_txdv_tbl OUT NOCOPY txdv_tbl_type,
74 x_txlv_rec OUT NOCOPY txlv_rec_type,
75 x_trxv_rec OUT NOCOPY trxv_rec_type);
76
77 PROCEDURE Create_Split_Transaction(p_api_version IN NUMBER,
78 p_init_msg_list IN VARCHAR2,
79 x_return_status OUT NOCOPY VARCHAR2,
80 x_msg_count OUT NOCOPY NUMBER,
81 x_msg_data OUT NOCOPY VARCHAR2,
82 p_cle_id IN NUMBER,
83 p_split_into_individuals_yn IN VARCHAR2,
84 p_split_into_units IN NUMBER,
85 p_trx_date IN DATE,
86 x_txdv_tbl OUT NOCOPY txdv_tbl_type,
87 x_txlv_rec OUT NOCOPY txlv_rec_type,
88 x_trxv_rec OUT NOCOPY trxv_rec_type);
89 ------------------------
90 --Bug# 3156924
91 ------------------------
92
93 Procedure Update_Split_Transaction(p_api_version IN NUMBER,
94 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
95 x_return_status OUT NOCOPY VARCHAR2,
96 x_msg_count OUT NOCOPY NUMBER,
97 x_msg_data OUT NOCOPY VARCHAR2,
98 p_cle_id IN NUMBER,
99 p_txdv_tbl IN txdv_tbl_type,
100 x_txdv_tbl OUT NOCOPY txdv_tbl_type);
101
102 PROCEDURE Split_Fixed_Asset(p_api_version IN NUMBER,
103 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
104 x_return_status OUT NOCOPY VARCHAR2,
105 x_msg_count OUT NOCOPY NUMBER,
106 x_msg_data OUT NOCOPY VARCHAR2,
107 p_txdv_tbl IN txdv_tbl_type,
108 p_txlv_rec IN txlv_rec_type,
109 x_cle_tbl OUT NOCOPY cle_tbl_type,
110 p_source_call IN VARCHAR2 DEFAULT 'UI');
111
112 Procedure Split_Fixed_Asset(p_api_version IN NUMBER,
113 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
114 x_return_status OUT NOCOPY VARCHAR2,
115 x_msg_count OUT NOCOPY NUMBER,
116 x_msg_data OUT NOCOPY VARCHAR2,
117 p_cle_id IN NUMBER,
118 x_cle_tbl OUT NOCOPY cle_tbl_type,
119 p_source_call IN VARCHAR2 DEFAULT 'UI');
120
121 Procedure Is_Inv_Item_Serialized(p_api_version IN NUMBER,
122 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
123 x_return_status OUT NOCOPY VARCHAR2,
124 x_msg_count OUT NOCOPY NUMBER,
125 x_msg_data OUT NOCOPY VARCHAR2,
126 p_inv_item_id IN NUMBER,
127 p_chr_id IN NUMBER,
128 p_cle_id IN NUMBER,
129 x_serialized OUT NOCOPY VARCHAR2);
130
131 Procedure Is_Asset_Serialized(p_api_version IN NUMBER,
132 p_init_msg_list IN VARCHAR2,
133 x_return_status OUT NOCOPY VARCHAR2,
134 x_msg_count OUT NOCOPY NUMBER,
135 x_msg_data OUT NOCOPY VARCHAR2,
136 p_cle_id IN NUMBER,
137 x_serialized OUT NOCOPY VARCHAR2);
138
139 Procedure Asset_Not_Srlz_Halt(p_api_version IN NUMBER,
140 p_init_msg_list IN VARCHAR2,
141 x_return_status OUT NOCOPY VARCHAR2,
142 x_msg_count OUT NOCOPY NUMBER,
143 x_msg_data OUT NOCOPY VARCHAR2,
144 p_cle_id IN NUMBER,
145 x_serialized OUT NOCOPY VARCHAR2);
146
147 Procedure Item_Not_Srlz_Halt(p_api_version IN NUMBER,
148 p_init_msg_list IN VARCHAR2,
149 x_return_status OUT NOCOPY VARCHAR2,
150 x_msg_count OUT NOCOPY NUMBER,
151 x_msg_data OUT NOCOPY VARCHAR2,
152 p_inv_item_id IN NUMBER,
153 p_chr_id IN NUMBER,
154 p_cle_id IN NUMBER,
155 x_serialized OUT NOCOPY VARCHAR2);
156
157 Procedure create_split_comp_srl_num(p_api_version IN NUMBER,
158 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
159 x_return_status OUT NOCOPY VARCHAR2,
160 x_msg_count OUT NOCOPY NUMBER,
161 x_msg_data OUT NOCOPY VARCHAR2,
162 p_itiv_tbl IN itiv_tbl_type,
163 x_itiv_tbl OUT NOCOPY itiv_tbl_type);
164
165 Procedure Cancel_Split_Asset_Trs
166 (p_api_version IN NUMBER,
167 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
168 x_return_status OUT NOCOPY VARCHAR2,
169 x_msg_count OUT NOCOPY NUMBER,
170 x_msg_data OUT NOCOPY VARCHAR2,
171 p_cle_id IN NUMBER);
172
173 END OKL_SPLIT_ASSET_PUB;