[Home] [Help]
PACKAGE: APPS.OKL_LEASE_RATE_FACTORS_PVT
Source
1 PACKAGE okl_lease_rate_factors_pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLRLRFS.pls 120.1 2005/09/30 11:00:47 asawanka noship $ */
3
4 -----------------------------------------------------------------------------
5 -- PACKAGE SPECIFIC CONSTANTS
6 -----------------------------------------------------------------------------
7
8 g_pkg_name CONSTANT varchar2(30) := 'okl_lease_rate_factors_pvt';
9 g_api_type CONSTANT varchar2(4) := '_PUB';
10
11 -----------------------------------------------------------------------------
12 -- APPLICATION GLOBAL CONSTANTS
13 -----------------------------------------------------------------------------
14
15 g_app_name CONSTANT varchar2(3) := okl_api.g_app_name;
16 g_api_version CONSTANT number := 1;
17 g_false CONSTANT varchar2(1) := fnd_api.g_false;
18 g_true CONSTANT varchar2(1) := fnd_api.g_true;
19 g_db_error CONSTANT varchar2(12) := 'OKL_DB_ERROR';
20 g_prog_name_token CONSTANT varchar2(9) := 'PROG_NAME';
21 g_sqlcode_token CONSTANT varchar2(7) := 'SQLCODE';
22 g_sqlerrm_token CONSTANT varchar2(7) := 'SQLERRM';
23 g_ret_sts_success CONSTANT varchar2(1) := fnd_api.g_ret_sts_success;
24 g_ret_sts_unexp_error CONSTANT varchar2(1) := fnd_api.g_ret_sts_unexp_error;
25 g_ret_sts_error CONSTANT varchar2(1) := fnd_api.g_ret_sts_error;
26 g_miss_char CONSTANT varchar2(1) := fnd_api.g_miss_char;
27
28 ---------------------------------------------------------------------------
29 -- DATA STRUCTURES
30 ---------------------------------------------------------------------------
31
32 SUBTYPE lrtv_rec_type IS okl_lrt_pvt.lrtv_rec_type;
33
34 SUBTYPE okl_lrvv_rec IS okl_lrv_pvt.okl_lrvv_rec;
35
36 SUBTYPE lrfv_rec_type IS okl_lrf_pvt.lrfv_rec_type;
37
38 SUBTYPE lrfv_tbl_type IS okl_lrf_pvt.lrfv_tbl_type;
39
40 SUBTYPE okl_lrlv_tbl IS okl_lrl_pvt.okl_lrlv_tbl;
41
42 SUBTYPE okl_lrlv_rec IS okl_lrl_pvt.okl_lrlv_rec;
43
44 ---------------------------------------------------------------------------
45 -- PROGRAM UNITS
46 ---------------------------------------------------------------------------
47
48 PROCEDURE handle_lrf_ents(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_lrfv_tbl IN lrfv_tbl_type
54 ,x_lrfv_tbl OUT NOCOPY lrfv_tbl_type
55 ,p_lrlv_tbl IN okl_lrlv_tbl
56 ,x_lrlv_tbl OUT NOCOPY okl_lrlv_tbl);
57
58 PROCEDURE delete_lease_rate_factors(p_api_version IN number
59 ,p_init_msg_list IN varchar2 DEFAULT fnd_api.g_false
60 ,x_return_status OUT NOCOPY varchar2
61 ,x_msg_count OUT NOCOPY number
62 ,x_msg_data OUT NOCOPY varchar2
63 ,p_lrv_id IN number);
64
65 PROCEDURE remove_lrs_factor (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_lrfv_rec IN lrfv_rec_type);
71
72 PROCEDURE remove_lrs_level(p_api_version IN number
73 ,p_init_msg_list IN varchar2 DEFAULT fnd_api.g_false
74 ,x_return_status OUT NOCOPY varchar2
75 ,x_msg_count OUT NOCOPY number
76 ,x_msg_data OUT NOCOPY varchar2
77 ,p_lrlv_rec IN okl_lrlv_rec);
78
79 PROCEDURE handle_lease_rate_factors(p_api_version IN number
80 ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
81 ,x_return_status OUT NOCOPY varchar2
82 ,x_msg_count OUT NOCOPY number
83 ,x_msg_data OUT NOCOPY varchar2
84 ,p_lrtv_rec IN lrtv_rec_type
85 ,p_lrvv_rec IN okl_lrvv_rec
86 ,p_lrfv_tbl IN lrfv_tbl_type
87 ,x_lrfv_tbl OUT NOCOPY lrfv_tbl_type
88 ,p_lrlv_tbl IN okl_lrlv_tbl
89 ,x_lrlv_tbl OUT NOCOPY okl_lrlv_tbl);
90
91 PROCEDURE handle_lrf_submit(p_api_version IN number
92 ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
93 ,x_return_status OUT NOCOPY varchar2
94 ,x_msg_count OUT NOCOPY number
95 ,x_msg_data OUT NOCOPY varchar2
96 ,p_lrtv_rec IN lrtv_rec_type
97 ,p_lrvv_rec IN okl_lrvv_rec
98 ,p_lrfv_tbl IN lrfv_tbl_type
99 ,x_lrfv_tbl OUT NOCOPY lrfv_tbl_type
100 ,p_lrlv_tbl IN okl_lrlv_tbl
101 ,x_lrlv_tbl OUT NOCOPY okl_lrlv_tbl);
102
103 FUNCTION get_rate_from_srt(p_srt_version_id IN number
104 ,p_lrs_eff_from IN date) RETURN number;
105
106 END okl_lease_rate_factors_pvt;