[Home] [Help]
PACKAGE: APPS.OKL_CASH_RECEIPT
Source
1 PACKAGE OKL_CASH_RECEIPT AUTHID CURRENT_USER AS
2 /* $Header: OKLRRTCS.pls 120.3 2007/08/02 15:51:02 nikshah ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6
7 SUBTYPE xcrv_rec_type IS Okl_Extrn_Pvt.xcrv_rec_type;
8 SUBTYPE xcav_tbl_type IS Okl_Extrn_Pvt.xcav_tbl_type;
9
10 ---------------------------------------------------------------------------
11 -- GLOBAL VARIABLES
12 ---------------------------------------------------------------------------
13
14 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
15 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
16 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
17 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
18
19 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CASH_RECEIPT';
20 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
21 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
22 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
23 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
24 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
25 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
26 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
27
28 ---------------------------------------------------------------------------
29 -- Procedures and Functions
30 ---------------------------------------------------------------------------
31 -- MODIFICATION HISTORY
32 -- Person Date Comments
33 -- -------------- ---------- ------------------------------------------
34 -- Ajay Pimpariya 29-Oct-01 Creation.
35 -- Bruno Vaghela 01-Nov-01 Modified to work.
36 -- Bruno Vaghela 16-Mar-02 Included Currency Conversion.
37 -- Bruno Vaghela 28-Oct-04 Addressed bug 3789514
38 ---------------------------------------------------------------------------
39
40
41 PROCEDURE CASH_RECEIPT( p_api_version IN NUMBER := 1.0
42 ,p_init_msg_list IN VARCHAR2 := OKC_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_over_pay IN VARCHAR2
47 ,p_conc_proc IN VARCHAR2
48 ,p_xcrv_rec IN xcrv_rec_type
49 ,p_xcav_tbl IN xcav_tbl_type
50 ,x_cash_receipt_id OUT NOCOPY NUMBER
51 );
52
53 PROCEDURE PAYMENT_RECEIPT( p_api_version IN NUMBER := 1.0
54 ,p_init_msg_list IN VARCHAR2 := OKC_API.G_FALSE
55 ,x_return_status OUT NOCOPY VARCHAR2
56 ,x_msg_count OUT NOCOPY NUMBER
57 ,x_msg_data OUT NOCOPY VARCHAR2
58 ,p_over_pay IN VARCHAR2
59 ,p_conc_proc IN VARCHAR2
60 ,p_xcrv_rec IN xcrv_rec_type
61 ,p_xcav_tbl IN xcav_tbl_type
62 ,x_cash_receipt_id OUT NOCOPY NUMBER
63 );
64
65 PROCEDURE CREATE_RECEIPT( p_api_version IN NUMBER := 1.0
66 ,p_init_msg_list IN VARCHAR2 := OKC_API.G_FALSE
67 ,x_return_status OUT NOCOPY VARCHAR2
68 ,x_msg_count OUT NOCOPY NUMBER
69 ,x_msg_data OUT NOCOPY VARCHAR2
70 ,p_rcpt_rec IN OKL_CASH_APPL_RULES.rcpt_rec_type
71 ,x_cash_receipt_id OUT NOCOPY NUMBER
72 );
73 END OKL_CASH_RECEIPT; -- Package spec