DBA Data[Home] [Help]

APPS.OKE_FLOWDOWN_UTILS dependencies on OKE_FLOWDOWNS

Line 269: INSERT INTO OKE_FLOWDOWNS

265: L_CREATION_DATE := SYSDATE;
266: L_CREATED_BY := FND_GLOBAL.USER_ID;
267: L_LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
268:
269: INSERT INTO OKE_FLOWDOWNS
270: ( BUSINESS_AREA_CODE
271: , FLOWDOWN_TYPE
272: , FLOWDOWN_CODE
273: , ATTRIBUTE_GROUP_TYPE

Line 302: DELETE FROM OKE_FLOWDOWNS

298: ) IS
299:
300: BEGIN
301:
302: DELETE FROM OKE_FLOWDOWNS
303: WHERE BUSINESS_AREA_CODE = P_BUSINESS_AREA_CODE
304: AND FLOWDOWN_TYPE = P_FLOWDOWN_TYPE
305: AND ( P_FLOWDOWN_CODE IS NULL
306: OR FLOWDOWN_CODE = P_FLOWDOWN_CODE