[Home] [Help]
PACKAGE: APPS.OKL_PAYMENT_PUB
Source
1 PACKAGE OKL_PAYMENT_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPPAYS.pls 120.6 2007/09/07 12:29:36 nikshah noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL VARIABLES
6 ---------------------------------------------------------------------------
7 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_PAYMENT_PUB';
8 G_APP_NAME CONSTANT VARCHAR2(3) := 'OKL';
9
10 ---------------------------------------------------------------------------
11 -- GLOBAL EXCEPTION
12 ---------------------------------------------------------------------------
13 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
14 ---------------------------------------------------------------------------
15
16 ---------------------------------------------------------------------------
17 -- Data Structures
18 ----------------------------------------------------------------------------
19 SUBTYPE receipt_rec_type IS OKL_PAYMENT_PVT.receipt_rec_type;
20 SUBTYPE payment_tbl_type IS OKL_PAYMENT_PVT.payment_tbl_type;
21 ---------------------------------------------------------------------------
22 -- FUNCTION Get receipt Number
23 ---------------------------------------------------------------------------
24 FUNCTION get_ar_receipt_number(p_cash_receipt_id IN NUMBER)
25 RETURN VARCHAR2;
26 ---------------------------------------------------------------------------
27
28 PROCEDURE CREATE_INTERNAL_TRANS(
29 p_api_version IN NUMBER,
30 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
31 p_customer_id IN NUMBER,
32 p_contract_id IN NUMBER,
33 p_payment_method_id IN NUMBER,
34 p_payment_ref_number IN VARCHAR2,
35 p_payment_amount IN NUMBER,
36 p_currency_code IN VARCHAR2,
37 p_payment_date IN DATE,
38 x_payment_id OUT NOCOPY NUMBER,
39 x_return_status OUT NOCOPY VARCHAR2,
40 x_msg_count OUT NOCOPY NUMBER,
41 x_msg_data OUT NOCOPY VARCHAR2
42 );
43
44 PROCEDURE CREATE_INTERNAL_TRANS(
45 p_api_version IN NUMBER,
46 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
47 p_customer_id IN NUMBER,
48 p_invoice_id IN NUMBER,
49 p_payment_method_id IN NUMBER,
50 p_payment_ref_number IN VARCHAR2,
51 p_payment_amount IN NUMBER,
52 p_currency_code IN VARCHAR2,
53 p_payment_date IN DATE,
54 x_payment_id OUT NOCOPY NUMBER,
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_msg_data OUT NOCOPY VARCHAR2
58 );
59
60 PROCEDURE CREATE_PAYMENTS(
61 p_api_version IN NUMBER,
62 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
63 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
64 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
65 x_return_status OUT NOCOPY VARCHAR2,
66 x_msg_count OUT NOCOPY NUMBER,
67 x_msg_data OUT NOCOPY VARCHAR2,
68 p_receipt_rec IN receipt_rec_type,
69 p_payment_tbl IN payment_tbl_type,
70 x_payment_ref_number OUT NOCOPY AR_CASH_RECEIPTS_ALL.RECEIPT_NUMBER%TYPE,
71 x_cash_receipt_id OUT NOCOPY NUMBER
72 );
73 END OKL_PAYMENT_PUB;