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_FORECAST_SV dependencies on RLM_INTERFACE_HEADERS

Line 15: x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

11: PROCEDURE NAME: ManageForecast
12:
13: ===========================================================================*/
14: PROCEDURE ManageForecast(x_InterfaceHeaderId IN NUMBER,
15: x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
16: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
17: x_ReturnStatus OUT NOCOPY NUMBER)
18: IS
19: --

Line 272: PROCEDURE ManageGroupForecast(x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

268:
269: PROCEDURE NAME: ManageGroupForecast
270:
271: ===========================================================================*/
272: PROCEDURE ManageGroupForecast(x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
273: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
274: x_forecast IN OUT NOCOPY
275: mrp_forecast_interface_pk.t_forecast_interface,
276: x_designator IN OUT NOCOPY

Line 426: PROCEDURE InitializeGroup(x_Sched_rec IN rlm_interface_headers%ROWTYPE,

422:
423: PROCEDURE InitializeGroup
424:
425: ===========================================================================*/
426: PROCEDURE InitializeGroup(x_Sched_rec IN rlm_interface_headers%ROWTYPE,
427: x_Group_ref IN OUT NOCOPY rlm_forecast_sv.t_Cursor_ref,
428: x_Group_rec IN rlm_dp_sv.t_Group_rec)
429: IS
430: x_progress VARCHAR2(3) := '010';

Line 449: FROM rlm_interface_headers rih,

445: ril.customer_item_id,
446: ril.inventory_item_id,
447: ril.industry_attribute15,
448: ril.ship_to_customer_id
449: FROM rlm_interface_headers rih,
450: rlm_interface_lines_all ril
451: WHERE rih.header_id = x_Sched_rec.header_id
452: AND ril.header_id = rih.header_id
453: AND ril.industry_attribute15 = x_Group_rec.ship_from_org_id

Line 561: FROM rlm_interface_headers

557: x_progress VARCHAR2(3) := '010';
558:
559: CURSOR c IS
560: SELECT *
561: FROM rlm_interface_headers
562: WHERE header_id = x_header_id
563: AND process_status = rlm_core_sv.k_PS_AVAILABLE
564: FOR UPDATE NOWAIT;
565:

Line 570: rlm_core_sv.dlog(k_DEBUG,'Locking RLM_INTERFACE_HEADERS');

566: BEGIN
567: --
568: IF (l_debug <> -1) THEN
569: rlm_core_sv.dpush(k_SDEBUG,'LockHeaders');
570: rlm_core_sv.dlog(k_DEBUG,'Locking RLM_INTERFACE_HEADERS');
571: END IF;
572: --
573: OPEN c;
574: --

Line 626: UPDATE rlm_interface_headers

622: rlm_core_sv.dpush(k_SDEBUG,'UpdateHeaderStatus');
623: rlm_core_sv.dlog(k_DEBUG,'UpdateHeaderStatus to ', x_status);
624: END IF;
625: --
626: UPDATE rlm_interface_headers
627: SET process_status = x_Status
628: WHERE header_id = x_HeaderId;
629: --
630: UPDATE rlm_schedule_headers

Line 874: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

870:
871: ===========================================================================*/
872:
873: PROCEDURE LoadForecast(
874: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
875: x_Group_rec IN rlm_dp_sv.t_Group_rec,
876: t_forecast IN OUT NOCOPY mrp_forecast_interface_pk.t_forecast_interface,
877: x_forecast_designator IN
878: mrp_forecast_designators.forecast_designator%TYPE)

Line 1283: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

1279:
1280: ===========================================================================*/
1281:
1282: PROCEDURE ProcessTable(
1283: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1284: x_Group_rec IN rlm_dp_sv.t_Group_rec,
1285: t_Forecast IN mrp_forecast_interface_pk.t_forecast_interface)
1286: IS
1287:

Line 1394: PROCEDURE GetDesignator( x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE DEFAULT NULL,

1390: /*=============================================================================
1391: PROCEDURE NAME: get_designator
1392: PURPOSE: Fetches the matching forecast designator
1393: ==============================================================================*/
1394: PROCEDURE GetDesignator( x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE DEFAULT NULL,
1395: x_Group_rec IN rlm_dp_sv.t_Group_rec DEFAULT NULL,
1396: x_Customer_id IN NUMBER,
1397: x_ShipFromOrgId IN NUMBER,
1398: x_Ship_Site_Id IN NUMBER,

Line 1699: PROCEDURE EmptyForecast( x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

1695: /*=============================================================================
1696: PROCEDURE NAME: emptyforecast
1697: PURPOSE: Deletes all the forecast for a designator
1698: ==============================================================================*/
1699: PROCEDURE EmptyForecast( x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1700: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
1701: x_forecast IN OUT NOCOPY
1702: mrp_forecast_interface_pk.t_forecast_interface,
1703: x_designator IN OUT NOCOPY

Line 1798: PROCEDURE ProcessReplaceAll (x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

1794: --
1795: END EmptyForecast;
1796:
1797:
1798: PROCEDURE ProcessReplaceAll (x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1799: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
1800: x_designator IN OUT NOCOPY mrp_forecast_interface_pk.t_forecast_designator)
1801:
1802: IS

Line 1926: PROCEDURE GetTPContext( x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE DEFAULT NULL,

1922:
1923: CHANGE HISTORY: created jckwok 12/11/03
1924:
1925: ===========================================================================*/
1926: PROCEDURE GetTPContext( x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE DEFAULT NULL,
1927: x_group_rec IN rlm_dp_sv.t_Group_rec DEFAULT NULL,
1928: x_customer_number OUT NOCOPY VARCHAR2,
1929: x_ship_to_ece_locn_code OUT NOCOPY VARCHAR2,
1930: x_bill_to_ece_locn_code OUT NOCOPY VARCHAR2,