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 295: update rlm_interface_lines

291: IF (l_debug <> -1) THEN
292: rlm_core_sv.dlog(C_DEBUG,' No of headers updated:', SQL%ROWCOUNT);
293: END IF;
294: --
295: update rlm_interface_lines
296: set process_status = rlm_core_sv.k_PS_AVAILABLE,
297: dsp_child_process_index = NULL
298: where header_id = v_header_id
299: and process_status = rlm_core_sv.k_PS_ERROR;

Line 309: from rlm_interface_lines ril

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)
311: or exception_level = 'E');
312: --Bugfix 6453415 End
313: --

Line 802: DELETE FROM RLM_INTERFACE_LINES

798: and process_Status = rlm_core_sv.k_PS_PROCESSED;
799: --
800: IF(v_process_status <> rlm_core_sv.k_PS_PARTIAL_PROCESSED) THEN
801: --
802: DELETE FROM RLM_INTERFACE_LINES
803: WHERE header_id = x_header_id
804: and process_Status = rlm_core_sv.k_PS_PROCESSED;
805: --
806: ELSE

Line 808: DELETE FROM RLM_INTERFACE_LINES

804: and process_Status = rlm_core_sv.k_PS_PROCESSED;
805: --
806: ELSE
807: --
808: DELETE FROM RLM_INTERFACE_LINES
809: WHERE header_id = x_header_id
810: and process_Status = rlm_core_sv.k_PS_PROCESSED
811: and item_detail_type <> rlm_rd_sv.k_MRP_FORECAST;
812: --

Line 972: UPDATE rlm_interface_lines

968: END IF;
969: --
970: IF x_UpdateLevel <> 'GROUP' THEN
971: --
972: UPDATE rlm_interface_lines
973: SET process_status = x_Status,
974: LAST_UPDATE_LOGIN = v_login_id ,
975: REQUEST_ID = v_request_id,
976: PROGRAM_APPLICATION_ID = v_program_app_id,

Line 998: FROM rlm_interface_lines_all il

994: WHERE sl.header_id = v_SchedHeaderId
995: AND process_status <> rlm_core_sv.k_PS_ERROR -- bug 5134706
996: AND interface_line_id in
997: (SELECT line_id
998: FROM rlm_interface_lines_all il
999: WHERE il.header_id = x_header_id);
1000: --
1001: IF (l_debug <> -1) THEN
1002: rlm_core_sv.dlog(C_DEBUG,'No of Schedule Lines Updated ', SQL%ROWCOUNT);

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

1007: IF (l_debug <> -1) THEN
1008: rlm_core_sv.dlog(C_DEBUG,'Update Group');
1009: END IF;
1010: --
1011: -- JAUTOMO: Update rlm_schedule_lines first before rlm_interface_lines
1012: --
1013: UPDATE rlm_schedule_lines sch
1014: SET process_status = x_Status,
1015: LAST_UPDATE_LOGIN = v_login_id ,

Line 1023: FROM rlm_interface_lines_all il

1019: PROGRAM_UPDATE_DATE = v_program_update_date
1020: WHERE header_id = v_SchedHeaderId
1021: AND interface_line_id in
1022: (SELECT line_id
1023: FROM rlm_interface_lines_all il
1024: WHERE header_id = x_header_id
1025: AND industry_attribute15 = x_Group_rec.industry_attribute15
1026: AND ship_to_org_id = x_Group_rec.ship_to_org_id
1027: AND customer_item_id = x_Group_rec.customer_item_id

Line 1037: UPDATE rlm_interface_lines

1033: IF (l_debug <> -1) THEN
1034: rlm_core_sv.dlog(C_DEBUG,'No of Schedule Lines Updated ', SQL%ROWCOUNT);
1035: END IF;
1036: --
1037: UPDATE rlm_interface_lines
1038: SET process_status = x_Status,
1039: LAST_UPDATE_LOGIN = v_login_id ,
1040: REQUEST_ID = v_request_id,
1041: PROGRAM_APPLICATION_ID = v_program_app_id,

Line 1121: FROM rlm_interface_lines

1117: -- else partial proc
1118: --
1119: SELECT count(*)
1120: INTO v_tot_recs
1121: FROM rlm_interface_lines
1122: WHERE header_id = x_HeaderId;
1123: --
1124: IF (l_debug <> -1) THEN
1125: rlm_core_sv.dlog(C_DEBUG,'v_tot_recs', v_tot_recs);

Line 1130: FROM rlm_interface_lines

1126: END IF;
1127: --
1128: SELECT count(*)
1129: INTO v_error_recs
1130: FROM rlm_interface_lines
1131: WHERE header_id = x_HeaderId
1132: AND process_status = rlm_core_sv.k_PS_ERROR;
1133: --
1134: IF (l_debug <> -1) THEN

Line 1140: FROM rlm_interface_lines

1136: END IF;
1137: --
1138: SELECT count(*)
1139: INTO v_proc_recs
1140: FROM rlm_interface_lines
1141: WHERE header_id = x_HeaderId
1142: AND process_status = rlm_core_sv.k_PS_PROCESSED;
1143: --
1144: IF (l_debug <> -1) THEN

Line 1374: FROM rlm_interface_lines

1370: END IF;
1371: --
1372: --
1373: SELECT count(*) into v_Count
1374: FROM rlm_interface_lines
1375: WHERE header_id = x_header_id
1376: AND industry_attribute15 = x_Group_rec.industry_attribute15
1377: AND ship_to_org_id = x_Group_rec.ship_to_org_id
1378: AND customer_item_id = x_Group_rec.customer_item_id

Line 1427: rlm_interface_lines_all ril

1423: CURSOR c_group_cur IS
1424: SELECT ril.order_header_id,
1425: ril.blanket_number
1426: FROM rlm_interface_headers rih,
1427: rlm_interface_lines_all ril
1428: WHERE ril.header_id = x_header_id
1429: AND ril.header_id = rih.header_id
1430: AND ril.process_status in ( rlm_core_sv.k_PS_AVAILABLE,
1431: rlm_core_sv.k_PS_PARTIAL_PROCESSED)

Line 1463: update rlm_interface_lines

1459: EXIT WHEN c_group_cur%NOTFOUND;
1460: --
1461: v_group_count:=v_group_count+1;
1462: --
1463: update rlm_interface_lines
1464: set dsp_child_process_index = v_index
1465: where header_id = x_header_id
1466: and nvl(order_header_id,-99) = nvl(v_Group_rec.order_header_id,-99)
1467: and nvl(blanket_number,-99) = nvl(v_Group_rec.blanket_number,-99);

Line 1641: update rlm_interface_lines

1637: END IF;
1638: --
1639: IF(upper(v_reqstatus) <> 'NORMAL') THEN
1640: --
1641: update rlm_interface_lines
1642: set process_status= rlm_core_sv.k_PS_ERROR
1643: where header_id = x_header_id
1644: and dsp_child_process_index = i
1645: and process_status <> rlm_core_sv.k_PS_PROCESSED;

Line 1656: from rlm_interface_lines_all il

1652: update rlm_schedule_lines sch
1653: set process_status = rlm_core_sv.k_PS_ERROR
1654: where interface_line_id in
1655: (select line_id
1656: from rlm_interface_lines_all il
1657: where header_id = x_header_id
1658: and dsp_child_process_index = i
1659: and process_status <> rlm_core_sv.k_PS_PROCESSED);
1660: --

Line 1781: update rlm_interface_lines

1777: WHEN OTHERS THEN
1778: --
1779: retcode := 2;
1780: --
1781: update rlm_interface_lines
1782: set process_status = rlm_core_sv.k_PS_ERROR
1783: where header_id = p_header_id
1784: and dsp_child_process_index = p_index;
1785: --

Line 1790: from rlm_interface_lines_all il

1786: update rlm_schedule_lines sch
1787: set process_status = rlm_core_sv.k_PS_ERROR
1788: where interface_line_id in
1789: (select line_id
1790: from rlm_interface_lines_all il
1791: where header_id = p_header_id
1792: and dsp_child_process_index = p_index);
1793: --
1794: COMMIT;

Line 1858: rlm_interface_lines_all ril

1854: ril.blanket_number,
1855: min(ril.start_date_time),
1856: ril.ship_to_customer_id
1857: FROM rlm_interface_headers rih,
1858: rlm_interface_lines_all ril
1859: WHERE ril.header_id = p_header_id
1860: AND ril.header_id = rih.header_id
1861: AND nvl(ril.dsp_child_process_index,-99) =nvl(p_index, -99)
1862: AND ril.process_status in ( rlm_core_sv.k_PS_AVAILABLE,