APPS.RLM_DP_SV dependencies on RLM_SCHEDULE_LINES

Line 987: UPDATE rlm_schedule_lines sl

983: IF (l_debug <> -1) THEN
984: rlm_core_sv.dlog(C_DEBUG,'No of interface Lines Updated ', SQL%ROWCOUNT);
985: END IF;
986:
987: UPDATE rlm_schedule_lines sl
988: SET process_status = x_Status,
989: LAST_UPDATE_LOGIN = v_login_id ,
990: REQUEST_ID = v_request_id,
991: PROGRAM_APPLICATION_ID = v_program_app_id,

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

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 ,
1016: REQUEST_ID = v_request_id,
1017: PROGRAM_APPLICATION_ID = v_program_app_id,

Line 1150: FROM rlm_schedule_lines

1146: END IF;
1147: --
1148: SELECT COUNT(1)
1149: INTO v_proc_sch
1150: FROM rlm_schedule_lines
1151: WHERE process_status = rlm_core_sv.k_PS_PROCESSED
1152: AND header_id = v_SchedHeaderId;
1153: --
1154: IF (l_debug <> -1) THEN

Line 1652: update rlm_schedule_lines sch

1648: rlm_core_sv.dlog(C_DEBUG,'x_header_id', x_header_id);
1649: rlm_core_sv.dlog(C_DEBUG,'No of interface Lines Updated', SQL%ROWCOUNT);
1650: END IF;
1651: --
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

Line 1786: update rlm_schedule_lines sch

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