APPS.WSH_ITM_OVERRIDE dependencies on WSH_ITM_RESPONSE_HEADERS

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

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

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

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

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

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