APPS.RLM_DP_SV dependencies on RLM_SCHEDULE_LINES

Line 994: UPDATE rlm_schedule_lines sl

990: IF (l_debug <> -1) THEN
991: rlm_core_sv.dlog(C_DEBUG,'No of interface Lines Updated ', SQL%ROWCOUNT);
992: END IF;
993:
994: UPDATE rlm_schedule_lines sl
995: SET process_status = x_Status,
996: LAST_UPDATE_LOGIN = v_login_id ,
997: REQUEST_ID = v_request_id,
998: PROGRAM_APPLICATION_ID = v_program_app_id,

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 1020: UPDATE rlm_schedule_lines sch

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 ,
1023: REQUEST_ID = v_request_id,
1024: PROGRAM_APPLICATION_ID = v_program_app_id,

Line 1157: FROM rlm_schedule_lines

1153: END IF;
1154: --
1155: SELECT COUNT(1)
1156: INTO v_proc_sch
1157: FROM rlm_schedule_lines
1158: WHERE process_status = rlm_core_sv.k_PS_PROCESSED
1159: AND header_id = v_SchedHeaderId;
1160: --
1161: IF (l_debug <> -1) THEN

Line 1659: update rlm_schedule_lines sch

1655: rlm_core_sv.dlog(C_DEBUG,'x_header_id', x_header_id);
1656: rlm_core_sv.dlog(C_DEBUG,'No of interface Lines Updated', SQL%ROWCOUNT);
1657: END IF;
1658: --
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

Line 1793: update rlm_schedule_lines sch

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: --
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