DBA Data[Home] [Help]

APPS.RLM_FORECAST_SV dependencies on RLM_DP_SV

Line 17: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,

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: --
21: v_SubGroup_ref t_Cursor_ref;

Line 22: v_SubGroup_rec rlm_dp_sv.t_Group_rec;

18: x_ReturnStatus OUT NOCOPY NUMBER)
19: IS
20: --
21: v_SubGroup_ref t_Cursor_ref;
22: v_SubGroup_rec rlm_dp_sv.t_Group_rec;
23: x_HeaderStatus NUMBER;
24: x_progress VARCHAR2(3) := '010';
25: t_forecast mrp_forecast_interface_pk.t_forecast_interface;
26: empty_designator mrp_forecast_interface_pk.t_forecast_designator;

Line 51: IF NOT rlm_dp_sv.CheckForecast(x_InterfaceHeaderId,x_Group_rec) THEN

47: END IF;
48: --
49: x_ReturnStatus := rlm_core_sv.k_PROC_SUCCESS;
50: --
51: IF NOT rlm_dp_sv.CheckForecast(x_InterfaceHeaderId,x_Group_rec) THEN
52: --
53: IF (l_debug <> -1) THEN
54: rlm_core_sv.dlog(k_DEBUG,'No Forecast processing');
55: END IF;

Line 290: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,

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
294: mrp_forecast_interface_pk.t_forecast_designator,

Line 445: x_Group_rec IN rlm_dp_sv.t_Group_rec)

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';
448:
449: BEGIN

Line 513: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec)

509: FUNCTION FetchGroup
510:
511: ===========================================================================*/
512: FUNCTION FetchGroup(x_Group_ref IN OUT NOCOPY t_Cursor_ref,
513: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec)
514: RETURN BOOLEAN
515: IS
516:
517: x_progress VARCHAR2(3) := '010';

Line 675: FUNCTION LockLines (x_Group_rec IN rlm_dp_sv.t_Group_rec,

671:
672: FUNCTION LockLines
673:
674: ===========================================================================*/
675: FUNCTION LockLines (x_Group_rec IN rlm_dp_sv.t_Group_rec,
676: x_header_id IN NUMBER)
677: RETURN BOOLEAN
678: IS
679: x_progress VARCHAR2(3) := '010';

Line 741: x_Group_rec IN rlm_dp_sv.t_Group_rec,

737:
738: ===========================================================================*/
739: PROCEDURE UpdateGroupStatus( x_header_id IN NUMBER,
740: x_ScheduleHeaderId IN NUMBER,
741: x_Group_rec IN rlm_dp_sv.t_Group_rec,
742: x_status IN NUMBER,
743: x_UpdateLevel IN VARCHAR2)
744: IS
745: x_progress VARCHAR2(3) := '010';

Line 892: x_Group_rec IN rlm_dp_sv.t_Group_rec,

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)
896: IS

Line 1303: x_Group_rec IN rlm_dp_sv.t_Group_rec,

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:
1307: v_Result NUMBER;

Line 1414: x_Group_rec IN rlm_dp_sv.t_Group_rec DEFAULT NULL,

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,
1418: x_bill_site_id IN NUMBER,

Line 1735: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,

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
1739: mrp_forecast_interface_pk.t_forecast_designator,

Line 1834: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,

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

Line 1962: x_group_rec IN rlm_dp_sv.t_Group_rec DEFAULT NULL,

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,
1966: x_inter_ship_to_ece_locn_code OUT NOCOPY VARCHAR2,