DBA Data[Home] [Help]

APPS.RLM_FORECAST_SV dependencies on RLM_DP_SV

Line 16: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,

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

Line 21: v_SubGroup_rec rlm_dp_sv.t_Group_rec;

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

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

42: END IF;
43: --
44: x_ReturnStatus := rlm_core_sv.k_PROC_SUCCESS;
45: --
46: IF NOT rlm_dp_sv.CheckForecast(x_InterfaceHeaderId,x_Group_rec) THEN
47: --
48: IF (l_debug <> -1) THEN
49: rlm_core_sv.dlog(k_DEBUG,'No Forecast processing');
50: END IF;

Line 273: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,

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

Line 428: x_Group_rec IN rlm_dp_sv.t_Group_rec)

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';
431:
432: BEGIN

Line 496: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec)

492: FUNCTION FetchGroup
493:
494: ===========================================================================*/
495: FUNCTION FetchGroup(x_Group_ref IN OUT NOCOPY t_Cursor_ref,
496: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec)
497: RETURN BOOLEAN
498: IS
499:
500: x_progress VARCHAR2(3) := '010';

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

654:
655: FUNCTION LockLines
656:
657: ===========================================================================*/
658: FUNCTION LockLines (x_Group_rec IN rlm_dp_sv.t_Group_rec,
659: x_header_id IN NUMBER)
660: RETURN BOOLEAN
661: IS
662: x_progress VARCHAR2(3) := '010';

Line 724: x_Group_rec IN rlm_dp_sv.t_Group_rec,

720:
721: ===========================================================================*/
722: PROCEDURE UpdateGroupStatus( x_header_id IN NUMBER,
723: x_ScheduleHeaderId IN NUMBER,
724: x_Group_rec IN rlm_dp_sv.t_Group_rec,
725: x_status IN NUMBER,
726: x_UpdateLevel IN VARCHAR2)
727: IS
728: x_progress VARCHAR2(3) := '010';

Line 875: x_Group_rec IN rlm_dp_sv.t_Group_rec,

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

Line 1284: x_Group_rec IN rlm_dp_sv.t_Group_rec,

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

Line 1395: x_Group_rec IN rlm_dp_sv.t_Group_rec DEFAULT NULL,

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

Line 1700: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,

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

Line 1799: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,

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

Line 1927: x_group_rec IN rlm_dp_sv.t_Group_rec DEFAULT NULL,

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