APPS.AHL_RM_OPERATION_PVT dependencies on AHL_RT_OPER_ACCESS_PANELS

Line 2101: DELETE AHL_RT_OPER_ACCESS_PANELS

2097: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Associated Operations' );
2098: END IF;
2099:
2100: -- 5.Delete Access Panels associated
2101: DELETE AHL_RT_OPER_ACCESS_PANELS
2102: WHERE OBJECT_ID = p_operation_id
2103: AND ASSOCIATION_TYPE_CODE = 'OPERATION';
2104:
2105: -- If no records exist, then, Continue.

Line 2816: INSERT INTO AHL_RT_OPER_ACCESS_PANELS

2812: WHERE operation_id = p_operation_id;
2813:
2814: -- Adithya added to fix bug# 6525763
2815: -- 5.Copy Access Panels
2816: INSERT INTO AHL_RT_OPER_ACCESS_PANELS
2817: (
2818: RT_OPER_PANEL_ID,
2819: OBJECT_VERSION_NUMBER,
2820: OBJECT_ID,

Line 2846: AHL_RT_OPER_ACCESS_PANELS_S.NEXTVAL,

2842: CREATED_BY,
2843: LAST_UPDATE_LOGIN
2844: )
2845: SELECT
2846: AHL_RT_OPER_ACCESS_PANELS_S.NEXTVAL,
2847: 1,
2848: l_operation_id,
2849: ASSOCIATION_TYPE_CODE,
2850: PANEL_TYPE_ID,

Line 2872: FROM AHL_RT_OPER_ACCESS_PANELS

2868: FND_GLOBAL.user_id,
2869: SYSDATE,
2870: FND_GLOBAL.user_id,
2871: FND_GLOBAL.login_id
2872: FROM AHL_RT_OPER_ACCESS_PANELS
2873: WHERE object_id = p_operation_id
2874: AND association_type_code = 'OPERATION';
2875:
2876: -- Set the Out values.