[Home] [Help]
PACKAGE: APPS.OKL_CNTR_GRP_BILLING_PUB
Source
1 PACKAGE OKL_CNTR_GRP_BILLING_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPCLBS.pls 115.1 2002/07/12 19:05:31 sanahuja noship $ */
3
4
5
6 SUBTYPE cntr_bill_rec_type IS OKL_CNTR_GRP_BILLING_PVT.cntr_bill_rec_type;
7 SUBTYPE cntr_bill_tbl_type IS OKL_CNTR_GRP_BILLING_PVT.cntr_bill_tbl_type;
8 ------------------------------------------------------------------------------
9 -- Global Variables
10 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CNTR_GRP_BILLING_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 PROCEDURE calculate_cntgrp_bill_amt(
22 p_api_version IN NUMBER
23 ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
24 ,x_return_status OUT NOCOPY VARCHAR2
25 ,x_msg_count OUT NOCOPY NUMBER
26 ,x_msg_data OUT NOCOPY VARCHAR2
27 ,p_cntr_bill_tbl IN cntr_bill_tbl_type
28 ,x_cntr_bill_tbl OUT NOCOPY cntr_bill_tbl_type);
29
30 PROCEDURE calculate_cntgrp_bill_amt(
31 p_api_version IN NUMBER
32 ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
33 ,x_return_status OUT NOCOPY VARCHAR2
34 ,x_msg_count OUT NOCOPY NUMBER
35 ,x_msg_data OUT NOCOPY VARCHAR2
36 ,p_cntr_bill_rec IN cntr_bill_rec_type
37 ,x_cntr_bill_rec OUT NOCOPY cntr_bill_rec_type);
38
39 PROCEDURE insert_cntr_grp_bill(
40 p_api_version IN NUMBER
41 ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
42 ,x_return_status OUT NOCOPY VARCHAR2
43 ,x_msg_count OUT NOCOPY NUMBER
44 ,x_msg_data OUT NOCOPY VARCHAR2
45 ,p_cntr_bill_tbl IN cntr_bill_tbl_type
46 ,x_cntr_bill_tbl OUT NOCOPY cntr_bill_tbl_type);
47
48 PROCEDURE insert_cntr_grp_bill(
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_cntr_bill_rec IN cntr_bill_rec_type
55 ,x_cntr_bill_rec OUT NOCOPY cntr_bill_rec_type);
56
57 end OKL_CNTR_GRP_BILLING_PUB;