[Home] [Help]
PACKAGE: APPS.OKL_TRX_ASSETS_PUB
Source
1 PACKAGE OKL_TRX_ASSETS_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPTASS.pls 115.3 2002/02/04 19:07:11 pkm ship $ */
3
4 subtype thpv_rec_type is okl_trx_assets_pvt.tavv_rec_type;
5 subtype thpv_tbl_type is okl_trx_assets_pvt.tavv_tbl_type;
6
7
8 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
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_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
13 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
14 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
15 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
16
17 -- Global variables for user hooks
18 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TRX_ASSETS_PUB';
19 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
20 g_thpv_rec thpv_rec_type;
21 g_thpv_tbl thpv_tbl_type;
22
23
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_thpv_rec IN thpv_rec_type,
31 x_thpv_rec OUT NOCOPY thpv_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_thpv_tbl IN thpv_tbl_type,
40 x_thpv_tbl OUT NOCOPY thpv_tbl_type);
41
42
43 PROCEDURE update_trx_ass_h_def(
44 p_api_version IN NUMBER,
45 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
46 x_return_status OUT NOCOPY VARCHAR2,
47 x_msg_count OUT NOCOPY NUMBER,
48 x_msg_data OUT NOCOPY VARCHAR2,
49 p_thpv_rec IN thpv_rec_type,
50 x_thpv_rec OUT NOCOPY thpv_rec_type);
51
52 PROCEDURE update_trx_ass_h_def(
53 p_api_version IN NUMBER,
54 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_msg_data OUT NOCOPY VARCHAR2,
58 p_thpv_tbl IN thpv_tbl_type,
59 x_thpv_tbl OUT NOCOPY thpv_tbl_type);
60
61 PROCEDURE delete_trx_ass_h_def(
62 p_api_version IN NUMBER,
63 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
64 x_return_status OUT NOCOPY VARCHAR2,
65 x_msg_count OUT NOCOPY NUMBER,
66 x_msg_data OUT NOCOPY VARCHAR2,
67 p_thpv_rec IN thpv_rec_type);
68
69 PROCEDURE delete_trx_ass_h_def(
70 p_api_version IN NUMBER,
71 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
72 x_return_status OUT NOCOPY VARCHAR2,
73 x_msg_count OUT NOCOPY NUMBER,
74 x_msg_data OUT NOCOPY VARCHAR2,
75 p_thpv_tbl IN thpv_tbl_type);
76
77 PROCEDURE lock_trx_ass_h_def(
78 p_api_version IN NUMBER,
79 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
80 x_return_status OUT NOCOPY VARCHAR2,
81 x_msg_count OUT NOCOPY NUMBER,
82 x_msg_data OUT NOCOPY VARCHAR2,
83 p_thpv_rec IN thpv_rec_type);
84
85 procedure lock_trx_ass_h_def(
86 p_api_version IN NUMBER,
87 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
88 x_return_status OUT NOCOPY VARCHAR2,
89 x_msg_count OUT NOCOPY NUMBER,
90 x_msg_data OUT NOCOPY VARCHAR2,
91 p_thpv_tbl IN thpv_tbl_type);
92
93 PROCEDURE validate_trx_ass_h_def(
94 p_api_version IN NUMBER,
95 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
96 x_return_status OUT NOCOPY VARCHAR2,
97 x_msg_count OUT NOCOPY NUMBER,
98 x_msg_data OUT NOCOPY VARCHAR2,
99 p_thpv_rec IN thpv_rec_type);
100
101 procedure validate_trx_ass_h_def(
102 p_api_version IN NUMBER,
103 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_thpv_tbl IN thpv_tbl_type);
108
109
110 END OKL_TRX_ASSETS_PUB;