1 PACKAGE okl_ins_rates_pub AUTHID CURRENT_USER AS
2 /* $Header: OKLPINRS.pls 115.3 2002/02/05 12:06:28 pkm ship $ */
3
4
5 subtype inrv_rec_type is okl_inr_pvt.inrv_rec_type;
6 subtype inrv_tbl_type is okl_inr_pvt.inrv_tbl_type;
7 ------------------------------------------------------------------------------
8 -- Global Variables
9 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_INS_RATES_PUB';
10 G_APP_NAME CONSTANT VARCHAR2(3) := 'OKL';
11 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
12 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
13 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
14 ------------------------------------------------------------------------------
15 --Global Exception
16 ------------------------------------------------------------------------------
17 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
18 ------------------------------------------------------------------------------
19
20
21 PROCEDURE insert_ins_rates(
22 p_api_version IN NUMBER
23 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
24 ,x_return_status OUT NOCOPY VARCHAR2
25 ,x_msg_count OUT NOCOPY NUMBER
26 ,x_msg_data OUT NOCOPY VARCHAR2
27 ,p_inrv_tbl IN inrv_tbl_type
28 ,x_inrv_tbl OUT NOCOPY inrv_tbl_type);
29
30 PROCEDURE insert_ins_rates(
31 p_api_version IN NUMBER
32 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
33 ,x_return_status OUT NOCOPY VARCHAR2
34 ,x_msg_count OUT NOCOPY NUMBER
35 ,x_msg_data OUT NOCOPY VARCHAR2
36 ,p_inrv_rec IN inrv_rec_type
37 ,x_inrv_rec OUT NOCOPY inrv_rec_type);
38
39 PROCEDURE lock_ins_rates(
40 p_api_version IN NUMBER
41 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
42 ,x_return_status OUT NOCOPY VARCHAR2
43 ,x_msg_count OUT NOCOPY NUMBER
44 ,x_msg_data OUT NOCOPY VARCHAR2
45 ,p_inrv_tbl IN inrv_tbl_type);
46
47 PROCEDURE lock_ins_rates(
48 p_api_version IN NUMBER
49 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
50 ,x_return_status OUT NOCOPY VARCHAR2
51 ,x_msg_count OUT NOCOPY NUMBER
52 ,x_msg_data OUT NOCOPY VARCHAR2
53 ,p_inrv_rec IN inrv_rec_type);
54
55 PROCEDURE update_ins_rates(
56 p_api_version IN NUMBER
57 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
58 ,x_return_status OUT NOCOPY VARCHAR2
59 ,x_msg_count OUT NOCOPY NUMBER
60 ,x_msg_data OUT NOCOPY VARCHAR2
61 ,p_inrv_tbl IN inrv_tbl_type
62 ,x_inrv_tbl OUT NOCOPY inrv_tbl_type);
63
64 PROCEDURE update_ins_rates(
65 p_api_version IN NUMBER
66 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
67 ,x_return_status OUT NOCOPY VARCHAR2
68 ,x_msg_count OUT NOCOPY NUMBER
69 ,x_msg_data OUT NOCOPY VARCHAR2
70 ,p_inrv_rec IN inrv_rec_type
71 ,x_inrv_rec OUT NOCOPY inrv_rec_type);
72
73 PROCEDURE delete_ins_rates(
74 p_api_version IN NUMBER
75 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
76 ,x_return_status OUT NOCOPY VARCHAR2
77 ,x_msg_count OUT NOCOPY NUMBER
78 ,x_msg_data OUT NOCOPY VARCHAR2
79 ,p_inrv_tbl IN inrv_tbl_type);
80
81 PROCEDURE delete_ins_rates(
82 p_api_version IN NUMBER
83 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
84 ,x_return_status OUT NOCOPY VARCHAR2
85 ,x_msg_count OUT NOCOPY NUMBER
86 ,x_msg_data OUT NOCOPY VARCHAR2
87 ,p_inrv_rec IN inrv_rec_type);
88
89 PROCEDURE validate_ins_rates(
90 p_api_version IN NUMBER
91 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
92 ,x_return_status OUT NOCOPY VARCHAR2
93 ,x_msg_count OUT NOCOPY NUMBER
94 ,x_msg_data OUT NOCOPY VARCHAR2
95 ,p_inrv_tbl IN inrv_tbl_type);
96
97 PROCEDURE validate_ins_rates(
98 p_api_version IN NUMBER
99 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
100 ,x_return_status OUT NOCOPY VARCHAR2
101 ,x_msg_count OUT NOCOPY NUMBER
102 ,x_msg_data OUT NOCOPY VARCHAR2
103 ,p_inrv_rec IN inrv_rec_type);
104
105 END okl_ins_rates_pub;
[Home] [Help]