APPS.WSH_ITM_OVERRIDE dependencies on WSH_ITM_RESPONSE_HEADERS

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 379: WSH_ITM_RESPONSE_HEADERS wrh

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
383: AND nvl(wrh.vendor_id,-99) = nvl(p_vendor_id, nvl(wrh.vendor_id,-99))

Line 729: l_sql_string := l_sql_string || ' WSH_ITM_RESPONSE_HEADERS wrh ';

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 ';
733: END IF;

Line 776: l_sql_string := l_sql_string || ' WSH_ITM_RESPONSE_HEADERS wrh, ';

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
780: l_sql_string := l_sql_string || ' , WSH_ITM_PARTIES wp ';