1 PACKAGE OKL_BILL_STATUS_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRBISS.pls 120.2 2005/08/11 13:49:51 abindal noship $ */
3 --
4 --
5 -- Purpose: Briefly explain the functionality of the package
6 --
7 -- MODIFICATION HISTORY
8 -- Person Date Comments
9 -- --------- ------ ------------------------------------------
10 -- Enter package declarations as shown below
11
12 ------------------------------------------------------------------------------
13 TYPE bill_stat_rec_type IS RECORD (
14 transaction_type VARCHAR2(200),
15 last_bill_date DATE,
16 last_schedule_bill_date DATE);
17
18 TYPE bill_stat_tbl_type IS TABLE OF bill_stat_rec_type
19 INDEX BY BINARY_INTEGER;
20
21 TYPE line_items_rec_type IS RECORD (
22 line_id NUMBER);
23
24 TYPE line_items_tbl_type IS TABLE OF line_items_rec_type
25 INDEX BY BINARY_INTEGER;
26
27 -- abindal bug 4396207 start --
28 TYPE valid_stm_rec_type IS RECORD (
29 stm_id NUMBER);
30
31 TYPE valid_stm_tbl_type IS TABLE OF valid_stm_rec_type
32 INDEX BY BINARY_INTEGER;
33
34 TYPE valid_sel_rec_type IS RECORD (
35 sel_id NUMBER);
36
37 TYPE valid_sel_tbl_type IS TABLE OF valid_sel_rec_type
38 INDEX BY BINARY_INTEGER;
39 -- abindal bug 4396207 end --
40
41
42 -- Global Variables
43 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_BILL_STATUS_PVT';
44 G_APP_NAME CONSTANT VARCHAR2(3) := Okc_Api.G_APP_NAME;
45 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
46 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
47 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
48 ------------------------------------------------------------------------------
49 --Global Exception
50 ------------------------------------------------------------------------------
51 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
52 ------------------------------------------------------------------------------
53
54 l_msg_data VARCHAR2(4000);
55
56 PROCEDURE billing_status(
57 p_api_version IN NUMBER
58 ,p_init_msg_list IN VARCHAR2
59 ,x_return_status OUT NOCOPY VARCHAR2
60 ,x_msg_count OUT NOCOPY NUMBER
61 ,x_msg_data OUT NOCOPY VARCHAR2
62 ,x_bill_stat_tbl OUT NOCOPY bill_stat_tbl_type
63 ,p_khr_id IN NUMBER
64 ,p_transaction_date IN DATE
65 );
66
67 END OKL_BILL_STATUS_PVT; -- Package spec
68