[Home] [Help]
PACKAGE: APPS.OKL_CURE_REQUEST_PVT
Source
1 PACKAGE OKL_CURE_REQUEST_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRREQS.pls 115.7 2003/10/10 19:00:37 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 G_PROCESS_SUCCESS CONSTANT VARCHAR2(200) := 'OKL_PROCESS_SUCCESSFUL';
18 ---------------------------------------------------------------------------
19 -- GLOBAL VARIABLES
20 ---------------------------------------------------------------------------
21 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CURE_REQUEST_PVT';
22 G_APP_NAME CONSTANT VARCHAR2(3) := 'OKL';
23 G_CONFIRM_SUBMIT CONSTANT VARCHAR2(200) := 'OKL_CONFIRM_SUBMIT';
24 G_INVALID_CURE_REQUEST CONSTANT VARCHAR2(200) := 'OKL_INVALID_CURE_REQUEST';
25 G_ERROR_GETTING_OBJECT_VERSION
26 CONSTANT VARCHAR2(200) := 'ERROR_GETTING_OBJECT_VERSION';
27 ---------------------------------------------------------------------------
28 -- GLOBAL EXCEPTION
29 ---------------------------------------------------------------------------
30 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
31 G_MISSING_EMAIL_ID EXCEPTION;
32 G_MISSING_TEMPLATE EXCEPTION;
33 ---------------------------------------------------------------------------
34 -- Procedures and Functions
35 ---------------------------------------------------------------------------
36
37 /*
38 PROCEDURE: SEND_CURE_REQUEST
39 This procedure is to send Vendor Cure Requests for
40 records generated in OKL_CURE_REPORTS and
41 OKL_CURE_REPORT_AMOUNTS table. These records are then
42 processed by Send Cure Request procedure via Fulfillment.
43 */
44 PROCEDURE SEND_CURE_REQUEST
45 (
46 errbuf OUT NOCOPY VARCHAR2,
47 retcode OUT NOCOPY NUMBER,
48 p_vendor_number IN NUMBER DEFAULT NULL,
49 p_report_number IN VARCHAR2 DEFAULT NULL,
50 p_report_date IN DATE DEFAULT NULL
51 );
52
53 END OKL_CURE_REQUEST_PVT;
54
55