DBA Data[Home] [Help]

APPS.RLM_FORECAST_SV dependencies on MRP_FORECAST_INTERFACE_PK

Line 25: t_forecast mrp_forecast_interface_pk.t_forecast_interface;

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

Line 26: empty_designator mrp_forecast_interface_pk.t_forecast_designator;

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

Line 27: empty_forecast mrp_forecast_interface_pk.t_forecast_interface;

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

Line 28: t_designator mrp_forecast_interface_pk.t_forecast_designator;

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

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

117: CLOSE v_SubGroup_ref;
118:
119: IF (l_debug <> -1) THEN
120: --
121: rlm_core_sv.dlog(k_DEBUG,'before mrp_forecast_interface_pk api');
122: --
123: END IF;
124:
125: SELECT hsecs INTO l_start_time from v$timer; --Bugfix 12863728

Line 127: IF mrp_forecast_interface_pk.mrp_forecast_interface(t_forecast,

123: END IF;
124:
125: SELECT hsecs INTO l_start_time from v$timer; --Bugfix 12863728
126:
127: IF mrp_forecast_interface_pk.mrp_forecast_interface(t_forecast,
128: t_designator) THEN
129: IF (l_debug <> -1) THEN
130: --
131: rlm_core_sv.dlog(k_DEBUG,'after mrp_forecast_interface_pk.

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

127: IF mrp_forecast_interface_pk.mrp_forecast_interface(t_forecast,
128: t_designator) THEN
129: IF (l_debug <> -1) THEN
130: --
131: rlm_core_sv.dlog(k_DEBUG,'after mrp_forecast_interface_pk.
132: mrp_forecast_interface api');
133: --
134: END IF;
135: --

Line 292: mrp_forecast_interface_pk.t_forecast_interface,

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

Line 294: mrp_forecast_interface_pk.t_forecast_designator,

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,
295: x_ReturnStatus OUT NOCOPY NUMBER)
296: IS
297: --
298: v_forecast_designator mrp_forecast_designators.forecast_designator%TYPE;

Line 855: t_forecast IN OUT NOCOPY mrp_forecast_interface_pk.t_forecast_interface)

851:
852: ===========================================================================*/
853:
854: PROCEDURE initialize_table(
855: t_forecast IN OUT NOCOPY mrp_forecast_interface_pk.t_forecast_interface)
856: IS
857: --
858: x_progress number :='010';
859: --

Line 893: t_forecast IN OUT NOCOPY mrp_forecast_interface_pk.t_forecast_interface,

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

Line 1304: t_Forecast IN mrp_forecast_interface_pk.t_forecast_interface)

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

Line 1737: mrp_forecast_interface_pk.t_forecast_interface,

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

Line 1739: mrp_forecast_interface_pk.t_forecast_designator,

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,
1740: x_t_designator IN OUT NOCOPY
1741: mrp_forecast_interface_pk.t_forecast_designator)
1742: IS
1743: --

Line 1741: mrp_forecast_interface_pk.t_forecast_designator)

1737: mrp_forecast_interface_pk.t_forecast_interface,
1738: x_designator IN OUT NOCOPY
1739: mrp_forecast_interface_pk.t_forecast_designator,
1740: x_t_designator IN OUT NOCOPY
1741: mrp_forecast_interface_pk.t_forecast_designator)
1742: IS
1743: --
1744: x_progress VARCHAR2(3) := '010';
1745: v_InterfaceLineId NUMBER;

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

1755: x_designator(1).forecast_designator := x_t_designator(x_t_designator.COUNT).forecast_designator;
1756: x_designator(1).organization_id:=x_t_designator(x_t_designator.COUNT).organization_id;
1757: --
1758: IF (l_debug <> -1) THEN
1759: rlm_core_sv.dlog(k_DEBUG,'before mrp_forecast_interface_pk api for REPLACE');
1760: END IF;
1761: --
1762: IF mrp_forecast_interface_pk.mrp_forecast_interface(x_forecast,
1763: x_designator) THEN

Line 1762: IF mrp_forecast_interface_pk.mrp_forecast_interface(x_forecast,

1758: IF (l_debug <> -1) THEN
1759: rlm_core_sv.dlog(k_DEBUG,'before mrp_forecast_interface_pk api for REPLACE');
1760: END IF;
1761: --
1762: IF mrp_forecast_interface_pk.mrp_forecast_interface(x_forecast,
1763: x_designator) THEN
1764: --
1765: g_designator_tab(g_designator_tab.count+1).designator :=
1766: x_t_designator(x_t_designator.COUNT).forecast_designator;

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

1766: x_t_designator(x_t_designator.COUNT).forecast_designator;
1767: g_designator_tab(g_designator_tab.count+1).organization_id :=
1768: x_t_designator(x_t_designator.COUNT).organization_id; --Bugfix 6817494
1769: IF (l_debug <> -1) THEN
1770: rlm_core_sv.dlog(k_DEBUG,'after mrp_forecast_interface_pk.mrp_forecast_interface api for REPLACE');
1771: rlm_core_sv.dlog(k_DEBUG,'Old forecast deleted for ', x_designator(1).forecast_designator);
1772: END IF;
1773:
1774: ELSE

Line 1835: x_designator IN OUT NOCOPY mrp_forecast_interface_pk.t_forecast_designator)

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

Line 1839: t_forecast mrp_forecast_interface_pk.t_forecast_interface;

1835: x_designator IN OUT NOCOPY mrp_forecast_interface_pk.t_forecast_designator)
1836:
1837: IS
1838: --
1839: t_forecast mrp_forecast_interface_pk.t_forecast_interface;
1840: empty_designator mrp_forecast_interface_pk.t_forecast_designator;
1841: empty_forecast mrp_forecast_interface_pk.t_forecast_interface;
1842: v_last NUMBER;
1843: v_counter NUMBER;

Line 1840: empty_designator mrp_forecast_interface_pk.t_forecast_designator;

1836:
1837: IS
1838: --
1839: t_forecast mrp_forecast_interface_pk.t_forecast_interface;
1840: empty_designator mrp_forecast_interface_pk.t_forecast_designator;
1841: empty_forecast mrp_forecast_interface_pk.t_forecast_interface;
1842: v_last NUMBER;
1843: v_counter NUMBER;
1844: v_mrp_count NUMBER:=0;

Line 1841: empty_forecast mrp_forecast_interface_pk.t_forecast_interface;

1837: IS
1838: --
1839: t_forecast mrp_forecast_interface_pk.t_forecast_interface;
1840: empty_designator mrp_forecast_interface_pk.t_forecast_designator;
1841: empty_forecast mrp_forecast_interface_pk.t_forecast_interface;
1842: v_last NUMBER;
1843: v_counter NUMBER;
1844: v_mrp_count NUMBER:=0;
1845: v_designator VARCHAR2(10);