PACKAGE: APPS.QP_JAVA_ENGINE_UTIL_PUB

Source

1 PACKAGE QP_JAVA_ENGINE_UTIL_PUB AUTHID CURRENT_USER 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;