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 16: x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

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

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

285:
286: PROCEDURE NAME: ManageGroupForecast
287:
288: ===========================================================================*/
289: PROCEDURE ManageGroupForecast(x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
290: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
291: x_forecast IN OUT NOCOPY
292: mrp_forecast_interface_pk.t_forecast_interface,
293: x_designator IN OUT NOCOPY

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

439:
440: PROCEDURE InitializeGroup
441:
442: ===========================================================================*/
443: PROCEDURE InitializeGroup(x_Sched_rec IN rlm_interface_headers%ROWTYPE,
444: x_Group_ref IN OUT NOCOPY rlm_forecast_sv.t_Cursor_ref,
445: x_Group_rec IN rlm_dp_sv.t_Group_rec)
446: IS
447: x_progress VARCHAR2(3) := '010';

Line 466: FROM rlm_interface_headers rih,

462: ril.customer_item_id,
463: ril.inventory_item_id,
464: ril.industry_attribute15,
465: ril.ship_to_customer_id
466: FROM rlm_interface_headers rih,
467: rlm_interface_lines_all ril
468: WHERE rih.header_id = x_Sched_rec.header_id
469: AND ril.header_id = rih.header_id
470: AND ril.industry_attribute15 = x_Group_rec.ship_from_org_id

Line 578: FROM rlm_interface_headers

574: x_progress VARCHAR2(3) := '010';
575:
576: CURSOR c IS
577: SELECT *
578: FROM rlm_interface_headers
579: WHERE header_id = x_header_id
580: AND process_status = rlm_core_sv.k_PS_AVAILABLE
581: FOR UPDATE NOWAIT;
582:

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

583: BEGIN
584: --
585: IF (l_debug <> -1) THEN
586: rlm_core_sv.dpush(k_SDEBUG,'LockHeaders');
587: rlm_core_sv.dlog(k_DEBUG,'Locking RLM_INTERFACE_HEADERS');
588: END IF;
589: --
590: OPEN c;
591: --

Line 643: UPDATE rlm_interface_headers

639: rlm_core_sv.dpush(k_SDEBUG,'UpdateHeaderStatus');
640: rlm_core_sv.dlog(k_DEBUG,'UpdateHeaderStatus to ', x_status);
641: END IF;
642: --
643: UPDATE rlm_interface_headers
644: SET process_status = x_Status
645: WHERE header_id = x_HeaderId;
646: --
647: UPDATE rlm_schedule_headers

Line 891: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

887:
888: ===========================================================================*/
889:
890: PROCEDURE LoadForecast(
891: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
892: x_Group_rec IN rlm_dp_sv.t_Group_rec,
893: t_forecast IN OUT NOCOPY mrp_forecast_interface_pk.t_forecast_interface,
894: x_forecast_designator IN
895: mrp_forecast_designators.forecast_designator%TYPE)

Line 1302: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

1298:
1299: ===========================================================================*/
1300:
1301: PROCEDURE ProcessTable(
1302: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1303: x_Group_rec IN rlm_dp_sv.t_Group_rec,
1304: t_Forecast IN mrp_forecast_interface_pk.t_forecast_interface)
1305: IS
1306:

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

1409: /*=============================================================================
1410: PROCEDURE NAME: get_designator
1411: PURPOSE: Fetches the matching forecast designator
1412: ==============================================================================*/
1413: PROCEDURE GetDesignator( x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE DEFAULT NULL,
1414: x_Group_rec IN rlm_dp_sv.t_Group_rec DEFAULT NULL,
1415: x_Customer_id IN NUMBER,
1416: x_ShipFromOrgId IN NUMBER,
1417: x_Ship_Site_Id IN NUMBER,

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

1730: /*=============================================================================
1731: PROCEDURE NAME: emptyforecast
1732: PURPOSE: Deletes all the forecast for a designator
1733: ==============================================================================*/
1734: PROCEDURE EmptyForecast( x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1735: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
1736: x_forecast IN OUT NOCOPY
1737: mrp_forecast_interface_pk.t_forecast_interface,
1738: x_designator IN OUT NOCOPY

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

1829: --
1830: END EmptyForecast;
1831:
1832:
1833: PROCEDURE ProcessReplaceAll (x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1834: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
1835: x_designator IN OUT NOCOPY mrp_forecast_interface_pk.t_forecast_designator)
1836:
1837: IS

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

1957:
1958: CHANGE HISTORY: created jckwok 12/11/03
1959:
1960: ===========================================================================*/
1961: PROCEDURE GetTPContext( x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE DEFAULT NULL,
1962: x_group_rec IN rlm_dp_sv.t_Group_rec DEFAULT NULL,
1963: x_customer_number OUT NOCOPY VARCHAR2,
1964: x_ship_to_ece_locn_code OUT NOCOPY VARCHAR2,
1965: x_bill_to_ece_locn_code OUT NOCOPY VARCHAR2,