PACKAGE: APPS.OKL_BILL_STATUS_PUB

Source

1 PACKAGE OKL_BILL_STATUS_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPBISS.pls 115.1 2004/01/07 18:36:05 sanahuja noship $ */
3 --
4 -- To modify this template, edit file PKGSPEC.TXT in TEMPLATE
5 -- directory of SQL Navigator
6 --
7 -- Purpose: Briefly explain the functionality of the package
8 --
9 -- MODIFICATION HISTORY
10 -- Person      Date    Comments
11 -- ---------   ------  ------------------------------------------
12    -- Enter package declarations as shown below
13 
14   ------------------------------------------------------------------------------
15   -- Global Variables
16   G_PKG_NAME             CONSTANT VARCHAR2(200) := 'OKL_BILL_STATUS_PUB';
17   G_APP_NAME             CONSTANT VARCHAR2(3)   :=  Okc_Api.G_APP_NAME;
18   G_UNEXPECTED_ERROR     CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
19   G_SQLERRM_TOKEN        CONSTANT VARCHAR2(200) := 'SQLERRM';
20   G_SQLCODE_TOKEN        CONSTANT VARCHAR2(200) := 'SQLCODE';
21   ------------------------------------------------------------------------------
22    --Global Exception
23   ------------------------------------------------------------------------------
24    G_EXCEPTION_HALT_VALIDATION	EXCEPTION;
25   ------------------------------------------------------------------------------
26 
27   l_msg_data VARCHAR2(4000);
28 
29   SUBTYPE bill_stat_tbl_type  is OKL_BILL_STATUS_PVT.bill_stat_tbl_type;
30 
31   --PROCEDURE ADD_LANGUAGE;
32 
33   --Object type procedure for calling calculate_late_charge
34 
35   PROCEDURE billing_status(
36      p_api_version                  IN  NUMBER
37     ,p_init_msg_list                IN  VARCHAR2
38     ,x_return_status                OUT NOCOPY VARCHAR2
39     ,x_msg_count                    OUT NOCOPY NUMBER
40     ,x_msg_data                     OUT NOCOPY VARCHAR2
41     ,x_bill_stat_tbl                OUT NOCOPY bill_stat_tbl_type
42     ,p_khr_id                       IN  NUMBER
43     ,p_transaction_date             IN  DATE
44     );
45 
46 END OKL_BILL_STATUS_PUB; -- Package spec
47 
48 
49 
50 
51