[Home] [Help]
PACKAGE: APPS.OKL_TAX_TRX_DETAILS_PUB
Source
1 PACKAGE OKL_TAX_TRX_DETAILS_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPTTDS.pls 120.0 2005/08/26 19:51:45 sechawla noship $ */
3
4
5
6 SUBTYPE ttdv_rec_type IS okl_ttd_pvt.ttdv_rec_type;
7 SUBTYPE ttdv_tbl_type IS okl_ttd_pvt.ttdv_tbl_type;
8 ------------------------------------------------------------------------------
9 -- Global Variables
10 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TAX_TRX_DETAILS_PUB';
11 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
12 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
13 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
14 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
15 ------------------------------------------------------------------------------
16 --Global Exception
17 ------------------------------------------------------------------------------
18 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
19 ------------------------------------------------------------------------------
20
21
22 PROCEDURE insert_tax_trx_details(
23 p_api_version IN NUMBER,
24 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
25 x_return_status OUT NOCOPY VARCHAR2,
26 x_msg_count OUT NOCOPY NUMBER,
27 x_msg_data OUT NOCOPY VARCHAR2,
28 p_ttdv_rec IN ttdv_rec_type,
29 x_ttdv_rec OUT NOCOPY ttdv_rec_type);
30
31
32 PROCEDURE insert_tax_trx_details(
33 p_api_version IN NUMBER,
34 p_init_msg_list IN VARCHAR2 DEFAULT FND_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_ttdv_tbl IN ttdv_tbl_type,
39 x_ttdv_tbl OUT NOCOPY ttdv_tbl_type);
40
41 PROCEDURE lock_tax_trx_details(
42 p_api_version IN NUMBER,
43 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
44 x_return_status OUT NOCOPY VARCHAR2,
45 x_msg_count OUT NOCOPY NUMBER,
46 x_msg_data OUT NOCOPY VARCHAR2,
47 p_ttdv_rec IN ttdv_rec_type);
48
49
50 PROCEDURE lock_tax_trx_details(
51 p_api_version IN NUMBER,
52 p_init_msg_list IN VARCHAR2 DEFAULT FND_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_ttdv_tbl IN ttdv_tbl_type);
57
58 PROCEDURE update_tax_trx_details(
59 p_api_version IN NUMBER,
60 p_init_msg_list IN VARCHAR2 DEFAULT FND_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_ttdv_rec IN ttdv_rec_type,
65 x_ttdv_rec OUT NOCOPY ttdv_rec_type);
66
67
68 PROCEDURE update_tax_trx_details(
69 p_api_version IN NUMBER,
70 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
71 x_return_status OUT NOCOPY VARCHAR2,
72 x_msg_count OUT NOCOPY NUMBER,
73 x_msg_data OUT NOCOPY VARCHAR2,
74 p_ttdv_tbl IN ttdv_tbl_type,
75 x_ttdv_tbl OUT NOCOPY ttdv_tbl_type);
76
77 PROCEDURE delete_tax_trx_details(
78 p_api_version IN NUMBER,
79 p_init_msg_list IN VARCHAR2 DEFAULT FND_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_ttdv_rec IN ttdv_rec_type);
84
85
86 PROCEDURE delete_tax_trx_details(
87 p_api_version IN NUMBER,
88 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
89 x_return_status OUT NOCOPY VARCHAR2,
90 x_msg_count OUT NOCOPY NUMBER,
91 x_msg_data OUT NOCOPY VARCHAR2,
92 p_ttdv_tbl IN ttdv_tbl_type);
93
94 PROCEDURE validate_tax_trx_details(
95 p_api_version IN NUMBER,
96 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
97 x_return_status OUT NOCOPY VARCHAR2,
98 x_msg_count OUT NOCOPY NUMBER,
99 x_msg_data OUT NOCOPY VARCHAR2,
100 p_ttdv_rec IN ttdv_rec_type);
101
102
103 PROCEDURE validate_tax_trx_details(
104 p_api_version IN NUMBER,
105 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
106 x_return_status OUT NOCOPY VARCHAR2,
107 x_msg_count OUT NOCOPY NUMBER,
108 x_msg_data OUT NOCOPY VARCHAR2,
109 p_ttdv_tbl IN ttdv_tbl_type);
110
111 END OKL_TAX_TRX_DETAILS_PUB;