[Home] [Help]
PACKAGE: APPS.OKL_CASH_FLOW_LEVELS_PUB
Source
1 PACKAGE OKL_CASH_FLOW_LEVELS_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPCFLS.pls 115.0 2003/10/16 01:55:34 sechawla noship $ */
3
4
5
6 SUBTYPE cflv_rec_type IS okl_cfl_pvt.cflv_rec_type;
7 SUBTYPE cflv_tbl_type IS okl_cfl_pvt.cflv_tbl_type;
8 ------------------------------------------------------------------------------
9 -- Global Variables
10 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CASH_FLOW_LEVELS_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_cash_flow_level(
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_cflv_rec IN cflv_rec_type,
29 x_cflv_rec OUT NOCOPY cflv_rec_type);
30
31
32 PROCEDURE insert_cash_flow_level(
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_cflv_tbl IN cflv_tbl_type,
39 x_cflv_tbl OUT NOCOPY cflv_tbl_type);
40
41 PROCEDURE lock_cash_flow_level(
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_cflv_rec IN cflv_rec_type);
48
49
50 PROCEDURE lock_cash_flow_level(
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_cflv_tbl IN cflv_tbl_type);
57
58 PROCEDURE update_cash_flow_level(
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_cflv_rec IN cflv_rec_type,
65 x_cflv_rec OUT NOCOPY cflv_rec_type);
66
67
68 PROCEDURE update_cash_flow_level(
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_cflv_tbl IN cflv_tbl_type,
75 x_cflv_tbl OUT NOCOPY cflv_tbl_type);
76
77 PROCEDURE delete_cash_flow_level(
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_cflv_rec IN cflv_rec_type);
84
85
86 PROCEDURE delete_cash_flow_level(
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_cflv_tbl IN cflv_tbl_type);
93
94 PROCEDURE validate_cash_flow_level(
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_cflv_rec IN cflv_rec_type);
101
102
103 PROCEDURE validate_cash_flow_level(
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_cflv_tbl IN cflv_tbl_type);
110
111 END OKL_CASH_FLOW_LEVELS_PUB;