PACKAGE: APPS.OKL_CURE_VNDR_RFND_PVT

Source

1 PACKAGE OKL_CURE_VNDR_RFND_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRRFSS.pls 115.0 2003/04/25 04:11:50 smereddy noship $ */
3 
4  TYPE cure_rfnd_rec_type is record (
5     cure_refund_stage_id OKL_CURE_REFUND_STAGE.cure_refund_stage_id%type ,
6     received_amount   OKL_CURE_REFUND_STAGE.received_amount%type ,
7     chr_id   OKL_CURE_REFUND_STAGE.chr_id%type ,
8     vendor_id   OKL_CURE_REFUND_STAGE.vendor_id%type ,
9     currency_code   okc_k_headers_b.currency_code%type ,
10     contract_number   okc_k_headers_b.contract_number%type ,
11     offset_amount   OKL_CURE_REFUNDS.offset_amount%type ,
12     offset_contract_number   okc_k_headers_b.contract_number%type ,
13     offset_contract_id   OKL_CURE_REFUNDS.offset_contract%type ,
14     cure_refund_header_id   OKL_CURE_REFUND_HEADERS_B.cure_refund_header_id%type ,
15     REFUND_HEADER_NUMBER   OKL_CURE_REFUND_HEADERS_B.REFUND_HEADER_NUMBER%type,
16     cure_refund_line_id OKL_CURE_REFUNDS.cure_refund_id%type ,
17     vendor_site_id OKL_CURE_REFUNDS.vendor_site_id%type,
18     rl_object_version_number OKL_CURE_REFUNDS.object_version_number%type ,
19     rh_object_version_number OKL_CURE_REFUND_HEADERS_B.object_version_number%type ,
20     rs_object_version_number OKL_CURE_REFUND_STAGE.object_version_number%type
21     );
22 
23  TYPE cure_rfnd_tbl_type is table of cure_rfnd_rec_type INDEX BY BINARY_INTEGER;
24 
25 -- GLOBAL VARIABLES
26 G_PKG_NAME           CONSTANT VARCHAR2(200) := 'OKL_CURE_RFND_PVT';
27 G_APP_NAME           CONSTANT VARCHAR2(3)   :=  OKL_API.G_APP_NAME;
28 G_API_TYPE	     CONSTANT VARCHAR2(4)   := '_PVT';
29 
30 
31 PROCEDURE create_cure_refund(
32             p_api_version    	     IN  NUMBER,
33             p_init_msg_list          IN  VARCHAR2 DEFAULT OKC_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_cure_rfnd_tbl          IN  cure_rfnd_tbl_type,
38             x_cure_rfnd_tbl          OUT NOCOPY cure_rfnd_tbl_type
39 );
40 
41 PROCEDURE update_cure_refund(
42             p_api_version    	     IN  NUMBER,
43             p_init_msg_list          IN  VARCHAR2 DEFAULT OKC_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_cure_rfnd_tbl          IN  cure_rfnd_tbl_type,
48             x_cure_rfnd_tbl          OUT NOCOPY cure_rfnd_tbl_type
49 );
50 
51 PROCEDURE delete_cure_refund(
52             p_api_version    	     IN  NUMBER,
53             p_init_msg_list          IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
54             x_return_status          OUT NOCOPY VARCHAR2,
55             x_msg_count              OUT NOCOPY NUMBER,
56             x_msg_data               OUT NOCOPY VARCHAR2,
57             p_cure_rfnd_tbl         IN  cure_rfnd_tbl_type
58 );
59 
60 END OKL_CURE_VNDR_RFND_PVT;