DBA Data[Home] [Help]

APPS.RLM_EXTINTERFACE_SV dependencies on RLM_SCHEDULE_LINES

Line 302: UPDATE rlm_schedule_lines_all

298: END IF;
299: --
300: IF l_oe_line_tbl_out(s).return_status <> FND_API.G_RET_STS_SUCCESS THEN
301: --
302: UPDATE rlm_schedule_lines_all
303: SET process_status = rlm_core_sv.k_PS_ERROR
304: WHERE line_id = l_oe_line_tbl_out(s).source_document_line_id;
305: --
306: BEGIN

Line 313: FROM rlm_schedule_lines_all

309: SET process_status = rlm_core_sv.k_PS_ERROR
310: WHERE line_id =
311: (
312: SELECT interface_line_id
313: FROM rlm_schedule_lines_all
314: WHERE line_id = l_oe_line_tbl_out(s).source_document_line_id
315: );
316: --
317: IF (l_debug <> -1) THEN

Line 334: UPDATE rlm_schedule_lines_all

330: END;
331: --
332: ELSE
333: --
334: UPDATE rlm_schedule_lines_all
335: SET process_status = rlm_core_sv.k_PS_PROCESSED
336: WHERE line_id = l_oe_line_tbl_out(s).source_document_line_id;
337: --
338: BEGIN

Line 345: FROM rlm_schedule_lines_all

341: SET process_status = rlm_core_sv.k_PS_PROCESSED
342: WHERE line_id =
343: (
344: SELECT interface_line_id
345: FROM rlm_schedule_lines_all
346: WHERE line_id = l_oe_line_tbl_out(s).source_document_line_id
347: );
348: --
349: IF (l_debug <> -1) THEN

Line 517: FROM rlm_schedule_lines

513: BEGIN
514: --
515: SELECT interface_line_id, header_id, order_header_id, industry_attribute2
516: INTO v_interface_line_id, v_schedule_header_id, v_order_header_id, v_request_date
517: FROM rlm_schedule_lines
518: WHERE line_id = l_source_document_line_id;
519: --
520: IF (l_debug <> -1) THEN
521: rlm_core_sv.dlog(k_DEBUG,'interface line',v_interface_line_id);