eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_E1APS_UTIL dependencies on DUAL

Line 30: sql_cnd := 'select INSTR('''||ws_prf||''','''||srch_str||''') from dual';

26: -- if found launch 10g soap request function MSC_E1APS_ODIScenExecute10g
27: -- else launch 11g soap request
28:
29: ws_prf := fnd_profile.value('MSC_E1APS_ODIURL');
30: sql_cnd := 'select INSTR('''||ws_prf||''','''||srch_str||''') from dual';
31: EXECUTE immediate sql_cnd into chk_cnd;
32:
33: IF (chk_cnd > 0) THEN
34: -- Launch Soap request for 10G -- call function MSC_E1APS_ODIScenExecute10g

Line 58: FROM dual;

54: utl_http.read_text(http_resp, soap_respond);
55: utl_http.end_response(http_resp);
56: SELECT instr(soap_respond,'')
57: INTO StartIndex
58: FROM dual;
59:
60: SELECT instr(soap_respond,'')
61: INTO EndIndex
62: FROM dual;

Line 62: FROM dual;

58: FROM dual;
59:
60: SELECT instr(soap_respond,'')
61: INTO EndIndex
62: FROM dual;
63:
64: SELECT SUBSTR(soap_respond,StartIndex+8,EndIndex-(StartIndex+8))
65: INTO returnStr
66: FROM dual;

Line 66: FROM dual;

62: FROM dual;
63:
64: SELECT SUBSTR(soap_respond,StartIndex+8,EndIndex-(StartIndex+8))
65: INTO returnStr
66: FROM dual;
67:
68: RETURN returnStr;
69: END IF;
70: EXCEPTION

Line 102: sql_cnd := 'select INSTR('''||ws_prf||''','''||srch_str||''') from dual';

98: -- if found launch 10g soap request function MSC_E1APS_ODIInitialize10g
99: -- else launch 11g soap request
100:
101: ws_prf := fnd_profile.value('MSC_E1APS_ODIURL');
102: sql_cnd := 'select INSTR('''||ws_prf||''','''||srch_str||''') from dual';
103: EXECUTE immediate sql_cnd into chk_cnd;
104:
105: IF (chk_cnd > 0) THEN
106: returnStr := MSC_E1APS_ODIInitialize10g(WsUrl,BaseDate);

Line 130: FROM dual;

126: utl_http.read_text(http_resp, soap_respond);
127: utl_http.end_response(http_resp);
128: SELECT instr(soap_respond,'')
129: INTO StartIndex
130: FROM dual;
131:
132: SELECT instr(soap_respond,'')
133: INTO EndIndex
134: FROM dual;

Line 134: FROM dual;

130: FROM dual;
131:
132: SELECT instr(soap_respond,'')
133: INTO EndIndex
134: FROM dual;
135:
136: SELECT SUBSTR(soap_respond,StartIndex+8,EndIndex-(StartIndex+8))
137: INTO returnStr
138: FROM dual;

Line 138: FROM dual;

134: FROM dual;
135:
136: SELECT SUBSTR(soap_respond,StartIndex+8,EndIndex-(StartIndex+8))
137: INTO returnStr
138: FROM dual;
139:
140: SELECT instr(returnStr,'#')
141: INTO StartIndex
142: FROM dual;

Line 142: FROM dual;

138: FROM dual;
139:
140: SELECT instr(returnStr,'#')
141: INTO StartIndex
142: FROM dual;
143:
144: SELECT SUBSTR(returnStr,0,StartIndex-1)
145: INTO SessionNum
146: FROM dual;

Line 146: FROM dual;

142: FROM dual;
143:
144: SELECT SUBSTR(returnStr,0,StartIndex-1)
145: INTO SessionNum
146: FROM dual;
147:
148: SELECT SUBSTR(returnStr,StartIndex+1,1800)
149: INTO ErrMessage
150: FROM dual;

Line 150: FROM dual;

146: FROM dual;
147:
148: SELECT SUBSTR(returnStr,StartIndex+1,1800)
149: INTO ErrMessage
150: FROM dual;
151: IF SessionNum = '-1' THEN
152: finalreturnStr:= 'ODI Scenario:'
153: ||'LOADPARAMETERSDATATOWORKREPPKG'
154: ||'#ODI Session No.#Error Message='

Line 202: FROM dual;

198: utl_http.read_text(http_resp, soap_respond);
199: utl_http.end_response(http_resp);
200: SELECT instr(soap_respond,'')
201: INTO StartIndex
202: FROM dual;
203:
204: SELECT instr(soap_respond,'')
205: INTO EndIndex
206: FROM dual;

Line 206: FROM dual;

202: FROM dual;
203:
204: SELECT instr(soap_respond,'')
205: INTO EndIndex
206: FROM dual;
207:
208: SELECT SUBSTR(soap_respond,StartIndex+8,EndIndex-(StartIndex+8))
209: INTO returnStr
210: FROM dual;

Line 210: FROM dual;

206: FROM dual;
207:
208: SELECT SUBSTR(soap_respond,StartIndex+8,EndIndex-(StartIndex+8))
209: INTO returnStr
210: FROM dual;
211:
212: SELECT instr(returnStr,'#')
213: INTO StartIndex
214: FROM dual;

Line 214: FROM dual;

210: FROM dual;
211:
212: SELECT instr(returnStr,'#')
213: INTO StartIndex
214: FROM dual;
215:
216: SELECT SUBSTR(returnStr,0,StartIndex-1)
217: INTO SessionNum
218: FROM dual;

Line 218: FROM dual;

214: FROM dual;
215:
216: SELECT SUBSTR(returnStr,0,StartIndex-1)
217: INTO SessionNum
218: FROM dual;
219:
220: SELECT SUBSTR(returnStr,StartIndex+1,1800)
221: INTO ErrMessage
222: FROM dual;

Line 222: FROM dual;

218: FROM dual;
219:
220: SELECT SUBSTR(returnStr,StartIndex+1,1800)
221: INTO ErrMessage
222: FROM dual;
223:
224: IF SessionNum = '-1' THEN
225: finalreturnStr:= 'ODI Scenario:'
226: ||'UPDATEVARIABLE'

Line 278: FROM dual;

274: utl_http.read_text(http_resp, soap_respond);
275: utl_http.end_response(http_resp);
276: SELECT instr(soap_respond,'')
277: INTO StartIndex
278: FROM dual;
279:
280: SELECT instr(soap_respond,'')
281: INTO EndIndex
282: FROM dual;

Line 282: FROM dual;

278: FROM dual;
279:
280: SELECT instr(soap_respond,'')
281: INTO EndIndex
282: FROM dual;
283:
284: SELECT SUBSTR(soap_respond,StartIndex+8,EndIndex-(StartIndex+8))
285: INTO returnStr
286: FROM dual;

Line 286: FROM dual;

282: FROM dual;
283:
284: SELECT SUBSTR(soap_respond,StartIndex+8,EndIndex-(StartIndex+8))
285: INTO returnStr
286: FROM dual;
287:
288: SELECT instr(returnStr,'#')
289: INTO StartIndex
290: FROM dual;

Line 290: FROM dual;

286: FROM dual;
287:
288: SELECT instr(returnStr,'#')
289: INTO StartIndex
290: FROM dual;
291:
292: SELECT SUBSTR(returnStr,0,StartIndex-1)
293: INTO SessionNum
294: FROM dual;

Line 294: FROM dual;

290: FROM dual;
291:
292: SELECT SUBSTR(returnStr,0,StartIndex-1)
293: INTO SessionNum
294: FROM dual;
295:
296: SELECT SUBSTR(returnStr,StartIndex+1,1800)
297: INTO ErrMessage
298: FROM dual;

Line 298: FROM dual;

294: FROM dual;
295:
296: SELECT SUBSTR(returnStr,StartIndex+1,1800)
297: INTO ErrMessage
298: FROM dual;
299:
300: IF SessionNum = '-1' THEN
301: finalreturnStr:= 'ODI Scenario:'
302: ||'SYNCHRONIZE_XML'

Line 399: ||'&sync=no'') FROM dual';

395: ||'&password='
396: ||l_password
397: ||'&schema='
398: || REPLACE(l_schema_name, ' ', '%20')
399: ||'&sync=no'') FROM dual';
400: msd_dem_common_utilities.log_debug (l_sql);
401: EXECUTE immediate l_sql INTO process_id;
402: -- msd_dem_common_utilities.log_message('Process Id:'||l_dummy);
403: -- syenamar

Line 773: FROM dual;

769: utl_http.read_text(http_resp, soap_respond);
770: utl_http.end_response(http_resp);
771: SELECT instr(soap_respond,'')
772: INTO StartIndex
773: FROM dual;
774:
775: SELECT instr(soap_respond,'')
776: INTO EndIndex
777: FROM dual;

Line 777: FROM dual;

773: FROM dual;
774:
775: SELECT instr(soap_respond,'')
776: INTO EndIndex
777: FROM dual;
778:
779: SELECT SUBSTR(soap_respond,StartIndex+12,EndIndex-(StartIndex+12))
780: INTO returnStr
781: FROM dual;

Line 781: FROM dual;

777: FROM dual;
778:
779: SELECT SUBSTR(soap_respond,StartIndex+12,EndIndex-(StartIndex+12))
780: INTO returnStr
781: FROM dual;
782:
783: RETURN returnStr;
784: EXCEPTION
785: WHEN OTHERS THEN

Line 834: FROM dual;

830: utl_http.read_text(http_resp, soap_respond);
831: utl_http.end_response(http_resp);
832: SELECT instr(soap_respond,'')
833: INTO StartIndex
834: FROM dual;
835:
836: SELECT instr(soap_respond,'')
837: INTO EndIndex
838: FROM dual;

Line 838: FROM dual;

834: FROM dual;
835:
836: SELECT instr(soap_respond,'')
837: INTO EndIndex
838: FROM dual;
839:
840: SELECT SUBSTR(soap_respond,StartIndex+12,EndIndex-(StartIndex+12))
841: INTO returnStr
842: FROM dual;

Line 842: FROM dual;

838: FROM dual;
839:
840: SELECT SUBSTR(soap_respond,StartIndex+12,EndIndex-(StartIndex+12))
841: INTO returnStr
842: FROM dual;
843:
844: SELECT instr(returnStr,'#')
845: INTO StartIndex
846: FROM dual;

Line 846: FROM dual;

842: FROM dual;
843:
844: SELECT instr(returnStr,'#')
845: INTO StartIndex
846: FROM dual;
847:
848: SELECT SUBSTR(returnStr,0,StartIndex-1)
849: INTO SessionNum
850: FROM dual;

Line 850: FROM dual;

846: FROM dual;
847:
848: SELECT SUBSTR(returnStr,0,StartIndex-1)
849: INTO SessionNum
850: FROM dual;
851:
852: SELECT SUBSTR(returnStr,StartIndex+1,1800)
853: INTO ErrMessage
854: FROM dual;

Line 854: FROM dual;

850: FROM dual;
851:
852: SELECT SUBSTR(returnStr,StartIndex+1,1800)
853: INTO ErrMessage
854: FROM dual;
855:
856: IF SessionNum = '-1' THEN
857: finalreturnStr:= 'ODI Scenario:'
858: ||'LOADPARAMETERSDATATOWORKREPPKG'

Line 901: FROM dual;

897: utl_http.read_text(http_resp, soap_respond);
898: utl_http.end_response(http_resp);
899: SELECT instr(soap_respond,'')
900: INTO StartIndex
901: FROM dual;
902:
903: SELECT instr(soap_respond,'')
904: INTO EndIndex
905: FROM dual;

Line 905: FROM dual;

901: FROM dual;
902:
903: SELECT instr(soap_respond,'')
904: INTO EndIndex
905: FROM dual;
906:
907: SELECT SUBSTR(soap_respond,StartIndex+12,EndIndex-(StartIndex+12))
908: INTO returnStr
909: FROM dual;

Line 909: FROM dual;

905: FROM dual;
906:
907: SELECT SUBSTR(soap_respond,StartIndex+12,EndIndex-(StartIndex+12))
908: INTO returnStr
909: FROM dual;
910:
911: SELECT instr(returnStr,'#')
912: INTO StartIndex
913: FROM dual;

Line 913: FROM dual;

909: FROM dual;
910:
911: SELECT instr(returnStr,'#')
912: INTO StartIndex
913: FROM dual;
914:
915: SELECT SUBSTR(returnStr,0,StartIndex-1)
916: INTO SessionNum
917: FROM dual;

Line 917: FROM dual;

913: FROM dual;
914:
915: SELECT SUBSTR(returnStr,0,StartIndex-1)
916: INTO SessionNum
917: FROM dual;
918:
919: SELECT SUBSTR(returnStr,StartIndex+1,1800)
920: INTO ErrMessage
921: FROM dual;

Line 921: FROM dual;

917: FROM dual;
918:
919: SELECT SUBSTR(returnStr,StartIndex+1,1800)
920: INTO ErrMessage
921: FROM dual;
922:
923: IF SessionNum = '-1' THEN
924: finalreturnStr:= 'ODI Scenario:'
925: ||'UPDATEVARIABLE'

Line 970: FROM dual;

966: utl_http.read_text(http_resp, soap_respond);
967: utl_http.end_response(http_resp);
968: SELECT instr(soap_respond,'')
969: INTO StartIndex
970: FROM dual;
971:
972: SELECT instr(soap_respond,'')
973: INTO EndIndex
974: FROM dual;

Line 974: FROM dual;

970: FROM dual;
971:
972: SELECT instr(soap_respond,'')
973: INTO EndIndex
974: FROM dual;
975:
976: SELECT SUBSTR(soap_respond,StartIndex+12,EndIndex-(StartIndex+12))
977: INTO returnStr
978: FROM dual;

Line 978: FROM dual;

974: FROM dual;
975:
976: SELECT SUBSTR(soap_respond,StartIndex+12,EndIndex-(StartIndex+12))
977: INTO returnStr
978: FROM dual;
979:
980: SELECT instr(returnStr,'#')
981: INTO StartIndex
982: FROM dual;

Line 982: FROM dual;

978: FROM dual;
979:
980: SELECT instr(returnStr,'#')
981: INTO StartIndex
982: FROM dual;
983:
984: SELECT SUBSTR(returnStr,0,StartIndex-1)
985: INTO SessionNum
986: FROM dual;

Line 986: FROM dual;

982: FROM dual;
983:
984: SELECT SUBSTR(returnStr,0,StartIndex-1)
985: INTO SessionNum
986: FROM dual;
987:
988: SELECT SUBSTR(returnStr,StartIndex+1,1800)
989: INTO ErrMessage
990: FROM dual;

Line 990: FROM dual;

986: FROM dual;
987:
988: SELECT SUBSTR(returnStr,StartIndex+1,1800)
989: INTO ErrMessage
990: FROM dual;
991:
992: IF SessionNum = '-1' THEN
993: finalreturnStr:= 'ODI Scenario:'
994: ||'SYNCHRONIZE_XML'