[Home] [Help]
PACKAGE: APPS.QP_JAVA_ENGINE_UTIL_PUB
Source
1 PACKAGE QP_JAVA_ENGINE_UTIL_PUB AS
2 /* $Header: QPXJUTLS.pls 120.1 2005/07/14 11:07:55 appldev ship $ */
3
4 --GLOBAL Constant holding the package name
5
6 G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_JAVA_ENGINE_UTIL_PUB';
7 G_QP_INT_TABLES_LOCK CONSTANT VARCHAR2(30) := 'QP_INT_TABLES_LOCK';
8 G_HARD_CHAR varchar2(1) := '&';
9 G_PATN_SEPERATOR varchar2(1) := '|';
10 G_PARAM_NAME_DBC varchar2(3) := 'dbc';
11 G_PARAM_NAME_USERID varchar2(6) := 'UserId';
12 G_PARAM_NAME_RESPID varchar2(6) := 'RespId';
13 G_PARAM_NAME_RESP_APPL_ID varchar2(10) := 'RespApplId';
14 G_PARAM_NAME_LOGIN_ID varchar2(7) := 'LoginId';
15 G_PARAM_NAME_ORG_ID varchar2(5) := 'OrgId';
16 G_PARAM_NAME_APP_SHORT_NAME varchar2(12) := 'AppShortName';
17 G_PARAM_NAME_CALL_TYPE varchar2(8) := 'CallType';
18 G_PARAM_NAME_ACTION varchar2(6) := 'Action';
19 G_PARAM_NAME_ICX_SESSION_ID varchar2(12) := 'IcxSessionId';
20 G_PARAM_NAME_STS_CODE varchar2(10) := 'StatusCode';
21 G_PARAM_NAME_STS_TEXT varchar2(10) := 'StatusText';
22 G_PARAM_NAME_DETAILS varchar2(10) := 'Details';
23 G_PARAM_NAME_DEBUG_FLAG varchar2(9) := 'DebugFlag';
24
25 G_TRANSFER_TIMEOUT number := 60;
26 G_NEWLINE_CHARACTER CHAR(1) := FND_GLOBAL.Newline;
27
28 --added for HTTP timeout issue handling
29 G_MAX_STATUS_REQUESTS NUMBER:=nvl(FND_PROFILE.VALUE('QP_JPE_MAX_STAT_REQUESTS'),240);
30 G_STATUS_REQUEST_INTERVAL NUMBER:=nvl(FND_PROFILE.VALUE('QP_JPE_STAT_REQUEST_INTERVAL'),15); -- seconds
31 --added for HTTP timeout issue handling
32
33 --'Y', JavaEngine is installed, 'N' is not installed.
34 FUNCTION Java_Engine_Installed RETURN VARCHAR2;
35
36 --'Y', JavaEngine is running, 'N' is not running.
37 FUNCTION Java_Engine_Running RETURN VARCHAR2;
38
39 --Return the URL to Servlet where Java Engine is deployed and running.
40 FUNCTION Get_Engine_Url RETURN VARCHAR2;
41
42 PROCEDURE Send_Java_Engine_Request (p_url_param_string IN VARCHAR2,
43 x_return_status OUT NOCOPY VARCHAR2,
44 x_return_status_text OUT NOCOPY VARCHAR2,
45 p_transfer_timeout IN NUMBER DEFAULT -1, -- defaulted to qp utl_http timeout setting
46 p_detailed_excp_support IN VARCHAR2 DEFAULT FND_API.G_FALSE,
47 p_timeout_processing IN VARCHAR2 default FND_API.G_FALSE);
48
49 PROCEDURE Send_Java_Engine_Request (p_url_param_string IN VARCHAR2,
50 x_return_status OUT NOCOPY VARCHAR2,
51 x_return_status_text OUT NOCOPY VARCHAR2,
52 x_return_details OUT NOCOPY UTL_HTTP.HTML_PIECES,
53 p_use_request_pieces IN BOOLEAN,
54 p_transfer_timeout IN NUMBER DEFAULT -1, -- defaulted to qp utl_http timeout setting
55 p_detailed_excp_support IN VARCHAR2 DEFAULT FND_API.G_FALSE,
56 p_timeout_processing IN VARCHAR2 default FND_API.G_FALSE);
57
58 PROCEDURE Send_Java_Request (p_server_url IN VARCHAR2,
59 p_url_param_string IN VARCHAR2,
60 x_return_status OUT NOCOPY VARCHAR2,
61 x_return_status_text OUT NOCOPY VARCHAR2,
62 x_return_details OUT NOCOPY UTL_HTTP.HTML_PIECES,
63 p_use_request_pieces IN BOOLEAN,
64 p_transfer_timeout IN NUMBER DEFAULT -1,
65 p_detailed_excp_support IN VARCHAR2 DEFAULT FND_API.G_FALSE,
66 p_timeout_processing IN VARCHAR2 DEFAULT FND_API.G_FALSE);
67
68 END QP_JAVA_ENGINE_UTIL_PUB;