[Home] [Help]
PACKAGE: APPS.OKL_TRX_ASSETS_PVT
Source
1 package OKL_TRX_ASSETS_PVT AUTHID CURRENT_USER as
2 /* $Header: OKLCTASS.pls 115.3 2002/02/05 11:50:21 pkm ship $ */
3
4 subtype tatv_rec_type is okl_tas_pvt.tas_rec_type;
5 subtype tatv_tbl_type is okl_tas_pvt.tas_tbl_type;
6 subtype tavv_rec_type is okl_tas_pvt.tasv_rec_type;
7 subtype tavv_tbl_type is okl_tas_pvt.tasv_tbl_type;
8 ---------------------------------------------------------------------------
9 -- GLOBAL MESSAGE CONSTANTS , VARIABLES
10 ---------------------------------------------------------------------------
11 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TRX_ASSEST_HEADER_PVT';
12 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
13 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
14 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
15
16 ----------------------------------------------------------------------------------
17 --Global Exception
18 ----------------------------------------------------------------------------------
19 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
20 ----------------------------------------------------------------------------------
21 --Public Procedures and Functions
22 ----------------------------------------------------------------------------------
23 -- PROCEDURE add_language;
24 PROCEDURE Create_trx_ass_h_def(
25 p_api_version IN NUMBER,
26 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_tasv_rec IN tavv_rec_type,
31 x_tasv_rec OUT NOCOPY tavv_rec_type);
32
33 PROCEDURE Create_trx_ass_h_def(
34 p_api_version IN NUMBER,
35 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
36 x_return_status OUT NOCOPY VARCHAR2,
37 x_msg_count OUT NOCOPY NUMBER,
38 x_msg_data OUT NOCOPY VARCHAR2,
39 p_tasv_tbl IN tavv_tbl_type,
40 x_tasv_tbl OUT NOCOPY tavv_tbl_type);
41
42 PROCEDURE lock_trx_ass_h_def(
43 p_api_version IN NUMBER,
44 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
45 x_return_status OUT NOCOPY VARCHAR2,
46 x_msg_count OUT NOCOPY NUMBER,
47 x_msg_data OUT NOCOPY VARCHAR2,
48 p_tasv_rec IN tavv_rec_type);
49
50 PROCEDURE lock_trx_ass_h_def(
51 p_api_version IN NUMBER,
52 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
53 x_return_status OUT NOCOPY VARCHAR2,
54 x_msg_count OUT NOCOPY NUMBER,
55 x_msg_data OUT NOCOPY VARCHAR2,
56 p_tasv_tbl IN tavv_tbl_type);
57
58 PROCEDURE update_trx_ass_h_def(
59 p_api_version IN NUMBER,
60 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
61 x_return_status OUT NOCOPY VARCHAR2,
62 x_msg_count OUT NOCOPY NUMBER,
63 x_msg_data OUT NOCOPY VARCHAR2,
64 p_tasv_rec IN tavv_rec_type,
65 x_tasv_rec OUT NOCOPY tavv_rec_type);
66
67 PROCEDURE update_trx_ass_h_def(
68 p_api_version IN NUMBER,
69 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
70 x_return_status OUT NOCOPY VARCHAR2,
71 x_msg_count OUT NOCOPY NUMBER,
72 x_msg_data OUT NOCOPY VARCHAR2,
73 p_tasv_tbl IN tavv_tbl_type,
74 x_tasv_tbl OUT NOCOPY tavv_tbl_type);
75
76 PROCEDURE delete_trx_ass_h_def(
77 p_api_version IN NUMBER,
78 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
79 x_return_status OUT NOCOPY VARCHAR2,
80 x_msg_count OUT NOCOPY NUMBER,
81 x_msg_data OUT NOCOPY VARCHAR2,
82 p_tasv_rec IN tavv_rec_type);
83
84 PROCEDURE delete_trx_ass_h_def(
85 p_api_version IN NUMBER,
86 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
87 x_return_status OUT NOCOPY VARCHAR2,
88 x_msg_count OUT NOCOPY NUMBER,
89 x_msg_data OUT NOCOPY VARCHAR2,
90 p_tasv_tbl IN tavv_tbl_type);
91
92 PROCEDURE validate_trx_ass_h_def(
93 p_api_version IN NUMBER,
94 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_tasv_rec IN tavv_rec_type);
99
100 PROCEDURE validate_trx_ass_h_def(
101 p_api_version IN NUMBER,
102 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
103 x_return_status OUT NOCOPY VARCHAR2,
104 x_msg_count OUT NOCOPY NUMBER,
105 x_msg_data OUT NOCOPY VARCHAR2,
106 p_tasv_tbl IN tavv_tbl_type);
107
108 END OKL_TRX_ASSETS_PVT;