16: G_WALLET_PATH VARCHAR2(32767) := NULL;
17: G_WALLET_PASSWORD VARCHAR2(1000) := NULL;
18: G_OTM_UNAME VARCHAR2(2000) := NULL;
19: G_OTM_PSWD VARCHAR2(2000) := NULL;
20: G_NEWLINE_CHARACTER CHAR(1) := FND_GLOBAL.Newline;
21: G_HARD_CHAR VARCHAR2(1) := '&';
22: G_PARAM_NAME_DBC VARCHAR2(3) := 'dbc';
23: G_PARAM_NAME_USERID VARCHAR2(6) := 'userId';
24: G_PARAM_NAME_RESPID VARCHAR2(6) := 'respId';
167: p_ctxt_str CLOB;
168: BEGIN
169: p_ctxt_str := G_PARAM_NAME_DBC||'='||fnd_web_config.database_id;
170: p_ctxt_str := p_ctxt_str||G_HARD_CHAR;
171: p_ctxt_str := p_ctxt_str||G_PARAM_NAME_USERID||'='||fnd_global.user_id;
172: p_ctxt_str := p_ctxt_str||G_HARD_CHAR;
173: p_ctxt_str := p_ctxt_str||G_PARAM_NAME_RESPID||'='||fnd_global.resp_id;
174: p_ctxt_str := p_ctxt_str||G_HARD_CHAR;
175: p_ctxt_str := p_ctxt_str||G_PARAM_NAME_RESP_APPL_ID||'='||fnd_global.resp_appl_id;
169: p_ctxt_str := G_PARAM_NAME_DBC||'='||fnd_web_config.database_id;
170: p_ctxt_str := p_ctxt_str||G_HARD_CHAR;
171: p_ctxt_str := p_ctxt_str||G_PARAM_NAME_USERID||'='||fnd_global.user_id;
172: p_ctxt_str := p_ctxt_str||G_HARD_CHAR;
173: p_ctxt_str := p_ctxt_str||G_PARAM_NAME_RESPID||'='||fnd_global.resp_id;
174: p_ctxt_str := p_ctxt_str||G_HARD_CHAR;
175: p_ctxt_str := p_ctxt_str||G_PARAM_NAME_RESP_APPL_ID||'='||fnd_global.resp_appl_id;
176: p_ctxt_str := p_ctxt_str||G_HARD_CHAR;
177: p_ctxt_str := p_ctxt_str||G_PARAM_NAME_TICKET||'='||p_fnd_ticket;
171: p_ctxt_str := p_ctxt_str||G_PARAM_NAME_USERID||'='||fnd_global.user_id;
172: p_ctxt_str := p_ctxt_str||G_HARD_CHAR;
173: p_ctxt_str := p_ctxt_str||G_PARAM_NAME_RESPID||'='||fnd_global.resp_id;
174: p_ctxt_str := p_ctxt_str||G_HARD_CHAR;
175: p_ctxt_str := p_ctxt_str||G_PARAM_NAME_RESP_APPL_ID||'='||fnd_global.resp_appl_id;
176: p_ctxt_str := p_ctxt_str||G_HARD_CHAR;
177: p_ctxt_str := p_ctxt_str||G_PARAM_NAME_TICKET||'='||p_fnd_ticket;
178: p_ctxt_str := p_ctxt_str||G_HARD_CHAR;
179: p_ctxt_str := p_ctxt_str||G_PARAM_NAME_WS_END_POINT||'='||G_WSH_OTM_WS_ENDPOINT;