[Home] [Help]
PACKAGE: APPS.OKL_CURE_RECON_PVT
Source
1 PACKAGE OKL_CURE_RECON_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRRCOS.pls 115.7 2003/09/24 14:35:00 jsanju noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL MESSAGE CONSTANTS
6 ---------------------------------------------------------------------------
7 G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
8 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
9 G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
10 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME';
11 G_COL_NAME1_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME1';
12 G_COL_NAME2_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME2';
13 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := 'PARENT_TABLE';
14 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
15 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
16 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
17 ---------------------------------------------------------------------------
18 -- GLOBAL VARIABLES
19 ---------------------------------------------------------------------------
20 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CURE_RECON_PVT';
21 G_APP_NAME CONSTANT VARCHAR2(3) := 'OKL';
22
23 ---------------------------------------------------------------------------
24 -- GLOBAL EXCEPTION
25 ---------------------------------------------------------------------------
26 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
27
28
29
30 TYPE cure_amount_rec IS RECORD
31 (
32 cam_id NUMBER,
33 negotiated_amount NUMBER,
34 process VARCHAR2(50)
35 );
36
37 TYPE cure_amount_tbl IS TABLE OF cure_amount_rec INDEX BY BINARY_INTEGER;
38
39
40 PROCEDURE UPDATE_CURE_INVOICE (
41 p_api_version IN NUMBER,
42 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.G_FALSE,
43 p_commit IN VARCHAR2 DEFAULT fnd_api.G_FALSE,
44 p_report_id IN NUMBER,
45 p_invoice_date IN DATE,
46 p_cam_tbl IN cure_amount_tbl,
47 p_operation IN VARCHAR2,
48 x_return_status OUT NOCOPY VARCHAR2,
49 x_msg_count OUT NOCOPY NUMBER,
50 x_msg_data OUT NOCOPY VARCHAR2) ;
51
52
53
54 END OKL_CURE_RECON_PVT;
55