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.CE_CEFPURGE_XMLP_PKG dependencies on CE_FORECASTS

Line 37: CE_FORECASTS

33: count(*)
34: INTO
35: C_COUNT
36: FROM
37: CE_FORECASTS
38: WHERE FORECAST_HEADER_ID = NVL(P_FORECAST_HEADER_ID
39: ,FORECAST_HEADER_ID)
40: AND START_DATE is not null
41: AND TRUNC(START_DATE) >= NVL(P_FORECAST_START_DATE_1

Line 53: CE_FORECASTS CF

49: ,0)
50: INTO
51: C_COUNT
52: FROM
53: CE_FORECASTS CF
54: WHERE CF.FORECAST_HEADER_ID = NVL(P_FORECAST_HEADER_ID
55: ,CF.FORECAST_HEADER_ID)
56: AND START_PERIOD in (
57: SELECT

Line 83: CE_FORECASTS

79: WHERE FORECAST_ID in (
80: SELECT
81: FORECAST_ID
82: FROM
83: CE_FORECASTS
84: WHERE FORECAST_HEADER_ID = NVL(P_FORECAST_HEADER_ID
85: ,FORECAST_HEADER_ID)
86: AND START_DATE is not null
87: AND TRUNC(START_DATE) >= NVL(P_FORECAST_START_DATE_1

Line 96: CE_FORECASTS

92: WHERE FORECAST_ID in (
93: SELECT
94: FORECAST_ID
95: FROM
96: CE_FORECASTS
97: WHERE FORECAST_HEADER_ID = NVL(P_FORECAST_HEADER_ID
98: ,FORECAST_HEADER_ID)
99: AND START_DATE is not null
100: AND TRUNC(START_DATE) >= NVL(P_FORECAST_START_DATE_1

Line 109: CE_FORECASTS

105: WHERE FORECAST_ID in (
106: SELECT
107: FORECAST_ID
108: FROM
109: CE_FORECASTS
110: WHERE FORECAST_HEADER_ID = NVL(P_FORECAST_HEADER_ID
111: ,FORECAST_HEADER_ID)
112: AND START_DATE is not null
113: AND TRUNC(START_DATE) >= NVL(P_FORECAST_START_DATE_1

Line 122: CE_FORECASTS

118: WHERE FORECAST_ID in (
119: SELECT
120: FORECAST_ID
121: FROM
122: CE_FORECASTS
123: WHERE FORECAST_HEADER_ID = NVL(P_FORECAST_HEADER_ID
124: ,FORECAST_HEADER_ID)
125: AND START_DATE is not null
126: AND TRUNC(START_DATE) >= NVL(P_FORECAST_START_DATE_1

Line 130: DELETE FROM CE_FORECASTS

126: AND TRUNC(START_DATE) >= NVL(P_FORECAST_START_DATE_1
127: ,TRUNC(START_DATE))
128: AND TRUNC(START_DATE) <= NVL(P_FORECAST_END_DATE_1
129: ,TRUNC(START_DATE)) );
130: DELETE FROM CE_FORECASTS
131: WHERE FORECAST_HEADER_ID = NVL(P_FORECAST_HEADER_ID
132: ,FORECAST_HEADER_ID)
133: AND START_DATE is not null
134: AND TRUNC(START_DATE) >= NVL(P_FORECAST_START_DATE_1

Line 145: CE_FORECASTS CF

141: WHERE FORECAST_ID in (
142: SELECT
143: FORECAST_ID
144: FROM
145: CE_FORECASTS CF
146: WHERE FORECAST_HEADER_ID = NVL(P_FORECAST_HEADER_ID
147: ,FORECAST_HEADER_ID)
148: AND START_PERIOD in (
149: SELECT

Line 163: CE_FORECASTS CF

159: WHERE FORECAST_ID in (
160: SELECT
161: FORECAST_ID
162: FROM
163: CE_FORECASTS CF
164: WHERE FORECAST_HEADER_ID = NVL(P_FORECAST_HEADER_ID
165: ,FORECAST_HEADER_ID)
166: AND START_PERIOD in (
167: SELECT

Line 181: CE_FORECASTS CF

177: WHERE FORECAST_ID in (
178: SELECT
179: FORECAST_ID
180: FROM
181: CE_FORECASTS CF
182: WHERE FORECAST_HEADER_ID = NVL(P_FORECAST_HEADER_ID
183: ,FORECAST_HEADER_ID)
184: AND START_PERIOD in (
185: SELECT

Line 199: CE_FORECASTS CF

195: WHERE FORECAST_ID in (
196: SELECT
197: FORECAST_ID
198: FROM
199: CE_FORECASTS CF
200: WHERE FORECAST_HEADER_ID = NVL(P_FORECAST_HEADER_ID
201: ,FORECAST_HEADER_ID)
202: AND START_PERIOD in (
203: SELECT

Line 212: DELETE FROM CE_FORECASTS CF

208: AND TRUNC(GLP.START_DATE) >= NVL(P_FORECAST_START_DATE_1
209: ,TRUNC(GLP.START_DATE))
210: AND TRUNC(GLP.START_DATE) <= NVL(P_FORECAST_END_DATE_1
211: ,TRUNC(GLP.START_DATE)) ) );
212: DELETE FROM CE_FORECASTS CF
213: WHERE FORECAST_HEADER_ID = NVL(P_FORECAST_HEADER_ID
214: ,FORECAST_HEADER_ID)
215: AND START_PERIOD in (
216: SELECT