APPS.RLM_AD_SV dependencies on RLM_INTERFACE_HEADERS_ALL

Line 20: v_HdrRec RLM_INTERFACE_HEADERS_ALL%ROWTYPE;

16: --
17: v_RlmScheduleId number;
18: x_progress number;
19: e_NullOrgIDHdr EXCEPTION;
20: v_HdrRec RLM_INTERFACE_HEADERS_ALL%ROWTYPE;
21: --
22: CURSOR c_Hdr IS
23: SELECT *
24: FROM rlm_interface_headers_all

Line 24: FROM rlm_interface_headers_all

20: v_HdrRec RLM_INTERFACE_HEADERS_ALL%ROWTYPE;
21: --
22: CURSOR c_Hdr IS
23: SELECT *
24: FROM rlm_interface_headers_all
25: WHERE header_id = x_InterfaceHeaderId
26: AND process_status IN (rlm_core_sv.k_PS_AVAILABLE,
27: rlm_core_sv.k_PS_PARTIAL_PROCESSED);
28: --

Line 48: UPDATE rlm_interface_headers_all

44: END IF;
45: --
46: x_RlmScheduleId := v_RlmScheduleId;
47: --
48: UPDATE rlm_interface_headers_all
49: SET schedule_header_id = v_RlmScheduleId
50: WHERE header_id = x_InterfaceHeaderId
51: AND process_status IN (rlm_core_sv.k_PS_AVAILABLE,
52: rlm_core_sv.k_PS_PARTIAL_PROCESSED);

Line 962: FROM rlm_interface_headers_all

958: CURSOR c_cur IS
959: SELECT schedule_header_id,
960: edi_test_indicator,
961: process_status
962: FROM rlm_interface_headers_all
963: WHERE header_id = x_InterfaceHeaderId;
964:
965: BEGIN
966: --

Line 1060: UPDATE rlm_interface_headers_all

1056: IF (l_debug <> -1) THEN
1057: rlm_core_sv.dlog(C_SDEBUG, 'No of Records Updated in schedule lines for test',SQL%ROWCOUNT);
1058: END IF;
1059: --
1060: UPDATE rlm_interface_headers_all
1061: SET process_status = rlm_core_sv.k_PS_PROCESSED
1062: WHERE header_id = x_InterfaceHeaderId
1063: AND process_status = rlm_core_sv.k_PS_AVAILABLE;
1064: --