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 207: wsh_itm_request_control wrc

203: exception_name,
204: exception_id,status,logged_at_location_id,exception_location_id,delivery_id,delivery_name
205: FROM
206: wsh_exceptions wex,
207: wsh_itm_request_control wrc
208: WHERE
209: wrc.ORIGINAL_SYSTEM_REFERENCE=wex.delivery_id
210: AND wrc.request_control_id = l_request_control_id
211: AND (wex.exception_name LIKE 'WSH_PR%'OR wex.exception_name LIKE 'WSH_SC%' OR wex.exception_name LIKE

Line 304: -- WSH_ITM_REQUEST_CONTROL, WSH_ITM_RESPONSE_HEADERS

300: -- ITM_Launch_Override
301: --
302: -- Purpose
303: -- This procedure selects all the eligible records from the tables
304: -- WSH_ITM_REQUEST_CONTROL, WSH_ITM_RESPONSE_HEADERS
305: -- and WSH_ITM_RESPONSE_LINES for Override.
306: --
307: -- For every record, it first updates the process_flag in the table
308: -- WSH_ITM_REQUEST_CONTROL to 3, meaning OVERRIDE and calls Application

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

304: -- WSH_ITM_REQUEST_CONTROL, WSH_ITM_RESPONSE_HEADERS
305: -- and WSH_ITM_RESPONSE_LINES for Override.
306: --
307: -- For every record, it first updates the process_flag in the table
308: -- WSH_ITM_REQUEST_CONTROL to 3, meaning OVERRIDE and calls Application
309: -- specific custom procedure.
310: --
311: -- Arguments
312: -- ERRBUF Required by Concurrent Processing.

Line 378: WSH_ITM_REQUEST_CONTROL wrc,

374: SELECT DISTINCT
375: wrc.request_control_id,
376: wrc.request_set_id
377: FROM
378: WSH_ITM_REQUEST_CONTROL wrc,
379: WSH_ITM_RESPONSE_HEADERS wrh
380:
381: WHERE
382: wrc.response_header_id = wrh.response_header_id

Line 396: WSH_ITM_REQUEST_CONTROL wrc

392: SELECT DISTINCT
393: wrc.request_control_id,
394: wrc.request_set_id
395: FROM
396: WSH_ITM_REQUEST_CONTROL wrc
397: WHERE
398: nvl(wrc.original_system_reference,-99) = nvl(p_reference_id,
399: nvl(wrc.original_system_reference,-99))
400: AND wrc.process_flag in (0,-4);

Line 408: WSH_ITM_REQUEST_CONTROL wrc,

404: SELECT DISTINCT
405: wrc.request_control_id,
406: wrc.request_set_id
407: FROM
408: WSH_ITM_REQUEST_CONTROL wrc,
409: WSH_ITM_SERVICE_PREFERENCES wsp,
410: WSH_ITM_VENDOR_SERVICES wvs
411: WHERE
412: nvl(wrc.original_system_reference,-99) = nvl(p_reference_id,

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

460: If p_vendor_id is NULL THEN
461: WSH_UTIL_CORE.println('Start the loop for Get_Unprocessed_Records_1');
462: if p_application_id=660 then
463: l_sql_string := 'SELECT DISTINCT wrc.request_control_id, wrc.request_set_id ';
464: l_sql_string := l_sql_string || 'FROM WSH_ITM_REQUEST_CONTROL wrc ';
465:
466: IF ( p_party_type is NOT NULL or p_party_id is NOT NULL ) THEN
467: l_sql_string := l_sql_string || ' , WSH_ITM_PARTIES wp ';
468: END IF;

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

535: ELSE
536: WSH_UTIL_CORE.println('Start the loop for Get_Unprocessed_Records_2');
537: if p_application_id=660 then
538: l_sql_string := 'SELECT DISTINCT wrc.request_control_id, wrc.request_set_id ';
539: l_sql_string := l_sql_string || 'FROM WSH_ITM_REQUEST_CONTROL wrc, ';
540: l_sql_string := l_sql_string || ' WSH_ITM_SERVICE_PREFERENCES wsp, ';
541: l_sql_string := l_sql_string || ' WSH_ITM_VENDOR_SERVICES wvs ';
542:
543: IF ( p_party_type is NOT NULL or p_party_id is NOT NULL ) THEN

Line 663: update wsh_itm_request_control

659:
660:
661: WSH_UTIL_CORE.println('Updating Process Flag');
662:
663: update wsh_itm_request_control
664: SET process_flag = 3
665: WHERE request_control_id = l_request_control_id;
666:
667: if p_application_id=665 then

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

724: if p_application_id =660 THEN
725: -- {
726: -- Using Dynamic Cursor instead of static cursor for performance.
727: l_sql_string := 'SELECT DISTINCT wrc.request_control_id, wrc.request_set_id ';
728: l_sql_string := l_sql_string || 'FROM WSH_ITM_REQUEST_CONTROL wrc, ';
729: l_sql_string := l_sql_string || ' WSH_ITM_RESPONSE_HEADERS wrh ';
730:
731: IF ( p_party_type is NOT NULL or p_party_id is NOT NULL ) THEN
732: l_sql_string := l_sql_string || ' , WSH_ITM_PARTIES wp ';

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

771: END IF;
772:
773: l_sql_string := l_sql_string || 'UNION ';
774: l_sql_string := l_sql_string || 'SELECT DISTINCT wrc.request_control_id, wrc.request_set_id ';
775: l_sql_string := l_sql_string || 'FROM WSH_ITM_REQUEST_CONTROL wrc, ';
776: l_sql_string := l_sql_string || ' WSH_ITM_RESPONSE_HEADERS wrh, ';
777: l_sql_string := l_sql_string || ' WSH_ITM_RESPONSE_LINES wrl ';
778:
779: IF ( p_party_type is NOT NULL or p_party_id is NOT NULL ) THEN

Line 934: UPDATE wsh_itm_request_control

930:
931:
932: WSH_UTIL_CORE.println('Updating process_flag to 3');
933:
934: UPDATE wsh_itm_request_control
935: SET process_flag = 3
936: WHERE request_control_id = l_request_control_id;
937:
938: IF p_application_id=665 THEN