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.RLM_DP_SV dependencies on RLM_INTERFACE_LINES

Line 301: update rlm_interface_lines

297: IF (l_debug <> -1) THEN
298: rlm_core_sv.dlog(C_DEBUG,' No of headers updated:', SQL%ROWCOUNT);
299: END IF;
300: --
301: update rlm_interface_lines
302: set process_status = rlm_core_sv.k_PS_AVAILABLE,
303: dsp_child_process_index = NULL
304: where header_id = v_header_id
305: and process_status = rlm_core_sv.k_PS_ERROR;

Line 315: from rlm_interface_lines ril

311: --Bugfix 6453415 Start <>
312: delete from rlm_demand_exceptions rde
313: where rde.interface_header_id = v_header_id
314: and (rde.interface_line_id in (select ril.line_id
315: from rlm_interface_lines ril
316: where ril.header_id = rde.interface_header_id)
317: or exception_level = 'E'
318: or message_name = 'RLM_WARN_DROPPED_ITEMS'); --Bugfix 8844817
319: --Bugfix 6453415 End

Line 809: DELETE FROM RLM_INTERFACE_LINES

805: and process_Status = rlm_core_sv.k_PS_PROCESSED;
806: --
807: IF(v_process_status <> rlm_core_sv.k_PS_PARTIAL_PROCESSED) THEN
808: --
809: DELETE FROM RLM_INTERFACE_LINES
810: WHERE header_id = x_header_id
811: and process_Status = rlm_core_sv.k_PS_PROCESSED;
812: --
813: ELSE

Line 815: DELETE FROM RLM_INTERFACE_LINES

811: and process_Status = rlm_core_sv.k_PS_PROCESSED;
812: --
813: ELSE
814: --
815: DELETE FROM RLM_INTERFACE_LINES
816: WHERE header_id = x_header_id
817: and process_Status = rlm_core_sv.k_PS_PROCESSED
818: and item_detail_type <> rlm_rd_sv.k_MRP_FORECAST;
819: --

Line 979: UPDATE rlm_interface_lines

975: END IF;
976: --
977: IF x_UpdateLevel <> 'GROUP' THEN
978: --
979: UPDATE rlm_interface_lines
980: SET process_status = x_Status,
981: LAST_UPDATE_LOGIN = v_login_id ,
982: REQUEST_ID = v_request_id,
983: PROGRAM_APPLICATION_ID = v_program_app_id,

Line 1005: FROM rlm_interface_lines_all il

1001: WHERE sl.header_id = v_SchedHeaderId
1002: AND process_status <> rlm_core_sv.k_PS_ERROR -- bug 5134706
1003: AND interface_line_id in
1004: (SELECT line_id
1005: FROM rlm_interface_lines_all il
1006: WHERE il.header_id = x_header_id);
1007: --
1008: IF (l_debug <> -1) THEN
1009: rlm_core_sv.dlog(C_DEBUG,'No of Schedule Lines Updated ', SQL%ROWCOUNT);

Line 1018: -- JAUTOMO: Update rlm_schedule_lines first before rlm_interface_lines

1014: IF (l_debug <> -1) THEN
1015: rlm_core_sv.dlog(C_DEBUG,'Update Group');
1016: END IF;
1017: --
1018: -- JAUTOMO: Update rlm_schedule_lines first before rlm_interface_lines
1019: --
1020: UPDATE rlm_schedule_lines sch
1021: SET process_status = x_Status,
1022: LAST_UPDATE_LOGIN = v_login_id ,

Line 1030: FROM rlm_interface_lines_all il

1026: PROGRAM_UPDATE_DATE = v_program_update_date
1027: WHERE header_id = v_SchedHeaderId
1028: AND interface_line_id in
1029: (SELECT /*+ unnest */ line_id --Bugfix 12863728
1030: FROM rlm_interface_lines_all il
1031: WHERE header_id = x_header_id
1032: AND industry_attribute15 = x_Group_rec.industry_attribute15
1033: AND ship_to_org_id = x_Group_rec.ship_to_org_id
1034: AND customer_item_id = x_Group_rec.customer_item_id

Line 1044: UPDATE rlm_interface_lines

1040: IF (l_debug <> -1) THEN
1041: rlm_core_sv.dlog(C_DEBUG,'No of Schedule Lines Updated ', SQL%ROWCOUNT);
1042: END IF;
1043: --
1044: UPDATE rlm_interface_lines
1045: SET process_status = x_Status,
1046: LAST_UPDATE_LOGIN = v_login_id ,
1047: REQUEST_ID = v_request_id,
1048: PROGRAM_APPLICATION_ID = v_program_app_id,

Line 1128: FROM rlm_interface_lines

1124: -- else partial proc
1125: --
1126: SELECT count(*)
1127: INTO v_tot_recs
1128: FROM rlm_interface_lines
1129: WHERE header_id = x_HeaderId;
1130: --
1131: IF (l_debug <> -1) THEN
1132: rlm_core_sv.dlog(C_DEBUG,'v_tot_recs', v_tot_recs);

Line 1137: FROM rlm_interface_lines

1133: END IF;
1134: --
1135: SELECT count(*)
1136: INTO v_error_recs
1137: FROM rlm_interface_lines
1138: WHERE header_id = x_HeaderId
1139: AND process_status = rlm_core_sv.k_PS_ERROR;
1140: --
1141: IF (l_debug <> -1) THEN

Line 1147: FROM rlm_interface_lines

1143: END IF;
1144: --
1145: SELECT count(*)
1146: INTO v_proc_recs
1147: FROM rlm_interface_lines
1148: WHERE header_id = x_HeaderId
1149: AND process_status = rlm_core_sv.k_PS_PROCESSED;
1150: --
1151: IF (l_debug <> -1) THEN

Line 1381: FROM rlm_interface_lines

1377: END IF;
1378: --
1379: --
1380: SELECT count(*) into v_Count
1381: FROM rlm_interface_lines
1382: WHERE header_id = x_header_id
1383: AND industry_attribute15 = x_Group_rec.industry_attribute15
1384: AND ship_to_org_id = x_Group_rec.ship_to_org_id
1385: AND customer_item_id = x_Group_rec.customer_item_id

Line 1434: rlm_interface_lines_all ril

1430: CURSOR c_group_cur IS
1431: SELECT ril.order_header_id,
1432: ril.blanket_number
1433: FROM rlm_interface_headers rih,
1434: rlm_interface_lines_all ril
1435: WHERE ril.header_id = x_header_id
1436: AND ril.header_id = rih.header_id
1437: AND ril.process_status in ( rlm_core_sv.k_PS_AVAILABLE,
1438: rlm_core_sv.k_PS_PARTIAL_PROCESSED)

Line 1470: update rlm_interface_lines

1466: EXIT WHEN c_group_cur%NOTFOUND;
1467: --
1468: v_group_count:=v_group_count+1;
1469: --
1470: update rlm_interface_lines
1471: set dsp_child_process_index = v_index
1472: where header_id = x_header_id
1473: and nvl(order_header_id,-99) = nvl(v_Group_rec.order_header_id,-99)
1474: and nvl(blanket_number,-99) = nvl(v_Group_rec.blanket_number,-99);

Line 1648: update rlm_interface_lines

1644: END IF;
1645: --
1646: IF(upper(v_reqstatus) <> 'NORMAL') THEN
1647: --
1648: update rlm_interface_lines
1649: set process_status= rlm_core_sv.k_PS_ERROR
1650: where header_id = x_header_id
1651: and dsp_child_process_index = i
1652: and process_status <> rlm_core_sv.k_PS_PROCESSED;

Line 1663: from rlm_interface_lines_all il

1659: update rlm_schedule_lines sch
1660: set process_status = rlm_core_sv.k_PS_ERROR
1661: where interface_line_id in
1662: (select line_id
1663: from rlm_interface_lines_all il
1664: where header_id = x_header_id
1665: and dsp_child_process_index = i
1666: and process_status <> rlm_core_sv.k_PS_PROCESSED);
1667: --

Line 1788: update rlm_interface_lines

1784: WHEN OTHERS THEN
1785: --
1786: retcode := 2;
1787: --
1788: update rlm_interface_lines
1789: set process_status = rlm_core_sv.k_PS_ERROR
1790: where header_id = p_header_id
1791: and dsp_child_process_index = p_index;
1792: --

Line 1797: from rlm_interface_lines_all il

1793: update rlm_schedule_lines sch
1794: set process_status = rlm_core_sv.k_PS_ERROR
1795: where interface_line_id in
1796: (select line_id
1797: from rlm_interface_lines_all il
1798: where header_id = p_header_id
1799: and dsp_child_process_index = p_index);
1800: --
1801: COMMIT;

Line 1865: rlm_interface_lines_all ril

1861: ril.blanket_number,
1862: min(ril.start_date_time),
1863: ril.ship_to_customer_id
1864: FROM rlm_interface_headers rih,
1865: rlm_interface_lines_all ril
1866: WHERE ril.header_id = p_header_id
1867: AND ril.header_id = rih.header_id
1868: AND nvl(ril.dsp_child_process_index,-99) =nvl(p_index, -99)
1869: AND ril.process_status in ( rlm_core_sv.k_PS_AVAILABLE,