APPS.AS_FORECAST_CATEGORIES_PKG dependencies on AS_FORECAST_CATEGORIES_B

Line 34: INSERT INTO AS_FORECAST_CATEGORIES_B(

30: FETCH C2 INTO px_FORECAST_CATEGORY_ID;
31: CLOSE C2;
32: End If;
33:
34: INSERT INTO AS_FORECAST_CATEGORIES_B(
35: FORECAST_CATEGORY_ID,
36: CREATED_BY,
37: CREATION_DATE,
38: LAST_UPDATED_BY,

Line 97: Update AS_FORECAST_CATEGORIES_B

93: p_END_DATE_ACTIVE DATE)
94:
95: IS
96: BEGIN
97: Update AS_FORECAST_CATEGORIES_B
98: SET
99: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
100: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
101: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

Line 134: DELETE FROM AS_FORECAST_CATEGORIES_B

130: PROCEDURE Delete_Row(
131: p_FORECAST_CATEGORY_ID NUMBER)
132: IS
133: BEGIN
134: DELETE FROM AS_FORECAST_CATEGORIES_B
135: WHERE FORECAST_CATEGORY_ID = p_FORECAST_CATEGORY_ID;
136:
137: If (SQL%NOTFOUND) then
138: RAISE NO_DATA_FOUND;

Line 164: FROM AS_FORECAST_CATEGORIES_B

160:
161: IS
162: CURSOR C IS
163: SELECT *
164: FROM AS_FORECAST_CATEGORIES_B
165: WHERE FORECAST_CATEGORY_ID = p_FORECAST_CATEGORY_ID
166: FOR UPDATE of FORECAST_CATEGORY_ID NOWAIT;
167:
168: Recinfo C%ROWTYPE;

Line 241: from AS_FORECAST_CATEGORIES_B B

237: begin
238: delete from AS_FORECAST_CATEGORIES_TL T
239: where not exists
240: (select NULL
241: from AS_FORECAST_CATEGORIES_B B
242: where B.FORECAST_CATEGORY_ID = T.FORECAST_CATEGORY_ID
243: );
244:
245: update AS_FORECAST_CATEGORIES_TL T set (

Line 304: l_forecast_category_id as_forecast_categories_b.forecast_category_id%Type;

300: X_OWNER in VARCHAR2,
301: x_START_DATE_ACTIVE in DATE,
302: x_END_DATE_ACTIVE in DATE)
303: IS
304: l_forecast_category_id as_forecast_categories_b.forecast_category_id%Type;
305: li_forecast_category_id NUMBER := 0;
306:
307: BEGIN
308: declare

Line 314: from AS_FORECAST_CATEGORIES_B

310: user_id number := 0;
311:
312: cursor custom_exist(p_forecast_category_id NUMBER) is
313: select 'Y'
314: from AS_FORECAST_CATEGORIES_B
315: where last_updated_by <> 1
316: and FORECAST_CATEGORY_ID = p_forecast_category_id;
317:
318: l_custom_exist varchar2(1) := 'N';