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_HEADERS

Line 57: v_Sched_rec RLM_INTERFACE_HEADERS%ROWTYPE;

53: --
54: TYPE ref_demand_cur IS REF CURSOR;
55: c_demand ref_demand_cur;
56: --
57: v_Sched_rec RLM_INTERFACE_HEADERS%ROWTYPE;
58: v_Group_rec t_Group_rec;
59:
60: l_start_time NUMBER;
61: l_end_time NUMBER;

Line 106: FROM rlm_interface_headers hdr';

102: --
103: IF p_header_id IS NOT NULL THEN
104: --
105: v_from_clause := '
106: FROM rlm_interface_headers hdr';
107: --
108: -- bug 3756599
109: v_where_clause := '
110: WHERE hdr.process_status IN (:k_PS_AVAILABLE, :k_PS_PARTIAL_PROCESSED, :k_PS_ERROR) AND header_id = :p_header_id ';

Line 120: FROM rlm_interface_headers hdr';

116: --
117: ELSE
118: --
119: v_from_clause := '
120: FROM rlm_interface_headers hdr';
121: v_where_clause := '
122: WHERE hdr.process_status IN (:k_PS_AVAILABLE, :k_PS_PARTIAL_PROCESSED, :k_PS_ERROR) ';
123: g_BindVarTab(g_BindVarTab.COUNT+1) := rlm_core_sv.k_PS_AVAILABLE;
124: g_BindVarTab(g_BindVarTab.COUNT+1) := rlm_core_sv.k_PS_PARTIAL_PROCESSED;

Line 287: update rlm_interface_headers_all

283:
284: IF v_header_ps IN (rlm_core_sv.k_PS_ERROR,
285: rlm_core_sv.k_PS_PARTIAL_PROCESSED) THEN
286: --
287: update rlm_interface_headers_all
288: set process_status = rlm_core_sv.k_PS_AVAILABLE
289: where header_id = v_header_id;
290: --
291: IF (l_debug <> -1) THEN

Line 793: from rlm_interface_headers

789: rlm_core_sv.dlog(C_DEBUG, 'x_header_id',x_header_id);
790: END IF;
791: --
792: select process_status into v_process_status
793: from rlm_interface_headers
794: where header_id = x_header_id;
795: --
796: DELETE FROM RLM_INTERFACE_HEADERS
797: WHERE header_id = x_header_id

Line 796: DELETE FROM RLM_INTERFACE_HEADERS

792: select process_status into v_process_status
793: from rlm_interface_headers
794: where header_id = x_header_id;
795: --
796: DELETE FROM RLM_INTERFACE_HEADERS
797: WHERE header_id = x_header_id
798: and process_Status = rlm_core_sv.k_PS_PROCESSED;
799: --
800: IF(v_process_status <> rlm_core_sv.k_PS_PARTIAL_PROCESSED) THEN

Line 849: FUNCTION LockHeader (x_HeaderId IN NUMBER, v_Sched_rec OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE)

845: PROCEDURE NAME: LockHeader
846:
847: ===========================================================================*/
848:
849: FUNCTION LockHeader (x_HeaderId IN NUMBER, v_Sched_rec OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE)
850: RETURN BOOLEAN
851: IS
852: x_progress VARCHAR2(3) := '010';
853:

Line 856: FROM rlm_interface_headers

852: x_progress VARCHAR2(3) := '010';
853:
854: CURSOR c IS
855: SELECT *
856: FROM rlm_interface_headers
857: WHERE header_id = x_HeaderId
858: and process_status IN (rlm_core_sv.k_PS_AVAILABLE,
859: rlm_core_sv.k_PS_PARTIAL_PROCESSED)
860: FOR UPDATE NOWAIT;

Line 866: rlm_core_sv.dlog(C_DEBUG,'Locking RLM_INTERFACE_HEADERS');

862: BEGIN
863: --
864: IF (l_debug <> -1) THEN
865: rlm_core_sv.dpush(C_SDEBUG,'LockHeader');
866: rlm_core_sv.dlog(C_DEBUG,'Locking RLM_INTERFACE_HEADERS');
867: END IF;
868: --
869: OPEN c;
870: FETCH c INTO v_Sched_rec;

Line 963: FROM rlm_interface_headers

959: v_program_id := fnd_global.conc_program_id;
960: --
961: SELECT schedule_header_id
962: INTO v_SchedHeaderId
963: FROM rlm_interface_headers
964: WHERE header_id = x_header_id;
965: --
966: IF (l_debug <> -1) THEN
967: rlm_core_sv.dlog(C_DEBUG, 'v_SchedHeaderId', v_SchedHeaderId);

Line 1107: FROM rlm_interface_headers

1103: END IF;
1104: --
1105: SELECT schedule_header_id
1106: INTO v_SchedHeaderId
1107: FROM rlm_interface_headers
1108: WHERE header_id = x_HeaderId;
1109: --
1110: IF (l_debug <> -1) THEN
1111: rlm_core_sv.dlog(C_DEBUG, 'v_SchedHeaderId', v_SchedHeaderId);

Line 1184: UPDATE rlm_interface_headers

1180: IF (l_debug <> -1) THEN
1181: rlm_core_sv.dlog(C_DEBUG,'x_HeaderStatus', x_HeaderStatus);
1182: END IF;
1183: --
1184: UPDATE rlm_interface_headers
1185: SET process_status = x_HeaderStatus,
1186: LAST_UPDATE_LOGIN = fnd_global.login_id ,
1187: REQUEST_ID = RLM_MESSAGE_SV.g_conc_req_id ,
1188: PROGRAM_APPLICATION_ID = fnd_global.PROG_APPL_ID ,

Line 1426: FROM rlm_interface_headers rih,

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

Line 1702: v_sched_rec rlm_interface_headers%ROWTYPE;

1698: p_org_id IN NUMBER)
1699: IS
1700: --
1701: v_group_rec t_group_rec;
1702: v_sched_rec rlm_interface_headers%ROWTYPE;
1703: e_linesLocked EXCEPTION;
1704: e_MDFailed EXCEPTION;
1705: e_FDFailed EXCEPTION;
1706: e_RDFailed EXCEPTION;

Line 1740: FROM rlm_interface_headers_all

1736: -- populate v_sched_rec
1737: --
1738: SELECT *
1739: INTO v_sched_rec
1740: FROM rlm_interface_headers_all
1741: WHERE header_id = p_header_id
1742: AND process_status IN (rlm_core_sv.k_PS_AVAILABLE,
1743: rlm_core_sv.k_PS_PARTIAL_PROCESSED);
1744: --

Line 1811: PROCEDURE ProcessGroups (p_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

1807: PROCEDURE NAME: ProcessGroups
1808:
1809: ===========================================================================*/
1810:
1811: PROCEDURE ProcessGroups (p_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1812: p_header_id IN NUMBER,
1813: p_index IN NUMBER DEFAULT NULL,
1814: p_dspMode IN VARCHAR2)
1815: IS

Line 1817: v_sched_rec RLM_INTERFACE_HEADERS%ROWTYPE;

1813: p_index IN NUMBER DEFAULT NULL,
1814: p_dspMode IN VARCHAR2)
1815: IS
1816: --
1817: v_sched_rec RLM_INTERFACE_HEADERS%ROWTYPE;
1818: v_Group_rec t_Group_rec;
1819: e_linesLocked EXCEPTION;
1820: e_MDFailed EXCEPTION;
1821: e_FDFailed EXCEPTION;

Line 1857: FROM rlm_interface_headers rih,

1853: ril.order_header_id,
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)