1 PACKAGE okl_bllng_chrg_hdrs_pub AUTHID CURRENT_USER AS
2 /* $Header: OKLPBGHS.pls 115.4 2002/02/05 12:04:17 pkm ship $ */
3
4
5
6 subtype bghv_rec_type is okl_bgh_pvt.bghv_rec_type;
7 subtype bghv_tbl_type is okl_bgh_pvt.bghv_tbl_type;
8 ------------------------------------------------------------------------------
9 -- Global Variables
10 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_BLLNG_CHRG_HDRS_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_bllng_chrg_hdrs(
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_bghv_tbl IN bghv_tbl_type
29 ,x_bghv_tbl OUT NOCOPY bghv_tbl_type);
30
31 PROCEDURE insert_bllng_chrg_hdrs(
32 p_api_version IN NUMBER
33 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
34 ,x_return_status OUT NOCOPY VARCHAR2
35 ,x_msg_count OUT NOCOPY NUMBER
36 ,x_msg_data OUT NOCOPY VARCHAR2
37 ,p_bghv_rec IN bghv_rec_type
38 ,x_bghv_rec OUT NOCOPY bghv_rec_type);
39
40 PROCEDURE lock_bllng_chrg_hdrs(
41 p_api_version IN NUMBER
42 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
43 ,x_return_status OUT NOCOPY VARCHAR2
44 ,x_msg_count OUT NOCOPY NUMBER
45 ,x_msg_data OUT NOCOPY VARCHAR2
46 ,p_bghv_tbl IN bghv_tbl_type);
47
48 PROCEDURE lock_bllng_chrg_hdrs(
49 p_api_version IN NUMBER
50 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
51 ,x_return_status OUT NOCOPY VARCHAR2
52 ,x_msg_count OUT NOCOPY NUMBER
53 ,x_msg_data OUT NOCOPY VARCHAR2
54 ,p_bghv_rec IN bghv_rec_type);
55
56 PROCEDURE update_bllng_chrg_hdrs(
57 p_api_version IN NUMBER
58 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
59 ,x_return_status OUT NOCOPY VARCHAR2
60 ,x_msg_count OUT NOCOPY NUMBER
61 ,x_msg_data OUT NOCOPY VARCHAR2
62 ,p_bghv_tbl IN bghv_tbl_type
63 ,x_bghv_tbl OUT NOCOPY bghv_tbl_type);
64
65 PROCEDURE update_bllng_chrg_hdrs(
66 p_api_version IN NUMBER
67 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
68 ,x_return_status OUT NOCOPY VARCHAR2
69 ,x_msg_count OUT NOCOPY NUMBER
70 ,x_msg_data OUT NOCOPY VARCHAR2
71 ,p_bghv_rec IN bghv_rec_type
72 ,x_bghv_rec OUT NOCOPY bghv_rec_type);
73
74 PROCEDURE delete_bllng_chrg_hdrs(
75 p_api_version IN NUMBER
76 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
77 ,x_return_status OUT NOCOPY VARCHAR2
78 ,x_msg_count OUT NOCOPY NUMBER
79 ,x_msg_data OUT NOCOPY VARCHAR2
80 ,p_bghv_tbl IN bghv_tbl_type);
81
82 PROCEDURE delete_bllng_chrg_hdrs(
83 p_api_version IN NUMBER
84 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
85 ,x_return_status OUT NOCOPY VARCHAR2
86 ,x_msg_count OUT NOCOPY NUMBER
87 ,x_msg_data OUT NOCOPY VARCHAR2
88 ,p_bghv_rec IN bghv_rec_type);
89
90 PROCEDURE validate_bllng_chrg_hdrs(
91 p_api_version IN NUMBER
92 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_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_bghv_tbl IN bghv_tbl_type);
97
98 PROCEDURE validate_bllng_chrg_hdrs(
99 p_api_version IN NUMBER
100 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
101 ,x_return_status OUT NOCOPY VARCHAR2
102 ,x_msg_count OUT NOCOPY NUMBER
103 ,x_msg_data OUT NOCOPY VARCHAR2
104 ,p_bghv_rec IN bghv_rec_type);
105
106 END okl_bllng_chrg_hdrs_pub;
107