DBA Data[Home] [Help]

APPS.RLM_FORECAST_SV dependencies on MRP_FORECAST_INTERFACE_PK

Line 24: t_forecast mrp_forecast_interface_pk.t_forecast_interface;

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;
26: empty_forecast mrp_forecast_interface_pk.t_forecast_interface;
27: t_designator mrp_forecast_interface_pk.t_forecast_designator;
28: e_forecastapifailed EXCEPTION;

Line 25: empty_designator mrp_forecast_interface_pk.t_forecast_designator;

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;
26: empty_forecast mrp_forecast_interface_pk.t_forecast_interface;
27: t_designator mrp_forecast_interface_pk.t_forecast_designator;
28: e_forecastapifailed EXCEPTION;
29: e_lines_locked EXCEPTION;

Line 26: empty_forecast mrp_forecast_interface_pk.t_forecast_interface;

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;
26: empty_forecast mrp_forecast_interface_pk.t_forecast_interface;
27: t_designator mrp_forecast_interface_pk.t_forecast_designator;
28: e_forecastapifailed EXCEPTION;
29: e_lines_locked EXCEPTION;
30: e_no_forecast EXCEPTION;

Line 27: t_designator mrp_forecast_interface_pk.t_forecast_designator;

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;
26: empty_forecast mrp_forecast_interface_pk.t_forecast_interface;
27: t_designator mrp_forecast_interface_pk.t_forecast_designator;
28: e_forecastapifailed EXCEPTION;
29: e_lines_locked EXCEPTION;
30: e_no_forecast EXCEPTION;
31: v_last NUMBER;

Line 116: rlm_core_sv.dlog(k_DEBUG,'before mrp_forecast_interface_pk api');

112: CLOSE v_SubGroup_ref;
113:
114: IF (l_debug <> -1) THEN
115: --
116: rlm_core_sv.dlog(k_DEBUG,'before mrp_forecast_interface_pk api');
117: --
118: END IF;
119:
120: IF mrp_forecast_interface_pk.mrp_forecast_interface(t_forecast,

Line 120: IF mrp_forecast_interface_pk.mrp_forecast_interface(t_forecast,

116: rlm_core_sv.dlog(k_DEBUG,'before mrp_forecast_interface_pk api');
117: --
118: END IF;
119:
120: IF mrp_forecast_interface_pk.mrp_forecast_interface(t_forecast,
121: t_designator) THEN
122: IF (l_debug <> -1) THEN
123: --
124: rlm_core_sv.dlog(k_DEBUG,'after mrp_forecast_interface_pk.

Line 124: rlm_core_sv.dlog(k_DEBUG,'after mrp_forecast_interface_pk.

120: IF mrp_forecast_interface_pk.mrp_forecast_interface(t_forecast,
121: t_designator) THEN
122: IF (l_debug <> -1) THEN
123: --
124: rlm_core_sv.dlog(k_DEBUG,'after mrp_forecast_interface_pk.
125: mrp_forecast_interface api');
126: --
127: END IF;
128:

Line 275: mrp_forecast_interface_pk.t_forecast_interface,

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,
278: x_ReturnStatus OUT NOCOPY NUMBER)
279: IS

Line 277: mrp_forecast_interface_pk.t_forecast_designator,

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,
278: x_ReturnStatus OUT NOCOPY NUMBER)
279: IS
280: --
281: v_forecast_designator mrp_forecast_designators.forecast_designator%TYPE;

Line 838: t_forecast IN OUT NOCOPY mrp_forecast_interface_pk.t_forecast_interface)

834:
835: ===========================================================================*/
836:
837: PROCEDURE initialize_table(
838: t_forecast IN OUT NOCOPY mrp_forecast_interface_pk.t_forecast_interface)
839: IS
840: --
841: x_progress number :='010';
842: --

Line 876: t_forecast IN OUT NOCOPY mrp_forecast_interface_pk.t_forecast_interface,

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

Line 1285: t_Forecast IN mrp_forecast_interface_pk.t_forecast_interface)

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;
1289: v_ProcessStatus NUMBER := 5;

Line 1702: mrp_forecast_interface_pk.t_forecast_interface,

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,
1705: x_t_designator IN OUT NOCOPY
1706: mrp_forecast_interface_pk.t_forecast_designator)

Line 1704: mrp_forecast_interface_pk.t_forecast_designator,

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,
1705: x_t_designator IN OUT NOCOPY
1706: mrp_forecast_interface_pk.t_forecast_designator)
1707: IS
1708: --

Line 1706: mrp_forecast_interface_pk.t_forecast_designator)

1702: mrp_forecast_interface_pk.t_forecast_interface,
1703: x_designator IN OUT NOCOPY
1704: mrp_forecast_interface_pk.t_forecast_designator,
1705: x_t_designator IN OUT NOCOPY
1706: mrp_forecast_interface_pk.t_forecast_designator)
1707: IS
1708: --
1709: x_progress VARCHAR2(3) := '010';
1710: v_InterfaceLineId NUMBER;

Line 1724: rlm_core_sv.dlog(k_DEBUG,'before mrp_forecast_interface_pk api for REPLACE');

1720: x_designator(1).forecast_designator := x_t_designator(x_t_designator.COUNT).forecast_designator;
1721: x_designator(1).organization_id:=x_t_designator(x_t_designator.COUNT).organization_id;
1722: --
1723: IF (l_debug <> -1) THEN
1724: rlm_core_sv.dlog(k_DEBUG,'before mrp_forecast_interface_pk api for REPLACE');
1725: END IF;
1726: --
1727: IF mrp_forecast_interface_pk.mrp_forecast_interface(x_forecast,
1728: x_designator) THEN

Line 1727: IF mrp_forecast_interface_pk.mrp_forecast_interface(x_forecast,

1723: IF (l_debug <> -1) THEN
1724: rlm_core_sv.dlog(k_DEBUG,'before mrp_forecast_interface_pk api for REPLACE');
1725: END IF;
1726: --
1727: IF mrp_forecast_interface_pk.mrp_forecast_interface(x_forecast,
1728: x_designator) THEN
1729: --
1730: g_designator_tab(g_designator_tab.count+1).designator :=
1731: x_t_designator(x_t_designator.COUNT).forecast_designator;

Line 1735: rlm_core_sv.dlog(k_DEBUG,'after mrp_forecast_interface_pk.mrp_forecast_interface api for REPLACE');

1731: x_t_designator(x_t_designator.COUNT).forecast_designator;
1732: g_designator_tab(g_designator_tab.count+1).organization_id :=
1733: x_t_designator(x_t_designator.COUNT).organization_id; --Bugfix 6817494
1734: IF (l_debug <> -1) THEN
1735: rlm_core_sv.dlog(k_DEBUG,'after mrp_forecast_interface_pk.mrp_forecast_interface api for REPLACE');
1736: rlm_core_sv.dlog(k_DEBUG,'Old forecast deleted for ', x_designator(1).forecast_designator);
1737: END IF;
1738:
1739: ELSE

Line 1800: x_designator IN OUT NOCOPY mrp_forecast_interface_pk.t_forecast_designator)

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: --
1804: t_forecast mrp_forecast_interface_pk.t_forecast_interface;

Line 1804: t_forecast mrp_forecast_interface_pk.t_forecast_interface;

1800: x_designator IN OUT NOCOPY mrp_forecast_interface_pk.t_forecast_designator)
1801:
1802: IS
1803: --
1804: t_forecast mrp_forecast_interface_pk.t_forecast_interface;
1805: empty_designator mrp_forecast_interface_pk.t_forecast_designator;
1806: empty_forecast mrp_forecast_interface_pk.t_forecast_interface;
1807: v_last NUMBER;
1808: v_counter NUMBER;

Line 1805: empty_designator mrp_forecast_interface_pk.t_forecast_designator;

1801:
1802: IS
1803: --
1804: t_forecast mrp_forecast_interface_pk.t_forecast_interface;
1805: empty_designator mrp_forecast_interface_pk.t_forecast_designator;
1806: empty_forecast mrp_forecast_interface_pk.t_forecast_interface;
1807: v_last NUMBER;
1808: v_counter NUMBER;
1809: v_mrp_count NUMBER:=0;

Line 1806: empty_forecast mrp_forecast_interface_pk.t_forecast_interface;

1802: IS
1803: --
1804: t_forecast mrp_forecast_interface_pk.t_forecast_interface;
1805: empty_designator mrp_forecast_interface_pk.t_forecast_designator;
1806: empty_forecast mrp_forecast_interface_pk.t_forecast_interface;
1807: v_last NUMBER;
1808: v_counter NUMBER;
1809: v_mrp_count NUMBER:=0;
1810: v_designator VARCHAR2(10);