APPS.AHL_RM_ROUTE_PVT dependencies on AHL_RT_OPER_ACCESS_PANELS

Line 2742: DELETE AHL_RT_OPER_ACCESS_PANELS

2738: NULL;
2739: END IF;
2740:
2741: -- 5.Delete Access Panel associations
2742: DELETE AHL_RT_OPER_ACCESS_PANELS
2743: WHERE OBJECT_ID = p_route_id
2744: AND ASSOCIATION_TYPE_CODE = 'ROUTE';
2745:
2746: -- If no records exist, then, Continue.

Line 3689: INSERT INTO AHL_RT_OPER_ACCESS_PANELS

3685: WHERE route_id = p_route_id;
3686:
3687: -- Adithya added to fix bug# 6525763
3688: -- 5.Copy Access Panels
3689: INSERT INTO AHL_RT_OPER_ACCESS_PANELS
3690: (
3691: RT_OPER_PANEL_ID,
3692: OBJECT_VERSION_NUMBER,
3693: OBJECT_ID,

Line 3719: AHL_RT_OPER_ACCESS_PANELS_S.NEXTVAL,

3715: CREATED_BY,
3716: LAST_UPDATE_LOGIN
3717: )
3718: SELECT
3719: AHL_RT_OPER_ACCESS_PANELS_S.NEXTVAL,
3720: 1,
3721: l_route_id,
3722: ASSOCIATION_TYPE_CODE,
3723: PANEL_TYPE_ID,

Line 3745: FROM AHL_RT_OPER_ACCESS_PANELS

3741: FND_GLOBAL.user_id,
3742: SYSDATE,
3743: FND_GLOBAL.user_id,
3744: FND_GLOBAL.login_id
3745: FROM AHL_RT_OPER_ACCESS_PANELS
3746: WHERE object_id = p_route_id
3747: AND association_type_code = 'ROUTE';
3748:
3749: -- Set the OUT values.