APPS.RLM_DP_SV dependencies on RLM_DEMAND_EXCEPTIONS

Line 306: delete from rlm_demand_exceptions rde

302: rlm_core_sv.dlog(C_DEBUG,' No of lines updated:', SQL%ROWCOUNT);
303: END IF;
304: --
305: --Bugfix 6453415 Start <>
306: delete from rlm_demand_exceptions rde
307: where rde.interface_header_id = v_header_id
308: and (rde.interface_line_id in (select ril.line_id
309: from rlm_interface_lines ril
310: where ril.header_id = rde.interface_header_id)

Line 319: update rlm_demand_exceptions

315: rlm_core_sv.dlog(C_DEBUG,' No of demand exceptions lines deleted:', SQL%ROWCOUNT);
316: END IF;
317: --
318: --Bugfix 6453415 Start
319: update rlm_demand_exceptions
320: set request_id = rlm_message_sv.g_conc_req_id
321: where interface_header_id = v_header_id;
322: --Bugfix 6453415 End
323: --

Line 1265: from rlm_demand_exceptions

1261: Exception Report. ****/
1262: --
1263: Select count(*)
1264: into x_errors
1265: from rlm_demand_exceptions
1266: where request_id = x_requestid
1267: and exception_level in ('E', 'W', 'I');
1268: --
1269: IF (x_errors > 0) then

Line 1625: update rlm_demand_exceptions

1621: v_devphase,
1622: v_devstatus,
1623: v_reqmessage);
1624: --
1625: update rlm_demand_exceptions
1626: set request_id = RLM_MESSAGE_SV.g_conc_req_id
1627: where request_id = x_child_req_id(i);
1628: --
1629: /* update group status for all lines with child req id*/