APPS.AHL_RM_ROUTE_PVT dependencies on AHL_RT_OPER_ACCESS_PANELS

Line 3073: DELETE AHL_RT_OPER_ACCESS_PANELS

3069: NULL;
3070: END IF;
3071:
3072: -- 5.Delete Access Panel associations
3073: DELETE AHL_RT_OPER_ACCESS_PANELS
3074: WHERE OBJECT_ID = p_route_id
3075: AND ASSOCIATION_TYPE_CODE = 'ROUTE';
3076:
3077: -- If no records exist, then, Continue.

Line 4185: INSERT INTO AHL_RT_OPER_ACCESS_PANELS

4181: -- Pekambar(Praveen) Modifed for USAF - VEE -- End
4182:
4183: -- Adithya added to fix bug# 6525763
4184: -- 5.Copy Access Panels
4185: INSERT INTO AHL_RT_OPER_ACCESS_PANELS
4186: (
4187: RT_OPER_PANEL_ID,
4188: OBJECT_VERSION_NUMBER,
4189: OBJECT_ID,

Line 4215: AHL_RT_OPER_ACCESS_PANELS_S.NEXTVAL,

4211: CREATED_BY,
4212: LAST_UPDATE_LOGIN
4213: )
4214: SELECT
4215: AHL_RT_OPER_ACCESS_PANELS_S.NEXTVAL,
4216: 1,
4217: l_route_id,
4218: ASSOCIATION_TYPE_CODE,
4219: PANEL_TYPE_ID,

Line 4241: FROM AHL_RT_OPER_ACCESS_PANELS

4237: FND_GLOBAL.user_id,
4238: SYSDATE,
4239: FND_GLOBAL.user_id,
4240: FND_GLOBAL.login_id
4241: FROM AHL_RT_OPER_ACCESS_PANELS
4242: WHERE object_id = p_route_id
4243: AND association_type_code = 'ROUTE';
4244:
4245: --Pekambar (Praveen) Added for - VEE - USAF -Start