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.WSH_ITM_OVERRIDE dependencies on WSH_ITM_REQUEST_CONTROL

Line 48: FROM WSH_ITM_REQUEST_CONTROL

44: WHERE application_id = appl_id;
45:
46: CURSOR Get_Process_Flag(req_set_id NUMBER) IS
47: SELECT 'x'
48: FROM WSH_ITM_REQUEST_CONTROL
49: WHERE request_set_id = req_set_id
50: AND process_flag not in (1,3);
51:
52:

Line 190: wsh_itm_request_control wrc

186: exception_name,
187: exception_id,status,logged_at_location_id,exception_location_id,delivery_id,delivery_name
188: FROM
189: wsh_exceptions wex,
190: wsh_itm_request_control wrc
191: WHERE
192: wrc.ORIGINAL_SYSTEM_REFERENCE=wex.delivery_id
193: AND wrc.request_control_id = l_request_control_id
194: AND (wex.exception_name LIKE 'WSH_PR%'OR wex.exception_name LIKE 'WSH_SC%' OR wex.exception_name LIKE

Line 287: -- WSH_ITM_REQUEST_CONTROL, WSH_ITM_RESPONSE_HEADERS

283: -- ITM_Launch_Override
284: --
285: -- Purpose
286: -- This procedure selects all the eligible records from the tables
287: -- WSH_ITM_REQUEST_CONTROL, WSH_ITM_RESPONSE_HEADERS
288: -- and WSH_ITM_RESPONSE_LINES for Override.
289: --
290: -- For every record, it first updates the process_flag in the table
291: -- WSH_ITM_REQUEST_CONTROL to 3, meaning OVERRIDE and calls Application

Line 291: -- WSH_ITM_REQUEST_CONTROL to 3, meaning OVERRIDE and calls Application

287: -- WSH_ITM_REQUEST_CONTROL, WSH_ITM_RESPONSE_HEADERS
288: -- and WSH_ITM_RESPONSE_LINES for Override.
289: --
290: -- For every record, it first updates the process_flag in the table
291: -- WSH_ITM_REQUEST_CONTROL to 3, meaning OVERRIDE and calls Application
292: -- specific custom procedure.
293: --
294: -- Arguments
295: -- ERRBUF Required by Concurrent Processing.

Line 361: WSH_ITM_REQUEST_CONTROL wrc,

357: SELECT DISTINCT
358: wrc.request_control_id,
359: wrc.request_set_id
360: FROM
361: WSH_ITM_REQUEST_CONTROL wrc,
362: WSH_ITM_RESPONSE_HEADERS wrh
363:
364: WHERE
365: wrc.response_header_id = wrh.response_header_id

Line 379: WSH_ITM_REQUEST_CONTROL wrc

375: SELECT DISTINCT
376: wrc.request_control_id,
377: wrc.request_set_id
378: FROM
379: WSH_ITM_REQUEST_CONTROL wrc
380: WHERE
381: nvl(wrc.original_system_reference,-99) = nvl(p_reference_id,
382: nvl(wrc.original_system_reference,-99))
383: AND wrc.process_flag in (0,-4);

Line 391: WSH_ITM_REQUEST_CONTROL wrc,

387: SELECT DISTINCT
388: wrc.request_control_id,
389: wrc.request_set_id
390: FROM
391: WSH_ITM_REQUEST_CONTROL wrc,
392: WSH_ITM_SERVICE_PREFERENCES wsp,
393: WSH_ITM_VENDOR_SERVICES wvs
394: WHERE
395: nvl(wrc.original_system_reference,-99) = nvl(p_reference_id,

Line 447: l_sql_string := l_sql_string || 'FROM WSH_ITM_REQUEST_CONTROL wrc ';

443: If p_vendor_id is NULL THEN
444: WSH_UTIL_CORE.println('Start the loop for Get_Unprocessed_Records_1');
445: if p_application_id=660 then
446: l_sql_string := 'SELECT DISTINCT wrc.request_control_id, wrc.request_set_id ';
447: l_sql_string := l_sql_string || 'FROM WSH_ITM_REQUEST_CONTROL wrc ';
448:
449: IF ( p_party_type is NOT NULL or p_party_id is NOT NULL ) THEN
450: l_sql_string := l_sql_string || ' , WSH_ITM_PARTIES wp ';
451: END IF;

Line 522: l_sql_string := l_sql_string || 'FROM WSH_ITM_REQUEST_CONTROL wrc, ';

518: ELSE
519: WSH_UTIL_CORE.println('Start the loop for Get_Unprocessed_Records_2');
520: if p_application_id=660 then
521: l_sql_string := 'SELECT DISTINCT wrc.request_control_id, wrc.request_set_id ';
522: l_sql_string := l_sql_string || 'FROM WSH_ITM_REQUEST_CONTROL wrc, ';
523: l_sql_string := l_sql_string || ' WSH_ITM_SERVICE_PREFERENCES wsp, ';
524: l_sql_string := l_sql_string || ' WSH_ITM_VENDOR_SERVICES wvs ';
525:
526: IF ( p_party_type is NOT NULL or p_party_id is NOT NULL ) THEN

Line 646: update wsh_itm_request_control

642:
643:
644: WSH_UTIL_CORE.println('Updating Process Flag');
645:
646: update wsh_itm_request_control
647: SET process_flag = 3
648: WHERE request_control_id = l_request_control_id;
649:
650: if p_application_id=665 then

Line 711: l_sql_string := l_sql_string || 'FROM WSH_ITM_REQUEST_CONTROL wrc, ';

707: if p_application_id =660 THEN
708: -- {
709: -- Using Dynamic Cursor instead of static cursor for performance.
710: l_sql_string := 'SELECT DISTINCT wrc.request_control_id, wrc.request_set_id ';
711: l_sql_string := l_sql_string || 'FROM WSH_ITM_REQUEST_CONTROL wrc, ';
712: l_sql_string := l_sql_string || ' WSH_ITM_RESPONSE_HEADERS wrh ';
713:
714: IF ( p_party_type is NOT NULL or p_party_id is NOT NULL ) THEN
715: l_sql_string := l_sql_string || ' , WSH_ITM_PARTIES wp ';

Line 758: l_sql_string := l_sql_string || 'FROM WSH_ITM_REQUEST_CONTROL wrc, ';

754: END IF;
755:
756: l_sql_string := l_sql_string || 'UNION ';
757: l_sql_string := l_sql_string || 'SELECT DISTINCT wrc.request_control_id, wrc.request_set_id ';
758: l_sql_string := l_sql_string || 'FROM WSH_ITM_REQUEST_CONTROL wrc, ';
759: l_sql_string := l_sql_string || ' WSH_ITM_RESPONSE_HEADERS wrh, ';
760: l_sql_string := l_sql_string || ' WSH_ITM_RESPONSE_LINES wrl ';
761:
762: IF ( p_party_type is NOT NULL or p_party_id is NOT NULL ) THEN

Line 917: UPDATE wsh_itm_request_control

913:
914:
915: WSH_UTIL_CORE.println('Updating process_flag to 3');
916:
917: UPDATE wsh_itm_request_control
918: SET process_flag = 3
919: WHERE request_control_id = l_request_control_id;
920:
921: IF p_application_id=665 THEN